USP_IMPORTDELIMITEDFILETEMPLATE_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@NAME	nvarchar(250)	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@FILENAME	nvarchar(255)	IN
@SITEID	uniqueidentifier	IN
@DETAILCOLUMNMAP	xml	IN
@HASHEADERROW	bit	IN
@DETAILROWPREFIX	nvarchar(50)	IN
@BATCHSUMMARYPREFIX	nvarchar(50)	IN
@FILESUMMARYPREFIX	nvarchar(50)	IN
@FILEDELIMITER	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BATCHRECORDCOUNTCOLUMNNAME	nvarchar(250)	IN
@BATCHREVENUETOTALCOLUMNNAME	nvarchar(250)	IN
@FILERECORDCOUNTCOLUMNNAME	nvarchar(250)	IN
@FILEREVENUETOTALCOLUMNNAME	nvarchar(250)	IN
@DELIMITEDHEADERROW	nvarchar(max)	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTDELIMITEDFILETEMPLATE_ADD
(
    @ID uniqueidentifier = null output,
  @NAME nvarchar(250) = '',
    @BATCHTEMPLATEID uniqueidentifier = null,        
    @FILENAME nvarchar(255) = '',
  @SITEID uniqueidentifier = null,    
  @DETAILCOLUMNMAP xml = null,            
    @HASHEADERROW bit = 1,
  @DETAILROWPREFIX nvarchar(50) = '',
  @BATCHSUMMARYPREFIX nvarchar(50) = '',
  @FILESUMMARYPREFIX nvarchar(50) = '',
  @FILEDELIMITER nvarchar(50) = '',
  @CHANGEAGENTID uniqueidentifier = null,
  @BATCHRECORDCOUNTCOLUMNNAME nvarchar(250) = '',
  @BATCHREVENUETOTALCOLUMNNAME nvarchar(250) = '',
  @FILERECORDCOUNTCOLUMNNAME nvarchar(250) = '',
  @FILEREVENUETOTALCOLUMNNAME nvarchar(250) = '',
  @DELIMITEDHEADERROW nvarchar(max) = ''
)
with execute as caller
as

    set nocount on;

    if @ID is null
        set @ID = newid();

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @CURRENTDATE datetime = getdate()

    begin try
        insert into dbo.IMPORTFILETEMPLATE 
        (
            ID,
      NAME,
        BATCHTEMPLATEID,        
        FILENAME,
      SITEID,    
      DETAILCOLUMNMAP,            
        HASHEADERROW,
      DETAILROWPREFIX,
      BATCHSUMMARYPREFIX,
      FILESUMMARYPREFIX,
      FILEDELIMITER,
      BATCHRECORDCOUNTCOLUMNNAME,
      BATCHREVENUETOTALCOLUMNNAME,
      FILERECORDCOUNTCOLUMNNAME,
      FILEREVENUETOTALCOLUMNNAME,
      DELIMITEDHEADERROW,
      ADDEDBYID,
      CHANGEDBYID,
      DATEADDED,
      DATECHANGED
        ) 
        values 
        (
            @ID,
      @NAME,
        @BATCHTEMPLATEID,        
        @FILENAME,
      @SITEID,    
      @DETAILCOLUMNMAP,            
        @HASHEADERROW,
      @DETAILROWPREFIX,
      @BATCHSUMMARYPREFIX,
      @FILESUMMARYPREFIX,
      @FILEDELIMITER,
      @BATCHRECORDCOUNTCOLUMNNAME,
      @BATCHREVENUETOTALCOLUMNNAME,
      @FILERECORDCOUNTCOLUMNNAME,
      @FILEREVENUETOTALCOLUMNNAME,
      @DELIMITEDHEADERROW,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
        )
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;