Issues and Risk List Error - Part 2

[Nach]

Hi..I am back with my problem.
To be breif the problem is while migrating from PS 2003 to PS 2007 the
Issues and Risks List doesnt synch properly and gives the following error..
"One or more field types are not installed properly. Go to the list settings
page to delete these fields."

The fields "Cost" from Risks List and "Priority" from Issues list have been
deleted in the older PS version while trying to customize the lists. And that
template was applied to all the sites that were created after that. So
currently we have like 150 sites with that template..and so when i migrate
them I see this error. "Cost" and "Priority" are the fields from sharepoint
by default and it's recommended to not delete them while customizing..but it
has already been done by my organization years back. What type of solution am
I suppoed to be looking for ?

1. Manually Click buttons on all sites (which does work..but dont wanna do
as it is time consuming)
2. creating those fields again in PS 2003 is not gonna help..right?
3. edit the tp_Fields in AllLists table in the sharepoint database of the
new server?

Any suggestions or ideas..!

Thanks
Nachal.

 

[Jonathan Sofer]

Without some sort of 3rd party tool or custom solution, there is no way to
propagate list changes automatically to already provisioned sites. It would
have to be done manually.

Your scenario of having an existing solution in MSPS 2003/WSS 2.0 without
those restrictions on Issues and Risks and then migrating to MSPS 2007/WSS
3.0 where there are these new restrictions, is an interesting one and I can
see this being a problem for many companies.

I had a custom tool built in 2003 that was able to synchronize list changes
automatically so I know it is possible to write something, but it does not
work in 2007. I think there are some 3rd party tools out there that do this
for 2007.

Jonathan

 

[Nach]

Jonathan,
Thanks a lot for your thoughts.

I am going to work on my ideas and see if that solves this problem. We are
still in the testing phase of migration to 2007. So it's really not affecting
any users. So we are gonna go ahead with migration again. I am going to
customize a site with same fields as the older one and save it as a template
and then apply it for all new sites. After this if we migrate the sites...it
has to take up this new template and not have any issues..am assuming this
will work...else have gotto do the manual stuff I'll keep posted on this
issue...