Import-Export Module

Interface performance

The file-based interface from BCS enables you to:

Flexible import and export of data in CSV format and numerous other file formats, for example XML, ASCII, and MPX

Manual execution of import and export directly via the BCS interface

Automated import and export at desired intervals, from minute-by-minute to monthly, as well as on fixed days and at specific times.

Data preparation and data migration

The interface allows you to automatically prepare your data for both import and export, enabling smooth data migration, for example:

Format adjustments, value mappings, and calculations

Data updates through multiple imports

Deletion of unnecessary data

Marking exported data

Interface performance

The database-based interface by BCS provides you with the following features:

All data preparation options also offered by the file-based interface

Communication via the Java Database Connectivity (JDBC) database interface

Individual database queries, such as for inserting new data or updating existing data

Subsequent selection of imported data

Automatic deletion of intermediate tables before execution of an export and after execution of an import

Exchange options

The database-based interface by BCS offers you two exchange options.

If the third-party system allows direct access to its database, BCS can write to the database of the third-party system and read data from it.

If direct access is not permitted, BCS works with intermediate tables that are filled by both systems for data exchange.

The import-export module allows you, for example, to import the following data into BCS:

• Project structures with assignments to customers and project teams
• Customer master data from CRM systems, for example address data from ACT! CRM
• Regular import of time entries for your project controlling
• Tickets for time tracking
• Material costs for your project calculation
• Absences, such as vacation or illness, for your resource management

The import-export module allows you, for example, to export the following data from BCS:

• Expenses as well as attendance and booking data for further processing in DATEV
• Outgoing invoices and expense data for DATEV Unternehmen Online or DATEV Pro
• Time entries
• Project structures with planned values
• Completed invoices and invoice line items
• All invoice documents of a billing run in PDF format for storage on a drive

Systems that do not directly support the options of our Import-Export module can usually be connected via an intermediate step.