This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4842 IT projects that we have successfully completed with our customers.How can we support you?
Quotation data – MS Excel interface
Project duration: 1 year, 5 months
Brief description
The task is to create an interface between the data from an Internet application and a centralized, operative system.
Supplement
The "product configurator" (PTA-ID 1172) provides the initial structures for the quotation data that is stored in the central costs database. At another of the customer's sites, an Internet-compatible system is developed that fulfills similar tasks to the product configurator. To ensure that the structures from this system are correctly transferred to the costs database, there is a data export from the external system. In the course of the support project, the system is adjusted to new MS Excel versions and country settings. A subarea of the functions from the product configurator is extracted and an import routine for MS Excel is added to it. The MS Excel application carries out a data validation, the data import and any country-specific conversions to the data format. The result is identical Excel worksheets (regardless of the source system) that can be imported without any problems through the "Quotation data – costs database interface" (PTA-ID 1162).
IT project data
- Industries mechanical and plant engineering
- Specialist tasks order processing
- DP tasks customised software new development
- System environments PC systems/networks
- Programming languages VBA
Project period01.02.2002 - 01.07.2003
Customers who trust us
