<>"p 63ORDERIMP2 - UPLOAD .CSV OF ORDERS w/ consignee emails3 $UZ#R$!$X!"JITEM,!".tpl1!!,!" Y$V$!$C!" JBDEALERS,!".tpl1!!,!" J%S$!$E!"JBPLAN,!".tpl1!!,!" F<@@A9$' pagetitle Order import from Tab Delim FileB$ F!$+CUSTNAME:C(1*=9),CONSNAME:C(1*=9),SHIPDATE:C(1*=9),REFNUM:C(1*=9),CONSADDR1:C(1*=9),CONSADDR2:C(1*=9),CONSADDR3:C(1*=9),CONSCITY:C(1*=9),CONSSTATE:C(1*=9),CONSZIP:C(1*=9),COUNTRY:C(1*=9),PONUM:C(1*=9),TERMS:C(1*=9),SHIPVIA:C(1*=9),QTY:C(1*=9),ITEMCODE:C(1*=9),DESC:C(1*=9) ,+H$-A:C(1*=09),B:C(1*=09),C:C(1*=09),D:C(1*=09),E:C(1*=09),F:C(1*=09),G:C(1*=09),H:C(1*=09),I:C(1*=09),J:C(1*=09),K:C(1*=09),L:C(1*=09),M:C(1*=09),N:C(1*=09),O:C(1*=09),P:C(1*=09),Q:C(1*=09),R:C(1*=09) .-,-I($AS $1CUSTOMERSCONSNAMESSHIPDATESREFNUMS CONSADDR1S CONSADDR2S CONSADDR3SCONSCITYS CONSSTATESCONSZIPSCOUNTRYSPONUMSTERMSSSHIPVIASQTYSITEMCODES DESCRIPTIONSSSSnJ$ 100100100100   sA$ td class="td" < ><  nowrap>z$  ($'TRHILITE
f$^  !$ $ +$ <  width="۩( ">8 ]  $   . Ө _$ Ө  $ A 8 ]  ,$   $ 
8 ]     1$ / /20  8  ]  $ " ",8 ]"#( $, ۩$5$ ۩ ۩ %8 &],  6$$$ө @@8E]T/ өDOSTEP2 #(^/ өDOSTEP3 #(3------------ START PROCESS&$

۩' pagetitle

$
Create a spreadhseet using a format like the image above. SAVE AS to a ".TXT (tab delimited)" format, and then use the Browse Button below and find the file. The click SUBMIT to begin verifying the file.
e$$U
Order File (.txt tab delim format) to Upload: >$- 4$%CALL۩#&Submit$'#(H8L$"8@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE&'&U3------------- VERIFY A LINE IN I$') @W'8'+ ,'8'.-$TUV۫@W1XT'0Y'8'0!$DItem Code Not on file'L8 K m:N(1*=47),d:N(1*=47),y:N(1*=47)$K@R///'V$G@L@M@N'`'j'`+$DInvalid date
s/b mm/dd/yyyy'j:3F LEN(CVS(I.I$,3))<>2 THEN LET DOWARN$[9]="Invalid State"'t @_'v'v'~'v$D Invalid Qty'_ DDDDD DD$H'83--------------- STEP 2 $@/COLAt$$@0COLB&$@2COLC'$@3COLD($@4COLE)$@5COLF*$@6COLG,$@7COLH.$@8COLI0$@9COLJj~t$.1%$Mapping file: @>H$?$,?@>$File not available. Update is complete, or, upload of file failed. Please check inventory to see if data has been updated before uploading again.R$6
 2$|
Select Inquiry Parameters
< :AF-$;COL۩@:<.@:Z$=;
= *:$ $]331CHAR PER LINEA1?@ @$,@ | Subtotal, Free Freight,Shipping & Handling,Discount, No Charge,̦0$f", f$,f Ӧ-3------ SPECIAL FIELD FIXES FOR TRACKING INFO [$[@\5$B O $BQ [@\$B   O;3----------- ORDER BREAK ---- DO THE F/O CREATE IF UPDATING a+$a^: ]. ORDERUPD1Va]#`$bb#5 DA  SHIP TO LINE1,U :A&z$I D:`$I
  D:+0$BB*:$B  TxnLine,̧$[@\^, @W8 @c)$]]C@c@c@c$ @c$]]C۩A@c7 @_($]]I۫@W۩A@_ ۩̧$
 
۩,@:I
G O]7$a^ ORDERUPD1Va]#`$bb# 3input screen\) O!$Update Complete!rj<$&l$' - ms Hk$ZClick BACK and fix the problems identified above in the spreadsheet and re-upload the filernn$Xqa$IVerify Passed! r$ $b83^1000 --- DO STEP 3D$OpK$PQuploads/۩'ULOGIN_۩ %Y%Mz%Dz%Hz%mz%sz.csv6$

Saving input file @> to P$)mv @> P 3--------- EMAIL TO PROPER PLACE!$dlaxweborders@champlog.com7$d&root ithelp@championlogisticsgroup.com3testing$e echo 'Order File Import Complete bh' | mailx -r 'do-not-reply@champlog.com (Champion Reports Whse)' -s'Order File Import Complete Customer-V' d $)e6$
Order alerts sent to: d

8U$'E$'' &$''' - R (F$''+ T &H$''- $'' "873---------- CREATE THE SELECT DROP DOWN FOR EACH COLUMN[$*SREC_DEALERCODE/REC_ITEM/REC_QTY/REC_REFNUM/REC_CARRIER/REC_TRACKINGNUM/REC_SHIPDATEJBITEMTRTDDTRO ERRMESSAGECW1CW2CW3CW4YYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRIDENT1TEXTTDDHBRYYCYYSYYZWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLDUMMY FINDURLGSEARCHWARNINGFFRESULT1FORMSTARTUPLOADDOFUNC SUBMITVALUEFORMENDSUBFUNCASSITPLICSVTPLCOL COL.A COL.B COLDEFAULT COL.C COL.D COL.E COL.F COL.G COL.H COL.I COL.JCOLCOLNAMECOLVALCOLGET CGI.NEWFILECSVFILEIICOLSR JBDEALERSDOWARNJBPLANJBPLANMDYABORT THEWARNING JBDEALERSMDYMDY.YMDY.MMDY.D DOUPDATE SAVEFILEWFDIR I.CT JITEMKEYCWFCUST I.PJITEMJITEM WFCOCODELASTREF I.DILINESLASTI I.OBOL1IREC RESULTTEXT I.QELISTAQQCW1BRD1XLCSZCGIVALFORMENDVERIFYIITEM