Import-Export Module

Interface performance

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

• Flexible import and export of data in CSV file format and numerous other file formats, such as XML and MPX.
• Manual initiation of import and export directly via the BCS interface
• Automated import and export at the desired intervals, from every minute to every month, on specific days and at specific times.

Data preparation and data migration

The interface provides you with automated preparation of your data for both import and export, making data migration easy, for example:

• Format customizations, value assignments and calculations
• Data updates via multiple imports
• Deletion of unnecessary data
• Selection of 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 to import the following data into BCS, for example:

• Project structures with assignments to customers and project teams
• Customer bases from CRM systems, such as address data from ACT! CRM
• Regular import of effort bookings for your project controlling
• Tickets for time recording
• Material costs for your project calculation
• Absences, such as leave or sick days, for your resource management

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

• Allowances for wage and salary accounting in DATEV programs
• Effort bookings
• Project structures with planned values
• Closed invoices and invoice items
• All invoice documents for an invoice run in PDF file 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.