Export a list of all projects

[dplumb_BWBR]

It is possible to export a list of all users

https://knowledge.autodesk.com/support/bim-360/learn-explore/caas/CloudHelp/cloudhelp/ENU/BIM-360-Do...

Is there an equivalent method to export a list of all of our Projects?

When we set up a BIM 360 project, we give it a "nickname".

Our project number is buried inside the Project info on the Project's Home page, but now I need to cross-reference with our accounting system, si I nee to export all out our project's information.

[pedro.hf.silva]

Hello Dave, 

You can do it through Forge using this API https://developer.api.autodesk.com/project/v1/hubs/:hub_id/projects 

You will need to authorize your user, please check if account admin access level is required. Next you have to generate a token, and in the url above overwrite the :hub_id variable with yours. The API will then give you a list of all projects inside the hub you pointed it to. 

For more information see this link. Hope it helps!

[mpetrucci]

I found this doing a quick search. I have never used. https://apps.autodesk.com/BIM360/en/Detail/Index?id=295972409172932946&appLang=en&os=Web

Projects Export is an App that allows you to view and export your Autodesk® BIM 360® Docs Project List in Excel, ODS, and CSV format.

Project Export enhances your BIM360 experience by allowing you to archive and manipulates your project metadata in Excel, Google Sheets, or a program of your choice. Using any of these tools, you can easily sort, categorize, and report on your projects. Project Export also enables you to archive the state of your projects at a point of time, so that you can report on progress over time, enabling auditing and accountability.

[dplumb_BWBR]

Thanks! that Projects Export sounds good.

I tried it, but I don't see the "Apps & Integration" page their video refers to. (see attached screenshot)

[mpetrucci · Accepted solution]

It's now called simply APPs and is to the right of SETTINGS. However, the link at bottom may help. The following is from the link...

Send an email to  bim360appsactivations@autodesk.com, with the subject “BIM 360 Docs – API Activation Request.” Include the following information in the body of the email:

• BIM 360 Account ID.
• BIM 360 Account Name.
• BIM 360 Account Admin email address.

https://knowledge.autodesk.com/support/bim-360/troubleshooting/caas/sfdcarticles/sfdcarticles/Apps-t...

[dplumb_BWBR]

Tiny steps, I guess.

After requesting, I now have the Apps link showing in my Account Admin, but I don't have the "Add" button the documentation refers to.

I do had Featured Apps and My Apps, but when I click My Apps, I get an "Add Applications" button....Which brings me right back to Featured Apps.

And, of course, Projects Exporter is not on the Featured list

[dplumb_BWBR]

I've written an Excel Macro that parses the Members file you can export and give you two Tabs - one sorted by BIM 360 Project, and the other by User.

The By Project shows which members are assigned to a Project, and

The By User shows which Projects each Users is assigned to.

It's got several BWBR-specific features in it, but if you're fluent in Excel Macro, it shouldn't be too hard to modify.

First step is to use the More Action...Export All Users from the Account Admin Members tab.

That creates a file named BIM360_Members.csv

The Import_BIM360Members.xlsm then looks for that file, parses it, sorts things out, and saves a .xlsx file

I'm happy to share. Feel free to modify, but please retain the BWBR Attribution in the header comments.

[Anonymous]

Hi,
the zip file gives an error on the line
" ChDir Environ$("USERPROFILE") & "\Downloads""
which is in
"Function GetFileToOpen(strTitle As String, strFileFilter As String, strExtension As String) As String"

[dplumb_BWBR]

Sorry, use at your own risk. I can't afford to debug it for you.

As I said, 

>> It's got several BWBR-specific features in it, but if you're fluent in Excel Macro, it shouldn't be too hard to modify.

That error, however, isn't anything specific to BWBR.

You did export a report first, didn't you?

[Anonymous]

Well forgive me for asking the obvious, but "Why do we have to get a 3rd party tool and go through hoops to do something as minor as to get a list of projects?"

[auburn]

https://forge.autodesk.com/blog/sam-nseir-export-bim-360-project-data-autodesk-forge

The Project Exporter app appears to no longer be available. This is the closest workaround I have encountered so far ^.

[auburn]

Link is broken, is there another app that works?