Z
Zac Maclean
I am developing a custom app to allow field agents to update timetables and
assign resources from the field.
Project 2003 and PocketPC based. I would eventually like to integrate
automated reporting that emails the execs weekly updates.
My front end is being written in VB (2003) and on the Pocket PC I am using
SQLCE, I will be saving the Projects directly to a SQL server through OBDC.
What I need to be able to do is assign resources to tasks based on the task
type.
ex: For task <Code User Interface> I would assign a programmer, not a
database admin or graphic artist.
John Programmer
Joe Programmer
Jeff Database Admin
Jerry Database Admin
Jack Graphic Artist
I want to have the PDA return a pick list of just Programmers when it comes
time to assign a specific resource to a task. I can build the task timeline
prior to assigning resources but I'll need to pick from a short prioritized
list (the priority part is done) at task lead time event.
I have a list of categories and specific resourse and a relationship already
created outside of Project. I can add these tables to the same SQL database
holding the projects. If there is a way to do this with out adding tables
to mix, it would make my life a little easier.
The only place that will be updating the SQL projects will be the PDAs
(through merge replication, which is another issue I am dealing with), the
initial creation of each project will end up being done through a custom
mini-application that calls Project VBA and has the user (an executive)
input just a couple variables (Start Date, Name, and maybe 2 or 3 others).
Every other form of access on this will be from html report pages. Read
only of course.
TIA for any help
Please reply via NG only
Zac
assign resources from the field.
Project 2003 and PocketPC based. I would eventually like to integrate
automated reporting that emails the execs weekly updates.
My front end is being written in VB (2003) and on the Pocket PC I am using
SQLCE, I will be saving the Projects directly to a SQL server through OBDC.
What I need to be able to do is assign resources to tasks based on the task
type.
ex: For task <Code User Interface> I would assign a programmer, not a
database admin or graphic artist.
John Programmer
Joe Programmer
Jeff Database Admin
Jerry Database Admin
Jack Graphic Artist
I want to have the PDA return a pick list of just Programmers when it comes
time to assign a specific resource to a task. I can build the task timeline
prior to assigning resources but I'll need to pick from a short prioritized
list (the priority part is done) at task lead time event.
I have a list of categories and specific resourse and a relationship already
created outside of Project. I can add these tables to the same SQL database
holding the projects. If there is a way to do this with out adding tables
to mix, it would make my life a little easier.
The only place that will be updating the SQL projects will be the PDAs
(through merge replication, which is another issue I am dealing with), the
initial creation of each project will end up being done through a custom
mini-application that calls Project VBA and has the user (an executive)
input just a couple variables (Start Date, Name, and maybe 2 or 3 others).
Every other form of access on this will be from html report pages. Read
only of course.
TIA for any help
Please reply via NG only
Zac