One of our European customer who is 175-year old in the business of manufacturing machines, Plants and services for Grain and Food processing industries. As a market leader, they offer comprehensive solutions and systems to suit specific customer needs such as equipment for rice milling, flour milling, colour sorting, animal feed technology, oil milling, grinding & dispersion technology to the global market, complete with engineering is continuously doing research in the advanced technologies and implementing it in the existing designs to get the benefits to its customers.
The client was looking to associate with a long-term engineering support services partner for Upgrading their existing platform from Bentley AutoPLANT to Siemens COMOS.
Hence all their legacy data related to Pipe Material Spec (PMS) needed to be created in Siemens COMOS. Challenge was Input provided in different format such as xls, csv, Hardcopies, and mdb files.
Sedin has provided engineering support services to a growing list of happy clients from around the globe. For this project, there were 2 teams involved in Pipe Spec creation. One was manually creating the Pipe Spec from the Hardcopies provided by client into the COMOS.
The other team was We involved our COMOS development team to reduce these manual efforts. The team has created a framework in VB script for Importing existing Pipe Spec data (mdb, xls and csv formats) and building the Pipe Spec data into COMOS.
Validation program inside the framework ensures the Quality of data import into COMOS. This checks all the mandatory attribute values at the catalogue component level and Imports the data to COMOS. Any missing attribute data during transfer will be noted in a log in Excel format for further analysis. Thus, the Import Framework saves lots of time, manual efforts and Increased users productivity specially when we did these creations in bulk.