1. fitorforestal
  2. RO CSVI
  3. Wednesday, 13 May 2020
  4.  Subscribe via email
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
Accepted Answer
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
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
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
No no, around the title header, "order_number".

Captura de pantalla 2020-05-14 a las 15.16.05.png
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hey, disabling Excel CSV it's solved. Thanks!
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!