I apologize if this has been answered elsewhere, but am having trouble exporting data from related tables. I have one JChem database table ('Inventory') with compound names, structure data and a standard database table ('Activity') with activity data for the compounds. The two tables are joined by the CdId. I'm trying to export the data in the Activity table to an excel file, but would also like to export the corresponding structures.
When exporting Activity data, I also add in the Structure field from Inventory. The excel file is generated, but for each molecule I get the following message:
ERROR: Failed to export molecule 0.
I'm sure there is a way to do this but am still trying to learn how to maneuver with Instant JChem. Any suggestions/help would be welcome and greatly appreciated.