You have saved the excel file as .CSV, and during an Acoustic Campaign import, it does not separate the columns as it's showing a semicolon (;) between the field names. When you save your file as a Comma Separated Value (CSV) file from Excel, the separator (delimiter) that is used is not the character that you chose to be the List separator for your system. When this occurs, you do not receive a warning or error message.
This can occur when you choose the same character for both your decimal symbol and your List separator in the Regional Settings of your system Control Panel. In this condition, Excel must substitute another character for the list separator to avoid a possible loss of information when the CSV file is saved.
In many countries in Europe they use a comma as the decimal separator and this can clash with the list separator.
You have two options, in this case, to resolve the import new/update problem with the CSV file in Acoustic Campaign.
- Change the decimal separator to dot (.) in regional settings within the operating system
- Open the CSV file in Notepad and replace all the semicolons with a comma with the find all and replace function. Once saved, try the import again.