Defining import templates

Import templates allow the administrator to pre-define a certain number of technical import configurations. These templates can then be made available to standard users to carry out and upload files.

An import template is defined by the functional administrator and can be managed under the Resources > Templates > Import templates menu.

import_template_list

Three default read-only templates are available:

  • Update Direct mail quarantines and delivery logs: this template can serve as a basis for new imports to update quarantines and delivery logs for Direct mail. The template's workflow contains the following activities:

  • Import data: this template can serve as a basis for new imports to insert data from a file into the database. This template's workflow contains the following activities:

    • Load file: this activity allows you to upload a file on the Adobe Campaign server.

    • Update data: this activity allows you to insert data from the file in the database.

  • Import list: this template can serve as a basis for new imports to create a List type audience from data in a file. This template's workflow contains the following activities:

    • Load file: this activity allows you to upload a file on the Adobe Campaign server.

    • Reconciliation: this activity allows you to link a targeting dimension to imported data. This then allows you to create a List type audience. If the targeting dimension of the imported data is not known, the audience is File type. See Targeting dimensions and resources.

    • Save audience: this activity allows you to save data imported in the form of a List type audience. The name of the saved audience corresponds to the name of the file imported by the user, and a suffix specifying the date and time of the import will be added. For example: 'profiles_20150406_151448'.

These default templates are read-only and are not visible to standard users. To create a template that will be available to users, follow these steps:

  1. Duplicate a default template. The duplicated template contains three tabs:

    • Properties: the import template's general parameters. This tab allows you to enable the template and to upload a sample file.

    • Workflow: import workflow. This tab allows you to define the workflow activities. These activities are not visible during simplified imports carried out by users.

    • Executed imports: list of imports carried out using this template. You can view the status, details and results of each import that has been carried out using this template. You can directly access the workflow (carried out in a transparent manner for the user) from this list.

  2. From the Properties tab, rename the template and add a description. Users will be able to view the description when the template is available.

    simplified_import_model1
  3. Go to the Workflow tab. From here you can enrich the workflow offered by default by adding new activities according to your needs.

    For more on how to configure the workflow activities, refer to the use case describe in this section: Example: Import workflow template. This use case will help you setting up a workflow that can be reused for importing profiles coming from a CRM in the Adobe Campaign database.

  4. Save your template so that the workflow's configuration is correctly taken into account.

  5. Upload a sample file from the Properties tab. The file uploaded can only have columns necessary for future imports or sample data. Data in the sample file allows you to test the simplified import once the workflow has been defined.

    import_template_Sample

    This sample file will then be available for users using the template to carry out an import. They will be able to download it to their computer, for example to fill it with data to import. Make sure to take this into account when adding a sample file.

  6. Save your template. The sample file is now taken into account. At any moment you can download it to your computer to check the content, or modify it by checking the Drop a new sample file option.

    simplified_import_model2
  7. Go back to the Workflow tab and open the Load file activity to check and adjust the column configuration of the sample file that was uploaded at the previous step.

  8. Test the import by starting the workflow. The sample file uploaded at step 5 has to contain data.

    The data from the sample file is then genuinely imported. Please make sure the data used is small and fictitious to ensure that your database is not compromised.

  9. Go to the workflow execution log, available in the action bar. If you encounter an error, check that the activities are configured correctly.

    simplified_import_model3
  10. In the Properties tab, set the Import template status to Available, then save the template. To stop using this template, you can set the Import template status to Archived.

The template workflow can be modified by re-uploading the sample file and checking the Load file configuration.

The import template is now available for the users and can be used to upload files.

Related topics:

Za ta izdelek je bila izdana neprenosljiva licenca za priznanje avtorstva, nekomercialno uporabo in skupno rabo pod enakimi pogoji 3.0  Objav v storitvah Twitter™ in Facebook ne urejajo pogoji pogodbe Creative Commons.

Pravna obvestila   |   Pravilnik o zasebnosti v spletu