DB import tool script lets you upload and import a tab separated text file


Category:
Scripts
Perl
Requirements:
Seller:
Price:
-
System:
Rating:
4.6
License:

Description - DB import tool script lets you upload and import a tab separated text file



This script lets you upload and import a tab separated text file into an SQL database. It`s so easy to use! The script takes a table name on the first line, then a list of fields (tab delimited) on the second. Each following line has a record (tab delimited) on it. A blank line will reset, and the script will again look for a line with a table name on it, then a line with a field list on it. The script makes a web PaGE that shows you what kind of import you`re going to get before it actually does anything. A word of caution, though: The script is currently set up to erase all data before importing! That works great when the data is being maintained offline and uploaded periodically. For other situations you`d want to make an easy code modification to change this. Integer or unquoted fields must be named with an i_ at their start in order for the script to format the SQL correctly. This may make the script hard to use in many existing setups.



More in Perl-DB import tool script lets you upload and import a tab separated text file

Separated Text Text File Tab Separated Text