Announcement

Collapse
No announcement yet.

Revit <--> Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    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
    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

    Sol Amour

    Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
    Portfolio Website @ Cargo Collective

    Comment


      #3
      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?
      Revit for newbies - A starting point for RFO


      chad
      BEER: Better, Efficient, Elegant, Repeatable.

      Comment


        #4
        == 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).

        Sol Amour

        Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
        Portfolio Website @ Cargo Collective

        Comment


          #5
          Thanks! I will give this a try and report back...

          Reuben

          Comment


            #6
            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?

            Import XL Screenshot.PNG

            Thanks for your help!

            Reuben

            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

            Comment


              #7
              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

              Sol Amour

              Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
              Portfolio Website @ Cargo Collective

              Comment

              Related Topics

              Collapse

              Working...
              X