Date field not recognized upon import

User 8a7878ec6d

18-02-2015 14:47:20

Hi,


I exported an SD file from an IJC database that contains a date field. The date field is present in the exported SD file (checked with MarvinView).


When I import it into a new database the date field is not visible amongst the fields available for importing.


This is in IJC 15.2.2.0, both databases are mySQL-based.


Regards/Evert

ChemAxon 4f0b8a99b5

18-02-2015 15:47:21

Hello Evert.


I was unable to reproduce your issue on neither current stable nor the 15.2.2 with MySQL 5.6.22, can you provide small example of the SD file?


Best regards,


Martin

User 8a7878ec6d

18-02-2015 15:56:31

Hi,


I think the problem is that not all the entries in the database have a value for the date field, at least not a number of entries sorted at the top of the table.


If I export only one entry that has a value in the date field it shows up in the import wizard.


Regards,


Evert

ChemAxon 4f0b8a99b5

18-02-2015 16:48:16

Hello Evert,


thanks for describing this to me, to resolve this, hit 'read more' button untill the date field appears as shown in screenshot.


Best regards,


Martin

User 8a7878ec6d

18-02-2015 17:44:59

Yes, that explains...thanks for clarifying!


Cheers,


Evert