Jump to content
AutoDesSys Forums
Alan Cooper

FormZ Information Management output to CutlistPlus for Woodworkers

Recommended Posts

FormZ is great for woodworkers as a modelling tool. It also has the Information Management palette to get the data out to a csv file and from that, into a cutlist program.

 

2 files attached: a translation spreadsheet in .xls format which can be opened in Open Office Calc or Microsoft Excel, among others, and instructions in the PDF file.

 

Enjoy! Alan.

SortThicknessLengthWidthTemplate04.zip

BillOfMaterialsFzToCutlistplusViaOOCalc.pdf

Share this post


Link to post
Share on other sites

Hi Alan,

 

Nice PDF Tutorial!  Lots of Step by Step documentation (that I was not expecting before opening the PDF).  

 

Here's just one screen capture from the document!

 

post-5-0-75525700-1418767143_thumb.jpg

Share this post


Link to post
Share on other sites

Thanks. I've had a quick skim read of the tutorial and potentially looks like something that might be useful. I'll go through it in more detail and let you know how i get on.

Share this post


Link to post
Share on other sites

Duncan, I look forward to hearing how you get on. If you will use it regularly, it is well worth recording a macro in Calc or Excel to speed up the process of conversion.

FormZ is great for woodworkers and deserves greater exposure, especially with the improvements in version 8 and the availability of FormZ free which brings it within reach of casual users and even for users' customers to use as a 3d viewer and more.

Share this post


Link to post
Share on other sites

Hi Alan,

 

Just to let you know I think you did a great job of this. I have been tinkering with this exact issue (creating cut lists from FormZ models). I ended up taking a different route, which involves exporting into another CAD program first. I would, however, love to stay in FormZ for modeling, shop drawings, and cut lists. What you’ve accomplished is a major step in this direction. Layout just needs a few improvements and everything could be done under one roof.

 

It’s worth noting that I convinced the developer of the other CAD program mentioned above to create a utility inside their B.O.M. function to do what you have done (the data exports from the CAD program already sorted). It parses the x,y,z extents or ‘bounding box’ data so that a ‘length’ field is always largest, and ‘thickness’ is always smallest, and ‘width’ is always in between. Maybe something the FormZ team would be interested in? This would be a benefit to not just woodworkers, but anyone who works with parts created through deduction (wood, metal, glass etc.). 

 

I absolutely agree that FormZ deserves more exposure in woodworking circles. 

 

Thanks again, Gavin

 

Share this post


Link to post
Share on other sites

Hi Gavinmac

 

Thanks for your post. I fully agree that it would be useful if the output from info-management were pre-sorted, however you will be able to get the info into cutlistplus surprisingly quickly once you get used to the routine and use a keyboard shortcut in Excel or in Open Office Calc to activate a macro to do most of the magic instantly. It's like many routines, once you get used to them, they become second-nature, however it would be amazing if there was a plugin for FormZ to export directly into cutlistplus.....or perhaps not, as I do tend to need to make a few adjustments to the spreadsheet, omit a few unneeded items for example, and that is easier to do in the spreadsheet than in cutlistplus. I suppose I am reasonably happy now with the way it is because I can get work done pretty quickly with this routine, but there are other priorities in my opinion, for the developers like improving the user interface to maximise real estate by improving palette sizes and labels, especially when inactive, and developing some of the plugin functions which were lost with the introduction of plugin labs.

Share this post


Link to post
Share on other sites

This year I have organised my models of furniture into numbered assembly groups and isolate each group in turn to name parts effectively and afterwards add serial numbers semi automatically all with the Rename Objects extension.

That leaves 'layers' free to use within any assembly group.

 

If I had time I would update this tutorial to include the adding of serial numbers [using the fantastically excellent 'rename objects' labs extension] for assembly groups and using the =RIGHT(cell ref;5) command in Open Office Calc to extract the serial number from name with serial number, eg to extract 02004 from a cell which contains 'table top 02004'

 

I don't need to control the part number following the group number eg 004 but appreciate greatly the fact that I can set the starting number to reflect the group [in this case for assembly group 02 I would use 02001 to start the serial numbers.]

This is great because no matter what part I find on a job, I know which group it refers to and does not require much effort to perform as the serial numbers can be set straight after cleaning up the object names one group at a time with the Rename Objects extension.

 

Hope that makes sense.

Hoping one day that FormZ pro will fully integrate with CutlistPlus FX like some other modelling programs have done.

Edited by Alan Cooper

Share this post


Link to post
Share on other sites

Update to routine: The last few months I've been more careful to model wooden parts orientated Z for length (height), X for width, Y for thickness (depth) and to make object axis corrections for individual parts by using the Edit Axis tool which is pretty efficient for rotating individual object axis by 90 degree steps. Having correctly orientated parts improves output for information-management BOM output, requiring less editing of the spreadsheet prior to importing into a cutlist program.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×