Loading sdf file

I used JChemManager to load a sdf file. When I created table using JChemManger, I added a compound id column (varchar2 type). The sdf file has the corresponding substance_id field. But when I tried to import the sdf file, I got duplicate column name error. The message is in the attachment.





Thanks very much in advance.





Yuhong Wang





wangyuh _at_ mail.nih.gov

Hi,





Please let me know your JChem version.





Did you add your field at the end of the list ?


Custom field should always be listed after the fix columns.








Best regards,





Szilard

PS:





I have checked, the very same error can be reproduced indeed if you do not add your custom DB fields at the end of the list in the table creation dialog.





Please see the following link for further information:





http://www.chemaxon.com/jchem/doc/admin/#create





The documentation writes:

Quote:

The definitions of additional columns should follow the definitions of fix columns (highlighted in the screenshot).

To check the order of the database fields of an existing table, type:

Code:

jcman t <table_name>

The fields added by the user should appear at the end of the list, if the table was created properly.





Best regards,





Szilard