ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
67545
|
Tue Jul 2 22:05:06 2013 |
| Jim Tinlin | jim@tinlin.net | Bug fix | All | 2.9.2-2481 | Re: Export entries to XLS or CSV? |
Stefan Ritt wrote: |
Andreas Luedeke wrote: |
Jim Tinlin wrote: |
Andreas Luedeke wrote: |
scogordo wrote: |
I've been asked to export one of our logbooks to xls or csv. Doable?
Thanks,
Scott
|
Hi Scott,
yes, every user can export entries using the "find" command.
Just select the export format in the first line
Export to:
  ⇄
Detect language » English
I often use the XML Format, but CSV is fine if you just want to import the entries to some spreadsheet program.
I was shocked to find out that this feature has not yet made it into the documentation?!? But it is that simple to use that there is not much to document.
There is even an "Import" command, to reimport entries from a file. But this is tricky to use: if you have fields of type date or datetime, then you have to convert those fields in the proper format.
|
I tried EXPORTING logbooks as .csv but have not been fully successful. Elog seems to only export the data entered for various fields with the exception of the text field.
Here is an example export from my logbook (used to track simulator problems), I would like to also export the TEXT field so it can be used by my managers in excel...but as you can see there is no entry for "TEXT" fields...
Thanks in advance!
"Message ID","Date","Author","Type","Status","Priority"
107,Thu 30 May 2013 11:28:57 -0700,"Jim Tinlin","Graphic Display","Evaluated","Low"
106,Thu 30 May 2013 10:02:24 -0700,"Jim Tinlin","Graphic Display","Identified","Low"
105,Thu 30 May 2013 08:07:27 -0700,"Jim Tinlin","Problem ID","Identified","Medium"
104,Thu 30 May 2013 08:04:30 -0700,"Jim Tinlin","Problem ID","Identified","Medium"
103,Wed 29 May 2013 09:36:11 -0700,"Jim Tinlin","Problem ID","Evaluated","High"
102,Wed 29 May 2013 08:58:02 -0700,"Jim Tinlin","Problem ID","Evaluated","High"
|
Yes, you're right: the text field is only exported in XML and Raw mode.
It is questionable how EXCEL should cope with HTML or ELCode output from the text fields.
But I admit that this would be a useful feature for logbooks that only use plain text entries. And it is simple to implement.
I've attached a patch to elogd.c from elog-2.9.2-2081 that adds a third CVS mode 'CSV (";" separated) + Text'.
(This string has not yet been added to the localization.)
As far as I've tested it works fine to import the text to OpenOffice and EXCEL, even with multiple text lines and HTML code in the text.
Of course the spreadsheet programs just display the HTML source.
Stefan, do you think this should be added to the official branch?
 ⇄
Detect language » English
⇄
Detect language » English
|
Hi Jim, can you confirm that this works for you? If so, I'm willing to incorporate the patch into the distribution.
|
Has this been added yet?
I don't have the means to create an executable for Windows, if someone does I can give it a try...it sounds/looks like it will work.
Thanks! |
67544
|
Mon Jul 1 13:30:28 2013 |
| Andreas Luedeke | andreas.luedeke@psi.ch | Question | Linux | 2.9.2-2455 | Re: update to ckeditor (formerly: Auto save?) |
Stefan Ritt wrote: |
Andreas Luedeke wrote: |
Daniel Roldan wrote: |
Hi,
One question, is possible activate auto-save while write a new "ticket"?
Thanks very much.
|
It is not clear to me, what you mean by "activate auto-save".
Do you mean that you want to have the typed in data in your forms temporarily saved, to be restored e.g. after a crash of the browser?
This functionality has to be provided by the browser. I use the add-on "Lazarus: form recovery" for firefox, that works fine for me.
⇄
Detect language » English
Regards Andreas
|
Great that you pointed out this possibility. I saw that Lazarus Form Recovery is even available for Google Chrome and it works fine. It however works only for the "EL Code" and "plain" encodings. In the "HTML" edit box it does not work (probably some collision with the FCKEditor). If anybody has an idea about this, please post it.
/Stefan
|
Hi Stefan,
that reminds me of something: you've wanted to upgrade from the obsolete FCKEditor to the successor CKEditor. That would allow to use the cool editor for math formulas: http://www.fmath.info/plugins/CKEditor/demo.jsp
⇄
Detect language » English
http://www.fmath.info/plugins/CKEditor/demo.jsp
Cheers, Andreas |
67543
|
Mon Jul 1 09:59:18 2013 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Linux | 2.9.2-2455 | Re: Auto save? |
Andreas Luedeke wrote: |
Daniel Roldan wrote: |
Hi,
One question, is possible activate auto-save while write a new "ticket"?
Thanks very much.
|
It is not clear to me, what you mean by "activate auto-save".
Do you mean that you want to have the typed in data in your forms temporarily saved, to be restored e.g. after a crash of the browser?
This functionality has to be provided by the browser. I use the add-on "Lazarus: form recovery" for firefox, that works fine for me.
⇄
Detect language » English
Regards Andreas
|
Great that you pointed out this possibility. I saw that Lazarus Form Recovery is even available for Google Chrome and it works fine. It however works only for the "EL Code" and "plain" encodings. In the "HTML" edit box it does not work (probably some collision with the FCKEditor). If anybody has an idea about this, please post it.
/Stefan |
67542
|
Mon Jul 1 09:39:52 2013 |
| Andreas Luedeke | andreas.luedeke@psi.ch | Question | Linux | 2.9.2-2455 | Re: Auto save? |
Daniel Roldan wrote: |
Hi,
One question, is possible activate auto-save while write a new "ticket"?
Thanks very much.
|
It is not clear to me, what you mean by "activate auto-save".
Do you mean that you want to have the typed in data in your forms temporarily saved, to be restored e.g. after a crash of the browser?
This functionality has to be provided by the browser. I use the add-on "Lazarus: form recovery" for firefox, that works fine for me.
⇄
Detect language » English
Regards Andreas |
67541
|
Fri Jun 28 10:43:03 2013 |
| Daniel Roldan | droldan@cells.es | Question | Linux | 2.9.2-2455 | Auto save? | Hi,
One question, is possible activate auto-save while write a new "ticket"?
Thanks very much. |
67540
|
Wed Jun 26 13:41:47 2013 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Linux | 2.9.2 | Re: Image attachments null in e-mails. Error log? |
Daniel Campora wrote: |
Hi there :)
I'm having a problem with the e-mail notification on my installation of elog. I'm testing the attachment upload with images, and it seems to work seamlessly. However upon posting, the e-mail notification sends a null attachment, instead of the image I would expect.
Is there an error log I can check for this? I started the elog process without the daemon option, but I can't see any error coming up.
Cheers,
|
Some people reported that there is a problem if you don't have ImageMagick installed. So please install that package and try again.
Cheers,
Stefan |
67539
|
Wed Jun 26 10:10:45 2013 |
| Andreas Luedeke | andreas.luedeke@psi.ch | Question | Linux | 2.9.2 | Re: Image attachments null in e-mails. Error log? |
Daniel Campora wrote: |
Hi there :)
I'm having a problem with the e-mail notification on my installation of elog. I'm testing the attachment upload with images, and it seems to work seamlessly. However upon posting, the e-mail notification sends a null attachment, instead of the image I would expect.
Is there an error log I can check for this? I started the elog process without the daemon option, but I can't see any error coming up.
Cheers,
|
This is one of the few exceptional cases where reading the documentation can actually help: https://midas.psi.ch/elog/config.html#global
⇄
Detect language » English
https://midas.psi.ch/elog/config.html#global
You can turn on logging using the "Logfile=<filename>" command in the elogd.cfg configuration. With "Logging level=3" you see all elog access, but sending email is in the log anyway. |
67538
|
Tue Jun 25 19:31:56 2013 |
| Daniel Campora | dcampora@cern.ch | Question | Linux | 2.9.2 | Image attachments null in e-mails. Error log? | Hi there :)
I'm having a problem with the e-mail notification on my installation of elog. I'm testing the attachment upload with images, and it seems to work seamlessly. However upon posting, the e-mail notification sends a null attachment, instead of the image I would expect.
Is there an error log I can check for this? I started the elog process without the daemon option, but I can't see any error coming up.
Cheers,
|
|