I need to export my multi-catogory schedule from revit to excel using dynamo I dont want to use family types nodes, Categories, All elements of categories nodes because while using that kind of nodes I was able to export only a single category.What ever In the multi-category schedule I need to export all the categories, values, parameters as same in the schedule. Then I need to edit some of the parameters,values in excel once again I have to import that multi-category excel file which I have edited into revit using dynamo.
I have tried and got the result , Now i can able to export the multi-category schedule from Revit using dynamo. But I am trying to import the same excel file after editing some parameters. I have uploaded my dynamo file for your reference below.
I have uploaded both Revit and dynamo Script, If any new concepts, ideas, new packages, New scripts that you can able to share with me will be appreciated
What really you have done on the previous dynamo script, The script which I have uploaded to you it will just export all the fields in that multi-category schedule.I am confused what you have done in your script can you elaborate it please.
Also for importing I don’t want to use Categories, all elements of categories nodes without using that I need to edit and import the multi-category excel to Revit.
Yes i realise now that changing “” values into null values is not actually needed for the export to work.
So your script would work just fine for exporting data
For the importing script have i not done anything, but i’ll take a short look at it.
Yes, the problem lies with the fact that you want only the exact items from the Multi Category, so you would also have to extract all the Unique Element ID’s from these Elements to be able to use those elements to import the data back.
PS: Well not really a problem, but you will need to export those aswell, i am almost done with that.
This is how that will look like:
Hey man i do not exactly know how to finish this because this is a very specific request and i have never done this before. This is what i have got and i would really appreciate you sharing this script once it is completely finished.
Thank you very much for trying and if I got the result for importing I am happy to share with you, even I am working on that.Exporting using element ID is actually a good idea. Did you know python programming? if you know we don’t want to search for a particular things we can do that with programming.
This is Aravind from India previously we where discussed Export and import using dynamo, On that particularly we were discussing about exporting of multi-category schedule from Revit and then need to export the same excel after editing the values of some parameters. In this special case without using the category I don’t want to import the excel only using the parameter I need to import. I found a solution for this and below I attached the dynamo script for this one
