Skip to main content

Featured post

XM Cloud content sync from prod to uat or UAT to prod step by step

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...
Post a Comment

How to separate data from comma format in stored procedure

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.

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


Labels:

Comments

Post a Comment

Popular posts from this blog

What is layout service in sitecore and how to configure it

 What is layout service in sitecore and how to configure it The Layout Service in Sitecore is a RESTful API that provides access to the data and presentation details of a Sitecore website, allowing developers to build modern, headless applications that consume content from Sitecore. To configure the Layout Service, you need to perform the following steps: Install the Sitecore JavaScript Services (JSS) package on your Sitecore instance. Define a new route in the jss.config file to specify the endpoint for the Layout Service. Configure the security settings to specify the roles and users who are allowed to access the Layout Service. Test the Layout Service endpoint to ensure that it is configured correctly and returning data as expected. Note that these steps are just a high-level overview and the specific details of each step may vary depending on the version of Sitecore you are using and the specific requirements of your project.
Post a Comment
Read more

HttpRequestProcessed pipeline implementation in sitecore with C# code

 HttpRequestProcessed pipeline implementation in sitecore with C# code Here is an example of how you can implement the HttpRequestProcessed pipeline in Sitecore using C# code: using System; using Sitecore.Pipelines.HttpRequest; namespace MySite.Pipelines {     public class MyHttpRequestProcessed : HttpRequestProcessor     {         public override void Process(HttpRequestArgs args)         {             // Perform custom processing logic here             Console.WriteLine("HttpRequestProcessed pipeline processed successfully");         }     } } This code defines a custom HttpRequestProcessed processor that will be executed as part of the HttpRequestProcessed pipeline. The Process method is called when the pipeline is executed, and you can perform any custom processing logic you need within this method. To activate this custom process...
Post a Comment
Read more