Batch loading Timesheets data from Excel files to EPM

  • Thread starter Konstantinos Christodoulakis
  • Start date
K

Konstantinos Christodoulakis

Dear all,

I had a request from one of our clients' regarding the batch loading of
Timesheet Data from Excel files to EPM.

I investigated the request and my conclusion is that this can be done using
SQL Integration Services (via a DTS).
My questions are the following:

1. Is it enough to batch load data on the following tables (of Published
database) ?

MSP_TIMESHEET_ACTUALS
MSP_TIMESHEET_LINES
MSP_TIMESHEETS

2. How can I batch create the UID (identifiers)?
Is there a specific Stored Procedure for that?

I'll appreciate any answer on that.

Best regards,
Konstantinos
 
G

Gary L. Chefetz

Konstantinos:

Firstly, you should use only the PSI (Project Server's API) and not use
direct editing of the published database, which would render your system
unsupported. Even if you were going to do this DTS is an old technology. I
suggest that you post your question to the Project Developer newsgroup.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"Konstantinos Christodoulakis"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
PS2007. Cube Build Failure. Failed to connect to the Analysis Serv 2
EPM Excel based Dashboard: how keep the data updated? 7
Macro to Consolidate Data from Various Excel Files 1
Loading data from Excel to Oracle 1
Using VBA to read/write data from Excel files 5
Transferring Data from Multiple Excel files to single excel files. 2
a way to append data from 2 different files 2

Top