CMDBuild Forum

CMDBuild 1.5 csv import failing for reference attributes

Dear Support,

 

I'm trying to import data from a csv file(~ 300 rows) and the import is failing. I have a class having one of the attribute defined as REFERENCE and for this field all data is marked in red colour and is not letting me to do the import unless I manually modify each row. I need to mention here that there is nothing wrong with my data.

I successfully replicated this issue by reinstalling the application and using the DEMO DB schema. Below are the steps I performed to replicate the issue:

-I've exported Floor class into csv file
-imported the resulting file(without any changes)
-preview of the import appears
-the Building's data is in marked red colour
-After pressing OK for import I got "Import failed" message and this description:

 

org.cmdbuild.exception.ORMException: ORM_CSV_INVALID_ATTRIBUTES
	at org.cmdbuild.exception.ORMException$ORMExceptionType.createException(ORMException.java:60)
	at org.cmdbuild.csv.CSVCard.checkValidity(CSVCard.java:155)
	at org.cmdbuild.csv.CSVCard.save(CSVCard.java:143)
	at org.cmdbuild.servlets.json.management.ImportCSV.storeCSVRecords(ImportCSV.java:80)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

It si annoying expecialy when you have to import large chunk of data...because you send a lot of time manually changing each row. Is this a bug?

Thank you in advance for your reply,

C.

Probably the problem depends on an incorrect compilation of the “reference” values in CSV file.
As indicated in the manual (User Manual, page 49) for “reference” attributes the CSV values must match the “Code” field of the related card.

Fabio