export BOM and/or Cutlist to excel using script

Integrated solution for design, manufacturing and management that provides all standard parts and procedures for wood processing.

Moderators: remi77, Daniel, jacs

quazoosl
Corporal
Corporal
Posts: 29
Joined: Thu Oct 10, 2019 12:41 pm
TopSolid Module: TopSolid'Design
TopSolid Version: 6.20

export BOM and/or Cutlist to excel using script

Unread post by quazoosl » Tue Jan 21, 2020 1:45 pm

I'm looking for any and all resources regarding scripting. Specifically to facilitate exporting a BOM and/or a cutlist to excel.

(assuming one needs scripting for this to work)

Thnx.

User avatar
Todd
Second Officer Cadet
Second Officer Cadet
Posts: 206
Joined: Mon Nov 10, 2014 9:28 pm
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20
Location: Detroit, MI

Re: export BOM and/or Cutlist to excel using script

Unread post by Todd » Tue Jan 21, 2020 2:07 pm

You should not need a script to export a bom just select the export bom button on the wood functions but it is a bit faster to make a script with the export bom function.
Attachments
script 2.jpg
script.jpg
export bom.jpg
Todd Craig
Great Lakes Woodworking
tcraig@glwdetroit.com

quazoosl
Corporal
Corporal
Posts: 29
Joined: Thu Oct 10, 2019 12:41 pm
TopSolid Module: TopSolid'Design
TopSolid Version: 6.20

Re: export BOM and/or Cutlist to excel using script

Unread post by quazoosl » Tue Jan 21, 2020 4:26 pm

This helps, thnx.

More info on how to manipulate the outcome would be very welcome.

User avatar
Todd
Second Officer Cadet
Second Officer Cadet
Posts: 206
Joined: Mon Nov 10, 2014 9:28 pm
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20
Location: Detroit, MI

Re: export BOM and/or Cutlist to excel using script

Unread post by Todd » Tue Jan 21, 2020 4:51 pm

Controlling the output is dependent on your part definition, BOM template, filters, & sometimes key word text's in the BOM template files
Attachments
Wood codification US.PDF
(701.6 KiB) Downloaded 32 times
filters.jpg
BOM TEMPLATE.jpg
Todd Craig
Great Lakes Woodworking
tcraig@glwdetroit.com

Post Reply