Note that editing a template might change its compatibility with files / tables you’ve already used it with for importing. See Step 3d for more details.
1. Click Analyst Tools then Data Import Template from the main menu in the top panel of Stratum.
2. In the Data Import Templates list window, select the template you need to edit.
3. Change the editable properties as needed:
a. Name or Description.
Note: This description is different that the import description. For each import that uses the template, you can use the Description field on its Data Import Mapping window to give the import a unique description.
b. Type – Global templates can be used by other data import users. Personal templates are meant only for your use.
c. Decide whether or not to use the Delete Category Data Before Import option. Select it if you want to have all existing data from ALL measures of the Target category to be cleared before the new data is imported. If left deselected, imported data is added to existing measure data.
d. Decide whether or not to use the Allow Schema Drift and Continue Processing option. This property tells Stratum how to treat changes to the import file / table that do not match the template’s data mapping details.
Selected means the import will adapt to differences between your template mapping and what’s in your import file / table. Processing will continue if there are differences. Data Import will use automatic mapping logic when new columns / fields are added in the import file / table that didn’t exist when the template mapping was originally set up. Also, if non-essential columns are missing or removed from your source file / table, the import will continue processing.
Deselect it if you don’t want to allow imports to proceed when there is a difference between the import file / table and the template data mapping. If differences are found, the Data Import will end in an error. You will need to change the format of the source data or use a different template. Use this option if you want to be aware of any changes to your import files / tables.
4. Save your template.