Jump to content
Developer Wiki and Function Reference Links ×

Record - Spreadsheet Linking


har

Recommended Posts

Hi all,

 

I can't find a proper subforum for my question, so I'm posting it here.

 

As seen in the screenshot I'm doing the following:

- Marionette Object will change its size and look according to user input via OIP (see 9 objects on shape pane)

    - The objects are "Rack Panel" used for 19" Rack assembly and have two parameters: "Rack Unit Height" (integer 1-4) & "Panel Type" (blank, vented, etc.)

- The parameters are written into a database ("RackPanelRecord" (see exported .txt bottom right)

 

However, when trying to generate a spreadsheet for that data, my approach doesn't seem to work (see bottom left).

As seen on the drawing, there's three different versions of Panels with 1RU: "Blank", "Security" and "Vented"

Instead of giving me three individual lines for each version, the spreadsheet will just "sum up" all 1 RU Panels and show "---" for the type field.

 

What am I doing wrong?

 

P.S.: I hope someone can make sense of what I wrote :)

RackPanelDatabaseLink.JPG

Link to comment
  • Marionette Maven

It looks like you have "Type" summarized.

If this is indeed the case, what you want to do is select row 2 by clicking on the gray 2 on the left (which will highlight the entire database row), and then you'll likely see a little box with 'sum' at the top of column 'C'. If you click and drag that out of the column, you should see all of the fields rather than a summary.

I'm attaching an image in hopes that it helps.

 

wkshtHelp.JPG

wkshtHelp2.JPG

Link to comment

Hi Marissa,

 

thanks a lot, that cleared it up.

By using the 'sum' on both columns, I got exactly what I wanted - Counting all Panel objects that are the same.

 

I've been trying to find some tutorials on worksheet scripting for a while now but didn't find anything useful.

Any hints for places to start?

Link to comment
  • 1 month later...
On 9/13/2016 at 2:34 PM, Alan Woodwell said:

Hi, Attached are a few networks that involve linking to spreadsheets by Marissa that may assist.

Marionette_Record_MFarrell_AFW_01.vwx

WorksheetHelp_Post223365_MFarrell (2).vwx

Untitled2.vwx

 

Alan, I'm interested in linking record formats with marionette objects. The purpose is to import a spreadsheet that will create all the objects contained in it.

The files attached to this post seem relevant but for some reason they are not available. Do you think you can post them again?

 

Thanks

--Carlos

 

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...