This is an old issue for us. However I thought I had come up with a clever solution this year.
Each year when we upgrade SEPDM the Viewers (Right click >View File or History viewer) breaks. This is because SEPDM stores the viewer paths by User, not locally on the computer, so it doesn't know when those paths have changed.
Usually this is a very manual process to deal with, basically I have to go into every user and change this value, it is very time consuming, and dumb.
This year I decided to try to upgrade it from the database. To that end i wrote this SQL script
update dbo.Settings
set dbo.settings.Value = '* %ProgramFiles%\SolidWorks Enterprise PDM\FileViewer.exe "%1%" sldasm, sldprt, slddrw, dwg %ProgramFiles% (x86)\Common Files\eDrawings2012\EModelViewer.exe "%1%"'
from dbo.Users left join dbo.GroupMembers on dbo.users.UserID = dbo.GroupMembers.UserID
left join dbo.Groups on dbo.GroupMembers.GroupID = dbo.groups.GroupID
left join dbo.Settings on dbo.Users.UserID = dbo.settings.UserID
where dbo.GroupMembers.IsMember = 1 and dbo.groups.GroupID = '@DesiredUserGroup' and dbo.Settings.VarID = '16'
The intention here to was to update the viewer string for everyone in our Engineering user group to a known good value. Since I know that all of our Engineers user 64-bit machines I can at least do this much.
The script does work, it that is updates the values in dbo.settings . However when I go into the UI after running the script I get this:
Obviously I am missing something here. When I look at all the Settings in SQL for that user, I can see that I did update the viewer setting, but obviously I am missing something.
UserID | FullName | GroupID | IsMember | Groupname | Value | VarID |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | GB | 0 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 2 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 3 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 4 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 5 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | dwg dxf eprt easm edrw sldprt sldasm slddrw pdf cfg mdb markup | 6 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | ~\$* *.newver.* *.bak *.tmp logoff* | 7 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 8 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 9 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 10 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 11 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 12 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 14 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 15 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | * %ProgramFiles%\SolidWorks Enterprise PDM\FileViewer.exe "%1%" sldasm, sldprt, slddrw, dwg %ProgramFiles% (x86)\Common Files\eDrawings2012\EModelViewer.exe "%1%" | 16 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1,9,1,10,1,40,1,11,1,26,2,111,3,1,3,25,3,27,3,14,3,18,3,37,3,133,3,136,4,-1 | 18 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | Constructs Elements Sheets Views | 19 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | OldVersions | 20 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 0 | 21 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 22 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 23 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 24 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 25 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 1 | 26 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 27 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 28 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 29 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 30 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 31 |
99 | Corey Vantilborg | 13 | 1 | T-Engineering | 0 | 32 |
Has anyone worked with this before? How do you upgrade all your viewers?
Regards,
Corey Vantilborg
SolidworksSolidworks Pdm enterprise Pdm