[ome-users] ZVI Acquisition Date Formatting

[Melissa Linkert]

Hi Joe,

> 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>
*snip*
> ...
> 
> Whereas the AxioVision LE displays the "Acquisition date" as
> 19/04/2011 16:10:42.

Interesting - that is definitely not the correct behavior.  Would you be
willing to send one of the files that produces this problem?  If you
need somewhere to upload a file, please let me know and I will send you
instructions in a private email on how to send a file to the OME team.

Regards,
-Melissa

On Tue, Aug 14, 2012 at 11:05:40AM +0100, Joseph Padfield wrote:
> 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