Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   csv import timestamp, posted by Ferdinand Gassauer on Wed May 13 22:03:37 2015 
    icon2.gif   Re: csv import timestamp, posted by Andreas Luedeke on Thu May 14 02:19:53 2015 
       icon2.gif   Re: csv import timestamp, posted by Ferdinand Gassauer on Thu May 14 07:01:23 2015 
          icon2.gif   Re: csv import timestamp, posted by Andreas Luedeke on Thu May 14 22:16:03 2015 
Message ID: 67911     Entry time: Thu May 14 22:16:03 2015     In reply to: 67910
Icon: Reply  Author: Andreas Luedeke  Author Email: andreas.luedeke@psi.ch 
Category: Question  OS: Linux  ELOG Version: 3.1 
Subject: Re: csv import timestamp 
Hi Ferdinand,
"import" is meant to be used for files that have been exported with "find". Therefore it is not very flexible with the date format.
Todays date should look like that: "Thu  14 May 2015 22:12:00 +0200".
You have to convert your file that the date matches this format (BTW: I found this out by using the find - export feature; it may depend on a local configuration.)
Cheers
Andreas
Ferdinand Gassauer wrote:

Thanks

what is the format of the Date field in the csv file ?

My Date is date and not datetime. 

Andreas Luedeke wrote:
Hi Ferdinand,
and that is exactly what happens when you import a csv file with a date field:
the creation date ($entry time) of the imported entries will be used from the "Date" column in the file.
I've just tried it and it works like a charm. Did you have any problems doing it?
Cheers
Andreas
Ferdinand Gassauer wrote:

I have to import a csv with a date field, which represents the creation date

this date should be used as "date" timestamp which is set automatically, otherwise all entries get the current datetime as timestamp

 

 

 

 

ELOG V3.1.5-2eba886