megs
2/6/2020 - 4:56 PM
Update Entry Point (Client Portal URLs)
This script can be used to update entry point/client portal URLs. Key things to remember here is that clientTree table needs to be updated, as well as entryPoint and entryPointHistory tables.
This specific script is mostly used to switch a child site's own entry point back to the parent site entry point.
----------
use bswift4_ShardLetter
begin tran
update clienttree
set
entryclientid = Client ID of the Entry Point Client
where clientid = Client ID of the client that needs the URL change
if @@rowcount = 1
commit tran
else
rollback tran
go
begin tran
insert into entrypointHistory (clientID,
entryLogoReturnURL,
entryWelcomeText,
entryInfoText,
entryLogo,
abbrName,
employeeIDLabel,
loginEnabledYN,
savedUserID,
savedDateTime,
entryWelcomeTextESP,
entryInfoTextESP,
historysavedDateTime,
historysavedUserID,
loginImageFilename,
abbrNameShopping,
entryWelcomeTextFRE,
entryInfoTextFRE,
entryWelcomeTextPOR,
entryInfoTextPOR,
entryWelcomeTextITA,
entryInfoTextITA,
entryWelcomeTextGER,
entryInfoTextGER,
abbrName2,
redirectServerName,
abbrNameShopping2
)
select clientID,
entryLogoReturnURL,
entryWelcomeText,
entryInfoText,
entryLogo,
abbrName,
employeeIDLabel,
loginEnabledYN,
savedUserID,
savedDateTime,
entryWelcomeTextESP,
entryInfoTextESP,
getdate(),
your User ID,
loginImageFilename,
abbrNameShopping,
entryWelcomeTextFRE,
entryInfoTextFRE,
entryWelcomeTextPOR,
entryInfoTextPOR,
entryWelcomeTextITA,
entryInfoTextITA,
entryWelcomeTextGER,
entryInfoTextGER,
abbrName2,
redirectServerName,
abbrNameShopping2
from entrypoint with (nolock)
where clientid = Client ID of the client that needs the URL change
if @@rowcount = 1
commit tran
else
rollback tran
go
begin tran
update entrypoint
set
abbrName = NULL,
abbrName2 = NULL,
savedUserID = Your User ID,
savedDateTime = getdate()
where clientid = Client ID of the client that needs the URL change
if @@rowcount = 1
commit tran
else
rollback tran