6 Using Data Import

Prerequisites for Data Import

Use data import to populate (seed) an Enterprise Template with all configuration from a property or import selected configuration details from CSV templates to Enterprise or Custom Templates.

Importing Configuration from OPERA Cloud

You can populate all configuration types to an unconfigured (blank) Enterprise Template from an OPERA Cloud property. The configuration is imported in Pending status.

Note:

Does not include OPERA Controls.

Tip:

Remember to assign the enterprise template task to a user group assigned to your user.

  1. From the Side menu, select Manage Imports Jobs.

  2. Click Create.

  3. Select OPERA Cloud Import and complete the following:

    1. Select the Enterprise Template to import to.

    2. Select the OPERA Cloud Property to import from.

    3. Job Description: Enter a job description. Defaults to 'Import from <property> to <template>'.

    4. Click Create.

Importing Configuration from CSV Templates

You can selectively import configuration to Enterprise or Custom Templates.

Start by downloading the CSV templates for each configuration type, then prepare the data using Microsoft Excel or similar solution.

Note:

Row 2 in each CSV file indicates the data type, string lengths, date format and other important information; this row is ignored on import.

Downloading Templates

Each CSV data file must have a maximum file size of 2MB, and you can import multiple files for one template (uniquely name each file. For example, Market_Codes01.csv and Market_Codes02.csv).

  1. From the Side menu, select Manage Imports Jobs.

  2. Click Download Template to download the ConfigurationCSVFiles.zip file.

    1. Navigate to the download folder then unzip the ConfigurationCSVFiles.zip file.

    2. Open and prepare data for each of the configuration CSV files.

Creating Import Jobs

The enterprise template(s), custom templates and configuration options displayed are based on the tasks assigned to your role. See Manage User Groups for more information.

Tip:

Click Refresh to refresh the results updated status of Job ID(s).

  1. From the Side menu, select Manage Imports Jobs.

  2. Click Create.

  3. Select CSV Import and complete the following:

    1. Job Description: Enter a job description.

    2. Select Template: Select the template from the list (both Enterprise and Custom templates are listed).

    3. Configuration Type: Select a configuration type from the list.

    4. Click Attach File and select the CSV file to import or drag the CSV file onto the area.

      1. Repeat for additional files to import.

    5. Click Create.

Deleting Import Job

You can delete jobs when Status is New.

  1. From the Side Menu select Manage Import Jobs.
  2. Select the job in the search result, then click Delete Delete icon

Viewing Import Job Logs

  1. From the Side Menu select Manage Import Jobs.
  2. Select the job in the search result, then click View LogsView logs icon
    1. Click Download Download data iconto download logs for a configuration type.