Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   Export entries to XLS or CSV?, posted by scogordo on Wed May 15 17:24:12 2013 
    icon2.gif   Re: Export entries to XLS or CSV?, posted by Andreas Luedeke on Wed May 15 23:31:30 2013 elog-find.png
       icon2.gif   Re: Export entries to XLS or CSV?, posted by Jim Tinlin on Thu May 30 22:52:51 2013 
          icon2.gif   Re: Export entries to XLS or CSV?, posted by Andreas Luedeke on Fri May 31 11:41:48 2013 diff.txt
             icon2.gif   Re: Export entries to XLS or CSV?, posted by Stefan Ritt on Tue Jun 4 12:38:01 2013 
                icon2.gif   Re: Export entries to XLS or CSV?, posted by Jim Tinlin on Tue Jun 4 16:17:22 2013 
                icon2.gif   Re: Export entries to XLS or CSV?, posted by Jim Tinlin on Tue Jul 2 22:05:06 2013 
                   icon2.gif   Re: Export entries to XLS or CSV?, posted by Andreas Luedeke on Thu Jul 4 15:27:13 2013 elog-2.9.2-2481_cvs3patch.diff
                      icon2.gif   Re: Export entries to XLS or CSV?, posted by Stefan Ritt on Fri Feb 21 13:25:55 2014 
Message ID: 67505     Entry time: Wed May 15 23:31:30 2013     In reply to: 67504     Reply to this: 67517
Icon: Reply  Author: Andreas Luedeke  Author Email: andreas.luedeke@psi.ch 
Category: Question  OS: Windows  ELOG Version: ELOG V2.7. 
Subject: Re: Export entries to XLS or CSV? 

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
 
 
Detect language » English
 
 
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.

Attachment 1: elog-find.png  88 kB  | Hide | Hide all
elog-find.png
ELOG V3.1.5-fe60aaf