Issue: This non-working sample for DB_EXPORT demonstrates proper formatting of the db-export-mapping.properties file. Please compare values in this file with how the BC and DB index fields are defined to gain proper understanding of setup.

 

Reference Files:

DB_EXPORT Sample BC and DB Creation Table Script – DBexport_ReferenceSample

 

Excerpt Examples:

Example1:

For the following ephesoft index fields and DB export table definition:

dbexport1

 

CREATE TABLE [dbo].[NoteARM](
[LoanNumber] [varchar](50) NULL,
[Rate] [varchar](50) NULL,
[PIPmt] [varchar](50) NULL,
[MonthsToFirstChange] [varchar](50) NULL
) ON [PRIMARY]

db-export-mapping.properties file would be defined as:

DLF||NoteARM::LoanNumber=NoteARM::LoanNumber
DLF||NoteARM::Rate=NoteARM::Rate
DLF||NoteARM::PIPmt=NoteARM::PIPmt
DLF||NoteARM::MonthsToFirstChange=NoteARM::MonthsToFirstChange

 

Example 2:

db-export-mapping.properties file with the option to export the default batch instance id would be defined as:

DLF||NoteARM::LoanNumber=NoteARM::LoanNumber||BI-ID::BIInfo
DLF||NoteARM::Rate=NoteARM::Rate
DLF||NoteARM::PIPmt=NoteARM::PIPmt
DLF||NoteARM::MonthsToFirstChange=NoteARM::MonthsToFirstChange

as long as BIInfo is defined in database table

 

Reference Syntax included in db-export-mapping.properties file :

# DB Export mapping syntax for exporting DLF attribute
# DLF||<Document-Type>::<DLF-Name>=<Database-Table-Name>::<Column-Name>||<Optional-Parameter-1>||<Optional-Parameter-2>….||<Optional-Parameter-N>

# Optional Paramters parameters to be exported with the extracted parameters

# BLF::<Database-Column-Name> ————- Extracts the Batch-class Level Fields.
# DT-ID::<Database-Column-Name> ————– Extracts the document type ID.
# DT-NAME::<Database-Column-Name> ————– Extracts the document type name.
# BC-ID::<Database-Column-Name> ————– Extracts the Batch Class ID.
# BI-ID::<Database-Column-Name> ————– Extracts the Batch Instance ID.

Was this article helpful to you?

Walter Lee

Comments are closed.