Skip to content
ProjectControls.com
Oracle Primavera - PM6

Extracting Data from a Hosted System

In the Open Standard
James BishopMember for 6 years 4 months
Created
6
3
0

I am currently working on a commission which utilises a hosting service, the system is very well setup by the host provider through their cloud based desktop. What this does mean is we cannot extract data without paying the hoster for retrieval and cleansing of the data.

Additionally I cannot extract to Excel as the virtual desktop is inaccessible and excel has been disabled.

If anyone has had similar issues and has found a solution to managing to extract data I would be very greatful for your advice.

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    David Kelly ·
    #1

    This is quite common, James,

    This is quite common, James, and I find it as an issue with many of my clients. Typically, you can extract the data in Excel format, but you cannot open the data you want to extract in Excel. (My guess is the Excel is not ‘inaccessible’ – just not licenced.) All forms of ‘Citrix-y’ environments allow you to save data inside the environment. You then require a ‘real’ desktop that can map to the host location. Using the tabular report writer, you can save pretty much any data in either CSV or HTML format. CSV is the easiest to process but you have a real problem if your out put contains fields like £1,000.56, and activity descriptions with single and double quotes, choosing a delimiter may be impossible. You may have to save as HTML ( which will open in Excel) but that does mean a bit more work to get it into the next system.
    Report
  2. 0
    Santosh Bhat ·
    #2

    Might sound like a silly

    Might sound like a silly question, but can you not copy and paste from your P6 layout into your own desktop's Excel? 

    Report
  3. 0
    James Bishop ·
    #3

    Thanks David, if you don't

    Thanks David, if you don't mind me asking in your experience additionally 'WebServices' is this a standard element of the primavera licence purchase or is this a bolt on with a hosted system?

    Report
  4. 0
    James Bishop ·
    #4

    Not a silly reply, just not

    Not a silly reply, just not practical in this instance unfortunately

    Report
  5. 0
    Santosh Bhat ·
    #5

    James, Can you describe why

    James,

     

    Can you describe why its not practical? Might help to understand the issue.

    Report
  6. 0
    David Kelly ·
    #6

    Gosh, James, I consider

    Gosh, James, I consider myself an expert in Primavera functions, but the Oracle Corporations ever-changing licencing terms and conditions are beyond me. Last time I looked Web services was part of the EPPM licence. That does not mean your hosting service has it installed. AND it could involve a major IT exercise to implement a solution. You need IT support.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?