When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...
Here, You may learn to separate data which is in the form of comma . If you have data in comma format and want to insert all data separately the follow the below technique.
Suppose you have data
Example
@pid="12,13,15,16,14"
@amount="123,435,543,344,343"
if want's to get separate and insert one by one in database then use the below code here, I have separated @pid and @amount.
Suppose you have data
Example
@pid="12,13,15,16,14"
@amount="123,435,543,344,343"
if want's to get separate and insert one by one in database then use the below code here, I have separated @pid and @amount.
CREATE proc [dbo].[usp_setvendorkkshre]
(
@vid int=0,
@pid varchar(max)='',
@amount varchar(max)='',
@intResult int out
)
as
begin transaction
declare @slicepid varchar(100),@sliceamount varchar(500),@index int=1,@index1 int=1
set @intResult=1
while @index<>0 and @index1<>0
begin
SELECT @index = CHARINDEX(',',@pid)
SELECT @index1 = CHARINDEX(',',@amount)
IF @index<>0 and @index1<>0
begin
SELECT @slicepid = RTRIM(LTRIM(LEFT(@pid,@index - 1)))
select @sliceamount=RTRIM(LTRIM(LEFT(@amount,@index1 - 1)))
end
ELSE
begin
SELECT @slicepid=RTRIM(LTRIM((@pid)))
select @sliceamount=RTRIM(LTRIM(@amount))
end
update tbl_vendor_product_mapping set isactive=0 where vid=@vid and pid not in(@slicepid)
update tbl_vendor_product_mapping set isactive=1,amount=@sliceamount where vid=@vid and pid=@slicepid
--
if(@@error<>0)
begin
set @intResult=0
Rollback Transaction
return
end
select @pid=RIGHT(@pid,LEN(@pid)-@index)
select @amount=RIGHT(@amount,LEN(@amount)-@index1)
if len(@pid)=0
if len(@amount)=0
break
end
commit transaction
GO
Comments
Post a Comment