USP_IMPORTPROCESS_ADD

Adds an import process to the database

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@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_ADD
(
    @ID uniqueidentifier = null output,
    @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 @ID is null
        set @ID = newid();

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

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

    begin try
        insert into 
            dbo.IMPORTPROCESS 
        (
            ID, 
            BATCHTEMPLATEID,
            NAME, 
            DESCRIPTION,
            FILENAME,
            COLUMNMAP,
            DATEFORMAT,
            FUZZYDATEFORMAT,
            MONTHDAYFORMAT,
            CODETABLEUSEID,
            SIMPLEDATALISTUSEID,
            USEDEFAULTVALUEWHENBLANK,
            BATCHAPPUSERID,
            DATEADDED, 
            DATECHANGED, 
            ADDEDBYID, 
            CHANGEDBYID,
            SEARCHLISTUSEQUICKFIND,
            ADDNEWCODETABLEENTRIES,
            TREATFIRSTROWASHEADER,
            BATCHCOMMITOPTIONCODE,
            CHECKFORDUPLICATES,
            AUTOMATCHTHRESHOLD,
            OVERALLMATCHTHRESHOLD,
            PARAMETERSXML,
            IMPORTSOURCEID,
            SUBDIRECTORY,
            USEWILDCARDS,
            DELIMITEDFILETEMPLATEID,
            FIXEDWIDTHFILETEMPLATEID,
            DELIMITER,
            USEBATCHTEMPLATEMATCHSETTINGS
        ) 
        values 
        (
            @ID, 
            @BATCHTEMPLATEID,
            @NAME, 
            @DESCRIPTION, 
            @FILENAME,
            @COLUMNMAP,
            @DATEFORMAT,
            @FUZZYDATEFORMAT,
            @MONTHDAYFORMAT,
            @CODETABLEUSEID,
            @SIMPLEDATALISTUSEID,
            @USEDEFAULTVALUEWHENBLANK,
            @BATCHAPPUSERID,
            getdate(), 
            getdate(), 
            @CHANGEAGENTID, 
            @CHANGEAGENTID,
            @SEARCHLISTUSEQUICKFIND,
            @ADDNEWCODETABLEENTRIES,
            @TREATFIRSTROWASHEADER,
            @BATCHCOMMITOPTION,
            @CHECKFORDUPLICATES,
            @AUTOMATCHTHRESHOLD,
            @OVERALLMATCHTHRESHOLD,
            @PARAMETERSXML,
            @IMPORTSOURCEID,
            @SUBDIRECTORY,
            @USEWILDCARDS,
            @DELIMITEDFILETEMPLATEID,
            @FIXEDWIDTHFILETEMPLATEID,
            @DELIMITER,
            @USEBATCHTEMPLATEMATCHSETTINGS
        )
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;