CMDBuild Forum

Import an excel

Old Versions
#1

Hi,

We have a huge excel which has the inventory information.

Is there a way to import the excel into CMDBuild? 

Can i create a empty database and create the same fields like in excel and import it?

Thanks and Best Regards.

 

 

#2

You can save your Excel file in CSV format (UTF8 encoding), check that headers and data format follow the CMDBuild requirements (see the User Manual) and use the CSV import function.

CMDBuild Team

 

 

#3
Thank you very much for the clarification.
 
Previously Tecnoteca wrote:

You can save your Excel file in CSV format (UTF8 encoding), check that headers and data format follow the CMDBuild requirements (see the User Manual) and use the CSV import function.

CMDBuild Team

 

 

 

#4
 
Previously Tecnoteca wrote:

You can save your Excel file in CSV format (UTF8 encoding), check that headers and data format follow the CMDBuild requirements (see the User Manual) and use the CSV import function.

CMDBuild Team

 

 

 

I'm doing these steps, and 2 columns (as reference attribute on target) are all coloured red
 
When I'm exporting data current data on CMDBuild, of the target class relation, i got special characters as weird characters
 
 
What can I do to fix it ¿?
 
I'm using pre-configured CMDBuild from OVF, upgraded to 2.3.1
 
thanks
 
 
 
#5

One of the
frequent errors in the CSV import is that for the Reference fields the
CSV file must contain the “Code” of the connected class (see the
CMDBuild User Manual 2.5 ENG, page 82 http://www.cmdbuild.org/it/documentazione/manuali ).
Can this be your problem ?

 

CMDBuild Team