Oct 9

CSV to iCal (Generic) Update 4

Category: CSV to iCal,Maintenance,Nerd,Windows Vista

Ok, so I have been getting the messages about the errors and I have finally had a chance to look into debugging.  So I changed the code around a bit and now it will throw a more detailed error with the file type it thinks you tried to upload.  Please post the link to the error you get.  It should look something like “http://www.thegreatco.com/csvtoical/calendar.php?msg=3&detail=”.  It is the information after the “detail=” that will help me figure out the problem.  I do have a few questions for those getting errors, what browser/OS are you using?  I know this works on vista, I use it myself so I can’t figure out why its not working.  Need your help with this one, make sure to put in your 2cents.

Thanks,

TheGreatCO

UPDATE: Please check here for the latest update on the subject!

24 comments

24 Comments so far

  1. rick fessler October 11th, 2008 11:48 am

    hope this helps

    http://www.thegreatco.com/csvtoical/calendar.php?msg=3&extra=application%2Fcsv
    File is not a CSV, only CSV files are allowed to be uploaded.
    File type you attempted to upload: application/csv.
    If you get this error and are sure you uploaded a csv, post here with the file type listed and make sure you register so I can respond directly to you.

  2. TheGreatCO October 11th, 2008 12:58 pm

    Well, everybody, thank Rick Fessler for getting back to me, everything should be working now. Let me know how things go for you guys. I hope everything is peachy now.

  3. Richard Sears December 1st, 2008 1:41 pm

    I also got the “not a CSV file” message. But the file’s properties say “CSV File” and it sure looks like one. It came from Yahoo Calendar.

  4. andres February 9th, 2009 7:32 am

    I also got the “not a CSV file”. :(

  5. Roush February 10th, 2009 10:57 pm

    Same error here – File type you attempted to upload: text/plain.

    I know that it’s a CSV file – the original is available here: http://kc.wizards.mlsnet.com/t105/schedule/download/

  6. TheGreatCO February 11th, 2009 4:39 pm

    What OS are you using?

  7. Bryan March 25th, 2009 10:38 am

    I tried your csv-to-ical converter and got this: File is not a CSV, only CSV files are allowed to be uploaded.
    File type you attempted to upload: application/vnd.ms-excel.
    If you get this error and are sure you uploaded a csv, post here with the file type listed and make sure you register so I can respond directly to you.

    Here is a 3-line sample from the top of the file:
    “Start Date”,”Start Time”,”End Time”,”Subject”,”Location”,”Description”
    “3/28/2009″,”10:00 AM”,”12:00 PM”,”Sea Dogs @ Sand Gnats”,”Holford 1″,”Scorekeeper: Jane Doe”
    “3/28/2009″,”10:00 AM”,”12:00 PM”,”Red Sox @ Diamondbacks”,”Holford 3″,”Scorekeeper: Lynn LastName”

    I am trying to import this into Vista’s Calendar.

  8. Sacha Heck June 18th, 2009 11:38 am

    Hi,

    I get this error while loading up a CSV-file. And I’m sure it is ;) Using Mac OSX Tiger 10.4.11:

    http://www.thegreatco.com/csvtoical/calendar.php?msg=3&extra=text%2Fplain

    Greetz,
    Sacha

  9. tob June 25th, 2009 5:33 am

    http://www.thegreatco.com/csvtoical/calendar.php?msg=3&extra=application/vnd.ms-excel

    File is not a CSV, only CSV files are allowed to be uploaded.
    File type you attempted to upload: application/csv.
    If you get this error and are sure you uploaded a csv, post here with the file type listed and make sure you register so I can respond directly to you.

  10. Tara July 12th, 2009 1:56 pm

    I am trying to upload an excel created csv and it is not allowing me to I get error message….

    File is not a CSV, only CSV files are allowed to be uploaded.
    File type you attempted to upload: application/octet-stream
    If you get this error and are sure you uploaded a csv, post here with the file type listed and make sure you register so I can respond directly to you.

  11. chris maino August 13th, 2009 5:48 pm

    I am getting the same error, complaining that the dat is not csv.
    startdate,F2,starttime,endtime,subject,private,reminder,F8,requiredattendees,Categories
    8/14/2009,,9:00 AM,10:00 AM,FEDOROCHKO WEEKLY DM CALL 888-765-3653×7321847,FALSE,TRUE,,”maino, christopher”,Weekly DM Call
    Is the top 2 lines.

  12. faraz mulla August 17th, 2009 4:34 am

    I was having same problem with my file, someone suggested remove application/octet-stream.

    If you have MS office somehow the browsers seem to send the ms default application/vn.excel or something like.

    try adding this

    ‘csv’ => array(‘text/x-comma-separated-values’, ‘text/comma-separated-values’, ‘application/octet-stream’, ‘application/vnd.ms-excel’, ‘text/csv’, ‘application/csv’, ‘application/excel’, ‘application/vnd.msexcel’, ‘\text/x-comma-separated-values\’),

  13. Suzanne Russo September 28th, 2009 10:56 pm

    I appreciate you taking the time to look into this – I wasn’t sure I’d ever find an option to convert – I did, though, receive the same error as others:

    File type you attempted to upload: application/octet-stream

    It was a back-up .csv from Outlook

    Thanks for your help!

    Suzanne

  14. Luis October 8th, 2009 8:34 am

    It’s unfortunate that this isn’t working. I have tried from 2 machines with different results. One telling me that the file is excel and the other telling me that the file is plain text. Either way, the site doesn’t accept anything but “csv”. Yet it is CSV.

    Perhaps the code can be made available in some other format. I am thinking of just creating a program myself, but since time is limited, I’d rather find something already made…

  15. Thomas October 21st, 2009 10:22 am

    http://www.thegreatco.com/csvtoical/calendar.php?msg=3&extra=text%2Fcomma-separated-values

    Unfortunatly I although received this message.
    I got 2 files whixh should be transformed in ics files.
    Both are converted from Outlook 2000 in window csv files.
    Please tell me what to do.

    Thanks Thomas

  16. tom November 12th, 2009 2:54 pm

    tried from mac os x 10.6.1 and now from vista. no luck. File itself identifies on mac as CSV/Excel …
    was created from plain text.

    file starts with
    Datum;Zeit;Termin
    02.01.2007;16:00:00;zurück von Teplice
    03.01.2007; ;Karte an Inge
    04.01.2007;09:30:00;Club-Fasching
    05.01.2007; ;Frau Berlitz

    File is not a CSV, only CSV files are allowed to be uploaded.
    File type you attempted to upload: application/vnd.ms-excel.
    If you get this error and are sure you uploaded a csv, post here with the file type listed and make sure you register so I can respond directly to you.

  17. TheGreatCO December 18th, 2009 10:21 pm

    The issue should be resolved. I apologize for the delay. Try now.

  18. TheGreatCO December 18th, 2009 10:21 pm

    The issue should be resolved. I apologize for the delay. Try now.

  19. maelcum February 19th, 2010 3:59 am

    Could you provide a template (like a csv in text format) of *how* the csv should look like for download?

    It would make it much easier for me to provide the right format

  20. Ron February 22nd, 2010 1:53 am

    I saved Outlook calendar as “CSV (Windows)” – also “CSV (DOS)” option, did not use that. Uploaded same file to your site, got back 2 different error messages (one each time):
    * msg=3&extra=text%2Fplain
    * msg=3&extra=application/octet-stream
    Same file.
    Subbird v 0.9 says it can import csv but does not generate appt’s from this Outlook-generated CSV (no error msg.) Another site, http://manas.tungare.name/software/csv-to-ical/, returns a 1KB ical ‘conversion’ (of a 3KB CSV) that also doesn’t import into Sundbird.

    Sure appreciate you nerds working on this – thanks!

    PS – never got password from trying to register at this site – hope my email here will get your kind reply.

  21. Ron February 22nd, 2010 2:11 am

    PPS – had exported this calendar as both an Outlook-generated .xls and .csv, then imported into OpenOffice Calc (spreadsheet) and both file types import perfectly and identically.

  22. TheGreatCO February 22nd, 2010 5:12 pm

    The mail issue should be fixed. I was having an issue with the local mail server. The upload issue should be fixed as well.

  23. Ron March 5th, 2010 1:31 pm

    Hi – like to report the converter took my file fine this time! Asked for field mappings (easy) gave me back a blank (?) web page/URL ID where I guess the converted file is posted but I don’t see it – ??? Sunbird requires a physical file on PC to Import, cannot take a URL. I have refreshed the page and there is nothin there to download, nothing in my Downloads folder. What is the last step I need to do>

    Thanks for fixing the file upload! Ron

  24. Ron March 5th, 2010 1:38 pm

    Here’s the address of the converted file if you need it:
    http://www.thegreatco.com/csvtoical/calendar.php?cmd=convert&ID=2141d92098b17314bb250684a85ce7fa

Leave a comment