Issue when importing reviews from other plugin

Please provide a link to the CSV file (a small sample will do) and also a screenshot of the settings you are using with the import tool.

Here is the test doc file. https://docs.google.com/spreadsheets/d/1HZZEp_oJSLuNYhU33FQroNPbUovpSm9GST_Oehzjsjk/edit?usp=sharing

For the settings I’m only choosing the file, using detect automatically for the delimiter and playing around with the different date formats because it doesn’t work with any of them.

Here is the screenshot: https://snipboard.io/elSjGc.jpg

thank you!

The date format in your CSV file is 04/11/16 (or dd/mm/yy). In order to import your reviews, you need to tell Site Reviews which format your dates are being written in. If Site Reviews does not provide a date format that matches your CSV file, then you will need to edit the date formatting in the CSV file to match one of the date options that Site Reviews provides.

For example, if your dates are formatted like “dd/mm/yy” then selecting the date option which looks like “dd-mm-yyyy” will not work since the date format is different.

Hello @geminilabs

Thank you for the answer. I think that part is clear, as I mentioned in my message above, none of the formats that you provided seems to work so I’m looking for a specific example that you know works so I can use. I tried changing the format of the CSV to use time and a few of the other different options that match visually with your settings for upload but they don’t work either so I’m not sure if there is a bug with it or what the problem with the format can actually be. Is it possible for you to provide an example that I can use inside Excel to export the CSV that I can use?

Thank you!

Maybe you misunderstood my reply.

Here is a screen recording: https://www.dropbox.com/s/8fm3iktz45aovy9/Import%20date%20format.mp4?dl=0