There is a curious glitch I am finding with the established method of exporting and reimporting information with Excel. When exporting the list of rooms and names to excel it exports in order of the ID. The problem with this that we did not create rooms sequentially, so when I export to excel the rooms come in in a way that I cannot easily modify.
I want to renumber the rooms in excel with a function. Therefore in order to export to excel from dynamo I’ve sorted the lists of names and rooms numerically prior to exporting to excel.
The glitch comes in when I try to reimport to revit from excel once these rooms are changed. The room names can easily be renamed with out issue and room numbers can have letters appended to the number. But if the number is changed or a letter is added as a prefix to the room number the entire file freaks out and acts completely irrationally.
Any assistance for sorting lists here would be great.
See image of the def. below and the associated warning spelled out below.
Here is a link to the file on Dropbox.
warning: Element.SetParameterByName operation failed.
The call is ambiguous between the following methods or properties: ‘Revit.Elements.InternalUtilities.ElementUtils.SetParameterValue(Autodesk.Revit.DB.Parameter, Revit.Elements.Element)’ and ‘Revit.Elements.InternalUtilities.ElementUtils.SetParameterValue(Autodesk.Revit.DB.Parameter, string)’