Fixed-length text file to database script
larry.bates at websafe.com`
Thu Aug 14 00:47:28 CEST 2008
ssharpjr at gmail.com 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?
Just use the built in import SQL statement to import the information. You don't
really need a Python script. import can handle fixed field records (as well as
More information about the Python-list