USP_IMPORTPROCESS_EDIT

Edits an import process

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BATCHTEMPLATEID	uniqueidentifier	IN
@NAME	nvarchar(255)	IN
@DESCRIPTION	nvarchar(1000)	IN
@FILENAME	nvarchar(250)	IN
@COLUMNMAP	xml	IN
@DATEFORMAT	nvarchar(50)	IN
@FUZZYDATEFORMAT	nvarchar(50)	IN
@MONTHDAYFORMAT	nvarchar(50)	IN
@CODETABLEUSEID	bit	IN
@SIMPLEDATALISTUSEID	bit	IN
@USEDEFAULTVALUEWHENBLANK	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BATCHAPPUSERID	uniqueidentifier	IN
@SEARCHLISTUSEQUICKFIND	bit	IN
@ADDNEWCODETABLEENTRIES	bit	IN
@TREATFIRSTROWASHEADER	bit	IN
@BATCHCOMMITOPTION	tinyint	IN
@AUTOMATCHTHRESHOLD	int	IN
@OVERALLMATCHTHRESHOLD	int	IN
@PARAMETERSXML	xml	IN
@IMPORTSOURCEID	uniqueidentifier	IN
@SUBDIRECTORY	nvarchar(255)	IN
@CHECKFORDUPLICATES	bit	IN
@USEWILDCARDS	bit	IN
@DELIMITEDFILETEMPLATEID	uniqueidentifier	IN
@FIXEDWIDTHFILETEMPLATEID	uniqueidentifier	IN
@DELIMITER	nvarchar(5)	IN
@USEBATCHTEMPLATEMATCHSETTINGS	bit	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTPROCESS_EDIT
(
    @ID uniqueidentifier = null,
    @BATCHTEMPLATEID uniqueidentifier = null,
    @NAME nvarchar(255) = '',
    @DESCRIPTION nvarchar(1000) = '',
    @FILENAME nvarchar(250) = '',
    @COLUMNMAP xml = null,
    @DATEFORMAT nvarchar(50) = '',
    @FUZZYDATEFORMAT nvarchar(50) = '',
    @MONTHDAYFORMAT nvarchar(50) = '',
    @CODETABLEUSEID bit = 0,
    @SIMPLEDATALISTUSEID bit = 0,
    @USEDEFAULTVALUEWHENBLANK bit = 0,
    @CHANGEAGENTID uniqueidentifier = null,
    @BATCHAPPUSERID uniqueidentifier = null,
    @SEARCHLISTUSEQUICKFIND bit = 0,
    @ADDNEWCODETABLEENTRIES bit = 0,
    @TREATFIRSTROWASHEADER bit = 1,
    @BATCHCOMMITOPTION tinyint = 1,
    @AUTOMATCHTHRESHOLD int = 0,
    @OVERALLMATCHTHRESHOLD int = 0,
    @PARAMETERSXML xml = null,
    @IMPORTSOURCEID uniqueidentifier = null,
    @SUBDIRECTORY nvarchar(255) = '',
    @CHECKFORDUPLICATES bit = 1,
    @USEWILDCARDS bit = 0,
    @DELIMITEDFILETEMPLATEID uniqueidentifier = null,
    @FIXEDWIDTHFILETEMPLATEID uniqueidentifier = null,
    @DELIMITER nvarchar(5) = '',
    @USEBATCHTEMPLATEMATCHSETTINGS bit = 1
)
with execute as caller
as

    set nocount on;

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

    if @DELIMITER is null or @DELIMITER = '' begin
        set @DELIMITER = ',';
    end

    begin try    
        update 
            dbo.IMPORTPROCESS 
        set 
            BATCHTEMPLATEID = @BATCHTEMPLATEID,
            NAME = @NAME, 
            DESCRIPTION = @DESCRIPTION,
            FILENAME = @FILENAME,
            COLUMNMAP = @COLUMNMAP,
            DATEFORMAT = @DATEFORMAT,
            FUZZYDATEFORMAT = @FUZZYDATEFORMAT,
            MONTHDAYFORMAT = @MONTHDAYFORMAT,
            CODETABLEUSEID = @CODETABLEUSEID,
            SIMPLEDATALISTUSEID = @SIMPLEDATALISTUSEID,
            USEDEFAULTVALUEWHENBLANK = @USEDEFAULTVALUEWHENBLANK,
            BATCHAPPUSERID = @BATCHAPPUSERID,
            DATECHANGED = getdate(), 
            CHANGEDBYID = @CHANGEAGENTID,
            SEARCHLISTUSEQUICKFIND = @SEARCHLISTUSEQUICKFIND,
            ADDNEWCODETABLEENTRIES = @ADDNEWCODETABLEENTRIES,
            TREATFIRSTROWASHEADER = @TREATFIRSTROWASHEADER,
            BATCHCOMMITOPTIONCODE = @BATCHCOMMITOPTION,
            CHECKFORDUPLICATES = @CHECKFORDUPLICATES,
            AUTOMATCHTHRESHOLD = @AUTOMATCHTHRESHOLD,
            OVERALLMATCHTHRESHOLD = @OVERALLMATCHTHRESHOLD,
            PARAMETERSXML = @PARAMETERSXML,
            IMPORTSOURCEID = @IMPORTSOURCEID,
            SUBDIRECTORY = @SUBDIRECTORY,
            USEWILDCARDS = @USEWILDCARDS,
            DELIMITEDFILETEMPLATEID = @DELIMITEDFILETEMPLATEID,
            FIXEDWIDTHFILETEMPLATEID = @FIXEDWIDTHFILETEMPLATEID,
            DELIMITER = @DELIMITER,
            USEBATCHTEMPLATEMATCHSETTINGS= @USEBATCHTEMPLATEMATCHSETTINGS
        where 
            ID = @ID        
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;