Troubleshooting DataBank Upload Issues

Check File Formatting:
Ensure that your file follows the formatting specifications outlined on the "Import DataBank" page.

Save as ‘CSV UTF-8’:
When saving your file, make sure to select the ‘CSV UTF-8’ format.

Avoid ‘UTF-8 with BOM’:
Some systems may save your file as ‘UTF-8 with BOM’, which is incompatible with the Panoramic Feedback platform. To verify the format:

• Open your CSV file in Microsoft Notepad.
• Look at the bottom-right corner of the Notepad window to check the encoding. It will display either ‘UTF-8’ or ‘UTF-8 with BOM’.

Re-save the file if necessary:
If your file is in ‘UTF-8 with BOM’, re-save it as ‘UTF-8’ (i.e. without BOM) by following these steps:

      Using Microsoft Notepad:

• Open the file in Microsoft Notepad.
• Go to File > Save As....
• At the bottom of the window, in the Encoding field, select UTF-8 from the dropdown menu.
• Click Save.

      Using Google Sheets (Mac):

      Google Sheets exports UTF-8 encoded CSV files without BOM by default. 

• From the new Google Sheet, go to File > Open > Select the applicable CSV file.
• Google Sheets will automatically convert the file to UTF-8 upon opening it.
• To save the encoded file, navigate to File > Download > select Comma-Separated Values (.csv). The downloaded file will automatically be UTF-8 encoded.