I would like a webpage that can import csv files and fixed width files using a format definition (see below).
The user can select a file, it is that echod back into a textarea or paste csv straight into text area.
It should use the right format definition below to convert into correct fields/format (sql field format)
After find a correct format send the data to the server using ajax (send 500 records at once),
i no format found then send plain data into other table (optional)
I added a htm file that parses the csv file already. only converting to destination format needs to be coded.
it is not a difficult design, will take 1-2 days i estimate.
// filedef: ['formatname']= "[sepchar],fielddef[,fielddef]]";
// fielddef: importfieldname[:xx]:datatype:newfieldname
// xx= is fixed fieldsize
// datatype= ['string','date','float']
// every csv value is checked against a datatype, maxlength
// make a function for every datatype that convert the value to the destination format (sql format)
var aFormats= new Array()
// Example of postbank format (only first 2 fields implemented)
aFormats["postbank_csv"]= ",,datum:date:docdate,naamomschrijving:string:description,rekening,tegenrekening,code,afbij,bedrag(eur),mutatiesoort,mededelingen";
if you hv any questions let me know,
hope to get a good offer, in the future it needs to be updated with different formats.
regards,
Niek
I can implement the YII php framework in this project and it makes your performance very fast and the website become very light to handle requests. And also can use java script libraries and css3 to make the user interface very rich and cool.