Importing rates via CSV: File type failing, but I'm sure it's right!

  • Newcomer

    Hi there,

    I'm a new myVR user. I'm trying to import my property rates using the Setup / API & Data Access / Import / Properties section, and keep running into the message "Bad File Type: Only CSV Files are supported".

    Just to clarify, I'm pretty handy at Microsoft Excel / Google Sheets. I've taken the template Rate file, downloaded it, filled in the data (including the required fields), ensured that I've saved it as CSV UTF-8, double-checked with Notepad to ensure that I didn't inadvertently resave as an XLSX sheet, and I get this error message every time. It's a simple three-line CSV file with sample rates to test the importing function before I go all out. For background, I have already created the property, and set up an External ID as required: Note that this is not failing on a given row of the import, myVR is stating it's not a CSV file. But I'm really sure it is.

    For what it's worth, I'm on a Windows 10 machine, using US English and just about every default imaginable.

    Does anyone have any advice? Thanks so much!

    John Bennett

  • Leader

    @John-Bennett - I would recommend submitting a problem report - I had some similar issues when I did it the first time as well. They may need to look at your specific data to determine what's gone wrong.

  • Newcomer

    Hi Jenny,

    Thanks so much for your reply. I will submit a problem report -- I thought I'd start here just in case I was missing something obvious.

    Just as an aside, you were the one that actually got me going on the import process: I had been looking through the forums to see if there was any mention of upload/import, and was thrilled to find someone who had asked the same question and successfully done it. I've learned a lot just by reading your questions and answers!

  • Leader

    @John-Bennett - I'm always trying new things! 🙂

  • MyVR Employee

    Hi @John-Bennett - thanks for submitting a support ticket on this issue. It has since been resolved. We can leave this post up since @Jenny-Oest gives a good reminder on when it's a good time to submit a ticket, as now this CSV issue (hopefully 🙂 ) isn't going to be useful info for folks moving forward.


Log in to reply

Looks like your connection to MyVR Community was lost, please wait while we try to reconnect.