Method:Classic General Q&A

Re: Non Standard Characters

Method_Morty — Thu, 25 Feb 2016 16:11:43 GMT

Both Method and QuickBooks do not support international characters. Behind the scenes it is saved as the characters you are seeing "Ã©" - todays browsers are smart enough to display it as the accented e.

But as you see when exported it will export it just as it's saved on the database level.

Easiest workound I found online (have not tested):

- On a Windows computer, open the CSV file using Notepad.
- Click "File > Save As".
- In the dialog window that appears - select "ANSI" from the "Encoding" field. Then click "Save".
- Open this new CSV file using Excel - your non-English characters should be displayed properly.

Give that a shot and update the thread it it works for you (just for future reference).

-- Mortaza

Re: Non Standard Characters

Rick — Thu, 25 Feb 2016 14:19:30 GMT

Hi Mortaza

Yes, looking at the csv in notepad, it is all correct, and opening in google it is correct - my issue is just in Excel! I can't think why though, it's like it doesn't have the correct character set?

Thanks
Rick

Re: Non Standard Characters

Method_Morty — Wed, 24 Feb 2016 15:33:55 GMT

Hey Rick,

After exporting, which application are you opening the .csv file in?

From my testing, opening in Google Sheets it displays correctly:

-- Mortaza

Non Standard Characters

Rick — Sat, 20 Feb 2016 15:12:34 GMT

We have a customer called:

Lollipops Soft Play Café Bournemouth

However when I export the data from the system the name is being displayed as:

How can I handle this correctly?

Thanks
Rick