none
How should we be going about creating and saving and/ or exporting our ODC files using Excel 2013 for use in Project Server 2013 Online? RRS feed

  • Question

  •  

    Hi I need your guidance on how I should go about setting up my Excel 2013 reports so that others in our Project Online 2013 environment can access and updates these reports of mine.

    My questions are as follows:

    I presume I need to create and save my ODC files in a PWA > Data Connections folder.  I have English and French users in our environment.  Do I need save them twice?  Once in the French and again in the English Data Connections folder?  Likewise for the Excel file? 

    How should I go about creating my ODC files within Excel?  By default, the ODC files are being created on my PC's > My Documents > My Data Sources folder.  I presume I need to get them saved or exported to the PWA > Data Connections folder. So, How should I be going about creating and saving and/ or exporting the ODC files???

    FYI...My oData Feeds that I wish to use and join in this particular Excel file are as follows:

    • https://cascades.sharepoint.com/sites/pwa/_api/projectdata/AssignmentTimephasedData01T00:00:00'

      https://cascades.sharepoint.com/sites/pwa/_api/projectdata/Projects()?$select=ProjectId,ProjectName,CAS_Classification,CAS_PCO,CAS_IT_Department,CAS_Program,CAS_SubProgram

      https://cascades.sharepoint.com/sites/pwa/_api/projectdata/TimeSet()?select=TimeByDay,TimeDayOfTheWeek$filter=TimeByDay ge datetime'2014-10-19T00:00:00'

      https://cascades.sharepoint.com/sites/pwa/_api/projectdata/Resources()?$select=ResourceId,ResourceName,Programs,Supplier,Source,Role,CostType

    Thanks in advance,


    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    • Edited by Spiro Theopoulos Saturday, October 25, 2014 8:25 AM type/ clarification
    Saturday, October 25, 2014 2:33 AM

Answers

All replies

  • I think I figured out how to create and Save my odc files in the Data Connections folder in PWA. and create an Excel report that uses these connection for others to share. 

    So, my only question that remains now is given that I have English and French users in the same environment.  Do I need save them twice?  Once in the French and again in the English Data Connections folder?  Likewise for the Excel file? 


    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Saturday, October 25, 2014 12:18 PM
  • Indeed Spiro, you have to do it for both languages.

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, MCP |

    Saturday, October 25, 2014 2:24 PM
    Moderator
  • Thank you Guilaume.  May I ask you to help clarify a bit more for me?  If I have to do it for both languages (the reports and ODC files), do I simply copy the same ODC files from e.g., the English to French folder in PWA (Odc files)?  Or does that defeat the purpose?  Or, do I need to create a new set of oData Feed Connection files with a French version of Excel 2013 and save them to the French Data Connections folder in PWA?  Do I need to have a French version of Excel 2013 to create French ODC files and ultimately French based reports and/ or vice versa?

    I did notice that the following oData metadata command from within a browser produces different results (ie., English versus French metadata returned) depending on who runs it (i.e., French or English user, etc).  As you can see I am a bit confused.  Any help you can provide would be greatly appreciated.

    https://XXXXX.sharepoint.com/sites/pwa/_api/projectdata/$metadata

     


    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Saturday, October 25, 2014 4:02 PM
  • Hi Spiro,

    I didn't tested it with Project Online, but I think you just need to create and save twice the ODC, one in english and one in french, but no need to do it specifically with the english or french Excel version.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, MCP |

    Sunday, October 26, 2014 2:33 PM
    Moderator
  • Hi Guillaume,

    Creating in the a directory does not seem to drive / determine the language of the reports.  My colleague here is using the same directories as me, and his turns out to be French like his environment and mine, even though I save the files in the French directories, display in English.

    Any ideas on how I can create reports so that they display in French?





    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)

    Tuesday, November 11, 2014 8:03 PM