Import Linked Revit File Data with Ideate BIMLink
Linked Revit file data that has been exported via Ideate BIMLink can be re-imported into the linked (sometimes referred to as the 'child') Revit files only if the Id column matches an element or type defined within that file. Due to the nature of the Revit IDs there is a risk of duplication across files when linked files are involved - this is why the linked file Id value has been prefaced with the unique file id number.
If you want to import modified data from an Excel file that includes linked file data there some steps you will need to take to avoid this duplicate Id risk.
IN THE MASTER (PARENT) FILE:
- REQUIRED: Add the 'Element Id' field as the 1st property in the list of properties.
- OPTIONAL: Include a Project Info parameter such as the "Building Name" as the 2nd property. Make sure the value for this Project Info property is filled out within each of the linked files.
- On the Sorting Tab, Sort on the 'Id' column (NOT the 'Element Id') to ensure that elements from each of the linked files are grouped together. Other Sort fields may be added afterwards.
- Use File>Save Link... to save this link definition.
- Use Export to create the master Excel file data.
NOTE: Using Excel's 'Highlight Duplicates' function on Column B will give you some insight into this data management challenge! If, by some stroke of luck, you do not have any duplicate Element Ids you can skip the part below where you need to make copies of the Excel files (Steps 6-7).
IN THE MASTER EXCEL FILE
- Open the master Excel file and remove the prefix (file Id) number. You can do this by copying the contents (but not the header) from Column B, which is the 'Element Id' field, into Column A. It's important that the header names remain unchanged. These two columns will now have identical values.
- Make appropriate changes to the Excel file.
- Make a copy of the master Excel file for each Revit link. If you have data within (5) links, you should make (5) copies.
- Within each of these Excel (child) files delete rows of data that do not apply to the Revit file into which you want to import.
- Save and close the Excel file.
IN THE LINKED REVIT (CHILD) FILE
- Use the File>Load Link option to import the Link Definition created within the master Revit file.
- Import the edited Excel file data into the respective Revit file.