7/5/2025 6:30:00 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
How to reposition tabs for all users
Posted: 30 Jul 09 1:53 PM
|
I have a requirement to reset the positioning of tabs (Details, Contacts, etc.) to a consistent state for each user. Where is the tab position stored? In the VFS table? Is there a way I could set the tabs the way the customer wants them for one user and then copy/paste to other users (using SQL update statements perhaps)?
The customer understands that users can reposition the tabs after this reset, but wants to start out in a consistent state.
Thanks,
Doug |
|
|
|
Re: How to reposition tabs for all users
Posted: 31 Jul 09 1:18 AM
|
As users utilize the system, a file is kept on the VFS table (per Page) that includes the tabs layout, however, this file does not exist prior to their original login.
I have not opened that file, but have dealt with some of the files and I would suspect that they contain XML that could be replicated. |
|
|
|
Re: How to reposition tabs for all users
Posted: 31 Jul 09 1:31 AM
|
Thanks for the reply Raul.
I did some more digging and found that the tab positioning data is indeed stored in the VFS table as compressed XML. A trip through the Virtual File System Explorer in AA reveals a lot. I wrote a quick sql script to replicate the tab position for a given user to all other users who have saved tab positioning info for the Accounts detail view. The script seems to work, but it is very hackish and probably dangerous to update things in the VFS this way. I've used it only on a non-production system so far. If anyone sees issues or improvements or better methods of accomplishing this please let me know.
Here's the script (do not use if you don't understand what it's doing - use at your own risk!):
declare @usr char(12)
declare @copypathfrom char(264)
declare @copypathto char(264)
set @copypathfrom = '\Configuration\Application_User\SlxClient\lee\ASP.account_aspxDetail\TabWorkspace-E53DA2EE-942A-4b9d-8885-55C2EF1A4E4A.xml'
begin
declare c1 cursor for
select distinct modifyuser from sysdba.virtualfilesystem where itempath like '\Configuration\Application_User\SlxClient\%\ASP.account_aspxDetail\TabWorkspace-E53DA2EE-942A-4b9d-8885-55C2EF1A4E4A.xml'
open c1
fetch next from c1 into @usr
while @@fetch_status = 0
begin
set @copypathto = '\Configuration\Application_User\SlxClient\' + LTRIM(RTRIM(@usr)) + '\ASP.account_aspxDetail\TabWorkspace-E53DA2EE-942A-4b9d-8885-55C2EF1A4E4A.xml'
update sysdba.virtualfilesystem set itemdata =
(select itemdata from sysdba.virtualfilesystem where itempath = @copypathfrom)
where itempath = @copypathto
fetch next from c1 into @usr
end
close c1
deallocate c1
end |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|