Save CSV Encoding Type in File (UTF-8) - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
340  Points
Open
Idea has been posted. Give it an upvote or downvote.

Save CSV Encoding Type in File (UTF-8)

Developer Tools

Currently CSV Files created with the Apex Data Loader or the Weekly Export (Data Management) that are in UTF-8 do not contain the Encoding Label. This causes external programs not being able to detect the proper encoding and display the information correctly.

For example: When doubleclicking a CSV file with UTF-8 to open it in Excel 2007, the characters are not displayed correctly because Excel cannot detect the correct Encoding type and uses its default value.

A work arround for this on how to open UTF-8 CSV files properly in Excel has been published in the SalesForce.com help. But doing this every time is frusstrating and time consuming. Also a program called Vi Viewer cannot display the correct Encoding aswel.

Curently a white paper standard on UTF-8 files is in the making which incorporates the storing of the Encoding type so it can be detected and applied by external programs.

Another workaroud is to open CSV Files with Notepad++ andd Change the encoding to UTF-8 and save it. After this MS Excel can open and display the file properly.

Solution: Adjust SalesForce.com to store the correct encoding type in CSV Files created with Dataloaders and also in the Weekly Exports.

Merge Idea · Flag

  • Upvotes
  • Downvotes

Ideas

Apps

from AppExchange

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.