Part 2: CSV Import
Part 2: Performing CSV Imports
First of all, it’s important to know that CSV import is not the method of choice in productive use. One downside of this upload method is, that you cannot handle data tables containing more than 10000 records. For testing purposes, CSV imports are useful and easy to handle. OData services, then again, can handle huge amounts of data. That’s why they are standard in this case. Check the end user information for more detailled information on CSV Upload. For the import of data using an OData service, check this link, or read the next part of this series.
2.1 CSV import of Contacts (Only Permissions, no Subscriptions)
In section “Import Data”, click the tile also labelled “Import Data”. Here you can find several structure types for each category listed under “Data Management”.
If you have contact data with marketing permissions, and you want to execute an initial upload from your source system, you can proceed as follows. Select the radio button “Contacts” and add fields according to your requirements:
Check the link above for details. You can see the pre-delivered fields when you download the CSV template. It contains important user instructions as a comment. Note that the fields for contact data have corresponding opt-in fields:
If the value is Y (yes), communication with the contact via the given email address is allowed. Filling in the given template with your data, you can get the Marketing Permission Information into the system. Just save the maintained file on your device and upload it:
This procedure only works for Permissions, not for Newsletter Subscriptions.
Note that uploading contacts does not create an interaction for the Permission.
In addition, bear in mind that some fields, especially some ID fields, are non-unique identifiers. For example, an email address is a so-called shareable ID, and thus can be used by several contacts. You should add additional fields or unique identifiers in this situation.
For huge data loads, as mentioned above, the CSV upload will not work. You should use the OData service CUAN_IMPORT_SRV for files containing more than 10000 records.
Another caveat: Please take into consideration that no time stamp of the permission is written seperately. Instead, the time stamp of the import is recorded as time stamp of the permission. This might cause problems from the legal point of view.
2.2 Import Interactions for Marketing Permissions
The upload of Marketing Permissions via interactions works both with CSV files and an OData service (Part 3 of this series). The procedure is nearly the same as with contacts in the precedent paragraph. Instead of “contacts”, you now select the radio button next to “interactions”, and upload the corresponding CSV template.
Note that the following properties are required to create or remove Marketing Permissions using interactions (regardless whether you choose the CSV upload or the OData service):
You should use Contact Upload instead of Interaction Upload when an email address is used by several contacts, since the Interaction Upload does not allow for shareable IDs. With Contact Upload, you can enter multiple attributes to identify the contact clearly.
As you can see in the table above, the issue with confusing upload time and Permission time does not occur here, because you explicitly provide a time stamp in the corresponding field.
2.3 CSV Import of Subscriptions (works also for Permissions)
As described above, select the appropriate radio button (“Subscriptions”) and download the CSV template. It is necessary that you provide the ID and the ID Origin of the given Contact in the CSV file. In addition, you have to maintain the mandatory fields of the Semantic Key, which ensures the uniqueness of an interaction record. Below a complete list of all mandatory fields:
Further fields are:
Though not mandatory, providing a time stamp is highly recommended to avoid mixing up Permission or Subscription time on the one hand, and upload time on the other hand. In contrast to the Contact Upload, the system records an interaction when importing Subscriptions this way.
Note: In order to import your own permission history from an external source, you should do it this way: Start with the oldest record and continue with the upload chronologically. Proceeding in this fashion is necessary to make sure all changes of Subscriptions and Permissions are properly written into the SAP Hybris Marketing Cloud system.
For more details, read section ‘Subscriptions’ of the integration guide ‘Data Management Upload Interfaces’. It also covers permissions.
Read the next part of this series to get to know more about the upload with the OData service CUAN_IMPORT_SRV. The first part of this blog you will find here: