| ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
|
67517
|
Thu May 30 22:52:51 2013 |
 | Jim Tinlin | jim@tinlin.net | Question | Windows | ELOG V2.7. | Re: Export entries to XLS or CSV? |
| 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
⇄
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" |
|
67529
|
Tue Jun 4 16:17:22 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.
|
I do not have the ability to compile a Windows executable, if someone does I'd be happy to test it out and report my results.
Thank you in advance! |
|
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! |
|
66815
|
Tue May 11 19:14:37 2010 |
 | Jim Covert | jim.covert+elog@gmail.com | Question | Windows | 2.7.8-2293 | HTML email format displays plain text if email client is offline | My elog server is hosted behind a firewall and I use a VPN client to connect to the network on which it is hosted. When I'm logged into the VPN emails from elog display fine, but when I'm not connected to the VPN emails display in plain text because the email client is unable to load "default.css" since it's behind a firewall.
Is there a way to include the style information in the HTML email rather than in a separate file that's hosted on the elog server? |
|
66918
|
Mon Oct 11 10:27:26 2010 |
 | Jianglai Liu | jianglai.liu@sjtu.edu.cn | Question | Linux | 2.8.0 | automated email notification did not work for me | Hi,
I am setting up an elog to organize my lab activities. I installed elog 2.8.0 on the latest CentOS 5.5, 32 bit. I got into trouble setting up the automated email notification.
According to the elog manual, I setup the smtp setting in the elogd.cfg as follows:
SMTP host = smtp.gmail.com
SMTP username = jianglai.liu
I then used "elogd -t" to encode the password into the configuration file.
But when I submit an entry, I always received: "Error sending Email via "smtp.gmail.com": 5.7.0 Must issue a STARTTLS command first. y17sm867489wfd.15"
If I switched to use my university email servers, similar things happened.
SMTP host = smtp.sjtu.edu.cn
SMTP username = jianglai.liu
I got "Error sending Email via "smtp.sjtu.edu.cn": 5.7.8 Error: authentication failed: another step is needed in authentication"
I also switched to use one of my old work server
SMTP host = smtp-server.its.caltech.edu
SMTP username = jliu
and ended up with the same error message.
I did a google search on this without much progress. I would appreciate it very much if someone could shed light on how do I fix this.
Thanks much! |
|
1539
|
Sat Dec 3 23:32:13 2005 |
| Jesse Wodin | jwodin@stanford.edu | Question | Linux | 2.6.0 | Upgrade from 2.3.8 to 2.6.0 logbook problem | Hi, I'd like to upgrade from an old version of elog 2.3.8 to 2.6.0. I installed the new version, and it runs fine, but it doesn't seem to see my old logbooks (the path in the conf file is correct). Do I have to upgrade my logbooks somehow?
THanks!
Jesse |
|
1541
|
Wed Dec 7 02:32:00 2005 |
| Jesse Wodin | jwodin@stanford.edu | Question | Linux | 2.6.0 | Re: Upgrade from 2.3.8 to 2.6.0 logbook problem | Thanks, you were right, it was just a permissions problem on the logbooks, which I had copied over as root.
j. |
|
1542
|
Wed Dec 7 02:37:40 2005 |
| Jesse Wodin | jwodin@stanford.edu | | | | Proxy question | I'm trying to run elog 2.6.0-beta4 under Apache 2.0. I follow the directions, and everything works fine, so my
elog runs as
http://grattalab3.stanford.edu/elog/
running under port 8082, with the following lines in my httpd.conf file
Redirect permanent /elog http://grattalab3.stanford.edu/elog
ProxyPass /elog/ http://grattalab3.stanford.edu:8082/
This machine has an alias, which is http://exo-elog.stanford.edu. My question is, how can I run elog so that
when someone types in this name, it brings up my elog? I know that I can make a VirtualHost entry and put a
redirect at the document root of that virtual host, but that seems clumsy. Can I just modify ProxyPass or add a
Redirect statement somehow?
Thanks! |
|