<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Melissa,<br>
<br>
Thank you for your response.<br>
<br>
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.<br>
<br>
For a test copy of my file that I tried a few days ago the xml
output included:<br>
...<br>
<Image ID="Image:0" Name="file_copy.zvi"><br>
<AcquisitionDate>2012-08-10T11:58:00</AcquisitionDate><br>
...<br>
<XMLAnnotation ID="Annotation:30"><br>
<Value><br>
<OriginalMetadata
xmlns="openmicroscopy.org/OriginalMetadata"><br>
<Key>Acquisition Date</Key><br>
<Value>4675820074566218095</Value><br>
</OriginalMetadata><br>
</Value><br>
</XMLAnnotation><br>
...<br>
<XMLAnnotation ID="Annotation:45"><br>
<Value><br>
<OriginalMetadata
xmlns="openmicroscopy.org/OriginalMetadata"><br>
<Key>File Date</Key><br>
<Value>4675820078182691028</Value><br>
</OriginalMetadata><br>
</Value><br>
</XMLAnnotation><br>
...<br>
<br>
Whereas the AxioVision LE displays the "Acquisition date" as
19/04/2011 16:10:42.<br>
<br>
So I was not sure what to try next.<br>
<br>
Thanks<br>
<br>
Joe<br>
<br>
<div class="moz-cite-prefix">On 14/08/12 04:05, Melissa Linkert
wrote:<br>
</div>
<blockquote cite="mid:20120814030538.GB3100@medusa" type="cite">
<pre wrap="">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=<a class="moz-txt-link-rfc2396E" href="http://www.openmicroscopy.org/Schemas/OME/2012-06">"http://www.openmicroscopy.org/Schemas/OME/2012-06"</a> xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a> xsi:schemaLocation=<a class="moz-txt-link-rfc2396E" href="http://www.openmicroscopy.org/Schemas/OME/2012-06https://raw.github.com/openmicroscopy/openmicroscopy/schema-2012-06/components/specification/InProgress/ome.xsd">"http://www.openmicroscopy.org/Schemas/OME/2012-06 https://raw.github.com/openmicroscopy/openmicroscopy/schema-2012-06/components/specification/InProgress/ome.xsd"</a>>
<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:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<div><small><font face="Frutiger 55 Roman"> <b>Joseph Padfield</b><br>
Conservation Scientist<br>
Scientific Department<br>
The National Gallery<br>
Trafalgar Square<br>
London WC2N 5DN<br>
44 (0)20 7747 2553<br>
</font></small> <a
href="mailto:joseph.padfield@ng-london.org.uk"
title="joseph.padfield@ng-london.org.uk" target="_blank"><img
style="border:none"
src="cid:part1.09030506.09090305@ng-london.org.uk"
alt="Email"></a> <a
href="http://www.twitter.com/JoePadfield" title="Follow
JoePadfield on Twitter" target="_blank"><img
style="border:none"
src="cid:part3.08000602.03080706@ng-london.org.uk"
alt="Follow JoePadfield on Twitter"></a> <a
href="http://research.ng-london.org.uk"
title="http://research.ng-london.org.uk" target="_blank"><img
style="border:none"
src="cid:part5.09070508.07020809@ng-london.org.uk" alt="Link
2"></a> </div>
</div>
<p><pre>
----------------------------------------------------------------
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
</pre></p>
</body>
</html>