Pages

Search

What database table is Resource Group information in? Microsoft Project

What database table is Resource Group information in? Microsoft Project

What database table is Resource Group information in?

Posted: 21 Dec 2005 11:26 AM PST

Hi,

For some reason the Resource Group is saved as custom text in the
MSP_Text_Fields table. Resource Group text has a Text_Field_Id of 205520899

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"Joe" <microsoft.com> wrote in message
news:com... 

Export MS Project to Excel indentation

Posted: 21 Dec 2005 09:56 AM PST

Hi omp,

See Jack Dahlgren's "Export hierarchy to Excel" macro at:
http://masamiki.com/project/macros.htm

Hope this helps. Let us know how you get along.

Julie
"omp" <microsoft.com> wrote in message
news:com... 

Filter to show who entered actual hours

Posted: 21 Dec 2005 07:53 AM PST

Thanks John, I was afraid that was going to be the answer. I will look at
running a query against the Timephased data.



"John" wrote:
 

How do I schedule resources?

Posted: 20 Dec 2005 09:51 PM PST

Hi Hai Vu,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine at this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site, :)
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP

Hai Vu wrote: 

How to display Task without resource name

Posted: 20 Dec 2005 04:44 PM PST

Perhaps you mean how to get the name of each Task and the Resources assigned
to each Task in a single field for each Task.
Good idea.
First solution is to use a formula in a spare Test field to concatenate the
contents of the Name and Resource fields.
Success with this will depend on whether the Data Type of the two fields can
be interpreted/pd as text and concatenated.
Yes, it works.
TOOLS, CUSTOMISE, FIELDS, TEXT1
[Name] & " " & [Resource Names]



"omp" <microsoft.com> wrote in message
news:com... 

Does MS Project store other MS docs (Excel, PP, Visio, Word)

Posted: 20 Dec 2005 11:42 AM PST

Hyperlinks associated with tasks can open files or file folders for you.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"PRT" <microsoft.com> wrote in message
news:com... 

Collaborating not using project server

Posted: 20 Dec 2005 05:32 AM PST

Thanks I will check it out.

"Rod Gill" wrote:
 

Can't get my standard calendar standard for my location

Posted: 20 Dec 2005 05:08 AM PST

Hacking is what they do to break concrete, indeed.
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Guy" <com> schreef in bericht
news:googlegroups.com... 

Gantt Chart not printing completely

Posted: 19 Dec 2005 01:21 PM PST

Thanks a lot!!! .... I just didn't notice those dates...

THANKS,
Dale N

"Jan De Messemaeker" wrote:
 

How do I add indicators in the indicators field (ie completed)?

Posted: 19 Dec 2005 11:16 AM PST


Danielle wrote: 

Of course! And I've never hunted for my glasses for 10 min only to find
them on top of my head! :)

Multi-Part Question, probably 101-level

Posted: 19 Dec 2005 09:21 AM PST

Because when you update a task there is no benefit in having anything except
what actually happened. If the task finishes early and you set actuals of
saying that, Project shows it finishing early. That way succeeding tasks
start earlier as well.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"IbanezJem" <microsoft.com> wrote in message
news:com... 

Start-to-Finish

Posted: 19 Dec 2005 08:50 AM PST

Adding to Dave's comment ... remember that in addition to the SF link
driving the timing of the successor there's also the constraint to finish
the task as soon as possible after the project start. The start of the
predecessor determines the earliest possible time the successor can finish
and the ASAP constraint prevents it from finishing later unless something
else such as a lag time gets into the picture.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



"scott_hanebutt" <microsoft.com> wrote in message
news:com... 

100% Complete not rolling up to Summary Tasks

Posted: 19 Dec 2005 05:36 AM PST

In article <com>,
PJH <microsoft.com> wrote:
 

PJH,
Only part of the referenced post relates to resources on summary lines.
Rod also talked about a potential problem with "normally assigned"
resources whose Remaining Work is > 0. Did you check that out?

If everything still looks ok, I'd be happy to take a look at your file
if you don't mind e-mailing it to me. If it has sensitive data, I can
send you a macro that will desensitize it or you can go to fellow MVP,
Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
and use his macro called "scrub". If you do send it, make sure to zip it
first.

John
Project MVP 

Filtering for split tasks

Posted: 19 Dec 2005 04:28 AM PST

In article <com>,
MarkLNash <microsoft.com> wrote:
 

Mark,
You're welcome.
John 

Project Mgt softwre Comparison

Posted: 19 Dec 2005 03:15 AM PST

Hi,

I'm not going to compare to other packages but can answer about the
requirements.
MS Project (Std or Pro, only the price is different) can perfectly handle
multiple projects scheduling and resourceing.
Project Server is not necessary.
Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"davegb" <com> schreef in bericht
news:googlegroups.com... 
(way 
packages. 
licenses). 
packages. 
these 

Text on Tracking Gantt Chart

Posted: 18 Dec 2005 11:00 PM PST

Thanks for the reply. But the problem shows up in print preview, so I
am assuming it is an issue with Project2000.

levelling II

Posted: 18 Dec 2005 03:16 PM PST

Hi,

"Leveling was changing the duration of the tasks"
Are you sure this was leveling and not a change in work or units?
Leveling basicly shifts tasks as they are, doesn't change work, units nor
duration (be it that when the task is split the time between start and
finish changes)
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"greg tatchell" <microsoft.com> schreef in bericht
news:com... 
changing 
timeline 
ms 
to 
dates is 
bericht 
that 
150mins 
change. 

How do I do a PERT analysis in Project 2002?

Posted: 17 Dec 2005 01:09 PM PST

Hi brujansen ,

Welcome to this Microsoft Project newsgroup :-)

If your ysis toolbar is not there, you might like to see FAQ Item: 46.
ysis Toolbar (Project 2000+)

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on :-)

Mike Glen
Project MVP

wrote: 

Time granularity in Project

Posted: 17 Dec 2005 02:52 AM PST

Hi,

The only thing you can do is what you wrote in your firsdt message, set the
GUI to months.
But when it displays mo or Mon in the data they will be converted from/to
minutes anyway :-(
HTH

--
Jan De Messemaeker
Microsoft Project MVP
+32 495 300 620
http://users.online.be/prom-ade
"major.tal" <com> wrote in message
news:googlegroups.com... 

Locate hidden fields in MS Project

Posted: 16 Dec 2005 05:59 PM PST

In article <com>,
"Mary" <microsoft.com> wrote:
 

Mary,
You're welcome.

John 

Linking Task Durations

Posted: 16 Dec 2005 12:44 PM PST

In article <com>,
"ko" <microsoft.com> wrote:
 

ko,
You're welcome. I don't generally recommend the use of Paste Links in
Project because they are fragile and easily corrupted. However, creating
a hammock task requires them and if they are used carefully and
sparingly, there shouldn't be a problem.

John 

Group by custom field shows field description

Posted: 16 Dec 2005 12:32 PM PST

In article <com>,
"Dann" <microsoft.com> wrote:
 

Dann,
I'm glad I was able to help. That's why this newsgroup exists.

John
Project MVP 

MS PRoject formatting

Posted: 16 Dec 2005 11:54 AM PST

In article <43a7d8d0$wn.com.au>,
"Trevor Rabey" <westnet.com.au> wrote:
 

Trevor,
I do agree that manually formatting individual tasks can be tedious,
(although the method I described streamlines the process considerably),
but I do NOT agree that it shouldn't be done. Is there some bad thing
that will happen (e.g. file corruption, unexpected results, etc.) if
users apply individual formatting? If so, please share with the rest of
us.

John 

Multiple resources with different allocations on a single task

Posted: 16 Dec 2005 07:26 AM PST

I forgot a few presteps to this.

select all tasks and make them all effort driven, constraint type: as soon
as possible, and task type: fixed work.

Thanks for pointing out effort driven.

"Devin" wrote:
 

Change the default Project Calendar

Posted: 16 Dec 2005 07:01 AM PST

See embedded ...

"scott_hanebutt" <microsoft.com> wrote in message
news:com... 

I'm not sure that the 24 calendar would actually be best there. My 3
resources are Joe Day, Bill Swing, and Fred Grave. I have task X to do that
will require 24 man-hours of work to complete. I have several options when
I assign the resource to the task, depending on the needs of my project. I
can assign one of those resources to it, I can assign 2 of them, or I can
assign all three. The 24-hour calendar assumes you will always assign all
three. With the Project calendar set to a normal generic workday for a
single resource, when I enter the task it will show up with timing as if one
resource was going to do it which is the normal level to take the work
breakdown to. That 24 man-hours task will take 3 workdays and the only
thing that changes with my choice of which resource to assign is the time it
starts on the first workday. If I need it done sooner I can add one or both
of the renmaining resources. If my Project Calendar is the normal day shift
calendar, Joe's base calendar is the same, Bill's is an added swing shift
base calendar and Fred's the night shift calendar, I get accurate scheduling
regardless of the way I choose to assign the workers.
 

Not sure about that example either but have to think on it a bit before
commenting.


--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs