can we import excel or csv files into windchill to make/create BOM's?

[msonnathi]

Hi team,

creating BOM in windchill taking long time, as i have to enter part number and it will take time for search engine available of part in windchill.

If I want to make 50 components BOM it will take minimum 15 to 20 mins.

I would like to make an customiziation macro for this please suggest me how to do it.

can windchill have option to import of excel or csv files? if it available let me know how to do.

thanks,

madhu

[BineshKumar1]

There is an out of the box feature to import BOMs through a spread sheet.

To get the template, one option is to

1. Navigate to an existing top level WTPart

2. Go to Actions > Export Importable Spreadsheet

3. Select "Parts", "BoM"

4. Select a format and file name

You will get a spreadsheet with two sheets one for Part and Other for BOM. You can modify the sheet as per your new requirement.

To import the template

1. Go to the product details > Actions

2. Select "Import from Spreadsheet"

3. You can select the action for the import, "Add or Update or both

4. Validate the file for any errors and import it.

[msonnathi]

thank you Binesh  for quick reply, but I could not able to see those option in my windchill.

1. unable to export imporatble spread sheet.

2. I didnot see import from spread sheet.

could you have reference documents or link for this it may help me.

thanks

[dschenken]

Curiously neither of you mentioned the version of Windchill you are referring to. There's also no indication of what user access is required to get to this or the user access available.

[BineshKumar1]

We are on 10.2 M030, Read/Download/Modify/Create is what you need to import. ACL depends on which state the parts are if you are updating the existing one.

WHC link - http://support.ptc.com/cs/help/windchill_hc/wc110_hc/index.jspx?id=ImExImportSpreadsheet&action=show