IDEAS home Printed from https://ideas.repec.org/a/eee/ininma/v34y2014i4p489-516.html

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

    for a different version of it.

    References listed on IDEAS

    as
    1. Unknown, 2000. "Quality assurance in agricultural produce," ACIAR Proceedings Series 135369, Australian Centre for International Agricultural Research.
    2. Li, Zhan G. & Gery, Nurit, 2000. "E-tailing--For all products?," Business Horizons, Elsevier, vol. 43(6), pages 49-54.
    3. anonymous, 2000. "Revolutions in productivity," Annual Report, Federal Reserve Bank of St. Louis, pages 2-13.
    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. 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.
    6. 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.
    7. Eric J. Bartelsman & Roel Beetsma, 2000. "Profit Shifting and Productivity Mismeasurement," Tinbergen Institute Discussion Papers 00-097/2, Tinbergen Institute.
    8. Armstrong,Stephen, 2001. "Engineering and Product Development Management," Cambridge Books, Cambridge University Press, number 9780521790697, August.
    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, March.
    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. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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 Scientific Publishing, vol. 12(4), pages 1-19, October.
    8. 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.
    9. 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.
    10. 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.
    11. Dirk Briskorn & Konrad Stephan & Nils Boysen, 2022. "Minimizing the makespan on a single machine subject to modular setups," Journal of Scheduling, Springer, vol. 25(1), pages 125-137, February.
    12. Khan, Sher Jahan & Albishri, Norah & Galgotia, Aradhana & Papa, Armando, 2026. "3D printing technologies and innovation performance. An agile manufacturing theory perspective," Technovation, Elsevier, vol. 149(C).
    13. Brian Squire & Steve Brown & Jeff Readman & John Bessant, 2006. "The Impact of Mass Customisation on Manufacturing Trade‐offs," Production and Operations Management, Production and Operations Management Society, vol. 15(1), pages 10-21, March.
    14. Erno Mustonen & Jonne Seppänen & Arto Tolonen & Janne~Harkonen & Harri Haapasalo, 2020. "Product Portfolio Management Strategic Targets and KPIs over Life-Cycle: A Case Study in Telecommunications Business," Managing Global Transitions, University of Primorska, Faculty of Management Koper, vol. 18(1 (Spring), pages 5-23.
    15. A. Arrighetti & F. Landini, 2018. "Eterogeneità delle imprese e stagnazione del capitalismo italiano," Economics Department Working Papers 2018-EP01, Department of Economics, Parma University (Italy).
    16. Ding, Huiping & Chen, Xiangbo & Lin, Kuanhai & Wei, Yunbing, 2019. "Collaborative mechanism of project profit allotment in petroleum engineering service chain with customized integration," International Journal of Production Economics, Elsevier, vol. 214(C), pages 163-174.
    17. Wang, John & Yan, Ruiliang & Hollister, Kimberly & Zhu, Dan, 2008. "A historic review of management science research in China," Omega, Elsevier, vol. 36(6), pages 919-932, December.
    18. Tolonen, Arto & Shahmarichatghieh, Marzieh & Harkonen, Janne & Haapasalo, Harri, 2015. "Product portfolio management – Targets and key performance indicators for product portfolio renewal over life cycle," International Journal of Production Economics, Elsevier, vol. 170(PB), pages 468-477.
    19. Weckenborg, Christian & Schumacher, Patrick & Thies, Christian & Spengler, Thomas S., 2024. "Flexibility in manufacturing system design: A review of recent approaches from Operations Research," European Journal of Operational Research, Elsevier, vol. 315(2), pages 413-441.
    20. Lihra, Torsten & Buehlmann, Urs & Graf, Raoul, 2012. "Customer preferences for customized household furniture," Journal of Forest Economics, Elsevier, vol. 18(2), pages 94-112.

    More about this item

    Keywords

    ;
    ;
    ;
    ;
    ;

    Statistics

    Access and download statistics

    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.