How to Retain Foreign Characters with .CSV Uploads for your Locations

How to prevent non-western and other foreign characters from becoming corrupted when you upload locations into your Bullseye account.

Requirements: Applies to all account types.

If you upload a location file into Bullseye from outside of North America, you may get corrupted characters in your data.  This may be displayed as question marks, instead of the actual characters.  This often happens with files that contain Asian characters.  The following instructions apply to data that is initially stored in a .xls (excel) file that is stored on a Windows machine:

1. Save the file as a Unicode Text file.

2. Open the file in an editor that supports Unicodes such as Note Pad ++ . (Note that, although regular notepad can save to Unicodes, it does not support all Unicode formats, and is likely to not convert all characters correctly). Between the header fields, there will be blank spaces (tabs).  Select any tab between one of the header fields (it will light up).

3. Copy the tab, and use the find/replace option.  In Notepad ++, there is a binocular icon you can click on.

4. After selecting the icon, you will see a Replace tab, select that tab.  In the Find What field, paste the tab you copied.  In the Replace With field, enter a comma (,). Select Replace All.  This will replace the tabs with commas, which Bullseye requires in order to upload.

5. Save the file by going to File/Save.

6. Rename the file to have .csv as the extension without opening it. Simply replace the .txt file extension to .csv by right clicking on the file and renaming it.  Make sure that your computer is configured to display the file extensions or you will not be able to change the extension.  

7. Upload the file.