Setting a structure column on CSV import into IJC

Hi,

 

I am importing a CSV file containing smiles and some data into IJC (6.3.3). IJC is stubbornly refusing to assign the structure field to the smiles column and I cant seem to specify the mapping.

 

Any ideas?

Hello,

I suppose you are trying to import to already existing entity. There are 2 things to take care of.

• First is that you should select the correct CSV separator. IJC should autodetect, but depending on the CSV, sometimes it detects incorrectly. 


• Second, what probably caused the confusion is that if you are importing to already existing entity, the dialog appends the recognised fields at the end of the existing fields in the entity, so you will get something like:

Fields in file	Fields in database
Field 1	Existing Entity 1
Field 2	Existing Entity 2
	+ Field 1
	+ Field 2

You need to highlight the added fields in "Fields in database" (in this example Field 1 and Field 2) and remove them.

This should create the following:

Fields in file	Fields in database
Field 1	Existing Entity 1
Field 2	Existing Entity 2

and enable you to merge/map the fields from file to fields in database (such as Field 1 -> Existing Entity 1 and Field 2 –> Existing Entity 2. Depending on the way how the csv file was exported or prepared, you have to know what field is to be assigned to what, or you can have first line in the csv file containing the field name.

 

I hope this clears the confusion and helps.

 

Wishing all the best

David