KingChaos Posted May 4, 2023 Share Posted May 4, 2023 (edited) Hi there, i got some node "Get Num Rows and Cols" from marissa here working fine. now i need to get the information out of the subrows of a worksheet. i need a marionette, which can extract the subrowed same objects, to read out how often i got those items in the file. The goal is to make a graphic bill of material for our metalworkers, because this graficBOM is only available for woodworking parts from extragroup. But i need this for self made metal parts which are connected with my "schlosserei V9" Database. Further i need a node to get and write data out and into this database. @Dominique Corpataux helped me with the start and "what might work", thx for this. but now i need some help to get specific data of accumulated parts. br KC Edited May 4, 2023 by KingChaos Quote Link to comment
KingChaos Posted May 4, 2023 Author Share Posted May 4, 2023 for VW 2022 534634755_BauteilableitungMetallV0.vwx Quote Link to comment
KingChaos Posted May 4, 2023 Author Share Posted May 4, 2023 was hidden ^^ now it works. now i need to know how to get data in and out the database, which node i have to use? Quote Link to comment
KingChaos Posted May 4, 2023 Author Share Posted May 4, 2023 (edited) @Marissa Farrellis it easy for a non-programmer like me to manipulate your "get num rows and cols"-NODE to make it count the subrows of a specific row? Edited May 4, 2023 by KingChaos Quote Link to comment
Marionette Maven Marissa Farrell Posted May 4, 2023 Marionette Maven Share Posted May 4, 2023 Here's a standalone node to return subrows. I couldn't find my copy of the node you were using earlier and decided just creating one would be faster. It's definitely possible to combine the functionality, rows that aren't database rows will return 0, so if you wanted you could add an output port that also told you the subrow count. GetSubrowCount_v2022.vwx 1 Quote Link to comment
KingChaos Posted May 4, 2023 Author Share Posted May 4, 2023 (edited) Hi, thank you very much. I dont get what u meant in the last sentence. I dont know yet how to deal with the parts which are more the 1 time in the file. If i Analyse the file content with a Filter of All objects with database Connection it will list me all the doubled parts. If i clean the Lust with Duplikate delete i dont know whether the List can be use for Making duplicates. I am now searching for a node which can reset the 3d rotation of the parts to have them lying down in the construction Level oriented in x,y and z in the case the parts are placed and rotated. I am also searching for a node which can make the 2d arrangement of the parts in the List to have them next to each other. If all this is done i will need a sort node to have the parts Sorted by pulldownoption: Name Assembly Name Material Coating type Like it is done by the xtragroup Feature for the 3d parts. If u can Support me further in this project i will make a Metal Layout in 5 Minuten instead of 2 hours. I will publish the wrap then for the community. Br kc ❤️ Edited May 4, 2023 by KingChaos Quote Link to comment
Marionette Maven Marissa Farrell Posted May 4, 2023 Marionette Maven Share Posted May 4, 2023 Can you supply me with a simple file that represents what you're trying to organize? 1 Quote Link to comment
KingChaos Posted May 4, 2023 Author Share Posted May 4, 2023 Plus i have to arrange the placement of the parts in a choosable columnsnumber to make it fit in diffferent Layouts. Btw is there a measure node which can used to automatically place aome measures? Quote Link to comment
KingChaos Posted May 4, 2023 Author Share Posted May 4, 2023 this node is needed, its only an example for the 2D arrangement. the stuff i need to make is something like this. this is made by xtragroupd for the CNC 3D Parts it copies all the 3d Parts flat into x-y with its name, material etc., but i need this for free parts which have nothing to do with xtragrou interiorcad. in bonus i need not only a top view of this part i need a side view under the top view and a side section right of my top view. It is a horror to make a viewport in the layout for all the metalparts i used and turn them into orthogonal views to place some measures while i have to be sure only having 1 of them in my viewport in the layout. In our business, shop interior the 3d parts of extragroup are not half the work we have to do. so it will be extremely comfortable to have such a tool for not-3D-part of XG. in the vwx file are some metal parts connected to the record schlosserei v9 i think and the corresponding list is Metallbau i think, u will see it in the bom folder in the manager. br nils BauteilableitungMetallV1.vwx Quote Link to comment
KingChaos Posted May 5, 2023 Author Share Posted May 5, 2023 some problems occured, because they objects are sometimes groups sometimes solids. I cant "set entity matrix" of a group to make it go x and y. so i would have to make the record field value onto the solids instead of groups to make it easier making the objects were 0° rotated in all axises. Quote Link to comment
KingChaos Posted May 5, 2023 Author Share Posted May 5, 2023 @DomC do you have any idea, how i can make this happen? i got your node and it can help, but it wont do all the rest ^^ i think with this node i can place the duplicates for the specific views (side, top front maybe isometric) but i dont know how to grab the right ones to move Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.