General information

All of the account's contact exports are listed in this area. You can add a new contact export using the button below the table. Please click on the “+” button at the top right - “Create new contact export”.

 

Step 1: contact details

The first step in the workflow consists of entering a name for the export and selecting a contact filter to be used for the export ("General Settings"). In the "Contact data fields" section, you determine which fields should ultimately be exported. The “Header” checkbox controls the export of a header with column headings, if required. Now please click the button "continue".

 

Step 2: file format

File formatting

Here you can adjust the formatting of the export file.  File format: the export is currently always carried out in CSV format. These can be opened and / or edited with a text editor or a spreadsheet program. Character set: the character encoding for the export can be set here, eg "ISO-8859-1 (optimized for Excel) or" UTF-8 ". Data field separator: semicolon, TAB or spaces are available. The separator defines when a new data field begins (eg "Max; Mustermann; Max.Mustermann@xqueue.de)However, we recommend using TAB or spaces, as it often happens that semicolons appear in the actual address data and the data records are then separated in the wrong places.

Decimal separator

Decimal separator: Choices are comma or period to determine how the decimal places are separated from whole numbers. Decimal places : specifies how many digits to be displayed after the decimal point in decimal numbers. The choices are 0 to 4.

Contact preview

Here you can check whether the contacts are displayed correctly in the export file. Then click on "continue".

 

Step 3: export

There is currently only one option available here. The menu was designed so that further options can be added in the future  Method: in the user interface (the export is displayed in the contact export overview and can then be downloaded from there) Interval : once Export start : immediately Please click on " Export contacts". You will find yourself in the “Contact export overview” menu, where your previous exports are displayed. By clicking on the name of the contact export, you can now download the CSV file, packed in a ZIP archive.

 

What exactly are CSV files?

The CSV file format stands for Comma-separated values (more rarely character-separated values, since the separator does not necessarily have to be a comma) and describes the structure of a text file for storing or exchanging simply structured data. The file name extension is .csv. There is no general standard for the CSV file format, but it is fundamentally described in RFC 4180. The character encoding to be used is also not specified; 7-bit ASCII is widely considered to be the lowest common denominator. Some characters within the text file have a special function for structuring the data.

  • A character is used to separate data records . This is usually the line break of the file-generating operating system - with the Windows operating system it is often actually two characters in practice.
  • A character is used to separate data fields (columns) within the data records. The comma is generally used for this. In our system, semicolons, colon, tabs and spaces are also possible.
  • In order to be able to use special characters within the data (e.g. commas in decimal values), a field delimiter (also: text delimiter ) is used. Usually this field delimiter is the quotation mark  . If the field delimiter itself is included in the data, it is doubled in the data field.

The first data record can be a header data record that defines the column names; this does not necessarily have to be included. According to RFC 4180 , Paragraph 2, Point 4, each data record should contain the same number of columns - but this is not always observed, especially Excel is known for not using a separator to indicate empty data fields when saving a CSV file. However, our system always expects a separator character, even if the data field does not contain a value. Accordingly, such a separator is always set during export.

Example of a CSV file

Hour; Monday; Tuesday; Wednesday; Thursday; Friday
1; Math; German; English; Math; Art
2; Sports; French; History; Sports; History
3; sport; "religion ev; cath"; art ;; art