ImportNAPOLExtract
Use this form set level rule to import an extract file into the GenData program that is made up of:
1. Typical transactions with one or more combined WIP/NA/POL export files from Documaker Desktop embedded into each transaction This illustration shows transactions with embedded WIP/NA/POL export files:
|
Transaction 1 <record1, field1>, <field 2>, <field 3>, <field4>, <field5> <record2, field1>, <field 2>, <field 3>, <field4>, <field5> |
|---|
|
WIP/NA/POL export file containing data associated with transaction 1. |
|
Transaction 1 (continued) <record3, field1>, <field 2>, <field 3>, <field4>, <field5> <record4, field1>, <field 2>, <field 3>, <field4>, <field5> |
|
Transaction 2 <record1, field1>, <field 2>, <field 3>, <field4>, <field5> <record2, field1>, <field 2>, <field 3>, <field4>, <field5> |
|
WIP/NA/POL export file 2 containing data associated with transaction 2. |
|
Transaction 2 (continued) <record3, field1>, <field 2>, <field 3>, <field4>, <field5> <record4, field1>, <field 2>, <field 3>, <field4>, <field5> |
2. One or more appended WIP/NA/POL export data files from Documaker Desktop. This illustration shows an extract file comprised of WIP/NA/POL files appended to one another:
|
WIP/NA/POL export file 1 |
|
WIP/NA/POL export file 2 |
|
WIP/NA/POL export file 3 |
|
WIP/NA/POL export file 4 |
|
WIP/NA/POL export file 5 |
Syntax
Although there are no parameters for this rule. Keep in mind:
- Specify the extract file name, which contains the import information for each transaction, in the ExtrFile option of the Data control group. This is the normal way to define the name of the extract file.
- Only use the SearchMask option in the ExtractKeyField control group; do not use the Key option.
- For each field that comprises a section (whose data comes from the combined WIP/NA/POL export data), you must create or have a DDT record whose field rule is set to one of the following field rules
- If you use the NoOpFunc rule for any field rule associated with the WIP/NA/POL export data, you must insert the ReplaceNoOpFunc rule in the <Base Rules> section of the AFGJOB.JDT file.
- You must place the ImportNAPOLExtract rule in the <Base Form Set Rules> section of the AFGJOB.JDT file after the BuildFormList rule or any custom rule that creates a form set.
- If the import extract file is comprised of normal transaction data records plus one or more embedded Documaker Desktop combined WIP/NA/POL export files; you can include the LoadRcpTbl and RunSetRcpTbl or GetCo and GetLOB rules in your AFGJOB.JDT file. You may need to use other rules, like Field2GVM, to move data from the imported form set fields to relevant GVM variables.
- To process without using DDT files, substitute the ForceNoImages rule for the RULStandardImageProc rule.
Example
Here are some examples which show how this rule works:
Extract file made up of transactions with embedded WIP/NA/POL files
In this example, the extract file is made up of normal transactions with embedded WIP/NA/POL export files. This example imports information from an extract file named IMPORT.DAT which is comprised of transactions with embedded WIP/NA/POL export files. Using this information, the system creates standard GenData files which are input to the GenPrint program. The GenPrint program then creates the print output files. Keep in mind:
- The ReplaceNoOpFunc rule is not required in the AFGJOB.JDT file because no fields in the sample DDT file use the NoOpFunc rule
- The options in the Trn_Fields control group are based on items in the first record of the typical transaction data
- The LoadRcpTbl and RunSetRcpTbl rules are required to load and run the recipient table
Here is a sample extract file:
SCO1234567HEADERREC00000030198 SCOM1FP WAT1I1B119990223 804-345-87…
SCO1234567FRMLSTREC0000010110 SCO FP T1 89999987 041598… SCO1234567PRODNMREC00000David Miller 000666666600000444...
SCO1234567PRODADREC00000100 Main Street, Suite 1200 Miami, FL 30202…
…
WIP="SAMPCO ""LB1 ""NAPOL FILE # 1 ""NB ""P" associated w Transaction # 1"
;SAMPCO;LB1;LETTER2;Second Letter;RD;;q1snam|D3<Insured>/q1fl2a|D3S<Insured>/q1b302|D3S<Insured>/q1ba36…;
\ENDDOCSET\
\NA=q1snam,LN=1,DUP=OFF,SIZE=C,TRAY=U,X=0,Y=0,PA=1,OPT=D3\
\ENDIMAGE\
\NA=q1fl2a,LN=1,DUP=OFF,SIZE=C,TRAY=U,X=0,Y=3360,PA=1,OPT=D3S\
FDate;235;3913;12012;;;\January 1, 2000
FLessee_NAME;235;4806;12012;G;;\Morris Sander
FLessee_addr;235;5212;12012;G;;\3200 Windy Hill Road
FLessee_city;235;5636;12012;G;;\Atlanta, GA 30339
\ENDIMAGE\
…
\ENDFORM\
\ENDDOCSET\
SCO1234567COVERGREC00000SPC 25000 250 Coverage Item 2…
SCO1234567GENRALREC000001 1 3 1 0 Liability1Liability2Liability3Libility4 …
…
WIP="SAMPCO ""LB1 ""NAPOL FILE # 2 ""NB ""P" associated w Transaction # 1"
;SAMPCO;LB1;CHARTS;Form q1cht;RD;;q1cht|D5<Insured>;
\ENDDOCSET\
\NA=q1cht,LN=1,DUP=OFF,SIZE=L,TRAY=U,X=0,Y=0,PA=1,OPT=D5\
FFORMSET PAGE NUM;17656;25740;16008;PF;;\
FFORMSET PAGE NUM OF;18408;25740;16008;PF;;\
\ENDFORM\
\ENDDOCSET\
…
SCO999567HEADERREC00000030198 SCOM1FP WAT1I1B119990223 804-345-87…
SCO9994567FRMLSTREC0000010110 SCO FP T1 89999987 041598…
…
Here is a sample DDT file:
<Image Field Rules Override>
;0;0;Date;0;0;Date;0;25;; MapFromImportData;;N;N;N;…
;0;0;Lessee_Name;0;9;Lessee_Name;0;25;; MapFromImportData;;N;N;N;…
;0;0;Lessee_addr;0;25;Lessee_addr;0;25;; MapFromImportData;;N;N;N;…
;0;0;Lessee_city;0;25;Lessee_city;0;25;; MapFromImportData;;N;N;N;…
Here is a sample AFGJOB.JDT file:
<Base Rules>
…
/* Every form set in this base uses these rules. */
<Base Form Set Rules>
;NoGenTrnTransactionProc;;;
;ResetOvFlw;;;
;BuildFormList;;;
;ImportNAPOLExtract;;;
;LoadRcpTbl;;;
;RunSetRcpTbl;;;
…
Here is a sample INI file:
< Data >
ExtrFile = Import.dat
< ExtractKeyField >
SearchMask = 1,SCO
< Trn_Fields >
Key1 = 1,3,N
Key2 = 40,2,N
KeyID = 4,7,N
< Trn_File >
BinaryExt = N
MaxExtRecLen = 120
Extract file made up of appended WIP/NA/POL files
In this example, the extract file is made up of one or more appended WIP/NA/POL export files. This example imports information from an extract file named IMPORT.DAT which is comprised of one or more appended WIP/NA/POL export data files. Using that information, the system then creates GenData files which are input to GenPrint. The GenPrint program then creates the print output files. Keep in mind:
- The ReplaceNoOpFunc rule is required in the AFGJOB.JDT file because one of the fields in the sample DDT file uses the NoOpFunc rule
- The options in the Trn_Fields control group are based on items in the first record of the WIP/NA/POL export file
- The LoadRcpTbl and RunSetRcpTbl rules not required
Here is a sample extract file:
WIP="SAMPCO ""LB1 ""NAPOL FILE # 1 ""NB ""P"
;SAMPCO;LB1;LETTER2;Second Letter;RD;;q1snam|D3<Insured>/q1fl2a|D3S<Insured>/q1b302|D3S<Insured>/q1ba36…;
\ENDDOCSET\
\NA=q1snam,LN=1,DUP=OFF,SIZE=C,TRAY=U,X=0,Y=0,PA=1,OPT=D3\
\ENDIMAGE\
\NA=q1fl2a,LN=1,DUP=OFF,SIZE=C,TRAY=U,X=0,Y=3360,PA=1,OPT=D3S\
FDate;235;3913;12012;;;\January 1, 2000
FLessee_NAME;235;4806;12012;G;;\Morris Sander
FLessee_addr;235;5212;12012;G;;\3200 Windy Hill Road
FLessee_city;235;5636;12012;G;;\Atlanta, GA 30339
\ENDIMAGE\
…
\ENDFORM\
\ENDDOCSET\
WIP="SAMPCO ""LB1 ""NAPOL FILE # 2 ""NB ""P"
;SAMPCO;LB1;CHARTS;Form q1cht;RD;;q1cht|D5<Insured>;
\ENDDOCSET\
\NA=q1cht,LN=1,DUP=OFF,SIZE=L,TRAY=U,X=0,Y=0,PA=1,OPT=D5\
FFORMSET PAGE NUM;17656;25740;16008;PF;;\
FFORMSET PAGE NUM OF;18408;25740;16008;PF;;\
\ENDFORM\
\ENDDOCSET\
Here is a sample DDT file:
<Image Field Rules Override>
;0;0;Date;0;0;Date;0;25;; NoOpFunce;;N;N;N;…
;0;0;Lessee_Name;0;9;Lessee_Name;0;25;; MapFromImportData;;N;N;N;…
;0;0;Lessee_addr;0;25;Lessee_addr;0;25;; MapFromImportData;;N;N;N;…
;0;0;Lessee_city;0;25;Lessee_city;0;25;; MapFromImportData;;N;N;N;…
Here is a sample AFGJOB.JDT file:
<Base Rules>
…
;ReplaceNoOpFunc;;;
/* Every form set in this base uses these rules. */
<Base Form Set Rules>
;NoGenTrnTransactionProc;;;
;ResetOvFlw;;;
;BuildFormList;;;
;ImportNAPOLExtract;;;
…
Here is a sample INI file:
< Data >
ExtrFile = Import.dat
< ExtractKeyField >
SearchMask = 1,WIP
< Trn_Fields >
Key1 = 1,3,N
Key2 = 6,6,N
KeyID = 26,20,N
< Trn_File >
BinaryExt = N
MaxExtRecLen = 120
See also
© Copyright 2020, Oracle and/or its affiliates. All rights reserved. Legal notices.