User login
Active forum topics
- content input form
- VAP Aplication is not running in Tomcat
- Exceptional opportunity with one of the Top Leading MNC for Project Managers in Portal Content Management.
- Exceptional opportunity with one of the Top Leading MNC for Project Managers in Portal Content Management.
- Vignette Workflow - Help
- Content Integration with VCM and VAP
- custom content input form
- pathing issue with Rich Media
- Installation of dynamic portal with vignette portal 7.4 with tomcat 6.0
- Create a custom widget
Approve all contents into VCM
Thu, 06/05/2008 - 19:24 — jyotisingla6@ya...
If you need to publish the site, but there are many unapproved contents !!
You can approve these contents using DML into Database.
Run the following DML on Vignette system schema in Oracle or Vignette System database in DB2 or SQL Server:
UPDATE VgnAsMoMetaData set status='approved';
Bookmark/Search this post with:
Comments
Things to keep in mind before running the above DML
1. This will mark every single content item in the system. So if you just want to approve a sub-set of content items, be careful.
2. In VCM 7.3.1.1 and above, you can actually approve the items on the fly while creating a Publish job. The job engine lists all the unapproved item in a paginated way and lets you approve in the same window
3. If you have approval workflows for your business/content processes, the above script will be against the entire purpose of approval workflow
4. Pressing the "Approve" button in Management Console also touches the content (means it is treated as an update action) but the database script does not achieve that effect.
I am strongly against doing
I am strongly against doing this! Vignette is very sensitive and fragile system and we should NOT touch the database unless we are very much SURE to do so. I had many nightmare experiences by touching the Vignette database before. Point 2 in the above comment makes sense and its useful approach as well.