Harm10

I am using your plug-in to migrate reviews from another platform (in this case OpenCart) to WooCommerce. For that I need to create my own version of the csv by using Excel and some functions to finally get to the lay-out your plug-in accepts to import. This is not hacking or whatsoever just using the import function.
Problem is that European Excel ONLY uses ; as a delimiter and you cannot change that (there are a lot of solutions to get around this on the net but also reports that these solutions are no longer working). If you use LibreOffice you can set that delimiter to comma or whatever you want.
Suppose someone wants to edit the exported reviews using Excel? When reading the file you can tell Excel to use the comma as the input delimiter but when you save the file to csv you cannot any longer. So problems for us European users….. 🙂
That is the sole reason I would like to be able to set my delimiter.
Does this description make my request more clear?

Then about the log. You only report some errors (like review already exists) after the export on a WordPress screen. In my view this is not the log. I mean the debug log set in WordPress. I can imagine that you do not want to write to that log always so combining it with a Test mode to report any warnings or errors would be a great addition.
Suppose you are importing a file with wrong encoding and processing the user leads to Anonymous. Surely you want to report this in some way? How would the user know if the import contains a lot of reviews?
Hope this makes it more clear too.

• This reply was modified 5 years, 2 months ago by Harm10.

I have encoded both files (first one the userid and second one the review text) and then there are no problems after importing.
So there is definitely something wrong with processing of some characters. In this case character é.

https://www.dropbox.com/s/lwzmh2wil12b77d/review-import-bugtest2_encoded.csv?dl=0

https://www.dropbox.com/s/9qp92wb4myc6ltk/review-import-bugtest3_encoded.csv?dl=0

Can you please look into it?

I can confirm that the fix works! Thank you for fixing it!

Thanks for the tip for LibreOffice! That works in saving with only comma delimiter.
Importing the sample file then works OK.
So I would strongly advise you to mention this somewhere on your plugin Introduction page (at least I couldn’t find any reference about the absolute delimiter in general).

But…….. still I think it is bad programming to not offer any error message when you are using the incorrect lay-out or delimiter. Especially the last situation should be easily discernible!

Having said this I also tested the line feeds and that works OK as do special characters as long as the whole review is within “” (which could also do with a mention or maybe just set it like that in the example file.

What I find very annoying is that when you import exactly the same review it just gets added again (even when I thick the Merge option). Can’t this be tested?

Something else about exporting: is the limitation to one product also lifted in the premium version? If so you should also emphasize this on the Introduction as this puts people of too!

I have upgraded the review to 3 stars now. Can you please reply on my different topics?

I am very sorry. I have been experimenting a lot and I did not save all file versions that I tried.
I tried to create an example file for you with this problem of encoding and failed. If I leave the characters both in display name and review content the import gives me no problems at the moment.
I am sure I had Anonymous and empty review when I was experimenting and still had the time stamp and the amount of stars correct.
As I need to redo all my imports after the Line Feed problem has been solved (other issue) I will try to identify this problem more exact.
For now you cannot do anything to analyse I am afraid……….

On the support site is this text “The support desk is exclusively for premium customers, so any queries regarding the free plugins will be addressed in the respective support forum in WordPress.org.”. So how would I send the template file?

I can see the delimiter is ‘;’ like it is standard in Europe.

I used the import function of your Export functionality. I supplied a hand made file (also with ‘;’ as a delimiter as in the example) with LF in it and it did not work.

Sorry, I totally missed your reply……

I only want to continue the discussion about
“So if there is no spam there is no entry added to the widget?”
I can definitely say that there is no value added to the widget display if no spam is detected.
The one I triggered with the BBcode test is still the only one on that test site I used for that. A merely single dot in further empty display.
In my view each day without spam detected should result in a 0 entry in the display and hence creating a proper graph.
Don’t you agree?