Project - Interfacing AJERA with Project or Project Serv
Asked By DavidSmal
30-Jun-08 12:42 PM
I am curious if anyone has any experience interfacing AJERA database data
with Microsoft Project or Microsoft Project Server 2007. I would like to
develop a product that allows me to create multiple projects with data
directly available from AJERA including the ability to determine the effects
of interactively transferring resources from one project to another. Any
technical responses or recommendations of other potentially helpful resources
would be greatly appreciated. Thanks!
Microsoft Project
(1)
Project Server
(1)
VBA
(1)
Database
(1)
Serv
(1)
FAA7F6D1FB60
(1)
Prototype
(1)
AJERA
(1)
Rod Gill replied...
Hi,
There are two possible solutions for you:
1) Use VBA in Project, especially to prototype your solution. For robustness
upgrade the solution to a Project Add-in
2) Use PSI with Project Server 2007. Again I would prototype in VBA as PSI
is a much slower and more costly process.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Project Installing MS Project Server 2007 onto a single server. Hello, I'm trying to make a decision for our group at work to proceed to use MS Project Server 2007 but before I do, I want to test it out with the trial version try it out, then I have no way to convince management to proceed with using Project Server 2007 for our group. I want to install the Project Server 2007 Trial version on
Project Failed - see the Event Log when trying to Create Project Web Access Site I have installed MS Project Server 2007 SP1 on top of a fresh MOSS 2007 Ent. SP1 and Windows Web Server 2008 install and when I attempt to "Create Project Web Access Site" I get a non-descript "Failed - see the Event Log" error in the MOSS SSP. I have looked at the Event Viewer, The SQL Server Log and Activity Viewer, SQL Profiler Trace and the log files in the MOSS 12 was not able to find any information regarding this error. The four databases used by Project Server 2007 are being created in SQL Server 2005, but they don't contain any
Project Predecessors in Proj Serv 2007 database Does anyone know where the predecessors (or successors, depending on how you look at it) are stored in the Project Server 2007 databases? I assumed there would be an obvious column in the DRAFT database, MSP_TASKS table. However, nothing in there seems to be indicate which task is a successor to another task. Thanks! Andy Hey Andy, Both the Draft and the Published database have the predecessor and successor relationships stored in MSP_LINKS, you will need to join it what you are trying to do? Are you trying to build reports? Develope code against Project Server? There may be better ways to get and set this information then going directly
Project Programaticly Backup projects storaged in the Project Server Hi, I am using MS Project 2003, and I am trying to create a Macro that will backup to a local folder all the projects that are stored in the Project Server. Have anyone already done this in the past? Thanks in advance for you help. Kind regards, Bruno Lagos Only VBA can do this as only VBA can create .mpp files. Your code needs to read the VIEW_project table in the database