Title: Import Not Working Last modified: May 15, 2024 --- # Import Not Working * Resolved [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/) * We are trying to import a csv file created from your template, but it’s saying it is not a valid csv file. It only has one row in it. How can we import? Viewing 15 replies - 1 through 15 (of 15 total) * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17757672) * Sounds like you have an error in your CSV file. What did you use to edit it? * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17757683) * We used Excel. We opened the template, then pasted the information in, one column at a time. We have run the file through a CSV checker, and it says it’s valid. - This reply was modified 2 years, 3 months ago by [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/). * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17757687) * Do you have a link to the CSV file? * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17757691) * And what is the exact error, can you post a screenshot? And are there any entries in the Site Reviews > Tools > Console? * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17757692) * [https://train.fitness/reviews-template20161.csv](https://train.fitness/reviews-template20161.csv) * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17757715) * Well, your date format is invalid. * ![](https://i0.wp.com/i.imgur.com/tr1Uwg1.png?ssl=1) * It should be `**01/20/2017 09:43:04**` (i.e. MM/DD/YYYY HH:MM:SS) * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17768041) * Still not working. We changed the date to DD/MM/YYYY and selected that on the import. Still not working. * [https://train.fitness/reviews-template20162.csv](https://train.fitness/reviews-template20162.csv) * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17768069) * Worked for me. * ![](https://i0.wp.com/i.imgur.com/NkKXSKo.png?ssl=1) * ![](https://i0.wp.com/i.imgur.com/qGqoBIW.png?ssl=1) * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17768247) * Just not working here – [https://app.screencast.com/86F47SjzgV8On](https://app.screencast.com/86F47SjzgV8On) * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17768377) * Site Reviews checks the mime type of the uploaded file and expects `text/csv`. If you are getting a “The import file is not a valid CSV file” error, it means that the uploaded file had a different mime type than what was expected. * Check it here: [https://mimetype.io/](https://mimetype.io/) * ![](https://i0.wp.com/i.imgur.com/7r99lSC.gif?ssl=1) * Since the import worked for me but not you, could it maybe be due to the browser you are using? * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17769507) * We downloaded your file and pasted the info into that, saved it and then tried to upload. So are you saying the server is not allowing the mime type, or the mime type of the file has been changed somehow? * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17770445) * Have downloaded your file again. Added the content again. It’s still not importing. Same error. * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17770477) 1. When you drop the CSV file into [https://mimetype.io/](https://mimetype.io/), does it say **text/csv**? If not, what does is show? 2. Have you tried with a different browser? I’d be interested to know if the browser has anything to do with it. 3. Also try this: Open the CSV file in Notepad (since you are using Windows), make a small change to the text and then save it. Does that work? Maybe Excel is saving it with a different mime type. 4. Last resort, I can tell you which line in the plugin code to comment out to bypass the mime type check. * - This reply was modified 2 years, 3 months ago by [Gemini Labs](https://wordpress.org/support/users/geminilabs/). * Thread Starter [trainfitnessint](https://wordpress.org/support/users/trainfitnessint/) * (@trainfitnessint) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17770505) * Your reviews-template.csv that’s downloaded from the plugin says application/ vnd.ms-excel * As is our file. * We have tested our file on another mime file checker site [https://www.htmlstrip.com/mime-file-type-checker](https://www.htmlstrip.com/mime-file-type-checker) and it is text/plain. * On this site [https://www.site24x7.com/es/tools/mime-type-checker.html](https://www.site24x7.com/es/tools/mime-type-checker.html) it is text/csv * Plugin Author [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * (@geminilabs) * [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17770639) * I am unable to replicate this issue on my side, when I download the CSV template file, it has the `text/csv` mime type as expected. * WordPress considers files with a `application/vnd.ms-excel` mime-type to be one of the following types of Excel files: `*.xla` `*.xls` `*.xlt` `*.xlw`. * ![](https://i0.wp.com/i.imgur.com/n7fm0i1.png?ssl=1) * A mime-type is like a binary signature that is prepended to files to declare their type to applications, so I guess it’s possible that an older version of Excel might add a proprietary Excel mime-type to the file. * Perhaps this problem is specific to Windows. Although, other people I have helped when they had an issue with a wrong date format used Windows computers and did not experience this problem. * Did you try editing the file in Notepad to see if that changed the mime type to the correct one? * Two other CSV editor options you can use in Windows (both free) are: [CSV Buddy](http://u) and [Modern CSV](https://www.moderncsv.com/). Perhaps you will have better luck using those to edit the file? * If you really don’t want to try a different CSV editor, then the only thing left that I can suggest is to modify the Site Reviews plugin directly to bypass the mime-type check. **But, I highly recommend you try one of the CSV editors above first!!!** * The lines to remove would be here: [https://github.com/pryley/site-reviews/blob/5c37c8362dca765bff73809857a64e51b577242f/plugin/Commands/ImportReviews.php#L83-L89](https://github.com/pryley/site-reviews/blob/5c37c8362dca765bff73809857a64e51b577242f/plugin/Commands/ImportReviews.php#L83-L89) Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Import Not Working’ is closed to new replies. * ![](https://ps.w.org/site-reviews/assets/icon-256x256.gif?rev=3307009) * [Site Reviews](https://wordpress.org/plugins/site-reviews/) * [Frequently Asked Questions](https://wordpress.org/plugins/site-reviews/#faq) * [Support Threads](https://wordpress.org/support/plugin/site-reviews/) * [Active Topics](https://wordpress.org/support/plugin/site-reviews/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/site-reviews/unresolved/) * [Reviews](https://wordpress.org/support/plugin/site-reviews/reviews/) * 15 replies * 2 participants * Last reply from: [Gemini Labs](https://wordpress.org/support/users/geminilabs/) * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/import-not-working-79/#post-17770639) * Status: resolved