Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG, Page 107 of 806  Not logged in ELOG logo
ID Date Icon Author Author Email Category OS ELOG Version Subject
  68990   Sat Jun 22 10:07:08 2019 Reply Stefan Rittstefan.ritt@psi.chOtherLinux | Windows | Mac OSX | All | OtherELOG V3.1.2-bd7Re: Calculations & Interfacing a DataBase with Elog.

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

 

  68989   Sat Jun 22 06:52:32 2019 Entry Johnsecondcomingtechnologies@fastmail.comOtherLinux | Windows | Mac OSX | All | OtherELOG V3.1.2-bd7Calculations & Interfacing a DataBase with Elog.

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

  68988   Sat Jun 15 23:44:35 2019 Reply Frank Baptistacaffeinejazz@gmail.comQuestionWindows3.3Re: enable batch file execution

I have not tried these, but since CKeditor works so well, you may want to consider taking a look at integrating jQuery Calx or jExcel...just for fun.

Stefan Ritt wrote:

I meant to use it instead of ELOG. Spreadsheets allow calculaiton of dates, etc. So you can achieve what you need. Again: WHAT YOU WANT IS NOT POSSIBLE WITH ELOG.

dev wrote:

Is it as good as Microsoft excel  sheet.

but how can achieve my aim of calculation  how how to integrate it with elog 

Sorry for disturbing yau again and again 

 

Stefan Ritt wrote:

https://docs.google.com/spreadsheets

dev wrote:

Sir, how to use that spreadsheet 

can the calculation is possible by running a batch file . 

Stefan Ritt wrote:

This is not possible with ELOG. May I suggest that you use a spreadsheet for that.

dev wrote:

First of all thanx for your kind help. Kindly help me on the following problem.

I have a logbook which keeps the record of all fault booked by different subscriber.this logbook has three attribute downtime,uptime & total duration (date &time format) . I want to calculate the total duration automatically whenevr uptime value is given and if the uptime is not given it should calculate depending upon the system present time.pleas explain it with example.

thanking you 

Stefan Ritt wrote:

May I kindly ask you to Google how to start/stop a service from the command line.

dev wrote:

From the command mode i am not able to stop and start  (elogd stop). But i can start/stop from services  .Kindly help  me stopping/starting it from command 

Stefan Ritt wrote:

Stop the old server first, but we told you this already on elog:67770. If you don't follow our suggestions we cannot help you.

dev wrote:

I tried it but still it gives error like Shell execution not enabled via -x flag 

 

Stefan Ritt wrote:

Modify the server start command in the Windows Registry. Or start the elogd server directly in a command window with "elogd -x", after "cd" to the elog installation directory.

dev wrote:

How to enable the batch file execution in elogd

 

 

 

 

 

 

 

 

 

 

 

 

  68987   Fri Jun 14 12:43:04 2019 Reply Stefan Rittstefan.ritt@psi.chBug reportAll3.1.4Re: Find cannot find values with brackets

I‘m happy to merge the PR after a quick test next week.

Stefan

Sebastian Schenk wrote:

For demonstration, I created https://elog.psi.ch/elogs/Linux+Demo/8

The Find search for category aaa(bb) does not give results.
A quick filter corrects the value to aaa\(bb) and delivers results.

I made a simple fix and submitted it as PR to the bitbucket repository.

 

  68986   Fri Jun 14 11:29:30 2019 Warning Sebastian Schenksebastian.schenk@physik.uni-halle.deBug reportAll3.1.4Find cannot find values with brackets

For demonstration, I created https://elog.psi.ch/elogs/Linux+Demo/8

The Find search for category aaa(bb) does not give results.
A quick filter corrects the value to aaa\(bb) and delivers results.

I made a simple fix and submitted it as PR to the bitbucket repository.

  68985   Tue May 21 17:20:19 2019 Reply Stefan Rittstefan.ritt@psi.chQuestionWindows3.1.4Re: Write by a .dll instead of the elog.exe

I presume you want to write from another program. You can call a command line shell (done via the "system()" command under C) which then calls the elog executable. If you absolutely want a DLL, you can einter try to compile one yourself using the fuctions in elog.c, or use the curl DLL with which you can also submit elog entries. See elog:68597 for usage of curl. While curl is usually executed from the command line, there is also a curl library containing the same functionality. See https://curl.haxx.se/windows/

Marcel Krenz wrote:

Dear All,

 

is it possible to write to the elog instead of the Command line throug a .dll

 

Best

MK

 

  68984   Tue May 21 15:42:46 2019 Reply Finn Junkerfj@tvis.netQuestionLinux | Windows3.1.3Re: Pinned entry

Hello Stefan

Works great and very usefull - but not when you use reverse sort = 1?.

Is there a way to get both. Pinned first and then the rest i reversed order (highest ID on page 1)

Kind Regards Finn

Stefan Ritt wrote:

This is not directly possible, but you can configure it with a trick. Create an attribute "pinned", make it of type "boolean", and set the start page such that it sorts using the "pinned" attribute:

Atributes = ..., Pinned
Options Pinned = boolean
Start page = ?rsort=Pinned

This move all entries where "Pinned" is true to the top of the list.

Stefan

 

Giuseppe Cucinotta wrote:

Hi everybody,

sorry if this question has already been posed (I did a quick search but I didn't found anything): elog sorts entry by ID, I wonder if it is possible to pin an entry in order to be always on top of the page independently on its ID.

Thanks

Giuseppe

 

 

  68983   Tue May 21 15:05:25 2019 Question Marcel Krenzkrenz@fhi-berlin.mp.deQuestionWindows3.1.4Write by a .dll instead of the elog.exe

Dear All,

 

is it possible to write to the elog instead of the Command line throug a .dll

 

Best

MK

ELOG V3.1.5-3fb85fa6