MySQL Forums
Forum List  »  Perl

insert data into mysql database
Posted by: aiswarya pawar
Date: October 21, 2010 12:31AM

Am looking for a perl script which will take up the lab data which is in text format into my mysql database. Lab devices produce data that is directly stored in text files. The format differs for each device and is not ideal for direct database import. I require perl scripts that can parse the data from these text files and import them into a normalized database.

Main things am looking for is-

- Is easily maintainable
- Is very transparent in that it can be easily followed (well commented)
- Contains quality checks that can produce error codes
- Can directly import the parsed data into a MySQL database
- Is independent of the order of text file content (ie. position of a header, line number of header etc.)
- Uses regular expressions (will help with quality checks)
- Runs fast


i need this as early as possible. please do help me with this.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
insert data into mysql database
October 21, 2010 12:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.