Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.