Import Cisco Price List - Microsoft Excel, VBA
Company: Swisscom, Bern
Technology: MS Excel, VBA.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Feb 2014 - Aug 2014
Cost: no details
Implementing an application to standardize CISCO price lists using Microsoft Access and Microsoft Excel for strategic purchasing at Swisscom in Bern. The decisive factor for this project was the fact that the company CISCO both the structures and the field formats of their price lists sometimes ended weekly. The goal was therefore to generate an application that could process these price lists automatically. This processing must also be able to take place if Cisco changed the formats or the price list structure. For this reason, a small ETL tool was developed using Access, which checks the files before importing them, unifies them automatically as far as possible and, if automated unification is not possible, informs the responsible users by e-mail. After checking the case structure as well as the field formats, the data was imported, refined and made available to the strategic purchasing staff in various Excel files.
- Creation of a Microsoft Access application for the import / preparation of large amounts of data.
- The import is fully parameterizable (fields, data types, source and destination information).
- After the data is imported, it is refined and output in a Microsoft template according to certain criteria and calculation formulas.
- The entire process is fully parameterizable and automated.
- Development of the application (Access, VBA) with CSV data sources.
- Creating and extending the data model (DeZign).
- Documentation of the data flow and the application.
- Creating specifications for new requirements and their implementation.
- Application development including client/server solutions with MS Access.
- VBA.