Skip to main content
M
mwaghmode-21-Visitor
1-Visitor
December 9, 2016
Question

Import csv file to make parametric BOM

  • December 9, 2016
  • 3 replies
  • 2735 views

Hello,

We are using WF4, is there any option in Pro/E to Import .csv or Excel file in Drawing as BOM Table and make it as repeat region.

Further we wanted to create Balloons out of the index.

Thanks in Advance

Manoj


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

3 replies

Chris3
Chris321-Topaz I
21-Topaz I
December 9, 2016

Parametric balloons can only be driven by repeat regions. Repeat regions can not be created by csv or Excel files. You can create a Pro/Table within Pro/E and then save that and reuse it. You can also import a csv file as a table in Pro/E but there is no way to turn it into a repeat region.

    B
    BenLoosli23-Emerald III
    23-Emerald III
    December 9, 2016

    With a repeat region BOM table, it will populate automatically from the assembly structure. You can then balloon the items from the BOM index.

    M
    mender12-Amethyst
    12-Amethyst
    December 9, 2016

    Parametric balloons derive from parametric repeat regions with instructions on how to traverse an assembly database and extract information.  If your CSV file contains the instructions in question, you can do it as follows:  1) contents of .csv are

    INDEX,MODEL, QTY

    &rpt.index,&asm.mbr.name,&rpt.qty

    2) Table > Table From File, specify the .csv, place it.  At this point, there is a table, but no repeat region yet...

    3) Repeat Region > Add.  Select 'rpt.index', then 'rpt.qty'.  Update Tables.  Voila!

    If your CSV file contains plain text, you can make a plain text table of it, and you could make some balloons that looked like BOM balloons, but none of it would have any relationship to the rest, or to your assembly structure, so you really want to make it parametric.

    Terms & ConditionsAccessibility statement