I am looking for the simplest and most elegant solution of a tagging problem, one that best utilizes the capabilities of the Revit Architecture database.
Here are the initial parameters:
My approach was to link the original file into my Revit model and then create simple 2D components for each of the pieces of furniture or special equipment. I ended up with 62 different families (.rfa) named according to the tagging convention. Although I tried, I could not figure out a way to have the category tags to automatically "read" the file name and schedule my components, so there was the extra step of entering this information. My solution was to link the Excel file our client provided into an AutoCAD drawing, then link to that drawing in Revit. Somewhat convoluted, but does the job fine + creates a link to a live information in Excel.
The downside is, of course, there is no feedback b/w the drawn components and the schedule. Is there a way to schedule these components with the spreadsheet automatically reflecting the information entered in the tag? How do I approach entering the rest of the data associated with each object, in order to make it available for adding into the schedule? Enter somehow in each family? A step-by-step would be appreciated.
Thanks,
R.