Support EDE file import with encoding or separator

  1. You have an EDE import file, when used to import, displays some unwanted characters and you want to fix it.
  1. Go to the folder where you have stored the csv files for import.
  2. In the same folder, use a text editor and create a text file with the file name as "ABTsettings.txt". Save this text file in the same folder where you stored the csv files.
  3. Open the text file and write Encoding in the first line and mention the type of encoding you want to enter. (See an example in step 5). For more information, see https://learn.microsoft.com/en-us/dotnet/api/system.text.encoding.getencodings?view=net-6.0.
    Default encoding - Windows-1252
  4. Write Separator in the second line in the text file and mention the type of separator. (See an example in step 5).
    Default separator - Semicolon ';'
    Supported separators are:
    Semicolon ';'
    Comma ','
    Tab '\t'
    Pipe '|'
  5. An example of the information to be written in the text file:
    Encoding=windows-1252
    Separator=;
  6. After saving the text file in the same folder where the csv files are stored, go to Engineering > BACnet references.
  7. Click Import EDE and select All files (*.*) next to the File name.
  8. Select the required EDE file (*.csv) and click Open.
  1. You have successfully imported the EDE file with no errors.