For our Revision levels we use alpha numeric (A0, A1,
A2...A9, B0, B1, B2...) for our major revisions.
We have some legacy data which needs to be added to vault which follows this revision scheme however it is not at A0 or near this revision level.
Is it possible to move the data into PDMWE and set it with its current revision ( E5 in this case) without stepping through each revision until we get to the desired revision?
Thanks, Tim...
We have some legacy data which needs to be added to vault which follows this revision scheme however it is not at A0 or near this revision level.
Is it possible to move the data into PDMWE and set it with its current revision ( E5 in this case) without stepping through each revision until we get to the desired revision?
Thanks, Tim...
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.
Best Regards,
Joy
We are currently on PDMWE 2007. We will be implementing 2008 in the coming months. Does this SQL statement work with both?
Thanks, 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.
Best Regards,
Joy
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...
Pat
Thanks for your response. I will try this and post my findings.
Tim...