End-user guides:: Exporting contact data from SAP CC – Emarsys

The information provided here is not for the SAP Commerce Cloud Integration with Emarsys.

This article describes how to export contact data from SAP CC using Script Generator and import it to Emarsys. This procedure can be useful if you are using a version of the Commerce Cloud in the Public Cloud that is not supported by the Emarsys integration.

There might be differences between a contact's opt-in status on Emarsys and on SAP CC end. Re-subscription is not an option with this method.

The process described here is only about exporting data from SAP CC to import into Emarsys. There is nothing here about getting data from Emarsys into SAP CC.

Configuring contact data to export

Chose type of information to export using SAP's Wizard: Script Generator.

SAP Help Portal: Exporting Users and Addresses

During the setup you can define the separator and few other properties as you would like.
Here is an overview about the Emarsys data standards to adhere to:

Data property	Value
Encoding	UTF-8
Delimiter	TAB, semicolon, comma
Separator	none, single or double quotation mark
Date formats	DD.MM.YYYY, DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD
Compression formats	.zip, .rar, .arj, .tar, .tgz, .7z
Maximum file size	64MB

Header configuration example

Related SAP Help Portal sections:

C reating Headers for Export

Modifying Export Headers

Exporting Data

Header example:

customerID;defaultShipmentAddress;description;name;originalUid;sapConsumerID;sapContactID;sessionCurrency;title;uid;userprofile

To get the header in the example above, you need to set up the Script Generator like this:

# ---- Extension: core ---- Type: Customer ----

"#% impex.setTargetFile( ""Customer.csv"" );"

insert_update Customer;customerID;defaultShipmentAddress(&Item);description;name;originalUid;sapConsumerID;sapContactID;sessionCurrency(isocode);title(code);uid[unique=true,allownull=true];userprofile(&Item)

"#% impex.exportItems( ""Customer"" , false );"