Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: no special characters in exported CSV file?

no special characters in exported CSV file? 15 years 8 months ago #8245

  • metmusic
  • metmusic's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
Hi,
Exported CSV file contains strange characters instead normal regional letters.
For example:
My language contains "ó" letter. In CSV file it looks like that: "Ăł".
How remove this issue?

P.S.
In data base characters are ok - also emails.

Thanks!
The administrator has disabled public write access.

Re:no special characters in exported CSV file? 15 years 8 months ago #8274

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Hello,

This might be generated by the fact that the encoding of the exported file is not utf-8 or is without BOM.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Re:no special characters in exported CSV file? 15 years 8 months ago #8282

  • metmusic
  • metmusic's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
Ok... so what should I do?
CSV file is generated by some PHP function and encoding depends on it, yes?
And what is BOM? :)
Last Edit: 15 years 8 months ago by metmusic.
The administrator has disabled public write access.

Re:no special characters in exported CSV file? 15 years 8 months ago #8286

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Hello,

Not quite... You can save the generated CSV file and change it's encoding to utf-8.

BOM stands for Byte Order Mark - used as a signature defining the byte order and encoding form, primarily of unmarked plaintext files.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Re:no special characters in exported CSV file? 15 years 8 months ago #8298

  • metmusic
  • metmusic's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
thanks for your help - now everything is ok. Encoding was ok, it was my mistake. I was opening csv direct in MS Excel but it is bad way :) CSV should be imported into excel... "case closed" :).
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!