Fixed-length text file to database script

Diez B. Roggisch deets at nospam.web.de
Thu Aug 14 13:11:26 CEST 2008


Stacey wrote:

> Hi Guys,
> 
> I'm new to Python (mostly) and I'm wanting to use it for a new project
> I'm faced with.
> 
> I have a machine (PLC) that is dumping its test results into a
> fixed-length text file.  I need to pull this data into a database
> (MySQL most likely) so that I can access it with Crystal Reports to
> create daily reports for my engineers.
> 
> I've been reading the Python manual for about a week now and I'm
> learning a lot.  Unfortunately, I was given a deadline today that I
> cannot meet without a little help.
> 
> I need to know how to write a script that will DAILY pull this text
> file into a MySQL database.
> 
> Can anyone show me how to do this?

Show us code & data, and we show you how to improve the code.

Or would you be able to write the script with the above information?

Diez



More information about the Python-list mailing list