Fixed-length text file to database script
Diez B. Roggisch
deets at nospam.web.de
Thu Aug 14 13:11:26 CEST 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?
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?
More information about the Python-list