Validating Uploaded Files

[gmail2]

OK I'll try to explain this as best I can. I've got a form which will be used to upload CSV files. the CSV files are then inserted in to a MySQL database. There are 4 different files and the user will select which table to put the file into. However, obviously the tables aren't all the same structure. Some have dates in certain columns etc. So how can I say if tablename is this - use this template to format the data. if tablename is soemthing else, use a different template? I don't even know if template is the right word I'm looking for. I just thought maybe it was possible to create a "template file" which says format field 1 as text, field 2 as maketime() etc etc.

Hopefully somebody can help me out???

 

[BabyJeffy]

Personally I scan the first line of the CSV file (which contains the headings of columns for my datasets) and use that to decide what table I will insert the CSV into. I believe you will have to do some of your own processing to make this decision.

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/

http://www.codecouch.com/jeff/blog/

[/tt]

What is Javascript? FAQ216-6094