Import Linked File Data
Linked 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:
- Include Link Definition properties to help identify the elements and their related source files. You may want to use the Sample Link, called "View-Linked_Files" as an example of how to organize your own link.
- 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.
Submit feature or issue request for Ideate Software
Thank you for taking time to inform us about a bug or feature request.
If you'd like to upload a file to help explain the issue, you can upload a file to Hightail.