Skip to content

Search the Omeda Knowledge Base

Data Loader – Templates

To save time and promote file consistency, you have the ability to create templates. There are 2 ways you can create a template:

  1. When you upload a new file, you can choose to save the mapping and validation rules as a template for future files
  2. Under the ‘Template’ section you can create a new template from scratch

A template will save and apply the following to future files:

  • Column to database field mapping (including any/all products, demographics, behaviors, etc)
  • Processing & Validation Rules

Creating a Template from an Uploaded File

To save a template based on a file that has been uploaded, choose “Create Template from Mapping” in the actions drop-down:

A popup will appear prompting you to re-name the template. Once that’s done, click ‘Create Template’ to finalize.

The new template option will appear in your templates list and will be available to apply to any future file.

Creating a Template from Scratch

Template Home Page

To get started, click ‘Templates’ on the left-hand side under the ‘Upload File’ button.

This will bring you to a new screen that lists out the templates that have been created. At a quick glance, you’ll have the following details:

  • Template Name
  • Creator
  • Modified By
  • Status Drop-down
    • Ready to Map
    • Active
    • Active w/Errors
    • Inactive
    • Inactive w/Errors
  • Actions Menu

You can sort each column individually, or search across templates by either status or text (name, creator, modified by, date, etc.).

Creating a New Template

If you haven’t created any templates yet, this screen will be blank. To get started, click ‘Create a Template’ in the lower right-hand corner.

First, you’ll have a popup that prompts you to name your new template

Hit ‘Create Template’ again to move to the General Mapping piece of the template

To build out your template you’ll need to select a data source. You can then add as many headers and constants as you would like. (for additional details, see our Adding Headers and Constants sections) Once you’re through with the ‘General Mapping’ page, you can jump to Settings and include those in your template as well.

Once you’re satisfied with your new Template, click ‘Finish’ on the Settings page to create.

Editing, Deactivating, Cloning  or Deleting your Templates

On the Template home page, you have several options available in the drop-down once a template has been created.

Edit Template:

Clicking on this will open the Template and allow you to make changes to the headers, constants, settings etc.

CAUTION: If you edit a template that has been applied to files the edits will impact all non-processed files.

Deactivate Template:

If you no longer need a template, but want to keep it in case you need to apply it down the road you can choose to deactivate it from the Template list. Deactivating a Template will prevent it from appearing in the template drop-down for newly uploaded files. Templates that have been deactivated will receive an ‘Inactive’ status bubble.

Clone Template:

If there are templates that you would like to build on, without having to re-create everything, you can clone an existing template and build on it. This also allows you to add or remove headers, constants, etc.

Delete Template:

If there is a Template that you no longer need you can choose to delete it entirely if there are no files associated to the template. If you attempt to delete a Template that is being applied to files, an error message will appear notifying you that the Template is associated with files and cannot be deleted. In lieu of deleting Templates, you can choose instead to Deactivate them.

Applying a Template

There are 2 ways you can apply a template to a newly-added file.

The first is when the file is initially uploaded. Once the file(s) have been selected, you can apply a template to each file by choosing from the ‘Select a Template’ drop-down.

Additionally, you can choose to apply a template when you’re editing a file’s mapping by clicking ‘Apply a Template’ found in the upper left-hand corner.

When you select this button, there is a prompt that will caution you any existing mappings and settings will be overwritten by the new template. You’ll need to either apply the template or cancel to move forward.

Tags:
Knowledge Base Feedback