How to imported the user-defined columns in JchemBase?

hello!

We want to add some user-defined columns in JchemBase's structure table, if  we import  molecule in the table, how to imported the user-defined columns at the same time?

Is there any examples in java?  thanks!

Hi,

 

Please check out the following areas of the documentation:

 

Concepts and user level documentation:

http://www.chemaxon.com/jchem/doc/dev/dbconcepts/index.html#tablestructure

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

 

Code example for importing in Java:

(Unfortunately, without extra column handling.)

http://www.chemaxon.com/jchem/doc/dev/import_export/index.html#importer

Useful API methods for user defined columns:

http://www.chemaxon.com/jchem/doc/dev/java/api/chemaxon/jchem/db/Importer.html

http://www.chemaxon.com/jchem/doc/dev/java/api/chemaxon/jchem/db/Importer.html#setFieldConnections%28java.lang.String%29

 

Let us know if you have any further questions.

 

Best regards,

Szabolcs

 

How to do structure search with a extra column?

Like this:If i have a extra column Named CAS_NO,and we want do substructure search with a mol and CAS_NO like ‘%1-1-1%’ 

 

 

Szabolcs wrote:

Hi,   Please check out the following areas of the documentation:   Concepts and user level documentation: http://www.chemaxon.com/jchem/doc/dev/dbconcepts/index.html#tablestructure http://www.chemaxon.com/jchem/doc/admin/#import   Code example for importing in Java: (Unfortunately, without extra column handling.) http://www.chemaxon.com/jchem/doc/dev/import_export/index.html#importer Useful API methods for user defined columns: http://www.chemaxon.com/jchem/doc/dev/java/api/chemaxon/jchem/db/Importer.html http://www.chemaxon.com/jchem/doc/dev/java/api/chemaxon/jchem/db/Importer.html#setFieldConnections%28java.lang.String%29   Let us know if you have any further questions.   Best regards, Szabolcs

Hi,

 

Please check out this section:

http://www.chemaxon.com/jchem/doc/dev/search/index.html#sss_combine

, especially the title "SQL Query Followed by Structure Searching".

Basically you can include the like condition in the filterQuery parameter.

 

Best regards,

Szabolcs