Migrating product structure bill of materials Excel files to STEP PDM implementation |
| |
| Institution: | 1. College of Business, Washington State University, Vancouver, WA 98686, United States;2. College of Business, Oregon State University, Corvallis, OR 97331, United States;3. Manchester Business School, University of Manchester, Manchester, M15 6PB, United Kingdom;1. Universidad Politécnica de Cartagena, Facultad de Ciencias de la Empresa, Cartagena, Murcia, Spain;2. School of Management,Royal Holloway, University of London, Egham Hill, Egham, Surrey TW200EX, UK;1. Department of Industrial Engineering, Louisiana Tech University, Ruston, LA 71272, USA;2. Department of Aviation and Supply Chain Management, Raymond J. Harbert College of Business, Auburn University, Auburn, AL 36849, USA;3. Department of Management, Birkbeck University of London, London, UK;4. Engineering & Technology Management, Louisiana Tech University, Ruston, LA 71272, USA;1. School of Information Management, Wuhan University, PR China;2. Economics and Management School, Wuhan University, PR China;3. USTC-CityU Joint Advanced Research Center, University of Science and Technology of China, PR China;1. Department of Information Management, National Sun Yat-Sen University, No. 70, Lienhai Road, Kaohsiung 80424, Taiwan, ROC;2. Department of Information Management, Chia-Nan University of Pharmacy and Science, No. 60, Erh-Jen Road, Sec. 1, Jen-Te, Tainan, Taiwan, ROC;3. Department of Information Science and Management System, National Taitung University, No. 684, Sec. 1, Chunghua Road, Taitung, Taiwan, ROC |
| |
| Abstract: | It is important for manufacturing companies to provide a standard for product data exchange between diverse computer systems. Past attempts to develop neutral format standards for data exchange have had limited success, and have led to the development of STEP (Standard for the Exchange of Product) as a data exchange standard. The STEP standard makes it easier to integrate systems that process various product life-cycle functions, such as design, engineering, manufacturing, logistics support, and will help to facilitate concurrent engineering. The goal of this paper is to facilitate the computer-readable exchange of the product bill of materials (BOM) information for product data management (PDM). In this paper, the STEP ISO 10303-21 is implemented to share the product data information in a manufacturing environment. A structural product bill of materials is first transformed into an Excel file format, then a PDM Schema Exporter is utilized to export a BOM Excel file to a STEP Part 21 file. A C# program decodes the STEP file into BOM information to update the PDM databases in SQL server for product data management. Also, SAS code is written to generate the indented bill of materials from the BOM information, to draw a tree diagram to present an accurate structural view of a product, and to export to PDM databases for product data structural view. |
| |
| Keywords: | ISO 10303 Product data exchange STEP Part 21 file Product data management (PDM) Bill of materials (BOM) |
| 本文献已被 ScienceDirect 等数据库收录！ |
|
