The Load file activity allows you to import data in one structured form to use this data in Adobe Campaign. The data is temporarily imported and another activity is necessary to definitively integrate it in the Adobe Campaign database.
The way in which the data will be extracted is defined when the activity is configured. The file to load may be a list of contacts, for example.
Only the "flat" structure files are taken into account, such as the .txt, .csv, etc., files for example.
The activity configuration involves two steps. First, you need to define the expected file structure by uploading a sample file. Once this is done, you can specify the origin of the file whose data will be imported.
The data of the sample file is used for configuring the activity but is not imported. We recommend using a sample file containing little data.
Go to the File structure tab to view the structure that is automatically detected from the sample file.
If the file structure was incorrectly detected, you have several options to correct any possible errors:
All of the detection options necessary to correctly recover the data from the file are regrouped in File format. You can modify them then re-detect the structure of the last file loaded in the activity by taking into account these new settings. To do this, use the Apply configuration button. For example, you can specify a different column separator.
This operation takes into account the last file that was loaded in the activity. If the file detected is large, the data preview will only show the first 30 lines.
Go to the Column definition tab to check the data format for each column and adjust the parameters if necessary.
The Column definition tab allows you to precisely specify the data structure of each column in order to import data that does not contain any errors (for example, using null management) and make it match the types that are already present in the Adobe Campaign database for future operations.
For example, you can change the label of a column, select its type (string, integer, date, etc.) or even specify error processing.
For more information, refer to the Column format section.
If the file that you want to load the data from is compressed into a GZIP file (.gz), select the Decompression option in the Add a pre-processing step field. This allows you to unzip the file before loading the data. This option is only available if the file comes from the activity's inbound transition.
When you load a sample 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 Edit properties from the quick actions of the column whose format you would like to define. The column format detail window will open.
Format and separators, Properties: specify the properties of a text, the time, date, and numerical value format, as well as the separator specified by the column context.
Error processing concerns errors regarding values in the imported file. For example, a faulty data type encountered ("four" all in letters for an "Integer" column), a string containing more characters than the maximum number authorized, a date with faulty separators, etc. However, this option does not concern errors generated by empty value management.
The load file activity mainly structures the data from a transfer file activity in order to integrate it into the existing data.
The following example shows the result of an automatically downloaded load file activity via a transfer file activity, followed by an update data activity. This workflow aims to enrich the Adobe Campaign database with new profiles or to update existing profiles using the data recovered from the imported file.