Re: Writing results and embedding images into database

Posted by Gluender on Jan 31, 2008; 5:26pm
URL: http://imagej.273.s1.nabble.com/Writing-results-and-embedding-images-into-spreadsheet-cells-tp3697333p3697336.html

Dear Andy,

not perfectly sure about the amount of data you want to store with
your images...

If the data is not too rich, then I should like to propose to store
it as Metadata with every image. To recover the data, either use the
corresponding IJ menu item or write a little macro to display it in a
IJ-Table or as an IJ-Graph.

This technique guarantees that the data remains with the image and
you recall it by opening the desired image. In the end you merely
need an application to manage your images and there are quite a lot
available, some even for free.

HTH,

Herbie

>What we are after here is a means by which we can save all our data
>from a macro (image and results) into some kind of format that makes
>it easy to subsequently view.
>
>At present we view our resultant images separately from the results,
>which are viewed in a spreadsheet.
>
>We would like to amalgamate these.  (My guess is that we should
>output to a format recognisable by some database.)
>
>Does anyone output their results/images into a database format of
>some kind, allowing them to view all their data 'together'?
>
>Is this possible?
>
>Some help/pointers would be greatly appreciated.
>
>Thanks, Andy
>
>Andy Weller wrote:
>>Dear all,
>>
>>I have a macro that writes several results and info to a separate
>>Results.txt file. Effectively, it is:
>>
>>dir = getDirectory("Choose Directory");
>>f = File.open(dir + "Results.txt"); // Open results file
>>.
>>out = fileName + "\t" + a + "\t" + b;
>>print(f, out + "\n");
>>
>>What would be interesting is when I open Results.txt in a
>>spreadsheet package, the cells in the first column would have the
>>images embedding into them. I can then check out my results in
>>relation to the images.
>>
>>Do you know if this is possible? I know you can do hyperlinks, but
>>I would really like to 'see' the images alongside the measurements,
>>in the same window.
>>
>>If it is, what would be the format of the "fileName" (or
>>"image1.tif") above (considering that Results.txt is stored in the
>>same folder as the images).
>>

Thanks, Andy