[ome-users] ZVI Acquisition Date Formatting

[Joseph Padfield]

Hi Melissa,

Thank you for your response.

Yes I did find the mention of an "AcquisitionDate" in the xml output, 
however the date displayed there seemed to be the last "Modified Date" 
rather than a conversion of the "Acquisition Date" data stored in the 
zvi file.

For a test copy of my file that I tried a few days ago the xml output 
included:
...
<Image ID="Image:0" Name="file_copy.zvi">
<AcquisitionDate>2012-08-10T11:58:00</AcquisitionDate>
...
<XMLAnnotation ID="Annotation:30">
          <Value>
             <OriginalMetadata xmlns="openmicroscopy.org/OriginalMetadata">
                <Key>Acquisition Date</Key>
                <Value>4675820074566218095</Value>
             </OriginalMetadata>
          </Value>
       </XMLAnnotation>
...
<XMLAnnotation ID="Annotation:45">
          <Value>
             <OriginalMetadata xmlns="openmicroscopy.org/OriginalMetadata">
                <Key>File Date</Key>
                <Value>4675820078182691028</Value>
             </OriginalMetadata>
          </Value>
       </XMLAnnotation>
...

Whereas the AxioVision LE displays the "Acquisition date" as 19/04/2011 
16:10:42.

So I was not sure what to try next.

Thanks

Joe

On 14/08/12 04:05, Melissa Linkert wrote:
> Hi Joe,
> The acquisition date should already be converted into ISO-8601 format
> (yyyy-MM-dd'T'hh:mm:ss) in the displayed OME-XML.  So if you run:
>
> $ showinf -omexml -nopix -nocore file.zvi
>
> near the bottom of the output you should see something like this:
>
> Generating OME-XML (schema version 2012-06)
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <OME xmlns="http://www.openmicroscopy.org/Schemas/OME/2012-06" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openmicroscopy.org/Schemas/OME/2012-06 https://raw.github.com/openmicroscopy/openmicroscopy/schema-2012-06/components/specification/InProgress/ome.xsd">
>     <Image ID="Image:0" Name="file.zvi">
>        <AcquisitionDate>2007-06-29T23:35:44</AcquisitionDate>
>
> ...which is the human-readable version of the "Acquisition date" value.
>
> If you do not see something like that in the output of showinf, please let us
> know.
>
> Regards,
> -Melissa
>
> On Fri, Aug 10, 2012 at 02:28:36PM +0100, Joseph Padfield wrote:
>> Hi,
>>
>> I am trying to extract the "Acquisition Date" from a large set of
>> Zeiss Vision Image (ZVI) files using the "bftools" command line
>> tools. I can get the field without any problem but I can not find
>> out how to convert the returned integer into a formatted date.
>> Hopefully I have just missed something simple.
>>
>> When I open an individual test file in the official AxioVision LE
>> software the following data can be displayed:
>> Acquisition date: 19/04/2011 16:10:42
>> Date: 19/04/2011 13:48:35
>>
>> But the only fields I can get via the bftools "showinf" function are:
>> Acquisition Date: 4675820074566218095
>> File Date: 4675820078182691028
>> (using showinf -omexml -nopix - nocore filename.zvi)
>>
>> Is there a way of converting "4675820074566218095" to something like
>> "19/04/2011 16:10:42" using any of the command lines tools or any
>> other standard datetime conversion processes. The only information I
>> can find is that the field should be stored as an "ISO 8601" date
>> which is described as using a format like
>> [YYYY]-[MM]-[DD]T[hh]:[mm]:[ss], but I can not find anything about a
>> 19 digit integer.
>>
>> I am using the command line tool "showinf" in linux:
>> Version: 4.4.1
>> VCS revision: fae9833
>> Build date: 19 July 2012
>>
>> Thank you for any help.
>>
>> Joe

-- 
*Joseph Padfield*
Conservation Scientist
Scientific Department
The National Gallery
Trafalgar Square
London WC2N 5DN
44 (0)20 7747 2553
Email <mailto:joseph.padfield at ng-london.org.uk> Follow JoePadfield on 
Twitter <http://www.twitter.com/JoePadfield> Link 2 
<http://research.ng-london.org.uk>


----------------------------------------------------------------
Metamorphosis: Titian 2012
A unique collaboration with The Royal Ballet
11 July - 23 September 2012
Admission Free
 
Find out more:
http://www.nationalgallery.org.uk/metamorphosis-titian-2012
 
Sign up for news, offers and exclusive competitions from the 
National Gallery:
http://www.nationalgallery.org.uk/what/news/subscribe.htm
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20120814/9c2ffba8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: email-icon-16x16.gif
Type: image/gif
Size: 949 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20120814/9c2ffba8/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: t_mini-a.png
Type: image/png
Size: 1524 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20120814/9c2ffba8/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: link-icon-16x16.gif
Type: image/gif
Size: 182 bytes
Desc: not available
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20120814/9c2ffba8/attachment-0001.gif>