| 1 | RRCI18X ; Internationalization eXtractor to Excel and From Excel | 
|---|
| 2 | ;RRCI18X V0.0001;;RCR/RCR/27MAY2004 | 
|---|
| 3 | ;Donated by Chris Richardson | 
|---|
| 4 | ;Initial database design by Marcus Werner | 
|---|
| 5 | ;Copyright 2008 WorldVistA.  Licensed under the terms of the GNU | 
|---|
| 6 | ;General Public License See attached copy of the License. | 
|---|
| 7 | ; | 
|---|
| 8 | ;This program is free software; you can redistribute it and/or modify | 
|---|
| 9 | ;it under the terms of the GNU General Public License as published by | 
|---|
| 10 | ;the Free Software Foundation; either version 2 of the License, or | 
|---|
| 11 | ;(at your option) any later version. | 
|---|
| 12 | ; | 
|---|
| 13 | ;This program is distributed in the hope that it will be useful, | 
|---|
| 14 | ;but WITHOUT ANY WARRANTY; without even the implied warranty of | 
|---|
| 15 | ;MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the | 
|---|
| 16 | ;GNU General Public License for more details. | 
|---|
| 17 | ; | 
|---|
| 18 | ;You should have received a copy of the GNU General Public License along | 
|---|
| 19 | ;with this program; if not, write to the Free Software Foundation, Inc., | 
|---|
| 20 | ;51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. | 
|---|
| 21 | V       QUIT | 
|---|
| 22 | ; Note: Snapshot file .84 before this run so that | 
|---|
| 23 | ;        it might be restored completely. | 
|---|
| 24 | ;  LNG is the language to be loaded (is optional) | 
|---|
| 25 | ; There are two major entry points to this routine; | 
|---|
| 26 | ;  M2EX^RRCI18X(LNG) Will generate a series of Excel Files (30,000 rows/file) | 
|---|
| 27 | ;  EX2M^RRCI18X(LNG) Will Load an Excel Sheet into the Dialog File | 
|---|
| 28 | ;  P2EX^RRCI18X      Will scan the Package File and build a list | 
|---|
| 29 | M2EX(LNG)       ; Load a series of excel loadable files from the Dialog File | 
|---|
| 30 | N FILE,FN,LC,X,D0,TB,SET | 
|---|
| 31 | S U="^",SET="" | 
|---|
| 32 | S D0=0,FILE="",TB=$C(9) | 
|---|
| 33 | S LC=600000,FN=-1 | 
|---|
| 34 | F  S D0=$O(^DI(.84,D0)) Q:'D0  D | 
|---|
| 35 | . S X=$P($G(^DI(.84,D0,0)),U,3) | 
|---|
| 36 | . Q:X="" | 
|---|
| 37 | . ; | 
|---|
| 38 | . I $L(X," ")>1 D SEND  Q  ; At least one space | 
|---|
| 39 | . I X?.E1PL.E   D SEND  Q  ; At least some punctuation or lower case | 
|---|
| 40 | . ; | 
|---|
| 41 | . S ^RRCTMP("I18","ODD",X)="" | 
|---|
| 42 | .QUIT | 
|---|
| 43 | D ENDFILE | 
|---|
| 44 | U 0 | 
|---|
| 45 | QUIT | 
|---|
| 46 | ;  ============ | 
|---|
| 47 | TEST    ; Load a series of excel loadable files from the Dialog File | 
|---|
| 48 | N FILE,FN,LC,X,D0,TB | 
|---|
| 49 | S U="^",SET="" | 
|---|
| 50 | S D0=0,FILE="",TB=$C(9),EXIT=0 | 
|---|
| 51 | F  D   Q:EXIT | 
|---|
| 52 | . S DIC=9.4,DIC(0)="AE" | 
|---|
| 53 | . D ^DIC | 
|---|
| 54 | . I Y>0 D   Q | 
|---|
| 55 | . . N K | 
|---|
| 56 | . . S K=$P($G(^DIC(9.4,+Y,0)),U,2) | 
|---|
| 57 | . . I $L(K) S SET(K)="" | 
|---|
| 58 | . .QUIT | 
|---|
| 59 | . ; | 
|---|
| 60 | . S:(+Y)<0 EXIT=1 | 
|---|
| 61 | .QUIT | 
|---|
| 62 | QUIT | 
|---|
| 63 | ;  ============ | 
|---|
| 64 | P2EX    ; Load a series of excel loadable files from the Dialog File | 
|---|
| 65 | N FILE,FN,LC,X,D0,SET,TB | 
|---|
| 66 | S U="^",SET="" | 
|---|
| 67 | S D0=0,FILE="",TB=$C(9),EXIT=0 | 
|---|
| 68 | F  D   Q:EXIT | 
|---|
| 69 | . S DIC=9.4,DIC(0)="AE" | 
|---|
| 70 | . D ^DIC | 
|---|
| 71 | . I Y>0 D   Q | 
|---|
| 72 | . . N K | 
|---|
| 73 | . . S K=$P($G(^DIC(9.4,+Y,0)),U,2) | 
|---|
| 74 | . . I $L(K) S SET(K)="" | 
|---|
| 75 | . .QUIT | 
|---|
| 76 | . ; | 
|---|
| 77 | . S:(+Y)<0 EXIT=1 | 
|---|
| 78 | .QUIT | 
|---|
| 79 | S LC=600000,FN=-1 | 
|---|
| 80 | F  S D0=$O(^DI(.84,D0)) Q:'D0  D | 
|---|
| 81 | . S X=$P($G(^DI(.84,D0,0)),U,3) | 
|---|
| 82 | . Q:X="" | 
|---|
| 83 | . ; | 
|---|
| 84 | . D:$$PICK(D0,.SET) | 
|---|
| 85 | . . I $L(X," ")>1 D SEND  Q  ; At least one space | 
|---|
| 86 | . . I X?.E1PL.E   D SEND  Q  ; At least some punctuation or lower case | 
|---|
| 87 | . . ; | 
|---|
| 88 | . . S ^RRCTMP("I18","ODD",X)="" | 
|---|
| 89 | . .QUIT | 
|---|
| 90 | .QUIT | 
|---|
| 91 | D ENDFILE | 
|---|
| 92 | U 0 | 
|---|
| 93 | QUIT | 
|---|
| 94 | ;  ============ | 
|---|
| 95 | PICK(D,V)       ; Find a member of the routines which matches | 
|---|
| 96 | N T,P,J,L | 
|---|
| 97 | S T=0,P=0 | 
|---|
| 98 | F  S P=$O(^DI(.84,D,5,"B",P))  Q:P=""  D  Q:T | 
|---|
| 99 | . S J="" | 
|---|
| 100 | . F  S J=$O(V(J))  Q:J=""  S L=$L(J)  I $E(P,1,L)=J S T=1 Q | 
|---|
| 101 | .QUIT | 
|---|
| 102 | QUIT T | 
|---|
| 103 | ;  ============ | 
|---|
| 104 | SEND    ; Resolve the String as being in DIALOG or add it. | 
|---|
| 105 | N Y | 
|---|
| 106 | I LC>30000  D NEWFILE U FILE | 
|---|
| 107 | S Y=$G(^DI(.84,D0,2,1,0)) | 
|---|
| 108 | I $L(Y)>$L(X) S X=Y | 
|---|
| 109 | W X_TB_TB_TB,! | 
|---|
| 110 | S LC=LC+1 | 
|---|
| 111 | QUIT | 
|---|
| 112 | ;  ============ | 
|---|
| 113 | NEWFILE ; Close any current file (FILE) and then open a new file | 
|---|
| 114 | N NM | 
|---|
| 115 | S LC=0 | 
|---|
| 116 | I FILE'="" D ENDFILE  ; Close the current file with an easily identifiable terminator | 
|---|
| 117 | S FN=$G(FN)+1 | 
|---|
| 118 | S NM=$O(SET("")) | 
|---|
| 119 | S:'$L(NM) NM="DIALOG" | 
|---|
| 120 | S FILE="WV-"_NM_"-"_$TR($J(FN,4)," ","0")_".txt" | 
|---|
| 121 | O FILE:NEW | 
|---|
| 122 | U FILE | 
|---|
| 123 | W "ENGLISH"_TB_"SPANISH"_TB,! | 
|---|
| 124 | QUIT | 
|---|
| 125 | ;  ============ | 
|---|
| 126 | ENDFILE ; Load the Exclusion File from ^RRCTMP("I18","ODD", | 
|---|
| 127 | N C,I | 
|---|
| 128 | S C=$TR($J("",20)," ","#") | 
|---|
| 129 | F I=1:1:5 W C_TB_C_TB_C_TB,! | 
|---|
| 130 | C FILE | 
|---|
| 131 | QUIT | 
|---|
| 132 | ;  ============ | 
|---|
| 133 | LOADX   ; Load the Exclusion File from ^RRCTMP("I18","ODD", | 
|---|
| 134 | N D0,DA,F,FN,X | 
|---|
| 135 | S U="^" | 
|---|
| 136 | S X="",F=$G(^WVDI(250.84,0)) | 
|---|
| 137 | S (DA,D0)=0 | 
|---|
| 138 | F  S X=$O(^RRCTMP("I18","ODD",X))  Q:X=""  D | 
|---|
| 139 | . S DA=$O(^WVDI(250.84,"B",X,"")) | 
|---|
| 140 | . I DA="" S D0=$P(F,U,3)+1,$P(F,U,3,4)=D0_U_D0,DA=D0 | 
|---|
| 141 | . S ^WVDI(250.84,DA,0)=X,^WVDI(250.84,"B",X,DA)="" | 
|---|
| 142 | .QUIT | 
|---|
| 143 | S ^WVDI(250.84,0)=F | 
|---|
| 144 | QUIT | 
|---|
| 145 | ;  ============ | 
|---|
| 146 |  | 
|---|