ELOG Forum

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.

Attachment 1: elog-find.png

67517

Thu May 30 22:52:51 2013

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: CSV ("," separated) CSV (";" separated) XML Raw

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"

67518

Fri May 31 11:41:48 2013

Andreas Luedeke

andreas.luedeke@psi.ch

Bug fix

All

2.9.2-2481

Re: Export entries to XLS or CSV?

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: CSV ("," separated) CSV (";" separated) XML Raw

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.

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?

Attachment 1: diff.txt

11645,11650d11644
<    if (strieq(mode, "CSV3"))
<       rsprintf("<input type=radio id=\"CSV3\" name=\"mode\" value=\"CSV3\" checked>");
<    else
<       rsprintf("<input type=radio id=\"CSV3\" name=\"mode\" value=\"CSV3\">");
<    rsprintf("<label for=\"CSV3\">%s&nbsp;&nbsp;</label>\n", loc("CSV (\";\" separated) + Text"));
< 
19535c19529
<    csv = strieq(mode, "CSV1") || strieq(mode, "CSV2") || strieq(mode, "CSV3");
---
>    csv = strieq(mode, "CSV1") || strieq(mode, "CSV2");
20266,20268c20260
<          } else {
<             if (strieq(mode, "CSV3"))
<                 rsprintf(";\"Text\"");
---
>          } else
20270d20261
<          }
20973,20987c20964
<             } else {
<                if (strlen(text)>0 && strieq(mode, "CSV3")) {
<                   rsprintf(";");
<                   strlcpy(str, text, sizeof(str));
<                   rsputs("\"");
<                   pt1 = str;
<                   while ((pt2 = strchr(pt1, '"')) != NULL) {
<                      *pt2 = 0;
<                      rsputs(pt1);
<                      rsputs("\"\"");
<                      pt1 = pt2 + 1;
<                   }
<                   rsputs(pt1);
<                   rsputs("\"");
<                }
---
>             } else
20989d20965
<             }

67526

Tue Jun 4 12:38:01 2013