This content has been marked as final. Show 7 replies
SW Technical support supplied me with a SQL update statement that went through the "revision" file property and set that value to the PDMWE revision. It worked pretty good...sorry I cannot find the statement they gave me you'll have to get it from them.
Hi Jeff -
A word of caution here :-)
The SQL update statement you were supplied may have been unique to your implementation.
Tim - have your VAR contact SW technical support with your request to insure that any SQL update is appropriate for your installtion.
We are currently on PDMWE 2007. We will be implementing 2008 in the coming months. Does this SQL statement work with both?
Hi Tim -
I do not know what the SQL statement was. I just wanted to caution against using something a one site that was used at another. It may be site dependent. You will need to contact your VAR if it is something you need to do.
The version I had was pretty generic, but Joy is right, you need to know what it is doing, blindly running an update SQL command on a production database base is risky.
It can be done, make sure you get with your VAR first before you start poking around directly in the database.
I've been dealing with this same issue for the last couple months as I import hundreds of translated files into PDWME each week. Also, we upgraded from 2007 to 2008 during this period, so I know it works with both versions.
The translated files have the correct custom file property for Revision, which appears on the File Data Card when brought into PDMWE. To get the PDMWE revision to match, I do the following:
1. in Windows Explorer I sort by Revision and select all of one level,
2. in PDMWE Administration I set the "initial counter value" of the "revision number component" to the number matching the desired revision in my value list,
3. in Windows Explorer I mass "Increment Revision" the selected files directly to that PDMWE revision level.
I repeat these 3 steps for each revision level needed for the translated files.
Of course, I ensure that nobody else uses the Increment Revision command, or approves anything to Released state, while I have the initial counter value at anything other than 1...
Thanks for your response. I will try this and post my findings.