Contact Export If you want to export contacts from your account into a CSV file, please click the link „export contacts“ in the contacts list: Export Contacts   This will open the page where you can set the export specifications. Export Contacts - Overview    

Data Selection and Filters

„Choose Data

Here you can select which data fields should be exported: „Only basic data“ or „Everything“. Exporting everything may take considerably more time. The default setting will export basic data like person ID or email address only. Please select „Everything“ in case you need all data fields exported (e.g. your custom fields). Furthermore you can set a field separator for the data records.

Tip: Export with Field Separator „TAB“

According to our experience it is quite possible that commas or even semicolons occur in contact datasets. In order to avoid problems caused by these please always select „TAB“ as field separator in the „Choose data“ area. TAB as Separator

„Status“ Area

Use the drop down list in this section to filter your contact export by status. Your options here are all, active, unsubscribed or bounced contacts.

„Filter 1“

Here you can filter the data to be exported by individual contact fields. Please mark the „Activate“ box and select the desired data field (e.g. ZIP), an operator (e.g. >) and enter a value into the last field. Please note that only certain values are possible for the various field types (e.g. letters for the last name field or a predetermined date format in a date-related field like „24-12-2000“).  

„Filter 2“

This section allows filtering by user behavior (response). You can, for instance, specify that only contacts who have opened mails in the last month will be exported. This filter can be combined with filter 1 and the other export settings. Following selection criteria are available:
  • all new: all contacts added (by subscription, import etc.) in the selected period of time
  • all new subscribers: all contacts who have subscribed (via registration page) in the selected period of time
  • email receiver: all contacts who have received (been part of the mailing list) at least 1 email in the selected period of time
  • no email receiver: all contacts who haven’t received any emails in the selected period of time
  • email opener: all contacts who have opened at least 1 email in the selected period of time
  • no email opener: all contacts who have received at least 1 email in the selected period of time but haven’t opened any
  • all unsubscribes:  all contacts who have unsubscribed in the selected period of time
  • all bounced:  all contacts who have been reverted to status „B“ in the selected period of time
  • all clicked:  all contacts who have clicked at least one link in the selected period of time
  • all changed:  all contacts whose data underwent changes in the selected period of time
Creating the export file may take some time, depending on the amount of data. If you export huge data amounts just check back a couple of minutes after starting the job – or let our system inform you via email when a file is ready for download. You will find a personal password underneath the filter settings. It is required for unzipping the exported archive. Any contact export will automatically be packed into a password protected zip archive – for safety reasons and in order to reduce file size. Once the file is ready for download, a link will be provided below the filter boxes. Download Link  

Tips / Display in Spreadsheet Software

The export archive contains a UTF-8 encoded CSV file. We recommend the following approach for well-arranged display of your data.

Select Spreadsheet Program

We recommend using OpenOffice or LibreOffice if you have the choice. With these programs you can import the CSV file in just one step. If you prefer MS Excel you need to perform the following steps to achieve the same result.

Excel

Double-clicking a CSV file that has been set to „open with Excel“ leads to relatively confusing display of the data. So please open a new, empty sheet in Excel first. Leere Arbeitsmappe Now please select „Data“ => „From Text“ or „Data“ => „Get External Data“ => „From Text“, depending on the program version. Data from Text Now please browse your PC for the CSV file and click „import“. Import in Excel This will open the Excel Text Import Wizard.
Text Import Wizard
Text Import Wizard 1 On page 1 please make the following settings:
Original Data Type
Delimited
File Origin
65001: Unicode (UTF-8)
Start Import at Row:
Since our Export files have column headers (CHQ_ADDRESS, STATUS) you can select „Start Import at Row 1“ if you like to keep these headers, otherwise just star with Row 2. Depending on the program version there might be a checkbox instead where you can select whether (mark) or not (leave blank) there are headlines to be imported. Now please click „Next“. Your data should already displayed in a more structured way in the preview window at the bottom.
Delimiters
Please check „Tab“ here and uncheck everything else.
Select Worksheet
In the third step you just need to select whether you want to put the date into an existing worksheet or into a new one. Then please click „OK“. Text Import Wizard 3  
Done!
Your data have now been imported and structured for perfect display. Fertig!    

CSV Files

The file format CSV means comma-separated values (or sometimes character-separated values, since the separator does not necessarily have to be a comma) and describes the structure of a text file for saving or exchanging data with simple structures. The file extension is .csv. There is no general standard for this file format, but it is basically specified in RFC 4180. The character encoding to be used is not specified either. 7-bit ASCII is generally considered the lowest common denominator. Some characters have a special function for structuring data within the text file. – one character is used for separating data sets This is usually the line break from the operating system where the file was created – in Windows you often have two different characters instead. – one character is used for separating data fields (columns) within the data sets („field terminator„).  Usually this is a comma. XQ:Campaign also allows semicolon, colon, tab or space. – In order to use special characters within the data (e.g. a comma or dot in decimal values), a field delimiter (also: text delimiter) is used, usually the quotation mark . If the field delimiter character itself is contained in the data it will be doubled. The first data set can be a header data record defining the column names, but it is not essential. According to RFC 4180, Paragraph 2, Section 4 the amount of columns should always be equal – this is not always the case, especially Excel is well-known for not representing empty data fields by a separating field terminator. However XQ:Campaign always expects a field terminator, even if the data field does not contain a value. This is why a field separator needs to be chosen on exports as well.
Example for a csv file:
Hour;Monday;Tuesday;Wednesday;Thursday;Friday 1;Maths;German;English;Maths;Art Education 2;Sports;French;History;Sports;History 3;Sports;“Religion pr;cath“;Art Education;;Art Education
     ]]>

English EN Deutsch DE