Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   Create entry from command line - override Date?, posted by David Wallis on Tue Oct 27 16:00:03 2020 
    icon2.gif   Re: Create entry from command line - override Date?, posted by Stefan Ritt on Tue Oct 27 16:15:26 2020 
       icon2.gif   Re: Create entry from command line - override Date?, posted by David Wallis on Tue Oct 27 16:37:07 2020 
          icon2.gif   Re: Create entry from command line - override Date?, posted by Stefan Ritt on Tue Oct 27 16:49:53 2020 
          icon2.gif   Re: Create entry from command line - override Date?, posted by Andreas Luedeke on Tue Oct 27 17:07:00 2020 
             icon2.gif   Re: Create entry from command line - override Date?, posted by David Wallis on Tue Oct 27 17:45:29 2020 
                icon2.gif   Re: Create entry from command line - override Date?, posted by Andreas Luedeke on Tue Oct 27 21:59:03 2020 
                   icon2.gif   Re: Create entry from command line - override Date?, posted by David Wallis on Tue Oct 27 22:24:18 2020 
Message ID: 69257     Entry time: Tue Oct 27 21:59:03 2020     In reply to: 69256     Reply to this: 69258
Icon: Reply  Author: Andreas Luedeke  Author Email: andreas.luedeke@psi.ch 
Category: Question  OS: Linux  ELOG Version: V3.1.4-ba84827 
Subject: Re: Create entry from command line - override Date? 

Hi David,
correct. And in addition you will need to convert "Orig Date" from seconds-of-the-epoch into a properly formated date string (see example below from Stefan) ...

Andreas

David Wallis wrote:

Hi Andreas,

Thanks for your input! After a little testing, it appears that if I make "Orig Date" the first field, it will fall under the Date field in the logbook file. I can then do a global delete of Date:, and replace Orig Date: with Date:, leaving it as the first field in the entry. Then I can delete the Orig Date field.

Andreas Luedeke wrote:

You could transform your entries into the ELOG file format (either XML or CSV) and then use the import function. That would upload the correct dates from your entries.

If you use the "Orig Date" trick you've proposed, you'll see that datetime fields are stored as seconds of the epoch (since 1.1.1970). Not so easy to copy and paste them, but you can convert them with a script.

Cheers, Andreas

David Wallis wrote:

Hi Stefan, thanks! Does the Date field need to be the first field in each entry? I can see adding a "termpory" field called "Orig Date", upload the old entries, then edit the file(s), delete the Date field, and rename Orig Date to Date. Will that work?

Stefan Ritt wrote:

You have to manually manipulate the logbook files YYMMDDa.log where you find the date at the top like:

MID@$: 1
Date: Wed, 02 Sep 2020 15:38:09 +0300 <==== change here !!!!
Author: Stefan
Type: General
Category: 
Subject: CURL test
Attachment: 
Encoding: plain
========================================
Text body
 

 

 

 

 

ELOG V3.1.5-3fb85fa6