Setup the Receiver

This article documents the steps required to setup the Receiver to process Orders from the Receiver.

1. Setup the ImportExportConnection table record within the ERP database:
   Note: This may have already been completed.
   
   

   Column	Value
   [idImportExportConnection]	(Auto-Assigned)
   [ImportExportConnectionDesc]	ERP
   [ImportExportConnectionString]	Full Connection String
   [fkImportExportDatabaseType]	2 (User Data)

   Column	Value
   [idImportExportConnection]	(Auto-Assigned)
   [ImportExportConnectionDesc]	Ext Database
   [ImportExportConnectionString]	Full Connection String
   [fkImportExportDatabaseType]	1 (External Data)

2. Setup ImportExportJob table records within the _Ext database:
   
   

   Column	Value
   idImportExportJob	(Auto-Assigned)
   ImportExportJobDesc	Process Incoming ERP EDI File
   ImportExportJobOrder	(Desired Order)
   IsQueued	False

3. Setup ImportExportStep table records within the _Ext database:
   Also, be sure to create the ImportExportMap records with each associated step.
   
   

   Column	Value
   [idImportExportStep]	(Auto-Assigned)
   [ImportExportStepDesc]	Read XML Files
   [fkImportExportJob]	Auto-Assigned Value from ImportExportJob
   [fkImportExportDirection]	1 (for Incoming)
   [CommandOrder]	1
   [SourceCommand]	SELECT '\\SERVER\ERPEDI' AS 'FilePath';
   [fkSourceCommandType]	1 (for Select Statement)
   [fkSourceConnection]	idImportExportConnection from ERP.dbo.ImportExportConnecton
   [DestinationCommand]	NULL
   [fkDestinationCommandType]	4 (for Internal Method)
   [fkDestinationConnection]	NULL
   [InternalMethodDLL]	Agrisoft.ERP.Process.dll
   [InternalMethod]	XMLFilesToDataTable
   [InternalClass]	Agrisoft.ERP.Process.BusinessObjects.ImportExport.ImportExportObject
   [ImportExportStepReferenceID]	NULL
   [IsProcessOnEmptyRecordSet]	False
   [ImportExportStepSourceTypeID]	NULL
   [ImportExportSourceTypeID]	NULL

   Column	Value
   [idImportExportStep]	(Auto-Assigned)
   [ImportExportStepDesc]	Insert Records into EDI Tables
   [fkImportExportJob]	Auto-Assigned Value from ImportExportJob
   [fkImportExportDirection]	2 (for Outgoing)
   [CommandOrder]	2
   [SourceCommand]	NULL
   [fkSourceCommandType]	NULL
   [fkSourceConnection]	NULL
   [DestinationCommand]	spEDIInsertRecords
   [fkDestinationCommandType]	2 (for Stored Procedure)
   [fkDestinationConnection]	idImportExportConnection from ERP.dbo.ImportExportConnection
   [InternalMethodDLL]	NULL
   [InternalMethod]	NULL
   [InternalClass]	NULL
   [ImportExportStepReferenceID]	idImportExportStep of the "Read XML Files" step created above.
   [IsProcessOnEmptyRecordSet]	False
   [ImportExportStepSourceTypeID]	2 (for Destination Command's Data Set)
   [ImportExportSourceTypeID]	NULL

   Column	Value
   [idImportExportStep]	(Auto-Assigned)
   [ImportExportStepDesc]	Mark EDI Files Ready & Archive
   [fkImportExportJob]	Auto-Assigned Value from ImportExportJob
   [fkImportExportDirection]	2 (for Outgoing)
   [CommandOrder]	3
   [SourceCommand]	spEDIMarkNewAsReady
   [fkSourceCommandType]	2 (for Stored Procedure)
   [fkSourceConnection]	idImportExportConnection from ERP.dbo.ImportExportConnecton
   [DestinationCommand]	NULL
   [fkDestinationCommandType]	4 (for Internal Method)
   [fkDestinationConnection]	NULL
   [InternalMethodDLL]	Agrisoft.ERP.Process.dll
   [InternalMethod]	MoveRenameFile
   [InternalClass]	Agrisoft.ERP.Process.BusinessObjects.ImportExport.ImportExportObject
   [ImportExportStepReferenceID]	NULL
   [IsProcessOnEmptyRecordSet]	False
   [ImportExportStepSourceTypeID]	NULL
   [ImportExportSourceTypeID]	NULL

   Note: Instead of doing a MoveRenameFile, a Delete File Statement option is also available.
    

4. Setup the Schedule table record within the ERP database:
   Note: Part of this may have already been completed.
   
   

   Column	Value
   [ScheduleID]	(Auto-Assigned)
   [TaskTypeID]	4 (Queue Import/Export Job)
   [ScheduleDesc]	Queue ERP EDI Incoming Process
   [ExecuteTime]	1/1/2012
   [IntervalTypeID]	1
   [IntervalUnits]	1
   [IsRecurring]	True
   [IsDeleted]	False
   [IsDisabled]	False
   [RowCreateDate]	(Auto-Populated)
   [RowModifyDate]	(Auto-Populated)
   [RowVersion]	(Auto-Populated)
   [TaskID]	Auto-Assigned Value from ImportExportJob

    

    

   Column	Value
   [ScheduleID]	(Auto-Assigned)
   [TaskTypeID]	2 (Process Queued Import/Export Jobs)
   [ScheduleDesc]	Process Job Queue
   [ExecuteTime]	1/1/2012
   [IntervalTypeID]	1
   [IntervalUnits]	1
   [IsRecurring]	True
   [IsDeleted]	False
   [IsDisabled]	False
   [RowCreateDate]	(Auto-Populated)
   [RowModifyDate]	(Auto-Populated)
   [RowVersion]	(Auto-Populated)
   [TaskID]	NULL