[ome-users] ZVI Acquisition Date Formatting

[Melissa Linkert]

Hi Joe,

> 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.

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

> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users