AnsweredAssumed Answered

Renaming PDM projects in mass through SQL?

Question asked by Paul Sharp on Dec 14, 2020
Latest reply on Dec 31, 2020 by Francisco Guzman

My company has a situation where they need to rename thousands of folders in a vault.
In a test server - I have partial success already through stopping services, SQL statement, and clearing the local cache of the structure 

 

In SQL I opened the vault database -->  went to the PROJECTS table

Then essentially renamed both the corresponding PROJECTS and PATH contents

 

BEFORE:

NAME: Customer123 

PATH: \Customer123\

 

AFTER:

NAME: 123Customer 

PATH: \123Customer\

 

All associated paths and files look perfect and open without error.

However I get this error when trying to add new files to the environment.

 

"SolidWorks PDM: Could not add documents! 

Cause: You don't have permissions to perform this action"

 

Outcomes