Exporting Data into the CSV Format

The eFactoring system enables the export of data into the CSV format. This export serves for further data processing. The exported file is ready to be used in the MS Excel application into which files in the CSV format are easily loaded. Calculations can be made or charts can be created based on the exported data.

Data on the overview page of any screen is always imported. The data is exported into the file in the order in which it appears in the individual overview columns. If a column contains several lines, these are exported as another column in the export overview.

Note

The payment overview is exported including individual payment orders from the payment detail.

Datum;Bankovní účet dodavatele;Banka dodavatele;Bankovní účet factora;Banka factora;Částka;Částka – Měna;Variabilní symbol;Částka;Částka – Měna;Typ platby;Variabilní symbol;VS Odkoupené faktury
11.1.2005;0000000124586541;0300;0000000157199863;0800;1600;CZK;9010394885;;;;;
;;;;;;;;1500;CZK;Předfinancování;123456;
;;;;;;;;-300;CZK;Předfinancování zápočtem – VS:230051;123456;4303
;;;;;;;;-100;CZK;Předfinancování zápočtem – VS:230052;123456;4306
;;;;;;;;-100;CZK;Předfinancování zápočtem – VS:230053;123456;2906
11.1.2005;0000000124586541;0300;0000000803504034;2700;600;CZK;123455;;;;;
18.1.2005;0000000124586541;0300;0000000803504034;2700;19796,25;CZK;6663638;;;;;
18.1.2005;0000000124586541;0300;0000000803504034;2700;692,93;CZK;6663636;;;;;
18.1.2005;0000000124586541;0300;;;0;CZK;6663637;;;;;
;;;;;;;;15422,72;CZK;Předfinancování;6663637;
;;;;;;;;-15422,72;CZK;Předfinancování zápočtem – VS:240019X;6663637;

Before carrying out export, you can set e.g. the decimal separator; see the section User Settings.

Exporting data into the CSV format is illustrated in the following example:

  • You would like to export payments with a matching code beginning with 9189.

Tip

The * placeholder substituting missing characters can be used when filtering.

Carry out the above example in the application as follows:

Select the Payments command from the Invoices menu. The overview of Payments appears.

Press the button in the upper right-hand corner. The Payment Filter dialog appears.

Enter 9189* into the Matching Code item.

Press the button. The application displays the Payments overview that corresponds to the entered filter.

Now press the button in the upper right-hand corner. The File Download dialog appears (Do you wish to open or save the file?). Press the Save button.

The Save as dialog appears. Here, select the location on the disc to which you want to save the file. Press the Save button.

A file is created, e.g.Platby.csv. This file contains information concerning payments corresponding to the entered filter.

Note

The file name (e.g. Payments) is derived from the name of the open overview.

Double-clicking Payments.csv opens the file in e.g. the MS Excel program (provided you have the application installed on your computer) in which you can work further with the data.

Copyright © ARBES, 2019