Sequential import templates (NL Meervoudig importsjabloon)

Sequential import templates allow for the execution of multiple import templates on the same import file in sequence.
This is useful for importing data if the file/string contains relational data that refers to multiple Novulo entities.

Examples:

  1. An Excel file contains contact information like the name and address data. In a Novulo application, this would require two import templates. One to import the contacts, based on the name, and one to import and link the addresses to the contacts.
    1. A JSON/XML string/file contains data about products and their sales prices. First, one would have to import the products and the sales price list items.

Adding and testing a new sequential import template

  1. To add a new sequential import template, go to all settings > sequential import template
  2. Click on the + button and give your template a description
  3. Choose “File” or “String” depending on what you intend to import.
  4. Add at least one sequential import step by linking an existing import template. The sequence defines the order for the execution of the import. The lowest will be executed first
  5. Once you added a few steps, the button “Generate sequential import” will appear. Click it to test your configuration.
  6. A new sequential import will be opened. The sequential import is based on the template and can be used to start an actual import. Click “Edit” to reveal the upload field for the file that you want to import.
  7. Upload a file, click save, disable the checkmark “run in background” and then click on the “Import” button.
  8. The uploaded file is now being imported for each import definition.
  9. Click on the blue link in the column “Embedded definition” to view the actual separate imports and the import logging to debug your import.
  10. To view a list of all sequential imports, go to All apps > Application maintenance > Import > Sequential imports.
1 Like