Jump to content
AutoDesSys Forums

Leaderboard


Popular Content

Showing content with the highest reputation on 02/24/2019 in all areas

  1. 1 point
    We are now finding the conversion of our FormZ bill of materials csv output to a format which Cutlistplus can import a very simple process by use of a macro recorded in open office calc. Please note that the parts are organised in numbered 2 digit assembly groups and 2 digit part numbers (serial numbers) which are produced with the FormZ rename objects labs extension tool. It puts a space in between the group number (suffix) and the serial number which is placed after that, so our parts have 5 digits including the space, which works well for us. (Set the appropriate padding in renamer serial numbers to include any required leading zeros). Others might prefer 6 or 7 digits in total depending on how many objects you have in your assembly groups, and the macro would need to be adjusted for this to take 6 or 7 digits across to the part number column using the RIGHT function instead of 5. Here is the macro we use in open office 4.1.6 calc, attached here as a rich text file. Even those of us who are not familiar with programming can recognise a logical process and command pattern structure within it. Please note that just before we apply the macro we have to select all cells in the csv file. I hope this encourages more woodworkers to use the combination of FormZ pro 8 and above and Cutlistplus FX (gold or platinum) as they make for a superb workflow and help to keep material waste to a minimum. OpenOfficeMacroCutlistplus190210.zip
×