ELOG Forum

Converting dates from an Excel import into ELOG

Windows

V2.7.1-200

Hi,

I'm importing an Excel spreadsheet into ELOG through CSV format. All working fine apart from dates.

Dates are exporting from Excel in the format "day/month/year" so 1st January 2008 is exported as 01/01/2008 in the CSV.

However all dates are displayed in ELOG as "01/01/1970" regardless of the field content, and looking at the raw ELOG data file dates are displayed as numeric's - so for example 01/01/2008 is "1199188800"

Can you tell me how dates are computed/stored in ELOG so that I can do the necessary conversion.

Many Thanks

Fergus

65711

Thu Jan 24 16:50:16 2008

Fergus Lynch

flynch@alternativenetworks.com

Re: Converting dates from an Excel import into ELOG

Windows

V2.7.1-200

Fergus Lynch wrote:

Hi,

I'm importing an Excel spreadsheet into ELOG through CSV format. All working fine apart from dates.

Dates are exporting from Excel in the format "day/month/year" so 1st January 2008 is exported as 01/01/2008 in the CSV.

Can you tell me how dates are computed/stored in ELOG so that I can do the necessary conversion.

Many Thanks

Fergus

S'ok - looked up the documentation and have converted Excel dates to ELOG 'seconds since 01/01/1970' and all has come over fine!

Thanks

Fergus

69209

Wed Sep 2 10:24:58 2020

Using curl to post new entries

Hey,

i'm trying to use curl to post new entries to our logbook as described here: https://elog.psi.ch/elogs/Forum/68597.
The Elog is installed via the Deban package on Buster.
I created a test logbook with attributes Author, Type, Category and Subject.

curl -u florian:foobaa -F cmd=Submit -F Author=Florian -F Type=Diary -F Category=General -F Subject="testing curl" -F Text="foo baa" http://localhost:8080/test <!DOCTYPE html> <html><head> <meta name="ROBOTS" content="NOINDEX, NOFOLLOW"> <title>ELOG Login</title> <link rel="stylesheet" type="text/css" href="elog.css"> <link rel="shortcut icon" href="favicon.ico" /> <link rel="icon" href="favicon.png" type="image/png" /> </head> <body OnLoad="document.form1.uname.focus();"> <form name=form1 method="POST" action="./" enctype="multipart/form-data">

<input type=hidden name=redir value=""> <table class="login_frame" cellspacing=0 align=center><tr><td class="login_title">Please login</td></tr> <tr><td class="login_form"> <span class="overlay_wrapper"> <label for="uname" id="uname" class="overlabel">Username</label> <input type="text" class="login_input" name="uname" value="" title="Username" onInput="document.getElementById('uname').style.display='none';"> </span></td></tr> <tr><td class="login_form"> <span class="overlay_wrapper"> <label for="upassword" id="upassword" class="overlabel">Password</label> <input type="password" class="login_input" name="upassword" onInput="document.getElementById('upassword').style.display='none';"> </span></td></tr> <tr><td align=center class="login_form"><input type=checkbox checked name=remember value=1> Keep me logged in on this computer for the next 31 days or until I log out</td></tr> <tr><td align=center class="login_form"> <a href="?cmd=Forgot">Forgot password?</a></td></tr> <tr><td align=center class="login_form_bottom"><input type="submit" class="login_submit" value="Submit"></td></tr></table> <center><a class="bottomlink" title="Goto ELOG home page" href="https://midas.psi.ch/elog/">ELOG V3.1.3-7933898</a></center></form></body></html>

As you can see, curl only prints the login page of the logbook and no new entry has been created. Any suggestions what might go worng here?

Regards,
Florian

69210

Wed Sep 2 11:56:04 2020

Re: Using curl to post new entries

After going through the code of the Python API (https://github.com/paulscherrerinstitute/py_elog/blob/master/elog/logbook.py) I tried the following:
$ python3 >>> from passlib.hash import sha256_crypt >>> sha256_crypt.hash( 'foobaa', salt='', rounds=5000)[4:] 'waa2sT6eBt.qk0wsucX/nxU5GcqffqlEx6ja5Lg1OR5' >>> from datetime import datetime >>> datetime.now().timestamp() 1599039390.964989 $ curl -F cmd=Submit -F exp=labor -F unm=florian -F upwd='waa2sT6eBt.qk0wsucX/nxU5GcqffqlEx6ja5Lg1OR5' -F Encoding=plain -F When=1599039390.964989 -F Author=curl -F Subject="curl test" -F Category=General -F Type=Diary -F Text="foo baa" http://localhost:8080/test/

This worked. It seems to me, that the "-u" option from Curl is not working for elog.

Cheers,
Florian

Florian Feldbauer wrote:

Hey,

As you can see, curl only prints the login page of the logbook and no new entry has been created. Any suggestions what might go worng here?

Regards,
Florian

69221

Mon Sep 21 09:17:52 2020

Query to get values for Attributes

Hey,

I'm trying to integrate the Elog into our SlowControl System (Phoebus/EPICS). As a first step I translated the python library to Java. So writing new Entries and viewing them works.
But for Phoebus, you need a list of the possible values for the attributes. Currently this is done via the config file from Phoebus.

Is there a way to get the values also via a query directly from the Elog?

Cheers,
Florian

69223

Tue Sep 22 09:27:45 2020

Re: Query to get values for Attributes

Thanks for the tipp. I managed to use XPATH to get the values for my Type and Category attributes!

The API, I'm developing for Phoebus is quiet simple. It currently just supports Author, Subject, Type and Category as attributes and the latter two are just lists of values.

Andreas Luedeke wrote:

That would be a nice feature...

If you are good in parsing HTML you can achieve this feature: when you create a new entry "<elog-URL>?cmd=new", you'll get HTML source code that provides you with all possible attribute choices.

Disclaimer: this only works if you don't use Conditional attributes.

Florian Feldbauer wrote:

Hey,

Is there a way to get the values also via a query directly from the Elog?

Cheers,
Florian

69261

Wed Nov 25 15:10:34 2020