Fixed-length text file to database script

Larry Bates larry.bates at`
Thu Aug 14 00:47:28 CEST 2008

ssharpjr at 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?
> Thanks
> Stacey

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 
CSV, etc.).


More information about the Python-list mailing list