ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
68990
|
Sat Jun 22 10:07:08 2019 |
| Stefan Ritt | stefan.ritt@psi.ch | Other | Linux | Windows | Mac OSX | All | Other | ELOG V3.1.2-bd7 | Re: 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 |
| John | secondcomingtechnologies@fastmail.com | Other | Linux | Windows | Mac OSX | All | Other | ELOG V3.1.2-bd7 | Calculations & 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 |
| Frank Baptista | caffeinejazz@gmail.com | Question | Windows | 3.3 | Re: 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 |
| Stefan Ritt | stefan.ritt@psi.ch | Bug report | All | 3.1.4 | Re: 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 |
| Sebastian Schenk | sebastian.schenk@physik.uni-halle.de | Bug report | All | 3.1.4 | Find 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 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | 3.1.4 | Re: 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 |
| Finn Junker | fj@tvis.net | Question | Linux | Windows | 3.1.3 | Re: 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 |
| Marcel Krenz | krenz@fhi-berlin.mp.de | Question | Windows | 3.1.4 | Write 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 |