Drawing list from Worksheet

[AlanW]

@BGHi Attached is the file with the objects as before. What you need to do with the network is right click on the network and select wrap network and you get one node, right click on that and select convert to object and you get the windows. To unwrap or edit the object just reverse, right click on the object and convert to wrapper and right click again to unwrap, or right click onthe object and click edit network to get to the network. Clear as Mud?

You can have a look at some of the videos about marionette on my youtube channel Alan Woodwell.

HTH

Window_Schedule_001.vwx

[BG]

That's clever.  Thanks. Brett

[AlanW]

7 hours ago, BG said:

Thanks Alan, will try that out.

Attached is a sample schedule.

Cheers Brett

Sample Window Schedule.vwx

@BGThe way you do the schedules is exactly the way we do them and this is why I have been trying to automate them. If you draw them as a 3D object you shouldn't have to redraw them. Also when you change a window you have to go between the plan, elevation and window schedule checking and redrawing. With a little bit more thought and learning I hope to get the dimensions screens and as much as possible to be automated in this way. Will keep at it.

[AlanW]

Hi, Back Playing again.

Question for the brains trust.

In the attached file if I run the network in oblique view (1 on num pad)  i get my windows laying flat on the working plane and dimensioned width and height,  go to sheet layer and they are getting more like what i want. just need to sort out more the settings of the text.

If I run it in top plan mode the windows appear in top and would need to be rotated and dimensioned seperatly. 
Why is it so??????

Window_Schedule_170623_001.vwx

[AlanW]

Hi,

Same issue as above but this file has the dimensions set off windows and also FFL to U/S window.

Another issue when the dimensions run is that the witness lines are not visible. Need to go in and make visible in the OIP. If i draw an dimension the witness lines are shown automatically. So something in the Dim node needs to be altered????? Maybe?

 

 

 

Window_Schedule_170623_003.vwx

Edited June 25, 2017 by Alan Woodwell

[AlanW]

In the attached file I have removed the ungroup node. Tab between 0 and 1 on num pad. The windows show in oblique but disappear in top plan mode.

Any reason for this?????

 

 

Window_Schedule_170623_004.vwx

Edited June 25, 2017 by Alan Woodwell

[Benny Franke]

On 5/9/2016 at 2:38 PM, Marissa Farrell said:

 

I've added two brand new nodes to your network (I probably have the same ones floating around, and these ones aren't clean in the sense of descriptions, but they work. One day I'll get all of my worksheet nodes posted with correct descriptions.)

The first node is "Get Subrow Count", this will tell you how many subrows there are for a row. In your spreadsheet, row 2 has 2 subrows. I've incorporated this into your network to show you how to use it.

The second one is "Get Subrow Value", this node will provide you with the value in the subrow cell. It takes the same inputs as "Get Cell Value" as well as a "Subrow" input.

 

@Marissa Farrellwhere can i find those GetSubrow Count and Get Subrow Value nodes? I would like to have them for my Marionette as well. Thank you very much

[AlanW]

@Benny Franke Hi, you will find the get subrow in the associated folder.

I have all these in my workgroup folder and many more that people added over time.

 

these may assist.

01. Worksheets.vwx

02. Set Operations.vwx

03. Get Operations.vwx

04. Conditional Operations.vwx

[Benny Franke]

@Alan Woodwell Thanks,  I already have those but every node in there that gives you a value or string from subrow needs an subrow int as input which I can't get....

I want the network to show me the value of a selected  subrow.

 

The whole idea is to update objects by changing parameters in the worksheet. If anyone has a better idea or a different way that works please tell me. I am stuck here since 2 weeks. 

 

Thanks for the files Alan.

 

[AlanW]

@Benny FrankeHi, Ok will have a look and see what i can do. Can you send me of post a network that you are looking at??

Edited November 27, 2017 by Alan Woodwell

[Benny Franke]

@Alan Woodwellsure. This is an example i am working on where i isolated this problem. I want to change the rectangles by manipulating there database values in the Worksheet.

05._EigenerWorksheetTest.vwx

[AlanW]

@Benny Franke Hi, in this network you can change the size of the object by the worksheet. Change the values in the worksheet and click on the object and yo uhave to trigger the script to update. There is an update button in the OIP that you toggle between and the object will change.

Trust this helps and is what you are trying to do.

Regards

 

Alan

Control By Worksheet_001v2018.vwx

[Marissa Farrell]

@Benny Franke

There's not a great way to do this with a database, but here's the closest I think we can get for now. The only issue is that your objects won't dynamically update, you will have to run Tools > Utilities > Reset All Plug-In Objects to get them all to redraw. This is a limitation with Marionette.

 

The idea is to attach a record to your rectangular Marionette object and create a database with the criteria Record = [Record Name] (In my example, the record is Rect)

Then the script will set the values that you defined as Width and Height in your worksheet database as the dimensions of the rectangle.

I've attached a quick video demonstrating this (no audio)

 

 

2017-11-28_8-29-27.mp4

DimsFromDatabaseExample_MFarrell.vwx

[Melissa Johnston]

Hi Alan,

 

Firstly, Thank You!!

 

I'm so excited by this Marionette tool! Being the person responsible for door/window schedules I can see its going to save me a LOT of time.

 

I've been playing around with it in the most recent VW and am finding that the doors/windows are not looking the same as yours. Please see screen shot.

 

I've gone through each string/node and "run" each one individually and it hasn't made much difference.

 

Is this something you have seen before?

 

Thanks in advance.

 

Mel - Vectorworks Newbie

[AlanW]

@Melissa JohnstonHi, Just noticed this so will have a look. Can you add your VW file here or a small test file so i can look at yours.

Thanks.

One thing i recall is set your view to an isometric type view (hit 1 on Num pad) then run script.

Edited December 7, 2017 by Alan Woodwell

[Melissa Johnston]

Thank you Alan, I really appreciate this. 

 

Please see my file attached. I'll try your suggestion also. Thanks!!

Test.vwx

[Melissa Johnston]

Almost there Alan!

 

The doors are in but on a different plane.

[AlanW]

@Melissa JohnstonHi you have it all you hav to do is hit 5 on the Num Pad to see the door & Windows.

0 on num pat only shows wireframe and not 3d (Top Plan),

I also tested by adding new window and ran it and it added it in and went to viewport and updated. You need to set viewport to render hidden line to make it clearer.

 

Also by numbering the symbols they will come out in the numeric order. 01, 02, 03, etc must be 03 as 3 =30 in computer language.

 

Also need to look at why some of the dimensions show 100mm at door base etc. It dimensions to the extremities of the symbols and should go to base level (off floor) Found it, your Design layer is set to 100mm so will have to look at how to cater for many design layers, hopefully simply adjusting the windows to link to the design layer and place them above the other line, maybe.

So I have added a few nodes to adjust for the design layer height so you shouldn't get any strange dimensions anymore.

One dimension is measuring to the sill which is wider that the door may need to adjust your door symbol and i will see if i can override this and dimension to the door,

 

Also noticed that you have some items set Elev sill of frame and some head of frame. I always use head of frame as it is usually the most constant line arounf a building and easy to work with.

if you need it to do anything else let me know and hope it assists.

 

Great that you are getting use out of it.

 

Regards

 

Alan

 

Test-AW.vwx

Edited December 7, 2017 by Alan Woodwell

[Melissa Johnston]

Hi Alan,

 

Thanks so much for all your help.

 

Attached is my latest VW file. I had to manually orientate the doors and windows in the design layer, which is easy, and I'm really happy with how it all looks.

 

My only issue now is that the doors and windows seem to just be extrudes and polylines rather than a symbol that I can change and is then reflected in the associated viewport or even in the design layer. 

This will be an operator issue I know!

 

I'm hoping this is my last question for you!!!

 

Mel

Test.vwx

Edited December 12, 2017 by Melissa Johnston

[AlanW]

Hi will have a look but I think the issue is I wanted to dimension the windows and you cannot rotate plugins about the x or y axis so to rotate them I exploded via the ungroup node. It doesn’t matter as it is only a representation of the windows for the drawing, it does not destroy the symbol.

If you need them to stay as symbols just delete the ungroup node and dimension after and then to will have to use a section viewport to look at the windows standing up, then dimension them all separately in annotations.

hope this makes sence.

Edited December 13, 2017 by Alan Woodwell

[Melissa Johnston]

Thank you Alan

 

This is all so new to me!

[AlanW]

@Melissa JohnstonHi, So the attached one leaves the windows a symbols in a group, but does not rotate them over and dimension automatically.

I don't see any reason to worry that the windows in the schedule drawing are broken down, but if its a problem use this one.

HTH

Window_Schedule_171213.vwx

[Melissa Johnston]

Thank you Alan!

 

Have a great Christmas and New Years.

[gplumb]

there are 2 nodes mentioned in this thread earlier "Get Subrow Count" and "Get Subrow Value".

 

they are not visible anywhere above and i would really love to get my hands on them if they exist please.

 

am example of how the plumb them in would be great too.

[Marissa Farrell]

@gplumb

I don't have the nodes that were created when mentioned before available right now, but here is a file that includes what I believe you're looking for.

 

Newer versions of VW come with a small set of worksheet nodes, you can use Get Cell Value to return the subrow value.
I created a node to get you the subrow count. I also saved it as a resource so you can save it to your library if you'd like. (If you need directions on how to get it to show up in the Marionette resource popup, let me know.)

 

Please let me know if you need a version prior to 2023.

Subrow Nodes_MFarrell.vwx