Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon1.gif   Calculations & Interfacing a DataBase with Elog., posted by John on Sat Jun 22 06:52:32 2019 
    icon2.gif   Re: Calculations & Interfacing a DataBase with Elog., posted by Stefan Ritt on Sat Jun 22 10:07:08 2019 
       icon2.gif   Re: Calculations & Interfacing a DataBase with Elog., posted by John on Sat Jun 22 10:21:39 2019 
Message ID: 68991     Entry time: Sat Jun 22 10:21:39 2019     In reply to: 68990
Icon: Reply  Author: John  Author Email: secondcomingtechnologies@fastmail.com 
Category: Other  OS: Linux | Windows | Mac OSX | All | Other  ELOG Version: ELOG V3.1.2-bd7 
Subject: Re: Calculations & Interfacing a DataBase with Elog. 

Thanks Stefan soo much. As I've said, I will update this post(s) as I make any progress :)

John

Stefan Ritt wrote:

Yes elog stores data in a flat file database. Go to your logbook directory and look for files YYMMDDa.log where you find all data. Some people do a post submit call to scripts, other integrate JS directly on each page (e.g. via "bottom text" option where you can load a whole JavaScript file), then pick the fields and do calculations directly in the edit window.

Stefan

John wrote:

Hi, I am trying to calculate two or more Elog fields and then return the value to Elog. I am currently learning Perl to do this. I realize JS can do this.. but so can IBM Basic ;)  I am savy with other db techniques like sql. My question is before I get too far along with this project, is it safe to say the current storage of Elog data is 'Flat File' database? I also want to find out if it would be better to try and grab the data prior OR  after it gets into the Elog database. I see there are other forum messages related to sql interfacing and such, but nothing conclusive.  I will submit my personal progress here. Thanks again, John

 

 

ELOG V3.1.5-3fb85fa6