ajax csv import

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