MONUMETRIC Video mmt-volt

Collapse

Getting metadata out of Revit Structure 2010

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rtblack
    Junior Member
    • October 13, 2011
    • 10

    Getting metadata out of Revit Structure 2010

    Hey all,

    Is there a way to run a report or something through BIM (Revit Structure 2010 is what we used for designing) to automatically extract metadata (Such as building #, sheet #, etc.) from the drawings to automatically place the drawings into a database? It sounds like Excel is going to be a factor, but looking for any help I can get. We do not want to manually type everything in.....twice. Thanks.
  • AHutchinson
    Senior Member
    • September 19, 2011
    • 232
    • Spokane, WA

    #2
    If you have the parameters set up you should be able to create a sheet schedule that, with the right list of parameters selected, will show what you want. Then you can export via report to a .txt file. Then open that file in excel choosing the options you want in order to get the correct format you want.
    Adam Hutchinson
    Engineer in Training
    Integrus Architecture, P.S.

    Comment

    • Munkholm
      Administrator
      • December 7, 2010
      • 4398
      • Kingdom of Denmark

      #3
      If you are on subscription, you should try the DB Link:



      Autodesk Revit DB Link 2012

      Import and export data between an Autodesk® Revit® Architecture 2012, Autodesk® Revit® Structure 2012, or Autodesk® Revit® MEP 2012 project and an external database, and then more easily maintain relationships of linked data with Autodesk® Revit® DB Link.
      • A grid view of the data enables you to make any final edits before import.
      • Databases can be updated following internal or external changes.
      • The grid control enables you to create Revit shared parameters to add new fields to related tables in the database.
      • Changes to new fields within the database automatically update Revit shared parameters upon future imports.
      Klaus Munkholm
      "Do. Or do not. There is no try."

      Comment

      • rtblack
        Junior Member
        • October 13, 2011
        • 10

        #4
        Originally posted by AHutchinson
        If you have the parameters set up you should be able to create a sheet schedule that, with the right list of parameters selected, will show what you want. Then you can export via report to a .txt file. Then open that file in excel choosing the options you want in order to get the correct format you want.


        Thank you for commenting! You say export via a .txt file? I'm still just a little confused. By the way have you heard of COBie2?

        Comment

        • rtblack
          Junior Member
          • October 13, 2011
          • 10

          #5
          Originally posted by Munkholm
          If you are on subscription, you should try the DB Link:



          Autodesk Revit DB Link 2012

          Import and export data between an Autodesk® Revit® Architecture 2012, Autodesk® Revit® Structure 2012, or Autodesk® Revit® MEP 2012 project and an external database, and then more easily maintain relationships of linked data with Autodesk® Revit® DB Link.
          • A grid view of the data enables you to make any final edits before import.
          • Databases can be updated following internal or external changes.
          • The grid control enables you to create Revit shared parameters to add new fields to related tables in the database.
          • Changes to new fields within the database automatically update Revit shared parameters upon future imports.



          Thanks Klaus! is DB Link free and will it work with 2010?

          Comment

          • Munkholm
            Administrator
            • December 7, 2010
            • 4398
            • Kingdom of Denmark

            #6
            It´s free if you're on subscription, and yes, I believe there's a 2010 version too.

            Have a look here: Sign in to Subscription Center
            Klaus Munkholm
            "Do. Or do not. There is no try."

            Comment

            • AHutchinson
              Senior Member
              • September 19, 2011
              • 232
              • Spokane, WA

              #7
              Originally posted by rtblack
              Thank you for commenting! You say export via a .txt file? I'm still just a little confused. By the way have you heard of COBie2?
              Haven't heard of COBie2 but if you go to the big R > Export > Reports > Schedule while you're in the schedule that you want to export. You'll get a dialog that asks you to save the file as a .txt, then you'll get another dialog and use the setup below to import easily into Excel.

              Click image for larger version

Name:	exportsetup.JPG
Views:	1
Size:	27.4 KB
ID:	372455
              Adam Hutchinson
              Engineer in Training
              Integrus Architecture, P.S.

              Comment

              • rtblack
                Junior Member
                • October 13, 2011
                • 10

                #8
                Originally posted by Munkholm
                If you are on subscription, you should try the DB Link:



                Autodesk Revit DB Link 2012

                Import and export data between an Autodesk® Revit® Architecture 2012, Autodesk® Revit® Structure 2012, or Autodesk® Revit® MEP 2012 project and an external database, and then more easily maintain relationships of linked data with Autodesk® Revit® DB Link.
                • A grid view of the data enables you to make any final edits before import.
                • Databases can be updated following internal or external changes.
                • The grid control enables you to create Revit shared parameters to add new fields to related tables in the database.
                • Changes to new fields within the database automatically update Revit shared parameters upon future imports.


                It says that our Revit is not on subscription, but waiting for our contract number from a gentleman but I believe he took a three day weekend. Thanks for continuing to respond Klaus!

                Comment

                • rtblack
                  Junior Member
                  • October 13, 2011
                  • 10

                  #9
                  Originally posted by AHutchinson
                  Haven't heard of COBie2 but if you go to the big R > Export > Reports > Schedule while you're in the schedule that you want to export. You'll get a dialog that asks you to save the file as a .txt, then you'll get another dialog and use the setup below to import easily into Excel.

                  [ATTACH=CONFIG]4671[/ATTACH]
                  Thanks for your help Adam. I am playing around with this as well as seeing what the DB Link software has to offer. I can't thank you guys enough.

                  Comment

                  • mdradvies
                    Moderator
                    "Mark Twain"
                    • December 16, 2010
                    • 4564
                    • Boxtel, Netherlands

                    #10
                    About exporting txt / importing to Excel, try this workflow:

                    1. Export all schedules needed
                    2. Open blank Excel file.
                    3. Select all files in Windows Explorer and drag them into your Excel screen. They will now open while retaining the txt-format and extension
                    4. In Excel go to cell A1 and type =. Now select cell A1 from the first schedule. It will show something like this = test$A$1. Manually remove the two dollar signs and hit enter
                    5. Select the dragmark at the right bottom corner of the cell and drag to the right to expand the coverage to all columns needed
                    6. Select the same dragmark and drag down to expand to all rows

                    You now have a dynamic link to the txt file. It will show a 0 for all empty positions in the txt-file.
                    Upside of this: when you re-export you can overwrite the original file, and easily batch upgrade your excel sheet by simply opening it.

                    btw, there are some things to consider:
                    - If more rows are added in your schedule they don't automatically show up in Excel. I usually put in more then enough rows which will fill all redundant cells with 0. When I need to print, save as, remove links and replace all 0's with blank space.
                    - It's a one way ticket. To get the data back into Revit, you'll need external software.
                    - It's currently not possible to export multiple schedules at once.
                    Martijn de Riet
                    Professional Revit Consultant | Revit API Developer
                    MdR Advies
                    Planta1 Revit Online Consulting

                    Comment

                    Related Topics

                    Collapse

                    Working...