Automated drawings using Excel

[Anonymous]

Hi guys!

My company makes a product that is almost the same every time, it just adds or remove product options and sets the correct distances.

For a while back I made an iLogic assembly that drives the panels and it works great. Now I`m planning to take it a step further by driving the entire model from an Excel spreadsheet and exporting a dwg for the final measurements. I`ve manged to make most of the code working by finding rules in this forum (many thanks to you guys) and tweaking them for my need. Step by step of the code is presented below.

1. Running rule :Load Excel - Opens Excel, update model parameters to "Right end distance" - working (row 14 in the attached excel file)
2. Run a separate rule (Sort Bom and Renumber (Stock number) that sorts the BOM and renumber item numbers - working
3. Run a separate rule (Step export) that export step files if the stock number contains CNC - working
4. Open predefined idw drawing - working
5. Run rule (in drawing using iLogic automation) Sort partlist in idw - working
6. Run rule (in drawing using iLogic automation) Rearrange view labels in idw - working
7. Run rule (in drawing using iLogic automation) Save as dwg, Panel 1 is now done - working
8. Close idw - working
9. Start updating model for panel 2 according to Excel - Catastrophic failure

The code manages to update the iproperites from row 15 to 17, but the model does not manage to write the new parameters to the model.

However, if I don`t trigger point 4 to 8, or if I dont trigger point 2 and 3, the code works. If I try to skip point 5 to 7, the catastrophic failure still occurs.

I`m guessing that it has something to do with returning to the assembly environment after the idw is closed? We do use vault, but all the files are checked out, including the idw.

I`ve attached the rules in word format and the excel spreadsheet .

Any help or pointers is greatly appreciated and if you find yourself in the west coast of Norway I will buy you a beer! 🙂

[b_sharanraj]

Hi @Anonymous

I can see that in your "Load Excel" iLogic Code that

ElseIf sCellValue = oRightD Then

if the above condition is true then only your rest of the steps will be executed else the code will just update your excel and close. Even it won't save b'coz of no code for that.

I'm not getting Step-9 start updating the model for next Assembly according to Excel but how you are making it b'coz no where I couldn't find a code for that.

So if you start again running iLogic you'll get same output.