Encodig converter - Examples

Encodig converter - Examples

Encoding a file to CSV, ready for Excel

One of the questions we get is the problem of reading the files, created by a File Drop, into Excel. The problem with these files is that they are written in UTF-8 encoding. Excel will have some problems with these files if there are special characters in these files. For instance the german city Düsseldorf will be displayed as Düsseldorf in Excel.

We must understand that Microsoft is using the systems Language and Region settings to select the correct encoding for its system. So check your system for the correct encoding.

We will use the next use-case. We have a file in UTF-8 encoding. This file is a .csv file. Wil will pick this file up, use a encoder converter service and drop the file in an output directory.

Example

Requirements

  • You can download the interface here.
  • You need a license for ConnectPlaza Control

Unzip the file and install the interface by creating a new Business Connector with the name Demo-EncodingConverterInterface (for example) and import the interface via the Create new interface window.

 

Select the Demo-EncodingConverter.cinterface file and press Save to upload the file into the system. 

Business connector / Interface and Flows

How it works

First we start the interface. After starting up there will be an input and an output directory available in your ConnectPlaza Agent installation directory. Copy the file cpTestFile.csv into the input directory. Check if the file is picked up, you will see the file dissapear from the input directory.

Now we check the output directory. You will find a .csv file there, try to open this file with Excel. If all is well there should be no problem at all.