IDEAS home Printed from https://ideas.repec.org/a/eee/ininma/v34y2014i4p489-516.html
   My bibliography  Save this article

Migrating product structure bill of materials Excel files to STEP PDM implementation

Author

Listed:
  • Shih, Han M.

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.

Suggested Citation

  • Shih, Han M., 2014. "Migrating product structure bill of materials Excel files to STEP PDM implementation," International Journal of Information Management, Elsevier, vol. 34(4), pages 489-516.
    • Handle: RePEc:eee:ininma:v:34:y:2014:i:4:p:489-516
    DOI: 10.1016/j.ijinfomgt.2014.01.004
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S026840121400005X
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.ijinfomgt.2014.01.004?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Da Silveira, Giovani & Borenstein, Denis & Fogliatto, Flavio S., 2001. "Mass customization: Literature review and research directions," International Journal of Production Economics, Elsevier, vol. 72(1), pages 1-13, June.
    2. Unknown, 2000. "Quality assurance in agricultural produce," ACIAR Proceedings Series 135369, Australian Centre for International Agricultural Research.
    3. Li, Zhan G. & Gery, Nurit, 2000. "E-tailing--For all products?," Business Horizons, Elsevier, vol. 43(6), pages 49-54.
    4. Chong-en Bai & Shan Li, 2000. "Capital Structure and Product Market Strategy," Annals of Economics and Finance, Society for AEF, vol. 1(2), pages 381-400, November.
    5. Eric J. Bartelsman & Roel Beetsma, 2000. "Profit Shifting and Productivity Mismeasurement," Tinbergen Institute Discussion Papers 00-097/2, Tinbergen Institute.
    6. anonymous, 2000. "Revolutions in productivity," Annual Report, Federal Reserve Bank of St. Louis, pages 2-13.
    7. Armstrong,Stephen, 2001. "Engineering and Product Development Management," Cambridge Books, Cambridge University Press, number 9780521790697.
    8. C. K. Li, 2000. "The product of r − k and ∇ δ on ℝ m," International Journal of Mathematics and Mathematical Sciences, Hindawi, vol. 24, pages 1-9, January.
    9. Li, Heng & Li, Zhicheng & Li, Ling X. & Hu, Bin, 2000. "A production rescheduling expert simulation system," European Journal of Operational Research, Elsevier, vol. 124(2), pages 283-293, July.
    10. Antti Saaksvuori & Anselmi Immonen, 2008. "Product Lifecycle Management," Springer Books, Springer, number 978-3-540-78172-1, June.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Zaumanis, Martins & Mallick, Rajib B. & Frank, Robert, 2014. "100% recycled hot mix asphalt: A review and analysis," Resources, Conservation & Recycling, Elsevier, vol. 92(C), pages 230-245.
    2. Rosenbaum, Mark S. & Ramirez, Germán Contreras & Campbell, Jeffrey & Klaus, Philipp, 2021. "The product is me: Hyper-personalized consumer goods as unconventional luxury," Journal of Business Research, Elsevier, vol. 129(C), pages 446-454.
    3. Seppo Kuula & Harri Haapasalo & Arto Tolonen, 2018. "Cost-efficient co-creation of knowledge intensive business services," Service Business, Springer;Pan-Pacific Business Association, vol. 12(4), pages 779-808, December.
    4. Rönnberg Sjödin, David & Parida, Vinit & Kohtamäki, Marko, 2016. "Capability configurations for advanced service offerings in manufacturing firms: Using fuzzy set qualitative comparative analysis," Journal of Business Research, Elsevier, vol. 69(11), pages 5330-5335.
    5. Laurent Lim, Lâm & Alpan, Gülgün & Penz, Bernard, 2014. "Reconciling sales and operations management with distant suppliers in the automotive industry: A simulation approach," International Journal of Production Economics, Elsevier, vol. 151(C), pages 20-36.
    6. Zhou, Wei & Piramuthu, Selwyn, 2012. "Manufacturing with item-level RFID information: From macro to micro quality control," International Journal of Production Economics, Elsevier, vol. 135(2), pages 929-938.
    7. František Freiberg & David Michálek & Marek Nemec & Miroslav Žilka & George Cristian Gruia, 2011. "Survey Regarding The Level Of Product Lifecycle Management In Manufacturing Companies," Annals - Economy Series, Constantin Brancusi University, Faculty of Economics, vol. 4, pages 116-120, December.
    8. Natalia Szozda & Artur Świerczek, 2022. "Upstream and downstream dyad governance within the network structures: Creating supply chain governance for the customized products," Electronic Markets, Springer;IIM University of St. Gallen, vol. 32(2), pages 873-898, June.
    9. Lyons, Andrew Charles & Um, Juneho & Sharifi, Hossein, 2020. "Product variety, customisation and business process performance: A mixed-methods approach to understanding their relationships," International Journal of Production Economics, Elsevier, vol. 221(C).
    10. Masahiko Hirata, 2015. "Linking Management, Environment and Morphogenetic and Structural Components of a Sward for Simulating Tiller Density Dynamics in Bahiagrass ( Paspalum notatum )," Agriculture, MDPI, vol. 5(2), pages 1-14, June.
    11. Gökçe Kiliçkaya & Tarik Küçükdeniz & Şakir Esnaf, 2021. "Fuzzy Clustering With Derivative–Free Search Algorithm for Location of Biogas Energy Systems," International Journal of Operations Research and Information Systems (IJORIS), IGI Global, vol. 12(4), pages 1-19, October.
    12. Bruno César Araújo & Rodrigo Abdalla Filgueiras de Sousa, 2015. "Market Leadership in Brazil´s ICT Sector: The Cases of Totvs And Positivo," Discussion Papers 0197, Instituto de Pesquisa Econômica Aplicada - IPEA.
    13. Teerling, M.L. & Huizingh, Eelko K.R.E., 2006. "Exploring the concept of web site customization: applications and antecedents," Research Report 06F07, University of Groningen, Research Institute SOM (Systems, Organisations and Management).
    14. Na Liu & Pui-Sze Chow & Hongshan Zhao, 2020. "Challenges and critical successful factors for apparel mass customization operations: recent development and case study," Annals of Operations Research, Springer, vol. 291(1), pages 531-563, August.
    15. Minvielle, Etienne & Waelli, Mathias & Sicotte, Claude & Kimberly, John R., 2014. "Managing customization in health care: A framework derived from the services sector literature," Health Policy, Elsevier, vol. 117(2), pages 216-227.
    16. Amable, Bruno & Ledezma, Ivan & Robin, Stéphane, 2016. "Product market regulation, innovation, and productivity," Research Policy, Elsevier, vol. 45(10), pages 2087-2104.
    17. Frédéric Segonds & Julien Nelson & Améziane Aoussat, 2012. "PLM and architectural rehabilitation : a framework to improve collaboration in the early stages of design," Post-Print hal-00719169, HAL.
    18. Sandrin, Enrico & Trentin, Alessio & Forza, Cipriano, 2018. "Leveraging high-involvement practices to develop mass customization capability: A contingent configurational perspective," International Journal of Production Economics, Elsevier, vol. 196(C), pages 335-345.
    19. Gedas Baranauskas & Agota Giedrė Raišienė & Renata Korsakienė, 2020. "Mapping the Scientific Research on Mass Customization Domain: A Critical Review and Bibliometric Analysis," JRFM, MDPI, vol. 13(9), pages 1-20, September.
    20. Süleyman BARUTCU, 2007. "Customized Products: The Integrating Relationship Marketing, Agile Manufacturing And Supply Chain Management For Mass Customization," Ege Academic Review, Ege University Faculty of Economics and Administrative Sciences, vol. 7(2), pages 573-593.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:ininma:v:34:y:2014:i:4:p:489-516. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: https://www.journals.elsevier.com/international-journal-of-information-management .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.