How to prevent non-western 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 stores 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 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 go to Edit/Replace from the Edit menu.


4. In the Find What field, paste the tab.  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.