Hello, when i export via url, the field header order_number , appears with " " . I addded a find/replace rule and i added an alias (field name) without "" . When i export from joomla administrator it goes well but when i export via URL it don't works. What can i do?
The URL is in view site details
Hello,
Do you mean that the order number has " around the values? If so, that is not a problem and according to the CSV standard. If that is not the problem, please explain with an example of the problem you see. I don't see a problem in the export with the order number field.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
No no, around the title header, "order_number".
Hello,
This has nothing to do with the " itself but your file has a double BOM (Byte Order Mark), see attached screenshot. Those 3 funny characters at the start of the file is the BOM. It is used by Excel to read a CSV file as UTF-8 for example. Since you have 2 of those BOMs, it goes wrong.
So you do not need any replace rules for this. Please check if you have done anything for this in your template settings. To have the setting, Excel CSV is fine, this adds 1 of the BOM. I have no idea where your second BOM is coming from. Do you have this with all exports? You can see if you turn off the Excel CSV option if you only have 1 BOM and then can read the file.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hey, disabling Excel CSV it's solved. Thanks!
Log in to reply to this topic.