Get Cell Value (Marionette)

[Nico vd Schaaf]

Hi

 

Seems a basic network but somehow I can't get it to work...

 

I'm trying to obtain the content from a certain worksheet cell and put it into a text. I've used some nodes found on this forum ...See files attached. 

 

Best,

 

N.

 

GetValue.vwx

[SBarrettWalker]

I believe that the output of the Get Cell Value node is already a string, so the Get String node is unnecessary. If you connect the "formula" output to the "s" input of the Text node it should work.

[Nico vd Schaaf]

Thanx for replying...

 

In the meanwhile I just figured it out too 😊. The input String cannot directly be connected to the worksheet. A 'select worksheet' node needed to be placed in between...I guess that's because the worksheet is 'outside of the wrapper'?

 

The GetString node isn't needed too...you're right about that...

 

N.

[Mi&D]

hello nicovanderschaaf, hello sbarrett,

I am a swiss architect with interest in marionette.

I am very happy that I've found this thread. 

because I have a similar problem to solve like you.

From a worksheet, which summarizes Spaces with identical Room ID

I'd like to obtain the content from column B (apartment area>see screenshot attached) and put it into a Room Database such as 11_Room User-Def (see attachment).  

I should be very thankful for your help.

Mi&D

[Nico vd Schaaf]

Hi,

 

I don't fully understand the workflow. What do you mean by roomdatabase? Space object data can be captured by a worksheet directly...you don't need marionette for it. 

 

N.

[Mi&D]

hi N.,

thanks for reply.

I try to explain it better: 

In the settings of Rooms (Spaces) I can select "additional Infos" (Zusatzinformationen).

My goal is to bring the whole apartment area into the following field for additional Infos "11_User-Def Info 2". 

I need to make a room stamp which shows:

 

• Room Name
• Room Area
• Apartment Area

I couldn't manage with worksheets, to get the apartment area into the roomstamp. I hope marionette can solve this problem.

Mi&D

Edited October 2, 2018 by Mi&D

[Nico vd Schaaf]

can you provide a VW file with just the space objects?

[Mi&D]

here it is.hope it works... 

Rooms only.vwx

[Nico vd Schaaf]

not sure if this is what you need but I created a room stamp (just the functionality...no layout) with room name, room area and apartment area...I also added the apartment nr. which is needed in the worksheet (named rooms) for 'summarizing' all the rooms of a certain apartment. In the worksheet you can just type in a value for the apartment area and it will be inserted in all the room stamps...

Rooms only_NvdS.vwx

[Mi&D]

hello! thx for this. I'll give it a try.

you'll get my feedback anytime soon.

[Mi&D]

hello nicowanderschaaf,

 

i had a look at your file.

It is not this, what I needed.

I need a tool, that does automatically summarize all Spaces with the same Room ID.

You just wrote the area by hand in the table. I have hundreds of apartments to provide with that information.

I don't want to insert all the data by hand. 

 

I send you back the file with my worksheet which does calculate the apartment area.

The Formula for it is:

=FLÄCHE(((R IN ['Space']) & ('Space'.'11_Room ID'='2201')))

 

You've posted above a marionette, which does "get cell values".

I would like to get this marionette in my file running.

It should get the values from column B (Apartment area) and write it into a Worksheet or into a Room Stamp.

 

Do you think, that this is possible?

Unfortunately, I don't have enough Skills in Marionette to program this.

I hope you can help me with it.

 

thx ,

Mi&D

 

 

 

 

VW Rooms only_NvdS.vwx

[SBarrettWalker]

Hello @Mi&D

 

I have made a script that I think does what you are asking. It takes the total area from the worksheet and writes it to the Additional Info 2 field of the correct space. It works on all the spaces in the document. I have wrapped the network and given it the name "Apply Apartment Area to Spaces." It works, but the space tags do not update automatically - they have to be "bumped." What worked for me was to select all of the spaces, and choose the correct space label from the dropdown list (even if it is already selected). This will update the tag to show the correct info.

VW Rooms only_NvdS_Marionette.vwx

[Mi&D]

hello sbarrett,

thank you so much for this.

I will give it a try anytime soon.

You'll get my feedback as soon as possible.

cheers,

Mi&D

[Mi&D]

hello sbarrett,

we have a big issue with marionette:

there is a problem with rotated plans ("Planrotation" in Swiss VW) and if the user-defined Zero-Point (Benutzernullpunkt) is not identical with the Vectorworks-Zero Point,

and if the plan is rotated: every time the Marionette Stamp is regenerated (or if we replace the symbol) it will be placed far out from its original position. in my case more than 30000 miles away. We think that the conflict is due to Zero-Point, Rotation angle and Center of the object.

Do you think you have an idea, of how we can solve this problem in marionette?

cheers,

Mi&D

[Marissa Farrell]

@Mi&D

There is a known issue running marionette in rotated plan with a user origin and it is being worked on right now. 

Currently, if you avoid rotated plan while running a marionette script, you won't have a user origin shift. There is no other workaround at this time. 

[Mi&D]

Hey! Thx for reply.

We have reset the user origin, so that it is equal to Vectorworks origin.

 

What sounds important to me is your expression "while running a marionette script".

That means, we can still keep on working in rotated plan, but at the moment we run the script,

we must take care, that the plan angle is 0° - correct?

[Marissa Farrell]

Yes. As long as you dont run the marionette script in rotated plan, you should have no issue. 

 

If you do find yourself still having an issue, please let me know the steps you took before the origin shifted. 

 

Hope this helps!

[Mi&D]

ok, I'll do so.

[Mi&D]

here is the problem with marionette stamp again:

I go from a layout into the construction layer. - NB: there is no plan rotation. -

I copy the marionette from one construction layer to another. marionette stamp doesn't appear.

as I do "zoom all", the rulers on the edges of the drawing area go far out from the origin...

in the info palette "marionette object" is still active. I do "select all" another time, but only the objects close to the origin are activated,

the marionette stamp is not taken in consideration. but it is still there...like a ghost ...

[Mi&D]

Another Feedback, Marissa:

whenever I turn visible all classes, the Marionette shows up again.

How come? before that, all classes related to marionette have been on...

 

[Mi&D]

@sbarrettHello, I started looking into the file you've posted. I've put some comments on your text message. Could you please give me some hints regarding this. 

have made a script that I think does what you are asking. It takes the total area from the worksheet and writes it to the Additional Info 2 field of the correct space. It works on all the spaces in the document. I have wrapped the network and given it the name "Apply Apartment Area to Spaces." It works, but the space tags  (>what is a tag?) do not update automatically - they have to be "bumped." (>what is a bumping?) What worked for me was to select all of the spaces, and choose the correct space label from the dropdown (>which dropdown list do you mean, where can i find it?) list (even if it is already selected). This will update the tag to show the correct info.

VW Rooms only_NvdS_Marionette.vwx

[SBarrettWalker]

Hello @Mi&D-

Here is a video that shows what I mean. I run the script in the video and update the tags so they show the correct info.

 

[Mi&D]

hello sbarrett

thx for the clip.

i understand the method now.

 

may I ask you another question?

as I understand, this marionette does get the values from each and every room with the same RoomID...

but, what if we want to get only the Rooms from a specific layer? is that possible?

 

In my case I have some split-level apartments. their area is divided amongst different layers. but, all spaces do have the same RoomID.

how can we tell the marionette stamp on level 1 to show only the area of the relating spaces?   

 

moreover, with the help of D. Corpataux we developed a script, that does update the apartment area tag automatically for all rooms.

I'll attached it here.   

VW Apartment Area v2.vwx

[SBarrettWalker]

Yes, its just a matter of creating a filter based on the layer of the object. You can do this with Marionette or you can add a field in your worksheet and query it there.

[Mi&D]

hey,

ok, if I get it right, marionette does get values from worksheets.

I think, I am able to solve this with a worksheet, myself.

but, i have no idea, how to make this work in marionette.

is there anywhere a tutorial around, from which I could learn how 

to get values from worksheets and bring them into a stamp symbol?

our support in Switzerland does not help customers with marionette issues.