[613] | 1 | DDMP ;SFISC/DPC-IMPORT ASCII DATA ;9/23/96 14:58
|
---|
| 2 | ;;22.0;VA FileMan;;Mar 30, 1999
|
---|
| 3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
---|
| 4 | FILE(DDMPF,DDMPFLDS,DDMPFLG,DDMPFSRC,DDMPFMT) ;
|
---|
| 5 | ;API for import tool.
|
---|
| 6 | ;DDMPF - file# of primary import file.
|
---|
| 7 | ;DDMPFLDS (by ref or value) - 1) name of import template (in [])
|
---|
| 8 | ; 2) ;-delimited fields array. Primary file in top element.
|
---|
| 9 | ; Other nodes subscripted by subfile#.
|
---|
| 10 | ;DDMPFLG (by ref.) - ("FLAGS"): 'E'xternal; 'F'ile contains specs
|
---|
| 11 | ; ("MSGS"): Root to contain error messages.
|
---|
| 12 | ; ("MAXERR"): Maximum # of errors allowed.
|
---|
| 13 | ; ("IOP"): Device for report printing.
|
---|
| 14 | ; ("QTIME"): Queue import time.
|
---|
| 15 | ;DDMPFSRC (by ref.) -("PATH"): Path to source file
|
---|
| 16 | ; ("FILE"): Source file name.
|
---|
| 17 | ;DDMPFMT (by value or ref.) - 1) top node = foreign format.
|
---|
| 18 | ; 2) ("FDELIM"): Field delimiter.
|
---|
| 19 | ; ("FIXED"): YES if fixed format.
|
---|
| 20 | ; ("QUOTED"): YES if delimited fields quoted.
|
---|
| 21 | ;
|
---|
| 22 | I '$D(DIQUIET) N DIQUIET S DIQUIET=1
|
---|
| 23 | I '$D(DIFM) N DIFM S DIFM=1 D INIZE^DIEFU
|
---|
| 24 | N DDMPNCNT
|
---|
| 25 | S DDMPFLG=$G(DDMPFLG("FLAGS"),$G(DDMPFLG)) I '$$VERFLG^DIEFU(DDMPFLG,"FE") G OUT
|
---|
| 26 | S DDMPFLG("MAXERR")=$G(DDMPFLG("MAXERR"),1000)
|
---|
| 27 | S DDMPFSRC("PATH")=$G(DDMPFSRC("PATH"))
|
---|
| 28 | I $G(DDMPFSRC("FILE"))="" D BLD^DIALOG(202,"host source file","host source file") G OUT
|
---|
| 29 | D GETFMT^DDMP1(.DDMPFMT) G:$G(DIERR) OUT
|
---|
| 30 | D GETSRC^DDMP1(.DDMPFSRC) G:'$D(^TMP($J,"DDMP")) OUT
|
---|
| 31 | S DDMPNCNT=$O(^TMP($J,"DDMP",""))
|
---|
| 32 | I DDMPFLG["F" D G:$G(DIERR) OUT
|
---|
| 33 | . I $G(DDMPF)'=""!($D(DDMPFLDS)&($G(DDMPFLDS)'="")) D BLD^DIALOG(1833) Q
|
---|
| 34 | . D INFILE^DDMP1("^TMP($J,""DDMP"")",.DDMPFMT,.DDMPF,.DDMPFLDS,.DDMPNCNT)
|
---|
| 35 | E I $G(DDMPF)=""!('$D(DDMPFLDS)) D BLD^DIALOG(202,"file or the fields","file or the fields") G OUT
|
---|
| 36 | I DDMPNCNT="" D BLD^DIALOG(1812,DDMPFSRC("FILE"),DDMPFSRC("FILE")) G OUT
|
---|
| 37 | I $E($G(DDMPFLDS))="[" N DDMPERR D G:DDMPERR'=$G(DIERR) OUT ;import template processing
|
---|
| 38 | . S DDMPERR=$G(DIERR)
|
---|
| 39 | . D TMPL2DR^DDMP1(DDMPF,.DDMPFLDS)
|
---|
| 40 | S DDMPFLDS(DDMPF)=$G(DDMPFLDS(DDMPF),$G(DDMPFLDS))
|
---|
| 41 | I '$$RQIDOK^DDMP1(.DDMPFLDS) G OUT
|
---|
| 42 | N DDMPSQ,DDMPFIEN S (DDMPSQ,DDMPFIEN)=0
|
---|
| 43 | D FLDBLD(DDMPF,.DDMPFLDS,.DDMPSQ,.DDMPFIEN,1) G:$G(DIERR) OUT
|
---|
| 44 | N DDMPIOP,ZTSK,POP ;Device and queuing setup.
|
---|
| 45 | D DEV^DDMP2(.DDMPFLG,.DDMPIOP)
|
---|
| 46 | I $G(DDMPIOP("NG")) D BLD^DIALOG(1850) G OUT
|
---|
| 47 | I $G(DDMPIOP("Q")) D QUE^DDMP2(.DDMPIOP) G OUT
|
---|
| 48 | TASK ;Entry point for queued imports. If not queued, processing continues.
|
---|
| 49 | N DDMPRPSB,DDMPLN,DDMPSTAT,POP
|
---|
| 50 | D REP1^DDMP2(.DDMPRPSB,.DDMPLN)
|
---|
| 51 | S DDMPSTAT("BEG")=$H,(DDMPSTAT("TOT"),DDMPSTAT("NG"))=0
|
---|
| 52 | D PUTDRVR(.DDMPSQ,.DDMPFMT,.DDMPFLG,DDMPNCNT,.DDMPSTAT)
|
---|
| 53 | D REP2^DDMP2(DDMPRPSB,DDMPLN,.DDMPSTAT)
|
---|
| 54 | OUT I $D(ZTQUEUED) D
|
---|
| 55 | . S ZTREQ="@"
|
---|
| 56 | . D CLEAN^DIEFU
|
---|
| 57 | E I $G(DDMPFLG("MSGS"))]"" D CALLOUT^DIEFU(DDMPFLG("MSGS"))
|
---|
| 58 | K ^TMP($J,"DDMP")
|
---|
| 59 | ;K ^XTMP(DDMPRPSB) ;Deletes the report from XTMP
|
---|
| 60 | Q
|
---|
| 61 | ;
|
---|
| 62 | FLDBLD(DDMPF,DDMPFLDS,DDMPSQ,DDMPFIEN,DDMPTFIX) ;
|
---|
| 63 | N DDMPI,DDMPNFLD,DDMPNIEN,DDMPINFD
|
---|
| 64 | S DDMPFIEN=DDMPFIEN+1
|
---|
| 65 | S DDMPNIEN="+"_DDMPFIEN_","_$G(DDMPFIEN("UP",DDMPF))
|
---|
| 66 | F DDMPI=1:1 S DDMPINFD=$P(DDMPFLDS(DDMPF),";",DDMPI) Q:DDMPINFD="" D Q:$G(DIERR)
|
---|
| 67 | . I DDMPINFD'["[" S DDMPNFLD=DDMPINFD
|
---|
| 68 | . E N DDMPOFIX S DDMPNFLD=+DDMPINFD,DDMPOFIX=$P($P(DDMPINFD,"]"),"[",2)
|
---|
| 69 | . I '$$VFIELD^DIEFU(DDMPF,DDMPNFLD,"D") Q
|
---|
| 70 | . N DDMP0P2
|
---|
| 71 | . S DDMP0P2=$P($G(^DD(DDMPF,DDMPNFLD,0)),U,2)
|
---|
| 72 | . I +DDMP0P2 D Q
|
---|
| 73 | . . N DDMPDWF
|
---|
| 74 | . . I $P($G(^DD(+DDMP0P2,.01,0)),U,2)["W" D Q
|
---|
| 75 | . . . N DDMPE S DDMPE(1)="word processing",DDMPE("FILE")=DDMPF,DDMPE("FIELD")=DDMPNFLD
|
---|
| 76 | . . . D BLD^DIALOG(520,"word processing",.DDMPE)
|
---|
| 77 | . . S DDMPDWF=+DDMP0P2
|
---|
| 78 | . . S DDMPFIEN("UP",DDMPDWF)=DDMPNIEN
|
---|
| 79 | . . I '$D(DDMPFLDS(DDMPDWF)) D Q
|
---|
| 80 | . . . N DDMPP S DDMPP("FILE")=DDMPDWF
|
---|
| 81 | . . . D BLD^DIALOG(525,.DDMPP,.DDMPP)
|
---|
| 82 | . . D FLDBLD(DDMPDWF,.DDMPFLDS,.DDMPSQ,.DDMPFIEN,DDMPTFIX)
|
---|
| 83 | . S DDMPSQ=DDMPSQ+1
|
---|
| 84 | . I DDMPFMT("FIXED")="YES",'$G(DDMPOFIX) D BLD^DIALOG(1822)
|
---|
| 85 | . S DDMPSQ(DDMPSQ)=DDMPF_"~"_DDMPNIEN_"~"_DDMPNFLD_"~"_$G(DDMPOFIX)
|
---|
| 86 | Q
|
---|
| 87 | ;
|
---|
| 88 | PUTDRVR(DDMPSQ,DDMPFMT,DDMPFLG,DDMPNODE,DDMPSTAT) ;
|
---|
| 89 | ;Sets up FDA and files data.
|
---|
| 90 | ;DDMPSQ (by reference): Contains specs for each field.
|
---|
| 91 | ;DDMPFMT (by reference): Format of imcoming data
|
---|
| 92 | ;DDMPFLG (by reference): Import control info.
|
---|
| 93 | ;DDMPNODE (by value): Number of first node containing data.
|
---|
| 94 | N DDMPTPAR,DDMPNDCT,DDMPUPFG,DDMPREF
|
---|
| 95 | I DDMPFLG["E" S DDMPUPFG="E"
|
---|
| 96 | S DDMPNDCT=1
|
---|
| 97 | S DDMPREF=$NA(^TMP($J,"DDMP",DDMPNODE))
|
---|
| 98 | S DDMPTPAR(1)=^TMP($J,"DDMP",DDMPNODE)
|
---|
| 99 | F S DDMPREF=$Q(@DDMPREF) Q:DDMPREF'[($J_",""DDMP""") D Q:$G(DDMPSTAT("ABORT"))
|
---|
| 100 | . I DDMPREF'["OVF" D
|
---|
| 101 | . . D RECPROC
|
---|
| 102 | . . K DDMPTPAR S DDMPNDCT=0
|
---|
| 103 | . S DDMPNDCT=DDMPNDCT+1
|
---|
| 104 | . S DDMPTPAR(DDMPNDCT)=@DDMPREF
|
---|
| 105 | I $G(DDMPSTAT("ABORT")) Q
|
---|
| 106 | D RECPROC
|
---|
| 107 | Q
|
---|
| 108 | ;
|
---|
| 109 | RECPROC ; Files a record from DDMPTPAR()
|
---|
| 110 | N DDMPIENS
|
---|
| 111 | K ^TMP($J,"DDMPFDA")
|
---|
| 112 | D TOT(.DDMPSTAT) Q:$G(DDMPSTAT("ABORT"))
|
---|
| 113 | D PARSE(.DDMPSQ,.DDMPTPAR,DDMPNDCT)
|
---|
| 114 | I '$D(^TMP($J,"DDMPFDA")) D RECERR Q
|
---|
| 115 | D UPDATE^DIE($G(DDMPUPFG),"^TMP($J,""DDMPFDA"")","DDMPIENS")
|
---|
| 116 | I $G(DIERR) D
|
---|
| 117 | . D RECERR
|
---|
| 118 | E I DDMPSTAT("TOT")-DDMPSTAT("NG")>1 S DDMPSTAT("LIEN")=DDMPIENS(1)
|
---|
| 119 | E S (DDMPSTAT("FIEN"),DDMPSTAT("LIEN"))=DDMPIENS(1)
|
---|
| 120 | Q
|
---|
| 121 | ;
|
---|
| 122 | TOT(DDMPSTAT) ;
|
---|
| 123 | S DDMPSTAT("TOT")=DDMPSTAT("TOT")+1
|
---|
| 124 | I '$D(ZTQUEUED) W "."
|
---|
| 125 | E I DDMPSTAT("TOT")#10=0,$$S^%ZTLOAD D
|
---|
| 126 | . S DDMPSTAT("ABORT")=2
|
---|
| 127 | . S ZTSTOP=1
|
---|
| 128 | Q
|
---|
| 129 | ;
|
---|
| 130 | RECERR ;
|
---|
| 131 | N DDMPERLN,DDMPERR
|
---|
| 132 | S DDMPSTAT("NG")=DDMPSTAT("NG")+1
|
---|
| 133 | D LDXTMP^DDMP2("Record #"_DDMPSTAT("TOT")_" Rejected:")
|
---|
| 134 | D MSG^DIALOG("AEB",.DDMPERR,$S($D(IOM):IOM-5,1:75))
|
---|
| 135 | S DDMPERLN=0
|
---|
| 136 | F S DDMPERLN=$O(DDMPERR(DDMPERLN)) Q:'DDMPERLN D LDXTMP^DDMP2(" "_DDMPERR(DDMPERLN))
|
---|
| 137 | D CLEAN^DIEFU
|
---|
| 138 | I DDMPSTAT("NG")'<DDMPFLG("MAXERR") S DDMPSTAT("ABORT")=1
|
---|
| 139 | Q
|
---|
| 140 | ;
|
---|
| 141 | PARSE(DDMPSQ,DDMPTPAR,DDMPNDCT) ;
|
---|
| 142 | N DDMPQ,DDMPHOLD,DDMPIN,DDMPI,DDMPTVAL,DDMPVAL
|
---|
| 143 | I DDMPTPAR(1)="" D BLD^DIALOG(1860) Q
|
---|
| 144 | S DDMPQ="""",DDMPSQ=0
|
---|
| 145 | F DDMPI=1:1:DDMPNDCT S DDMPIN=DDMPTPAR(DDMPI) F Q:DDMPIN=""!($G(DIERR)) D
|
---|
| 146 | . I $G(DDMPFMT("QUOTED"))="YES",($E(DDMPIN)=DDMPQ!($E($G(DDMPHOLD))=DDMPQ)) D
|
---|
| 147 | . . I $G(DDMPHOLD)]"" D
|
---|
| 148 | . . . I DDMPHOLD'=DDMPQ,$E(DDMPHOLD,$L(DDMPHOLD))=DDMPQ D
|
---|
| 149 | . . . . S DDMPVAL=DDMPHOLD,DDMPHOLD=""
|
---|
| 150 | . . . . S DDMPIN=$P(DDMPIN,DDMPFMT("FDELIM"),2,99)
|
---|
| 151 | . . . E D
|
---|
| 152 | . . . . S DDMPVAL=DDMPHOLD_$P(DDMPIN,DDMPQ)_DDMPQ,DDMPHOLD=""
|
---|
| 153 | . . . . S DDMPIN=$P($P(DDMPIN,DDMPQ,2,99),DDMPFMT("FDELIM"),2,99)
|
---|
| 154 | . . E D
|
---|
| 155 | . . . S DDMPTVAL=$P(DDMPIN,DDMPQ,1,2)_$S($L(DDMPIN,DDMPQ)>2:DDMPQ,1:"")
|
---|
| 156 | . . . S DDMPIN=$P(DDMPIN,DDMPTVAL,2)
|
---|
| 157 | . . . I DDMPIN=DDMPFMT("FDELIM") S DDMPIN="",DDMPVAL=DDMPTVAL Q
|
---|
| 158 | . . . S DDMPIN=$P(DDMPIN,DDMPFMT("FDELIM"),2,99)
|
---|
| 159 | . . . I DDMPIN="",DDMPI'=DDMPNDCT S DDMPHOLD=DDMPTVAL Q
|
---|
| 160 | . . . S DDMPVAL=DDMPTVAL
|
---|
| 161 | . E I $G(DDMPFMT("FDELIM"))'="" D
|
---|
| 162 | . . S DDMPTVAL=$P(DDMPIN,DDMPFMT("FDELIM"))
|
---|
| 163 | . . I $L(DDMPIN,DDMPFMT("FDELIM"))=2,$P(DDMPIN,DDMPFMT("FDELIM"),2)="" S DDMPIN="",DDMPVAL=$G(DDMPHOLD)_DDMPTVAL,DDMPHOLD="" Q
|
---|
| 164 | . . S DDMPIN=$P(DDMPIN,DDMPFMT("FDELIM"),2,99)
|
---|
| 165 | . . I $G(DDMPHOLD)]"" S DDMPVAL=DDMPHOLD_DDMPTVAL,DDMPHOLD="" Q
|
---|
| 166 | . . I DDMPIN="",DDMPI'=DDMPNDCT S DDMPHOLD=DDMPTVAL Q
|
---|
| 167 | . . S DDMPVAL=DDMPTVAL
|
---|
| 168 | . E D
|
---|
| 169 | . . N DDMPLEN,DDMPLAST
|
---|
| 170 | . . I '$D(DDMPSQ(DDMPSQ+1)) D BLD^DIALOG(1862) Q
|
---|
| 171 | . . S DDMPLEN=$P(DDMPSQ(DDMPSQ+1),"~",4)
|
---|
| 172 | . . I $G(DDMPHOLD)]"" D
|
---|
| 173 | . . . S DDMPVAL=DDMPHOLD_$E(DDMPIN,1,DDMPLEN-$L(DDMPHOLD))
|
---|
| 174 | . . . S DDMPIN=$E(DDMPIN,DDMPLEN-$L(DDMPHOLD)+1,255)
|
---|
| 175 | . . . S DDMPHOLD=""
|
---|
| 176 | . . E D
|
---|
| 177 | . . . S DDMPTVAL=$E(DDMPIN,1,DDMPLEN)
|
---|
| 178 | . . . S DDMPIN=$E(DDMPIN,DDMPLEN+1,255)
|
---|
| 179 | . . . I DDMPIN="",DDMPI'=DDMPNDCT S DDMPHOLD=DDMPTVAL Q
|
---|
| 180 | . . . S DDMPVAL=DDMPTVAL
|
---|
| 181 | . . I $D(DDMPVAL) F S DDMPLAST=$L(DDMPVAL) Q:$E(DDMPVAL,DDMPLAST)'=" " S DDMPVAL=$E(DDMPVAL,1,DDMPLAST-1)
|
---|
| 182 | . I $D(DDMPVAL) D K DDMPVAL
|
---|
| 183 | . . S DDMPSQ=DDMPSQ+1
|
---|
| 184 | . . I '$D(DDMPSQ(DDMPSQ)) D BLD^DIALOG(1862) Q
|
---|
| 185 | . . I $G(DDMPFMT("QUOTED"))="YES" S DDMPVAL=$TR(DDMPVAL,DDMPQ)
|
---|
| 186 | . . D FDASET(DDMPVAL,DDMPSQ(DDMPSQ))
|
---|
| 187 | I $G(DDMPFMT("FIXED"))="YES" F DDMPSQ=DDMPSQ+1:1 Q:'$D(DDMPSQ(DDMPSQ)) S DDMPVAL="" D FDASET(DDMPVAL,DDMPSQ(DDMPSQ))
|
---|
| 188 | Q
|
---|
| 189 | ;
|
---|
| 190 | FDASET(DDMPVAL,DDMPSPEC) ;
|
---|
| 191 | S ^TMP($J,"DDMPFDA",$P(DDMPSPEC,"~"),$P(DDMPSPEC,"~",2),$P(DDMPSPEC,"~",3))=DDMPVAL
|
---|
| 192 | Q
|
---|
| 193 | ;
|
---|