If you used the Export Reviews tool to export your reviews to a CSV file, the date format option to select when importing is:
2021-01-13 12:00:00
This reply was modified 1 year, 11 months ago by Gemini Labs
Hi, Yes I am using the Export Reviews Tool.
Thanks, The file is now importing with the correct date format and all other data.
However, the categories (assigned_terms) is now blank
Even when I cut and paste the data into the template or manual type the number in
PS I am using Excel with a PC
Go to the Site Reviews > Categories page, open the screen options and enable the TID and TTID columns. Are both values the same for each category, or are they different?
The TID and TTID have different values in the two sites
e.g. Axx.global (importing site) has TID and TTID value of 1772
Axx.edu.au (exporting site) has TID and TTID value of 107
Are you using the correct Site Reviews category IDs in your CSV file that correspond to the Category IDs of the site you are importing reviews to?
Hi,
I will give you an example to answer your question.
We have a whole of site review category
That ID is 113 on axx.edu.au (the exporting site)
That ID is 1693 in axx.global (the importing site)
PS We have used the WordPress import / Export feature up until now, but it is timing out because the file size is too large, I think.
Did you adjust the assigned_terms column values in your CSV file to use the correct term IDs used on your second website?
