Problem importing SDF files

When I try to import the pubchem sdf files (e.g. Compound_00000001_00010000.sdf) with JChemManager


into an MS Access table, only the structure data is imported.


How I can import the others fields with JChemManager ?





Thanks very much.





Daniel

Hi,





You should have some extra fields in the JChem table for that.


Currently you can add these fields by appending to the table creation SQL statement in the "Create Table Statement" dialog.





Please see the table creation section in the Administration Guide:


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


You will see a screenshot example of how these fields are appended.


Please note that these extra fields should go at the end of the fields list.





Of course you can also add any extra fields to the table later with your favourite DB administration tool.





In the import dialog you can specify how many lines should be checked for data field names. It's recommended to check the "Check the whole file for field names ..." checkbox to find all data field names. See:


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





In the following dialog you can specify what SDF field should go into what DB column. Identical names are automatically paired, settings are remembered for next import.





Best regards,





Szilard





PS: We are currently working on an out-of-the-box application, that will offer to automatically create the necessary extra fields during the import.


(and in general it will be much better suited for the end user).





Best regards,





Szilard