Re: Extracting MSP_TIMEPHASED_DATA via ODBC connection to SQL Server

From: WGHayes (hayes_at_nospam99-please.com.au)
Date: 07/05/04

  • Next message: Rod Gill: "Re: Extracting MSP_TIMEPHASED_DATA via ODBC connection to SQL Server" 
    Date: Mon, 5 Jul 2004 12:27:01 +0930

    Rod,

    Thanks for the advice, however in my circumstance that approach is not
    workable. I actually need the data to be dynamically available. (i.e. cant
    accept overnight or even hourly refresh of data).

    You noted that it was a 'pain' to extract the timephased data and make it
    'accurate' but is it possible? Have you done this or is this approach a
    'black hole'?

    Thanks,
    WGH.

    "Rod Gill" <rodsngtrap@hotmail.com> wrote in message
    news:%23wBMeZ0XEHA.2944@TK2MSFTNGP11.phx.gbl...
    > Hi,
    >
    > Firstly I agree that extracting timephased data from the database is a
    pain,
    > especially to make it accurate (to do this I'm sure you need to take
    account
    > of the calendar table as well.
    >
    > Yes the oledb interface is easy.
    >
    > Possible solution: write an application to read daily data from each
    project
    > into a separate database every night. Data won't be right up to date, but
    > you could provide a utility to re-read individual projects.
    >
    > Your app then reads data straight out of your other database in whatever
    > format is easiest for you.
    >
    > --
    > For VBA posts, please use the public.project.developer group.
    > For any version of Project use public.project
    > For any version of Project Server use public. project.server
    >
    > Rod Gill
    > Project MVP
    > For Microsoft Project companion projects, best practices and Project VBA
    > development services
    > visit www.projectlearning.com/
    > "WGHayes" <hayes@nospam99-please.com.au> wrote in message
    > news:40e36f3f$1@duster.adelaide.on.net...
    > > Our requirement is to extract the timephased data from the
    > > MSP_TIMEPHASED_DATA table stored in SQL Server. After reviewing the
    > > ProjDB.HTM project database tables information and examining the actual
    > > storage or data in this table it looks like an near impossible job to
    > > extract/interpret the data for a DAY by DAY view. Has anyone done
    this?
    > >
    > > I have already developed a method to extract the timephased data using
    the
    > > OLEDB provider for MS Project which presents task, assignment and
    resource
    > > views of data at all time levels (i.e. minute, hour, day, etc..) This
    > works
    > > really well and we have developed a solution that meets our requirements
    > > perfectly from this data source. However, this method requires the MS
    > > Project be installed on the Workstation/PC (i.e. the OLEDB provider is
    > > installed by MS Project). The problem with this is that ALL
    > users(clients)
    > > or our application software will require MS Project to be installed to
    be
    > > able to view this data. Whilst it is NOT MANDATORY to have MS project
    > > installed to run our software there will be certain aspects of our
    > software
    > > which cannot be used unless MS Project is installed.
    > >
    > > Assistance, comments or advise most welcome.
    > >
    > > Thanks,
    > > WGH.
    > >
    > >
    >
    >

  • Next message: Rod Gill: "Re: Extracting MSP_TIMEPHASED_DATA via ODBC connection to SQL Server"

    Relevant Pages
    Loading