You have to put "Last x" in the menu, not "Last day". Unfortunately by default the label "Last day" does not show up. I fixed this in the current version. But you can yourself start this thing by adding "past1" to the URL, or by making yourself a bookmark in your browser. Like

https://midas.psi.ch/elogs/Forum/past1

then the "Last 2 days" will show up.

 Thanks very much, Stefan.

I did not know "Last x" was the appropriate menu option.
--Mike

Announcing:  elog2sql

elog2sql was created to help translate logbooks created by the program
``elog'' from the native elog flat file format to a MySQL database.  I had a
need to have the elog data in a database, and it appears from the forum that
several others had a similar need.

 I created a set of perl scripts that will allow the translation of elog
logbooks into a MySQL database. The design and implementation of these
scripts are a simple one, and allow the one-time copying of a set of logbooks.

The elog2sql toolkit consists of two scripts. The first script, parsecfg.pl,
reads a elogd.cfg, and creates a sql file that will create a set of db
tables corresponding to elog logbooks. The second script, parselog.pl, takes
a set of elog logfiles, and creates a sql file that will enter the logbook
data into the database. The result is a copy of the elog logbook that can
used as desired inside the framework of MySQL. Attachments are handled by
inserting an entry of the attachment name into an seperate attachment table.
This allows multiple attachments per entry.

You can download the elog2sql program archive at
http://www.davidfannin.com/elog2sql/elog2sql.tar.gz . It contains the
scripts and basic documentation.  You can read the man page at
http://www.davidfannin.com/elog2sql/index.html 

email for questions or comments.

I know this thread was started 2003 but if anyone have this MySQL export script please attach it to this thread.

Thanks,

Pelle

> > I know this thread was started 2003 but if anyone have this MySQL export script please attach it to this thread. > > Thanks, > > Pelle

Sorry, found it in the contribution list https://midas.psi.ch/elogs/Contributions/5

Hi,

when i try to send a form after edit or create an entry i got this message : Connection closed by remote server

is there any idea

thanks

Hi!

I like to format an Elog "directory" such that all entries make/occur as a table. Say: 5 columns and a large number of rows. In a sense, make an excel spreadsheet in Elog. Is this possible? How can this be done? Is there perhaps a template?

Thanks in advance.

Walter Reviol

reviol@anl.gov

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:

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