Fixing Workflow States (a real-life example)

When workflows get confused, content items get reset to the default state. If you have a backup or a QA server, you can restore the correct workflow states.

1. The problem The upgrade situation that caused messed-up workflow states.
2. Dump the workflow states Query the portal_catalog and write simple text files with the original workflow states for each item.
3. Fix the site workflow Reset the workflow of the sites to the original workflow.
4. Find the differences Use command-line tools to find the differences in workflow states.

All content on one page (useful for printing, presentation mode etc.)