Export Views, Groups, Filters

[MarkP]

I am using MS Project 2007 Professional

Trying to export the "Schema" for a project for later import to another.

I am unable to find all the parameters for Views, Groups, Filters

For example, when adding a new View, I recorded a macro and Project gave me
this code:


ViewEditSingle Name:="B - ViewX", Create:=True, Screen:=5, _
ShowInMenu:=True, HighlightFilter:=False, Table:="A - Task Entry", _
Filter:="A - Time-Off", Group:="Complete and Incomplete Tasks"

Unfortunately, the View object does not contain the HighlightFilter, Table,
Filter, or Group values.

Where can I find them.

Also, in the spirit of teach me how to fish... any idea where this might be
documented ?

- MarkP

 

[Gary L. Chefetz]

Mark:

This is not a developer question, as you can do all of this using the
Organizer. Go to tools > Organizer

Using this tool, you can copy all of your views, filters, tables, groups,
etc from your local global file into a Project file. You can then transfer
them from the project file onto another system.

 

[MarkP]

Sorry. Should have been more clear.

I am trying to do this in VBA so that users will not need to learn how to
copy using the organizer.

I will create once Macro that copies all custom attributes (Views, Groups,
Filters, tables, etc)

-Mark

 

[Rod Gill]

Record a macro of you manually using Organizer to move one View, Table and
filter then you will have the code you need.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Sorry. Should have been more clear.

I am trying to do this in VBA so that users will not need to learn how to
copy using the organizer.

I will create once Macro that copies all custom attributes (Views, Groups,
Filters, tables, etc)

-Mark



__________ Information from ESET Smart Security, version of virus
signature database 5063 (20100426) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5063 (20100426) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[MarkP]

Rod,

That will create code usinging the "OrganizerMoveItem" method to move from
one plan to another.

I am trying to Export to an excel file for later import.

What I really want is to do is read the View object and export all fields so
that I can use the "ViewEditSingle" method to add the View and all the
required fields into another plan.

The "ViewEditSingle" requires some fields that seem to be missing from the
View object.

Any other ideas?

Thanks,
MarkP

 

[MarkP]

Unless I misread the following thread, I can't read the filter structure as I
want to..
http://www.eggheadcafe.com/software/aspnet/34167896/how-to-read-filter-defini.aspx

Further thoughts are welcome.

thanks all,
Mark

 

[Rod Gill]

I've done this many times: copy Views, Tables and filters to a new project
with OrganizerMoveItem. Take the file with me or email and then
OrganizerMoveItem to copy to other projects.

You don't say why this doesn't work for you. There is no way to read Filter
structure so you have to either re-create filters with VBA or copy from a
project file.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Unless I misread the following thread, I can't read the filter structure
as I
want to...
http://www.eggheadcafe.com/software/aspnet/34167896/how-to-read-filter-defini.aspx

Further thoughts are welcome.

thanks all,
Mark





__________ Information from ESET Smart Security, version of virus
signature database 5064 (20100427) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5064 (20100427) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[MarkP]

Rod,

My challenge is this: I have created a project plan that has many custom
features (groups, views, tables, fields, etc)

In an effect to maintain this, I am trying to find a way to keep individual
plans updated with new features as they are written.

I have built out a "Standard" plan which I would then like to Export all the
features to an Excel file. (Think of the "Standard" plan as a code
repository)

I would then like to have one simple Macro the Project Managers can run to
Import all changes at once.

Asking them to manually copy multiple modules, groups, views, etc is just
not a workable solution. I am sure they will miss a module or something.

Any other thoughts on how I can export the details would be greatly
appreciated.

Thanks for looking into this.

MarkP

 

[Rod Gill]

Your business goal is to copy custom settings. You've been told a number of
times you can't do it thru Excel.

Copy all Views, Tables, Filters modules etc to a .mpp file using Organizer
then have a macro in the .mpp project to automatically copy that info to the
user's Global file. Again, there is no manual copying.

Make it easier by naming all your custom stuff with a unique identifier, EG
_Gantt Chart - Weekly Report. Now your macro just has to copy all items
beginning with _ (which also sorts them to the top of alphabetic lists).


--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Rod,

My challenge is this: I have created a project plan that has many custom
features (groups, views, tables, fields, etc)

In an effect to maintain this, I am trying to find a way to keep
individual
plans updated with new features as they are written.

I have built out a "Standard" plan which I would then like to Export all
the
features to an Excel file. (Think of the "Standard" plan as a code
repository)

I would then like to have one simple Macro the Project Managers can run to
Import all changes at once.

Asking them to manually copy multiple modules, groups, views, etc is just
not a workable solution. I am sure they will miss a module or something.

Any other thoughts on how I can export the details would be greatly
appreciated.

Thanks for looking into this.

MarkP



__________ Information from ESET Smart Security, version of virus
signature database 5067 (20100428) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5067 (20100428) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gary L. Chefetz]

Mark:

Have you considered moving to Project Server? This is so easy when you have
Project Server.