MasterDataCleanEnabled

Description

When importing master data, some fields must contain a value (see the XML master data structures to see which fields are mandatory). If you import data that contains an empty value for one or more mandatory fields, the entire import is canceled and no data is imported into Invoices.

However, you can avoid canceling the entire import by setting MasterDataCleanEnabled to 1 (on). You must then specify which fields are to be ignored if they contain no value. Use the MasterDataCleanSuppliersColumns, MasterDataCleanSupplierBanksColumns, and MasterDataCleanBuyersColumns settings to do this. If one of the specified fields has no value during a master data import:

  • The Supplier/ SupplierBank/Buyer is not imported.
  • An entry is created in the log file.
  • The master data import proceeds.

Example

You want to import master data. Some entries have no values for the following fields:

  • SupplierNumber for both Supplier and SupplierBank.
  • CorporateGroupID for Buyer.

You do not want a few missing pieces of information preventing the other entries from being imported. So you specify the following entries in Eiglobal.ini, in the [Options] section:

MasterDataCleanEnabled=1

MasterDataCleanSuppliersColumns=SupplierNumber

MasterDataCleanSupplierBanksColumns=SupplierNumber

MasterDataCleanBuyersColumns=CorporateGroupID

Now, when you import your master data, entries with no values for these fields are not imported, but the rest are.

Valid values

  • 0 (off – default)
  • 1 (on)