Script for uploading bitmaps

User e05b1833aa

26-04-2012 12:09:16

Hi,


I wondered if you could help me out with creating a Groovy script that allows me to add dose-response curves (as bitmaps) to a database column. The images would be stored in a specified location and have unique identifiers tying them to the right compound. 


I know something similar can be done using the dynamic URL field but this does nat actually add the images to the database.


Let me know if you need more info.


Thanks,


Evert

ChemAxon 60ee1f1328

27-04-2012 07:59:57

Hi Evert,


 


Could you please tell us which RDBMS system you wish to load your images into.


We can assume Oracle but IJC also works with derby and mysql.


If it is possible to attach a small number of sample sources or at least some items that reflect your sources.


You mention unique identifiers - the files are name uniquely or the ID is mapped to file name in some other file ? 


 


Thanks,


Daniel.

User e05b1833aa

27-04-2012 15:21:02

Hi,


 


I'm using a mySQL-based system.

ChemAxon 60ee1f1328

30-04-2012 08:37:27

Hi Homer,


We will look to provide a simple/basic example for loading an image into a suitable column in each RDBMS.


i.e. we will update the scripting docs area with the examples.


Cheers,


Daniel.