CMDBuild Forum

Import N:N relationships

Old Versions
#1

Hi,

How could I import N:N relationships from a CSV file?

 

Thanks in advance.

Alex.

#2
You can not directly import N:N relationships from a CSV file.
The solution that we use in these cases is to write an insert SQL query and run it from pgAdmin.
But this can be a critical operation (the database may become inconsistent) and is recommended for advanced users.

CMDBuild Team

#3
Thanks.
 
I understand there is no way neither to import Lookups from a CSV but inserting records directly in the database?
 
Thanks in advance.
Alex.
 
Previously Tecnoteca wrote:
You can not directly import N:N relationships from a CSV file.
The solution that we use in these cases is to write an insert SQL query and run it from pgAdmin.
But this can be a critical operation (the database may become inconsistent) and is recommended for advanced users.

CMDBuild Team

 

#4
Create a script to read CSV file and import using WebService API.
 
Regards,
Herru
 
Previously Alex wrote:
Thanks.
 
I understand there is no way neither to import Lookups from a CSV but inserting records directly in the database?
 
Thanks in advance.
Alex.
 
Previously Tecnoteca wrote:
You can not directly import N:N relationships from a CSV file.
The solution that we use in these cases is to write an insert SQL query and run it from pgAdmin.
But this can be a critical operation (the database may become inconsistent) and is recommended for advanced users.

CMDBuild Team