I have a variable where all the data needs to be converted to upper case. There are about 40,000 instances of the variable in the vault. I don't care that the old revisions are updated -- I just want it all in upper case. ...and I don't want to retype everything one file at a time through the PDM Explorer interface.
Please point me in a direction for solving this.
Regards,
Thys
Tim,
Thanks for your response and for the reminder not to mess with the database!
I am constantly amazed at these big software systems not having some basic capabilities. I suppose that is opportunity for developers.
Will chat more in PM.
Regards,
Thys
Another option would be to write a macro that could be run using the SOLIDWORKS Task Scheduler.
Michael,
Thanks for that idea. Basically that would touch every file as if a user was doing it by hand, right? That would add versions to every file every time it runs?
Regards,
Thys
AFAIK, any file modification will create a new version except in PDM Professional 2017 where there is an option to overwrite the latest version on check in.
Hi Thys,
This is probably not going to happen without an API add-in. I've run into this before and created an add-in to do this because Dispatch cannot change variables to upper or lower case.
CAUTION: Editing the SQL database directly is NOT recommended and NOT supported. Please do not consider doing this as an option.
We have a paid add-in that does this. If you'd like more information, PM me. We also have lots more add-in products that may help you.
Hope this helps,
Tim CEPA
Believe in The Q!