Glue Viewer or Access to Filter and Group Parameters

[Dean C]

We are evaluating implementing Glue Viewer and the Deltek expert supporting
us wants us to move to another field, the data that we have in the fields
that they picked for Glue Viewer. Instead of developing a mapping function,
Deltek Glue Viewer developers made the assumption that no one used MS
Project’s custom fields other than Deltek and essentially hard coded the
fields needed for Glue Viewer, including Finish1, Finish2 and Finish3, which
are used by MS Project for pert analysis.
Moving data from one field to another means
determining whether there is a formula associated with the custom field
(done),
whether the formula is applied (help needed),
whether a data list is defined for the field (haven’t tried yet),
unnaming the original field (done),
renaming the new field (done) and
copying the formula (done) or data list (haven’t tried yet), and/or data
from the original field to the new field (done).

Once the fields have been swapped,
every table needs to be checked to determine if it contains the original
field and if so, replacing it with the new field (done).
every filter needs to be checked to determine if it contains the original
field and if so, replacing it with the new field (help needed).
every group needs to be checked to determine if it contains the original
field and if so, replacing it with the new field (help needed).

Has anyone already developed a solution to this problem? If not, using VB,
how can I determine if a formula is applied?
How can I determine if a field is included in a filter?
How can I determine if a field is included in a group?

 

[Jack Dahlgren MVP]

It shouldn't be that much work to browse through all the fields, tables,
filters and views to check.
I think you could do it in an hour or two.

To check fields, select a column header and click customize fields,
In the dialog box, just look through the fields and see if they have any
formulas or value lists associated with them.
If you are just checking those three finish fields you can do this in under
a minute.

Tables will take more time but you should only need to look at the ones you
are using.
Same with filters and groups.

I don't think that developing something to do this in VBA would be much of a
timesaver. It would take more time to write the code than it would take to
do the work.

Deltek should be a bit more flexible in their product. It would be an easy
matter to allow configuration.

-Jack Dahlgren

 

[Dean C]

Thanks, but I didn't list all of the fields used by Glue Viewer and wInsight
Connect, there are 17 fields.
I already told the person who is doing the browsing to do just what you
described for the filters and groups. Except that I had him do screen shots
of Organizer so that he only had to do the 30 filters and 8 groups that had
been used in the file instead of all that exist in the global file.
I was trying to build something for the entire organization so that we
wouldn't have a couple of hours times 30.

 

[Jack Dahlgren MVP]

If you are just looking at custom fields and many projects , you could begin
with the Checkfields macro I have on my old website:

http://masamiki.com/project/macros.htm

Look at the checkfields2 macro:

http://masamiki.com/project/checkfields2.txt

-Jack Dahlgren

 

[Dean C]

Thanks, but I already created a table containing the seventeen fields and a
filter that displays any task containing any non-default data in any of those
fields.

By the way I think we must have met during the Microsoft Project Advisory
Council meeting at Microsoft in 1995 or 1996. I gave a presentation on a
macro I used for ad hoc summary tasks, which Microsoft used the concept for
to develop the Grouping feature. I also won the contest to display the most
bugs in Project 98 in five minutes.

 

[Jack Dahlgren MVP]

Perhaps, but I think it might have been 1997 or 1998...
I won the contest for the "Aurora" (Project 2000) bug bash so we
probably have crossed paths.

-Jack