ARG split tasks don't show correct in PWA....

[John Sitka]

and the Gantt chart is incorrect.

Sign post up ahead reads.

Welcome to non relational hell, birthplace of poor data design and our new
prodigal son XML.

Time to throw the baby out with the bathwater?

 

[Gary L. Chefetz \(MVP\)]

John:

Learning project at the same time you're trying to learn Project Server is
hell, but one that you've created, not Microsoft. The database, other than
the duplication between web tables and project tables, is far more
normalized than your typical application database of its complexity. Take a
look at the help directory on your Project Server machine where Project
Server is installed. You'll find some enlightening database documentation
there.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[John Sitka]

Fair enough, although discussion about normalization
usually have declarative foregin key declarations as an starting point
or at least a primary key declaration for 1NF

What do you think of the split task presentation?
I'm looking at a PWA screen that effectively displays overallocation
What should I tell my resources? Do both tasks at the same time?
They aren't gonna like that.

I'll keep ranting and learning, you keep preaching.

 

[Gary L. Chefetz \(MVP\)]

John:

You're correct when speaking of the logical model, however the physical
world, foreign keys can be managed programmatically or through database
constraints. As you've discovered, the database has no such constraints, so
you need to rely on the documentation, which is pretty good.

As for split tasks and the Gantt chart in general, I think it takes some
getting used to. As you're using the leveling tools, you should get used to
task splits unless you turn that option off. I think you need to explain
what you're seeing as opposed to what you expect to see before anyone can
address your blanket statement "Gantt chart is incorrect" in a meaningful
way. Inasmuch as this aspect of the software is fairly stable and unchanged
for years, it's more likely that your interpretation is incorrect.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[John Sitka]

foreign keys can be managed programmatically,
so why use MSSQL at all

rely on the documentation,

I'd rather have an assurance of data integrity and extensibility rather than
read about it.
Just why "can't" we publish Master projects or have to hide deleted tasks
not to be able
to get them back?


I like the splits. Look fine and handle fine to me in Project but they don't
show in PWA

js>I'm looking at a PWA screen that effectively displays overallocation

Not much more I can explain, take a task split it Gantt bars show in PWA
without splits. ie. multiple tasks being done at the same time.
Haven't found an option to add STOP/RESUME to the timesheet view
so my resources would not be able to see what they should be working on.
Education? sort by ID(if applicable)? or an artificial column(?) to
establish order.

More compromises.

But I'm too feed up with this thing right now. No need to answer.
This is what you get in a desktop non-transaction product pushed
to the enterprise, limited junk that doesn't make anybody any better.