Announcement

Collapse
No announcement yet.

Revit to Excel and Excel to Revit

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

    Revit to Excel and Excel to Revit

    Hello All,
    Firstly I am beginner in Dynamo so please bare with me. Thank You.


    Scenario is as follows,
    Three are rooms with Name, Number, Finish and say Color.

    I have successfully created revit to excel data sheet. Also I have added 'name' (Header) of each of column of excel sheet using "List.addItemToFront".
    Please find attached Image "Revit_To_Excel'.

    Now I want to Extract the "Changed" data from Existing Excel sheet to Revit model. Facing problem is, its fetch headers strings instead of start from second row of excel sheet.

    Simply I won't Headers strings or first row which has added strings.

    Please find attached Image "Excel_TO_Revit'.

    Requesting you please correct my links.

    Thanks & Regards,
    Attached Files

    #2
    Hello Yogihit! Welcome and awesome stuff that you're using Dynamo

    Below is a quick suggestion for a little efficiency gains. I would pull in data in the following way;

    RevitForumDotOrg_Push_Data_to_Excel_Image.jpg


    In terms of your questions:

    Using List.GetItemAtIndex will get the index for the first tier of of objects. You'll have to run another one to get the next tier.

    Or you can use the DesignScript short hand. Both are shown in my image below.

    RevitForumDotOrg_ListGetItemAtIndexLong.JPG

    The third option is using List.Map. What this node does is 'maps' a certain function over a sub-list. This option will be harder to manage though. You'll simply get index 0 and index 0 without the ability to change the sub-index listing.

    The reason that you're Element.SetParameterValueByName node is failing is because the data being read from Excel is a "String" (Which basically just means text).

    Revit needs a number to push into a number parameter. As such you'll have to look at 'String.ToNumber' and potentially 'String From Object' nodes to change the data type before you try to push it back int Dynamo.

    Sol Amour

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

    Comment


      #3
      Sol Amour sir,

      Thanks a lot for introduce me to something new and amazing. I will try all options you have given.

      Thanks again.

      Best Regards,
      Yogesh

      Comment


        #4
        hi Sol Amour, is it possible to set parameters in the same way as to get parameters? i mean using list of elements instead of individual element, see attached JPG, thanks.
        Attached Files

        Comment


          #5
          Originally posted by Ning Zhou View Post
          hi Sol Amour, is it possible to set parameters in the same way as to get parameters? i mean using list of elements instead of individual element, see attached JPG, thanks.
          It should be by using using Cross-Product lacing ('XXX' on the node)!

          Sol Amour

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

          Comment


            #6
            sorry to bother you sir, but i missed steps and failed to extract data from revit to excel. Please find attached image.
            Attached Files

            Comment


              #7
              Originally posted by yogihit View Post
              sorry to bother you sir, but i missed steps and failed to extract data from revit to excel. Please find attached image.
              If you right click on that little icon - it will give you an option to change your Lacing. You want to change it to Cross-Product which is demarcated as 'XXX'. This means the data checks all of those fields.

              I explain lacing in this thread here - halfway down. That should help clarify the principles behind it.

              Sol Amour

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

              Comment


                #8
                Originally posted by amoursol View Post
                It should be by using using Cross-Product lacing ('XXX' on the node)!
                i've already used cross-product lacing if you noticed 'XXX' on set paramater node just same as get parameter node

                Comment


                  #9
                  Originally posted by amoursol View Post
                  If you right click on that little icon - it will give you an option to change your Lacing. You want to change it to Cross-Product which is demarcated as 'XXX'. This means the data checks all of those fields.

                  I explain lacing in this thread here - halfway down. That should help clarify the principles behind it.
                  Thank you for explaining @ lacing. unfortunately still facing problem .. now its not combining my lists
                  Attached Files

                  Comment


                    #10
                    Originally posted by Ning Zhou View Post
                    i've already used cross-product lacing if you noticed 'XXX' on set paramater node just same as get parameter node
                    Ah so I made a graph to test this - and my machine is now running in recursion haha. My best guess is that you need to convert your 'number' parameter data into numbers as it's currently just a string.

                    You can use a few String.ToObject / String.ToNumber nodes and some list chopping / sewing to get there. If my test Revit session stops crying i'll show you my results...

                    Sol Amour

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

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X