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: This will open the page where you can set the export specifications.
Data Selection and Filters
„Choose DataHere 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.
„Status“ AreaUse 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
Tips / Display in Spreadsheet SoftwareThe export archive contains a UTF-8 encoded CSV file. We recommend the following approach for well-arranged display of your data.
Select Spreadsheet ProgramWe 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.
ExcelDouble-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. Now please select „Data“ => „From Text“ or „Data“ => „Get External Data“ => „From Text“, depending on the program version. Now please browse your PC for the CSV file and click „import“. This will open the Excel Text Import Wizard.
Text Import WizardOn page 1 please make the following settings:
Original Data TypeDelimited
File Origin65001: 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.
DelimitersPlease check „Tab“ here and uncheck everything else.
Select WorksheetIn 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“.
Done!Your data have now been imported and structured for perfect display.
CSV FilesThe 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]]>