Donate Now Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

Results 1 to 7 of 7
Like Tree4Likes
  • 2 Post By amoursol
  • 1 Post By WVReviter
  • 1 Post By amoursol

Thread: Revit <--> Excel

  1. #1
    Member
    Join Date
    January 10, 2011
    Posts
    61
    Current Local Time
    05:01 PM

    Unhappy Revit <--> Excel

    Dynamo gurus:

    I am just getting started, so please forgive my ignorance. I have managed (mostly using Data-Shapes) to cobble together a way to export room parameters to Excel, along with the ID of each room object.

    My challenge is to re-import once the Excel has been filled out. The problem is associating the data in each line with the ID. If a room has been deleted since the Excel export or a cell has been left blank, it throws a null value. This, in turn, throws off the number of items in the final list.

    Any suggestions on keeping the data in each row associated with the ID would be appreciated!

    Thanks,

    RL

  2. #2
    Senior Member amoursol's Avatar
    Join Date
    November 21, 2012
    Location
    London, United Kingdom
    Posts
    612
    Current Local Time
    10:01 PM
    Kia ora RL,

    Please have a look at my blog post WRANGLE THAT DATA: DYNAMO FILTRATION AND SORTING - Design Tech, specifically the Get Keys method as it will do exactly what you're after
    Andres Franco and ryntau like this.

  3. #3
    Moderator cellophane's Avatar
    Join Date
    August 9, 2011
    Location
    Louisville, KY
    Posts
    6,140
    Current Local Time
    05:01 PM
    Quote Originally Posted by amoursol View Post
    Kia ora RL,

    Please have a look at my blog post WRANGLE THAT DATA: DYNAMO FILTRATION AND SORTING - Design Tech, specifically the Get Keys method as it will do exactly what you're after
    Why do you use the == node into your Filter.ByBoolMask node?

    FWIW - I can never get the stupid bool filter to work the way I think it should - perhaps because I don't use the == node?

  4. #4
    Senior Member amoursol's Avatar
    Join Date
    November 21, 2012
    Location
    London, United Kingdom
    Posts
    612
    Current Local Time
    10:01 PM
    == is simply a comparison. Does A equals B? If so it spits out true, if not it spits out false. I use it as the basis for almost all of my List.FilterByBoolMask filtration. It's extremely powerful in conjunction with the Get Keys workflow in the link for processing an Element ID check of data (Even better with GUID).

  5. #5
    Member
    Join Date
    January 10, 2011
    Posts
    61
    Current Local Time
    05:01 PM
    Thanks! I will give this a try and report back...

    Reuben
    amoursol likes this.

  6. #6
    Member
    Join Date
    January 10, 2011
    Posts
    61
    Current Local Time
    05:01 PM
    Sol:

    Sorry to be so thickheaded here, but I couldn't figure out how to get this to work using GetKeys. I used the List.ContainsItem to parse through the list and make a new list based on whether the room still exists. Then I passed this info on to a List.Transpose node to make lists that I use to populate parameters. (see image) Do you think this method will cause any problems, or is the GetKeys method way more reliable?

    Revit &lt;--&gt; Excel-import-xl-screenshot.png

    Thanks for your help!

    Reuben

    Quote Originally Posted by amoursol View Post
    Kia ora RL,

    Please have a look at my blog post WRANGLE THAT DATA: DYNAMO FILTRATION AND SORTING - Design Tech, specifically the Get Keys method as it will do exactly what you're after

  7. #7
    Senior Member amoursol's Avatar
    Join Date
    November 21, 2012
    Location
    London, United Kingdom
    Posts
    612
    Current Local Time
    10:01 PM
    List Get Keys method will allow you to use any jumble list versus any other jumbled list.

    In your example, you're hard coding in some queries (i.e GetItemAtIndex to 7), which is great in an isolated case, but may fall flat if your data structure changes.

    In essence, for robustness of script, you want to avoid hard-coding as much as possible
    uaifestival likes this.

Similar Threads

  1. Revit To Excel
    By veeranna.guggari13 in forum Dynamo BIM
    Replies: 0
    Last Post: February 9th, 2016, 08:58 AM
  2. Renaming From Excel - After Sorting Data in Excel
    By cellophane in forum Dynamo BIM
    Replies: 8
    Last Post: January 18th, 2016, 01:24 PM
  3. Revit to Excel and Excel to Revit
    By yogihit in forum Dynamo BIM
    Replies: 16
    Last Post: October 13th, 2015, 01:23 PM
  4. Replies: 3
    Last Post: June 6th, 2015, 11:18 AM
  5. Excel to Revit
    By trohman in forum MEP - General
    Replies: 9
    Last Post: December 22nd, 2014, 01:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •