Exporting profiles

You can export profiles and subprofiles to a tab delimited file, or files in other formats. The export feature can be use to export the entire database in one go, or to export only parts of the database, for example one collection at a time. An export creates a file that you can download or you can have it emailed to your address.

If you want to receive information about clicks, opens, etc. as they happen you can also set up a feedback loop.

Extra remarks

  • The fields ID, Access code and Profile created are system fields;
  • You can only export fields from one collection at a time to a CSV file. To export multiple collections, choose for export to XML;
  • UTF-8 is normally the best encoding for output files;
  • Date fields can be formatted in a the format that best suits your needs;
  • If you want to keep the export files small, you can compress them. This is especially useful if you want to send export files by mail.

The delimiter

The delimiter is a special character that is used to separate the fields in the output file. This normally is a tab, but you can also choose for a comma or semicolon. if the database contains columns that use the delimiter in field values (for example a hardcoded tab inside a postal code), you can choose for "Quoted columns". The values in the output file will then be wrapped in quotes to prevent conflicts with the delimiter.

Exporting

The results of a mailing can be exported too. See this article for more information.

Exports in Publisher

To export a database or collection you need to select it under profile. Under Current view you can find the option to import or export.

If you want to export profiles or subprofiles based on email results you can make a selection with condition type Check on email campaign results. Use the export function in the Profiles section to download the profiles from this selection.

Exports in Marketing Suite

You can export your database from the Marketing Suite in the database management menu.

More information

We always recommend checking if your database is up-to-date before exporting data. You can then easily sync it to your own system or use it for your own statistics.