Adding Columns to Tables - link to MS Project Accounting

[CharlieZ]

I am new to project server. I am in the process of integrating Project
Server to Microsoft Great Plains Project Accounting 9.0 for the purpose
of feeding Timesheets into Project Accounting. I am very familiar with
Project Accounting and the integration connector eConnect. I have read
up on Timephased data and how it works in PS with
sp_psactualsbyday.sql.

I need to add a Column to the following Tables in PS in order to store
the link between MS PA and PS. How do I add an extra Column to the
following tables:

MSP_WEB_ASSIGNMENTS (store PA Cost Category)
MSP_WEB_PROJECTS (store PA Project Alias)
MSP_WEB_RESOURCES (store PA Employee ID)
MSP_WEB_WORK

charlie

 

[tonyzink]

Hi Charlie --

You could manually add the columns to the appropriate tables using SQL
Server Enterprise Manager, but doesn't the connector come with a script
which does the database modifications for you? ...And after the columns
are added, how are they populated with data?

Good luck!

Tony Zink
========================================
http://www.msprojectreporter.com
http://www.pmreporter.com
http://www.sharepointreporter.com
http://www.msofficereporter.com
http://www.dotnetreporter.com
========================================

 

[Mike Glen]

Hi charlie,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[CharlieZ]

Thanks. I have posted the question on the other site.
charlie