Importing a company

Note: Company copy can be done between environments or within the same environment.
  1. On the Business Engine Data Management page, click the Import tab.
  2. Select a component.
  3. Select the data zip file or file collection to import.
  4. Click Import. The Import data window is displayed.
  5. Based on what is available in the data zip file or file collection, consider these options for company import:

    a. To import a specific company, specify this information:

    Source company

    Specify the company available in the data zip file or file collection. Only the tables where company=<the specified value> are imported.

    Target company

    Specify the target company for the import.

    b. To import all companies, specify this information:

    All companies

    Select the check box to import all companies. Only the tables available in the data zip file or file collection with a company field will be imported.

  6. Select an import strategy:
    1. Keep existing records: The record that exists in both source and target are left unchanged in the target.
    2. Replace existing records: The records in target that have a duplicate in source are replaced by the ones imported. For example, tables like MITBAL that has CONO and WHLO as key but also a DIVI field not in key, will be replaced during import.
    3. Clear target table: The tool clears the target tables of all entries that match the target company before import.
  7. Skip the Allow data mismatch option (It allows the format of the existing table and the imported data to differ without causing any errors.
  8. Click Import. A BE Data Management Import job is submitted.
  9. Click Job Overview to go to the Job Overview tab. See Viewing and managing M3 Business Engine data management jobs. When the job is finished, the data has been imported into the database.