| ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
|
69822
|
Thu Aug 8 09:07:45 2024 |
 | Stefan Ritt | stefan.ritt@psi.ch | Question | All | 2 | Re: Can Elog make a table? |
I'm not exactly sure what you want to do, but there are two options in elog:
1) Insert directly a table like this one:
| Index |
Value |
| first |
123 |
| second |
432 |
2) Use one ELOG entry as a row in a table. You can try this by clicking on "List" here in the Forum should you not already see the list display, then on "Summary" which give you a spreadsheet like display, where you can specify in the config file which columns of the ELOG entries you want to see. See also the demo here: https://elog.psi.ch/elogs/Linux+Demo/
Best,
Stefan |
|
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
|
|
|
68991
|
Sat Jun 22 10:21:39 2019 |
| John | secondcomingtechnologies@fastmail.com | Other | Linux | Windows | Mac OSX | All | Other | ELOG V3.1.2-bd7 | 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
|
|
|
|
67471
|
Wed Apr 3 15:09:09 2013 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | 2.9.2-2456 | Re: Calculate with dates |
| UlfO wrote: |
|
Hi,
Is it possbile to compare dates in E-log?
And based on that calculation have conditonal formats on certain attributes.
We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.
And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.
Regards
/UlfO
|
This is a good idea, but not implemented. I will put this on the wishlist.
/Stefan |
|
67473
|
Wed Apr 3 19:08:22 2013 |
| David Pilgram | David.Pilgram@epost.org.uk | Question | Windows | 2.9.2-2456 | Re: Calculate with dates |
| Stefan Ritt wrote: |
|
| UlfO wrote: |
|
Hi,
Is it possbile to compare dates in E-log?
And based on that calculation have conditonal formats on certain attributes.
We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.
And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.
Regards
/UlfO
|
This is a good idea, but not implemented. I will put this on the wishlist.
/Stefan
|
Please add my vote for this on the wishlist. |
|
67475
|
Thu Apr 4 17:54:23 2013 |
| UlfO | ulf.olsson@dynamate.se | Question | Windows | 2.9.2-2456 | Re: Calculate with dates |
| Stefan Ritt wrote: |
|
| UlfO wrote: |
|
Hi,
Is it possbile to compare dates in E-log?
And based on that calculation have conditonal formats on certain attributes.
We have a need to monitor a date attribute named "Preferred finished date" on records placed in E-log.
And if SYSDATE is greater than the "Preferred finished date" we want to mark certain attibutes with a color.
Regards
/UlfO
|
This is a good idea, but not implemented. I will put this on the wishlist.
/Stefan
|
Thanks
Give it a vote from me.
|
|
2299
|
Tue Jul 24 08:30:02 2007 |
| Stefan Ritt | stefan.ritt@psi.ch | Bug report | | 2.6.5-1872 | Re: CVS import + french = impossible |
| toumbi wrote: | Hi ,
I found a bug , when I want to import a cvs file and if i had set Language=french into global , I m not allowed.Erreur : commande "CSV Import" non autorisée
Utilisez le bouton "page précédente" de votre navigateur pour revenir en arrière
there is no problem if i use english. |
This bug has been fixed in SVN revision 1892 and will be contained in the next release. |
|
320
|
Tue May 6 11:34:22 2003 |
| Stefan Ritt | stefan.ritt@psi.ch | Info | | | Re: CVS URL |
> Can anyone tell me the URL for the CVS download section
>
> the link has gone from one of the main screens
>
> Cheers
The message stating the URL is still in this forum: elog:233 |