Import Master Data

With the FACTON Excel import, you can import your own master data from Excel and update imported master data.

Resources Global Properties Selection Lists
  • Work Step
  • Commercial Measures
  • Machine
  • Material
  • Special Direct Costs
  • Technical Measures
  • Fixture
  • Tool
  • Exchange Rates
  • Location Factors
  • Overhead Rates
  • Wages
  • Target Achievement Indicator (Target Costing)
  • Confidence Level
  • Supplier
  • Commodity Group
  • Tool Classification
  • Fixture Classification
  • Business Unit
  • Purpose
  • Industrial Sector
  • Location
  • Labor Group
  • Target Achievement Indicator

The Excel import consists of two steps:

Generally, the Excel template is imported row by row. If an error occurs, the import is interrupted and an error message appears. This message contains the cause of the error, so it can be debugged straight away, e.g. the respective row and/or column number of the missing values.

Note

If a cell is left "empty" when updating the master data, this means that the previous value is retained.

If you wish to reset a value as part of an update, you must enter "#DEFAULT" in the cell.

Step 1: Import Master Data

WARNING

Before you import the master data, publish local changes so that no changes can be lost. If errors occur during the import, changes can be undone by discarding them.

Import Master Data

  • You are logged in as SC Master Data Administrator.
  • You are in the Master Data workspace.

  1. In the ribbon, click on Manage > Data Exchange > Import From File.

    The FACTON - Select file to import dialog opens.

  2. Select the .xlsx file you wish to import.

  3. Click Open.

    All sheets of the Excel file are imported.

    If an error occurs, a detailed error message is displayed at the end of the import.

Hint

If you want to exclude selected Excel columns of the Excel file from the import, insert a # symbol in front of the sheet name, e.g. "#Table2".

Step 2: Publish Imported Master Data

Publish Changes

You can publish changes using the following options:

  1. In the ribbon, click on the File > Publish All.

  2. In the ribbon, click on the Local Data > Discard All.

    3. All existing changes are published.

Note

It is not possible to undo changes after publishing.