Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon1.gif   elog2sql - a script to convert elog logbooks to a MySQL database, posted by Fred Hooper on Thu Jul 3 07:25:49 2003 
    icon2.gif   Re: elog2sql - a script to convert elog logbooks to a MySQL database, posted by Pelle on Sat Apr 23 08:56:26 2011 
       icon2.gif   Re: elog2sql - a script to convert elog logbooks to a MySQL database, posted by Pelle on Sat Apr 23 14:32:38 2011 
Message ID: 387     Entry time: Thu Jul 3 07:25:49 2003     Reply to this: 67054
Icon: Entry  Author: Fred Hooper  Author Email: fhooper@sushisoft.com 
Category: Info  OS: Linux  ELOG Version: 2,3.8 
Subject: elog2sql - a script to convert elog logbooks to a MySQL database 
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.
ELOG V3.1.4-ead6bbc