Excel import and export
The supplier management in Onventis Buyer offers the possibility to export the supplier list into an Excel file. At the same time, suppliers can also be imported via BcJobs using corresponding Excel files.
The supplier import and export via Excel also supports the options for extending suppliers for organizational units.
This means that the enhancement for organizational units can already be made when importing the supplier data, and master data can be defined for the respective organizational units.
Files an BC Jobs
The import templates in Excel format are available on the Master Data Import Templates page.
The following BcJob configurations are required to use the import templates:
Description | BcJob configuration |
Vendor import (total) via Excel This import includes all the individual imports mentioned below in a single file. | Controller: Import Controller Adapter: Supplier Adapter Converter: Supplier Import-Converter (Excel) Port: depending on scenario |
Import of supplier addresses via Excel | Controller: Import Controller Adapter: Supplier Address Import Adapter Converter: Supplier Address Import-Converter (Excel) Port: depending on scenario |
Import of supplier bank details via Excel | Controller: Import Controller Adapter: Supplier Bank Details Import Adapter Converter: Supplier Bank Details Import Converter (Excel) Port: depending on scenario |
Import of supplier contact persons via Excel | Controller: Import Controller Adapter: Supplier Contact Import Adapter Converter: Supplier Contact Import-Converter (Excel) Port: depending on scenario |
Import of organizational unit-specific characteristics via Excel | Controller: Import Controller Adapter: Supplier OrgUnit Extension Import Adapter Converter: Supplier OrgUnit Extension Import-Converter (Excel) Port: depending on scenario |