none
Custom Field URL RRS feed

  • Question

  • Is it possible to create a custom field  which will show the URL of the project site?

    I need to create an extract of our entire pipeline with a link to each project site, I'd rather not do this manually for 300+ projects!

    Thanks.

    Wednesday, January 24, 2018 11:13 AM

Answers

  • Hi, 

    Have a look at either Microsoft's Power BI report,

    Paul Mather's https://gallery.technet.microsoft.com/Online-Power-BI-Report-abcb3c3b

    or mine - https://gallery.technet.microsoft.com/Microsofts-Online-Power-BI-0260454a 

    I've never created an ECF with the URL in it, but the above will give you them.



    Ben Howard [MVP] | web | blog | book | downloads | P2O

    • Marked as answer by ASQU Tuesday, January 30, 2018 12:43 PM
    Wednesday, January 24, 2018 1:48 PM
    Moderator
  • The reports Ben sent will be fine as examples for Project Online, if you are using Project Server 2013 / 2016 on-prem, the reports will need tweaking abit or create a new report that either gets the data from the Reporting schema in the database or one that uses the Projects endpoint in the OData Reporting API.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    • Marked as answer by ASQU Tuesday, January 30, 2018 12:43 PM
    Wednesday, January 24, 2018 2:22 PM
    Moderator

All replies

  • Hi, 

    Have a look at either Microsoft's Power BI report,

    Paul Mather's https://gallery.technet.microsoft.com/Online-Power-BI-Report-abcb3c3b

    or mine - https://gallery.technet.microsoft.com/Microsofts-Online-Power-BI-0260454a 

    I've never created an ECF with the URL in it, but the above will give you them.



    Ben Howard [MVP] | web | blog | book | downloads | P2O

    • Marked as answer by ASQU Tuesday, January 30, 2018 12:43 PM
    Wednesday, January 24, 2018 1:48 PM
    Moderator
  • The reports Ben sent will be fine as examples for Project Online, if you are using Project Server 2013 / 2016 on-prem, the reports will need tweaking abit or create a new report that either gets the data from the Reporting schema in the database or one that uses the Projects endpoint in the OData Reporting API.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    • Marked as answer by ASQU Tuesday, January 30, 2018 12:43 PM
    Wednesday, January 24, 2018 2:22 PM
    Moderator
  • King Baba --

    If you are not able to use Power BI in your organization, one workaround would be to navigate to the Connected SharePoint Sites page in PWA, to highlight all of the data in the data grid and copy it to the Clipboard, and then to paste the information into an Excel workbook.  Just an additional thought.  Hope this helps.


    Dale A. Howard [MVP]

    Wednesday, January 24, 2018 5:39 PM
    Moderator