Hello All

Could anybody give me any idea's on a problem I am having. I have been on the W3 schools excellent site and used their PHP upload script, found at the link below.

http://www.w3schools.com/php/php_file_upload.asp

This works great except for one small problem. I don't want to upload image files' I want to upload a CSV file to the server. From there I want to import it into MySql, which I have written a script for and it is working fine.

However, trying to upload a CSV file returns the message "File Invalid". Any idea's on what is required to allow CSV uploads?

Just to give you some background, this is for a project at work, we have been told there is no chance of IT doing it, but the senior management are happy for us to "dabble" and see what we can come up. It will be hosted externally, but entered through a Login system. It will basically be a CSV file of stock info loaded into the database (the CSV is sent to us on email by a 3rd party company), we will upload the CSV to the server, and then import into the database on the server. We then have numerous PHP script's with various query's for different info req'd to streamline our operation.

Any help anyone could give me would be great, thanks for taking your time to read this.

HS

Looking at the upload script only three mime types are allowed.

You will need to add a further mime type for csv files. Add this line between jpeg and pjpeg.

PHP Code:

 || ($_FILES["file"]["type"] == "application/octet-stream") 


Hi Maxximus

Thanks for the reply, I had seen something like that when I googled it, but I have tried it and it doesn't seem to work, it still say's invalid file.

At the moment I am testing it locally using Apache.

Perhap's I need to check my PHP.ini or even something on Apache.

Think the problem is there is no formal specification for .csv files. Various programs can produce different mime types.

When i tested with a local csv file I got 'application/octet stream'. The easiest way is to test is to add the line

PHP Code:

  echo "file type is ".$_FILES["file"]["type"]; 


at the top of the upload script and see what mime type is shown when you try to upload your csv file.

"trying to upload a CSV file returns the message "File Invalid" sounds like a nonsense. Who exactly returns this message? Your function that copies the uploaded file? Your function that tries to read it? For the php's file upload mechanism csv file does not differ at all from the image file or text file or anything else.