Fixed-length text file to database script

Stacey ssharp at thomsonplastics.com
Wed Aug 13 17:04:49 EDT 2008


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?

Thanks in advance

Stacey




More information about the Python-list mailing list