Jump to content


Photo
- - - - -

FormZ Information Management output to CutlistPlus for Woodworkers

Information management woodworking cabinetmakers cutting lists cutlist csv file furniture

  • Please log in to reply
8 replies to this topic

#1 Alan Cooper

Alan Cooper

    Advanced Member

  • Members
  • PipPipPip
  • 447 posts
  • LocationBuckinghamshire, UK

Posted 16 December 2014 - 04:43 PM

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.

Attached Files


  • Bo Atkinson, VitezDiny and khabarnaak like this

FZ8.5 pro with Renderzone on Windows 7 64bit.

Family Plan.


#2 Tech

Tech

    Moderator

  • Moderators
  • 4,047 posts

Posted 16 December 2014 - 04:59 PM

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!

 

Screen Shot 2014-12-16 at 4.57.48 PM.jpg



#3 Duncan303

Duncan303

    Advanced Member

  • Members
  • PipPipPip
  • 37 posts

Posted 21 January 2015 - 02:23 PM

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.



#4 Alan Cooper

Alan Cooper

    Advanced Member

  • Members
  • PipPipPip
  • 447 posts
  • LocationBuckinghamshire, UK

Posted 21 January 2015 - 05:42 PM

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.


FZ8.5 pro with Renderzone on Windows 7 64bit.

Family Plan.


#5 Gavinmac

Gavinmac

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 03 May 2015 - 12:23 PM

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

 


  • Bo Atkinson likes this

#6 Alan Cooper

Alan Cooper

    Advanced Member

  • Members
  • PipPipPip
  • 447 posts
  • LocationBuckinghamshire, UK

Posted 03 May 2015 - 01:16 PM

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.


FZ8.5 pro with Renderzone on Windows 7 64bit.

Family Plan.


#7 Alan Cooper

Alan Cooper

    Advanced Member

  • Members
  • PipPipPip
  • 447 posts
  • LocationBuckinghamshire, UK

Posted 25 July 2016 - 12:19 PM

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, 25 July 2016 - 12:21 PM.

FZ8.5 pro with Renderzone on Windows 7 64bit.

Family Plan.


#8 Tech

Tech

    Moderator

  • Moderators
  • 4,047 posts

Posted 25 July 2016 - 12:20 PM

Sounds great Alan, thanks for sharing! ;)



#9 Alan Cooper

Alan Cooper

    Advanced Member

  • Members
  • PipPipPip
  • 447 posts
  • LocationBuckinghamshire, UK

Posted 20 December 2016 - 06:17 PM

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.


FZ8.5 pro with Renderzone on Windows 7 64bit.

Family Plan.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users