{\rtf1\fbidis\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} {\colortbl ;\red0\green0\blue255;} \viewkind4\uc1\pard\ltrpar\b\f0\fs20 Application:\b0 FireRating\line\b Revit Platform:\b0 All\line\b Revit Version:\b0 2010.0\line\b First Released For:\b0 8.0\line\b Last Modified:\b0 02/26/2008\line\b Modified By:\b0 CL Autodesk\line\b Programming Language:\b0 VB.NET\line\b Skill Level:\b0 Beginning\line\b Category:\b0 Parameters\line\b Type:\b0 ExternalCommand\line\line\b Subject:\b0 Create shared parameter;export and import form excel.\line\b Summary:\b0 \line This program defines three commands: ApplyParameter which is used to add a new shared parameter; ExportFireRating which is used to export fire rating values to an Excel file and ImportFireRating which is used to import fire rating values from the Excel file and apply them to doors.\f1\par \par \b\f0 Classes:\b0 \f1\par \pard\ltrpar\fi360\f0 Autodesk.Revit.IExternalCommand \f1\par \lang1024\f0 Autodesk.Revit.Parameters\par Autodesk.Revit.Category\par \pard\ltrpar\lang1033\f1\par \b\f0 Project Files:\b0 \f1\par \f0 ApplyParameter.vb\f1\par \pard\ltrpar\li360\f0 This file contains a class Command which inherits from IExternalCommmand interface and is used to add a new shared parameter to Revit and apply it to all doors.\b\f1\par \pard\ltrpar\par \b0\f0 ExportFireRating.vb\f1\par \pard\ltrpar\li360\f0 This file contains a class Command which inherits from IExternalCommmand interface and is used to export fire rating values to an Excel file\f1\fs24 .\par \pard\ltrpar\par \f0\fs20 ImportFireRating.vb\f1\par \pard\ltrpar\li360\f0 This file contains a class Command which inherits from IExternalCommmand interface and is used to import fire rating values from the Excel file and apply them to doors\f1 .\par \pard\ltrpar\fi720\par \pard\ltrpar\f0 MainModule.vb\f1\par \pard\ltrpar\li360\lang1024\f0 A Module contains names and paths\f1 .\lang1033\par \pard\ltrpar\par \b\f0 Description:\b0 \f1\par \f0 This program defines three commands: \f1\par \pard\ltrpar\fi-421\li421\tx421\f0 -\tab ApplyParameter - add a new shared parameter to revit and apply it to all doors. \par -\tab ExportFireRating - export fire rating values to an Excel file.\par \pard\ltrpar\fi-421\li421 -\tab ImportFireRating - import fire rating values from the Excel file and apply them to doors.\par \pard\ltrpar\f1\par \b\f0 Instructions:\cf1\b0 \f1\par \pard\ltrpar\fi-420\li420\tx420\cf0\f0 1.\tab Open Revit.\par 2.\tab Draw a few walls and place a couple of doors. Execute the "Apply Parameter" command. This will add a shared parameter to Revit and apply it to all the doors. Pick any level select a door and look at the properties. You'll see a property named "Fire Rating" has been added to the door. \par 3.\tab Run the "Export Fire Rating" command. This will launch Excel and extract all the fire ratings to excel. You can see the one that you changed in there.Pick any door and set a new value in Excel under the fire rating column. (Take note of the level and the id. We are going to import it with the next command.) Save the excel file and close excel.\f1\par \pard\ltrpar\fi-420\li420\f0 4.\tab Run the "Import Fire Rating" command. This will load the file and read the data from excel back to the model.Bring up the element properties and notice that the fire rating has been changed.\f1\par }