The Data loading (File) activity lets you directly access a source of external data and use it in Adobe Campaign. Indeed, all the data required for targeting operations isn’t always found in the Adobe Campaign database: it can be made available in external files.
The file to be loaded can be specified by the transition or calculated during the execution of this activity. For example, it can be the list of a client’s 10 favorite products whose purchases are managed in an external database.
The upper section of the configuration window for this activity lets you define the file format. To do this, use a sample file with the same format as the one to be imported. This file can be stored locally or on the server.
Only “flat” structure files are supported (e.g. CSV, TXT, etc.). Using the XML format is not recommended.
You can define a pre-process to be executed during file import, for example so as not to have to unzip the file on the server (and therefore save space for the unzipped file) but to include unzipping in file processing. Select the Pre-process the file option and choose from one of 3 options: None, Decompression (zcat) or Decrypt (gpg).
You cannot uncompress zipped files larger than 4Gb.
When you load a file, the column format is automatically detected with the default parameters for each data type. You can modify these default parameters in order to specify the particular processes to apply to your data, particularly when there is an error or an empty value.
To do this, select Click here to change the file format… in the main window of the Data loading (file) activity. The format detail window will then open.
You can then modify the general formatting of the file as well as the formatting for each column.
The general file formatting allows you to define the way in which the columns will be recognized (file encoding, separators used, etc.).
The column formatting allows you to define the value processing of each column:
You can add as many columns as desired. The maximum length of values in each column is determined by the chose data type.
Ignore column: does not process this column during data loading.
Data type: specifies the type of data expected for each column.
Allow NULLs: specifies how to manage empty values.
Length: specifies the maximum number of characters for the string data type.
Format: defines the time and date format.
Data transformation: defines whether a character case process needs to be applied on a string.
White space management: specifies whether certain spaces need to be ignored in a string. The Ignore spaces value only allows spaces at the beginning and at the end of a string to be ignored.
Error processings: defines the behavior if an error is encountered.
Default value: specifies the default value according to the error processing chosen.
Mapping: this field is only available in the column detail configuration (accessed via a double-click or via the options on the right of the column list). This transforms certain values when they are imported. For example, you can transform “three” into “3”.
The following example lets you collect a file on the server every day, load its content and update the data in the database depending on the information it contains. The file to be collected contains information on clients who may have made purchases (for more or less than 3,000 Euro), asked for a refund on a purchase or visited the shop without purchasing anything. Depending on this information, various processes will be applied to their profile in the database.
The file collector lets you recover files stored in a directory, depending on the given frequency.
The Directory tab contains information on the file(s) to be recovered. In our example, all files in text format whose names contain the word ‘customers’ and which are stored in the tmp/Adobe/Data/files directory of the server will be recovered.
Using the File collector is detailed in the File collector section.
The Schedule tab lets you schedule the execution of the collector, i.e. to specify the frequency with which the presence of these files will be checked.
Here, we want to trigger the collector every workday at 9PM.
To do this, click the Change… button located in the lower right-hand section of the editing tool and configure the schedule.
For more on this, refer to Scheduler.
Then configure the data loading (file) activity to indicate how the collected file(s) should be read. To do this, select a sample file with the same structure as the files to be loaded.
Here, the file contains five columns:
The format configuration of the file to be loaded coincides with that defined during a data import in Adobe Campaign.
In the split activity, specify the subsets to create, according to the Event column value.
The Split activity is detailed in the section.
For each subset, specify one of the values in the Event column.
The Split activity will therefore contain the following information:
Then specify the processes to be carried out for each type of population. In our example, we are going to Update the data in the database. To do this, place an Update data activity at the end of each outbound transition from the split activity.
The Update data activity is detailed in the Update data section.