Onshape BOM App installed- where is it?

edward_petrillo

I went to the App store and downloaded the "Onshape BOM for Google Sheets".  It's shown in my Manage Account>Onshape Settings>Applications, and in the App store it's shown as "Installed".  But where is it?  How do I open and use it?  

edward_petrillo

Answered, thanks to roadmap from @viru. @lougallo, perhaps a "read me"  or equivalent communication when installing the app would be helpful.

lougallo

I'm the developer of that app. It is a Google sheets addon so you have to run it from google sheets. Let me know if you have questions from there. 

viru

@edward_petrillo , You have to open your google drive account and refer method as shown in below video.


Onshape BOM for Google Sheets Add-on connects to your Onshape account and extracts bills of material (BOMs) from your assemblies. Once extracted, all important metadata from the assembly is populated into the Google Sheet including:

• Created by
• Created date (UTC)
• Modified by
• Modified date (UTC)
• BOM creation date

BOM columns:

• Item number
• Quantity
• Name
• Description
• Part Number
• Revision
• State

Modification of the BOM values in Google Sheets can also be updated and synchronized back to the Onshape part and assembly metadata fields for the following:

For workspaces and versions:

• Description
• Part number
• Revision

For workspaces only:

• Name

For versions only:

• State

Currently this add-on extracts a "Parts-only" BOM. Connecting Google Sheets to Onshape's full cloud CAD centralizes your Bills of Material management.

edward_petrillo

Answered, thanks to roadmap from @viru. @lougallo, perhaps a "read me"  or equivalent communication when installing the app would be helpful.

shawn_crocker

@lougallo
My heart jumped and rose up when I saw this post.  BOM straight to sheets is basically what I do manually all the time (unsure if open BOM is what we need and do not have the brain power right now to attempt figuring out implementing it).  No customizing transferred columns sank my heart right back down (.  It would be great to be able to customize exported columns and export into an unfolded structured bom.  I have templates that I past info into that figures out what part numbers should be folded up and which one dissolved then sums up all the length and sheet size properties to generate a total material used style list for ordering and such.  I hoping for a way other can perform this task without having to import data in a very specific way.

alan_baljeu

@shawn_crocker I don't know if it will serve you, but have you looked at the Open BOM app?