<>]F 63WFIMPORT - GENERIC DATA IMPORT TO TABLE WITH TEMPLATE *3generic version for any table BE CAREFULL3%_3F=UNT,PREL=F,F$="PREL"; OPEN (F)F$+".tpl"; READ (F)TPL$; CLOSE (F); OPEN (F)F$; DIM PREL$:TPL$<@@A/$' pagetitleImport data into tableB$#nJ$ 100100100100   sA$ td class="td" < ><  nowrap>z$  ($('TRHILITE
]$U  !$ $ +$ <  width="۩( ">8 ]  !  $  8 ]  ,$   $ 
8 ]     1$ / /20  8  ]  $ " ",8 ]"#( $, ۩$5$ ۩ ۩ %8 &],  6$$$ө @@8E]T' өBULK^ph!#(3DISPLAY INQUIRY SCREENvE2p 3---------------- DO THE UPDATESu-]$
Update Results for @)1
Enter Parameters
 .3TEXT$=TEXT$+""$%@$ $*@)=$6$,6*.tpl166,6* 7 $:6 %6$,Missing Data, click BACK and fix the problem!$' % '1$&ө%'%%'$&&   +8+$' & 'X3TEST TPL0 '%$++&' :C(1*=09),$&&'8 3DATA RECORDSB 5 5L$5&'N2$55 3GARBAGE FROM EXPORTED XLS 7 79 7 uttplcp.wbb57% *JITEM$87$8/7:V 813--- COPY THE NEW VALUES INTO THE EXISTING RECORD(3-------- LOOK FOR EXISTING RECORD FIRST 1689,$793STARTING POINT IS THE EXISTING REC2 uttplcp.wbb57"8 *JITEM'$77L6776' $;7, L6;"LOGIT1*879 7$
,$Raw Data:
@$
N#(X 3TEST THE TPLb$+++l 5+vv35$+THE FIRST ROW MUST CONTAIN THE FIELD NAMES!C$ '?PGM=JBB&WF=JBDEALERS&PGMFUNC=VIEW&SEQ=&POPUP=1L$""8@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE& 3input screen$!transitinquiryL$
 S$GThis version supports pasting new recs AND updates to existing recs
$l$Paste Field names and data
2$X$!Select which TABLE to import intojP$:l$' - nI$1
r!$
|$Data can be copy/pasted from Excel. Columns must be contiguous , copy the cells you want updated, INCLUDE column headers with exact field name.

8 ,- $., .($ .- .ܨ,8 ]D  N#  $/ŞX( 0 M:N(1*=47),D:N(1*=47),Y:N(1*=47)b'$0 ///1@2@3@4Ŕl$/ 1%Y%Mz%DzŔŀŞŔ $/Ş8/ţ]Ũ 350600,20ż< / /   !  $  8 ]JBITEMTRTDDTRO ERRMESSAGECW1CW2CW3CW4YYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRIDENT1TEXTTDDHBRYYCYYSYYZWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLDUMMYRKEYVIEWURL FORMNAME FINDURLGSEARCHWARNING CGI.BULKBULKBULK1P TRHIGHLITE CGI.DOWFDOWFBTPLYYY1YYY2YYYYYMDYJMDYMDY.YMDY.MMDY.DRDOWFDOWFRECDOKEY DOWFREC1FINREC2CW1BREMPTYD1XLCSZCGIVALSUBMDYSAVEY2M