How to Import / Maintain Custom Field/Outline Code Lookup Values

J

John

Hello.

Looking for the best way to maintain the valid values for custom fields / outline codes. I can not see an import from Project Professional to read from an external text file or database...

We are trying to replicate the fields we have in our project financial management system and we already have lookup tables for those fields in that system. Our financial system is in oracle and it would be great if we could run a batch process to update the data in sql server everynight...

Thanks.
 
K

Kevin Flanagan

A couple of things com eto mind. One option would be to
use DTS within SQL Server and set up a job to fire off
the transfer every night. There are some requirements
when doing so in the tables themselves so that project
will pick up the edits. I believe you would have to set
the lookup table once manually and then autmote the
update thereafter. The other would be to write a macron
in VBA to accomplish the same thing or maybe even VB.
You may want to post to the VBA group for project to see
what they have to say.

Kevin
-----Original Message-----
Hello.

Looking for the best way to maintain the valid values
Click to expand...
for custom fields / outline codes. I can not see an
import from Project Professional to read from an external
text file or database...
We are trying to replicate the fields we have in our
Click to expand...
project financial management system and we already have
lookup tables for those fields in that system. Our
financial system is in oracle and it would be great if we
could run a batch process to update the data in sql
server everynight...
 
Top