Tab, Marin just called because I asked them to run their VReg Import. Attached are her files. All the party export fields are correct (except that they have two NP types, a N.P. that has a blank export ID and a NonPartisan with the correct export ID.) I swapped the two NP export IDs and it still has the same problem, import runs without error, but when you go to display the VR totals, it only shows the NP column. Where are the other party totals? ----- Original Message ----- From: DeJusto, Madelyn <MDeJusto@co.marin.ca.us> To: Steve Knecht (E-mail) <skglobal@earthlink.net> Sent: Friday, January 25, 2002 12:09 PM > <<marin primary 030502 1 25 02.gbf>> <<EWMGlobal01252002.txt>> >
marin primary 030502 1 25 02.gbf
"","8","11","13","17","19","20","25","35" "681",10,253,10,0,5,2,172,89 "682",5,199,23,0,3,0,88,76 "685",9,255,7,2,3,1,112,70 "693",8,239,14,1,3,2,142,73 "686",4,208,5,4,4,0,68,50 "692",7,304,12,5,7,0,184,80 "688",3,165,2,2,2,1,136,78 "697",2,149,1,1,0,0,99,40 "696",6,159,2,0,1,0,60,39 "694",15,229,3,1,7,0,185,80 "695",0,185,0,1,1,0,160,68 "700",9,274,16,4,4,3,96,104 "699",4,183,7,5,0,1,76,67 "703",4,171,21,0,2,1,52,69 "714",8,294,18,5,5,0,151,116 "704",3,161,21,1,8,0,83,59 "705",10,302,10,3,6,0,170,101 "707",7,176,6,1,1,0,185,60 "706",11,186,15,4,2,1,156,70 "708",8,233,4,3,4,2,251,85 "709",2,155,3,1,2,1,179,54 "710",3,157,2,3,2,0,129,46 "711",6,264,8,2,0,1,185,66 "716",6,279,9,2,2,1,122,91 "717",4,180,21,3,2,0,59,59 "718",7,258,14,4,7,0,86,75 "719",4,165,22,2,3,1,82,76 "720",7,204,6,2,1,0,75,65 "727",9,241,8,1,1,0,123,84 "721",14,252,6,5,3,1,193,87 "723",10,184,6,2,3,0,116,66 "722",2,194,9,5,4,5,89,66 "726",5,233,11,1,3,0,99,60 "730",4,181,5,3,4,1,143,53 "729",4,152,5,0,0,1,143,49 "677",6,381,25,2,5,0,99,98 "678",8,269,25,5,2,1,83,82 "679",10,492,29,1,2,3,222,136 "680",4,531,27,7,5,2,217,171 "683",18,396,33,4,5,1,169,154 "684",8,323,31,4,8,3,128,125 "687",1,131,0,3,1,0,204,42 "689",19,426,8,0,5,2,185,190 "690",9,462,20,6,5,0,279,130 "691",7,288,5,2,2,0,216,104 "698",16,513,14,10,6,3,227,140 "701",11,406,5,7,2,0,207,113 "702",15,308,21,8,4,0,152,104 "712",12,391,9,4,7,0,396,142 "713",8,315,4,2,2,0,358,99 "715",8,384,15,3,4,2,210,113 "724",6,324,8,2,3,0,205,87 "725",13,402,6,4,4,1,245,108 "728",5,129,12,1,2,0,127,36 "734",4,212,9,5,2,2,174,71 "735",2,67,2,0,0,0,45,18 "743",3,140,3,2,0,2,71,36 "744",1,3,0,0,0,0,0,0 "746",4,16,2,0,0,0,9,9 "771",4,81,0,1,0,1,82,33 "774",5,213,8,3,3,1,113,52 "772",0,15,0,0,0,0,18,6 "775",9,259,8,4,4,1,143,74 "776",11,265,8,7,7,5,80,71 "778",6,209,7,2,0,1,191,79 "779",8,149,7,2,0,0,152,67 "731",21,492,13,5,1,1,297,135 "732",14,433,23,4,5,0,209,154 "733",6,234,1,1,3,0,237,72 "777",7,205,15,5,5,0,169,77 "786",10,262,4,3,4,0,215,80 "787",5,210,4,2,0,0,150,63 "736",0,60,0,0,0,0,41,15 "741",5,288,8,0,3,1,169,85 "740",7,200,6,4,2,1,70,62 "745",8,206,9,3,0,0,82,74 "742",4,99,4,0,0,0,76,22 "747",4,234,19,2,1,0,59,66 "750",8,227,11,4,1,0,92,50 "751",14,234,17,2,1,0,125,77 "749",11,286,18,4,0,0,64,102 "755",7,293,24,1,3,0,68,73 "756",1,256,17,2,3,0,89,52 "757",7,280,11,1,5,1,116,75 "758",7,260,18,1,4,1,58,74 "759",9,334,15,3,2,0,120,70 "760",6,227,13,3,1,0,84,62 "773",2,71,2,1,0,0,121,32 "783",1,81,5,2,0,0,14,22 "784",1,90,12,1,1,0,26,27 "788",5,117,8,2,4,0,41,46 "789",0,0,0,0,0,0,0,0 "791",14,236,18,2,2,0,86,78 "794",13,259,20,0,2,0,67,101 "792",13,312,15,4,1,2,129,96 "793",5,215,9,2,4,1,77,65 "737",12,265,15,1,5,0,94,79 "738",11,412,14,4,5,2,191,157 "739",15,274,18,4,4,0,129,104 "748",11,289,21,1,4,0,128,87 "752",15,586,45,4,8,0,171,164 "753",15,545,46,4,5,2,108,174 "754",11,501,44,9,6,2,124,153 "761",15,469,71,1,5,2,79,138 "762",16,487,64,5,4,1,94,127 "763",7,427,100,1,2,2,70,163 "764",12,558,79,3,10,1,143,153 "765",13,456,72,2,10,1,68,147 "766",14,424,49,2,2,2,120,135 "780",15,271,20,2,1,2,203,93 "781",4,230,12,3,4,1,190,59 "782",5,218,9,0,5,0,142,68 "785",11,323,18,0,3,0,129,94 "790",7,318,33,2,2,0,123,86 "795",15,394,34,2,8,2,91,162 "796",21,411,30,3,9,3,78,124 "767",0,3,0,0,0,0,1,1 "768",5,144,3,0,2,0,170,76 "769",10,158,2,1,7,0,136,78 "770",17,307,14,3,5,1,342,114 "798",4,209,7,2,8,1,96,111 "797",14,228,11,3,3,1,108,98 "799",7,185,14,1,4,3,93,82 "800",9,202,10,2,3,0,160,82 "801",9,395,21,5,8,1,166,167 "802",14,404,41,6,4,1,152,193 "803",15,371,15,7,1,0,182,170 "804",16,369,35,5,4,2,192,166 "806",7,299,11,0,1,1,67,70 "807",6,303,21,2,3,3,95,88 "809",5,318,21,3,8,2,93,96 "810",4,235,18,1,4,1,72,73 "814",7,291,16,3,4,1,110,95 "812",4,263,11,1,4,1,74,76 "815",7,210,4,0,1,0,113,46 "818",8,287,18,0,5,1,83,67 "816",12,243,8,1,1,1,67,70 "817",9,258,8,1,2,2,96,67 "821",9,350,13,0,2,0,196,138 "819",6,149,3,1,3,0,46,47 "831",9,305,16,2,3,1,85,103 "837",5,169,6,0,1,0,29,49 "832",3,216,19,4,0,1,62,76 "839",5,182,8,1,3,0,81,72 "835",2,199,7,3,4,0,79,69 "836",9,212,16,0,2,1,115,113 "843",14,239,9,3,1,0,221,125 "849",4,171,7,3,3,1,104,62 "844",7,250,15,6,3,2,127,78 "846",6,135,8,2,5,2,138,76 "845",4,103,5,1,2,0,20,30 "850",7,128,3,4,1,1,180,60 "851",3,102,2,1,3,0,115,49 "805",5,282,9,2,2,2,167,94 "808",12,480,29,3,1,5,139,162 "811",16,553,18,1,7,1,156,161 "813",8,212,13,1,3,0,121,82 "820",10,282,11,0,1,2,113,61 "822",10,370,7,6,4,0,266,131 "823",5,419,10,2,0,0,357,169 "824",10,259,5,5,1,1,166,133 "825",8,322,6,1,6,0,347,158 "826",12,309,7,7,5,2,262,147 "827",10,231,5,2,1,3,187,116 "828",11,452,9,3,1,0,310,180 "829",13,242,5,1,0,2,395,100 "830",9,241,9,1,3,1,353,106 "833",12,429,26,2,6,3,130,154 "834",12,487,23,4,2,2,138,168 "838",10,378,14,7,6,0,143,124 "840",19,440,37,1,4,2,95,160 "841",20,540,14,1,3,1,36,164 "842",13,292,30,11,2,0,67,121 "847",13,297,17,2,3,0,192,118 "848",7,216,15,2,3,1,62,82 "856",3,86,11,0,1,1,23,28 "865",0,16,2,0,0,0,2,3 "866",9,395,17,3,7,4,121,120 "869",3,177,13,2,4,1,60,61 "872",0,1,0,0,0,0,0,0 "876",0,83,11,0,2,0,4,25 "877",0,0,0,0,0,0,0,0 "878",0,4,1,0,0,0,1,0 "890",4,235,18,1,4,0,89,92 "896",7,197,15,3,3,0,52,69 "891",8,244,9,0,1,0,59,74 "892",7,272,10,0,4,1,129,71 "894",6,225,7,3,0,0,133,70 "895",9,203,9,3,1,0,96,50 "901",0,0,0,0,0,0,0,0 "903",4,68,7,0,0,0,22,26 "904",1,58,10,0,0,0,12,12 "852",13,437,69,2,5,2,111,96 "853",5,250,24,2,6,0,206,94 "854",2,274,38,2,4,0,46,59 "855",10,355,50,3,3,0,108,109 "857",5,198,18,1,3,0,94,77 "867",2,167,28,2,0,1,31,49 "868",9,323,24,6,3,4,110,98 "870",9,323,22,0,0,0,78,84 "871",12,312,20,1,3,0,105,111 "881",7,416,80,2,2,2,56,140 "882",6,395,78,3,1,2,72,129 "883",9,320,74,2,10,0,87,104 "884",7,291,68,3,3,0,67,64 "888",19,494,30,9,7,3,152,216 "889",20,478,24,1,6,1,234,188 "893",14,327,12,3,4,2,111,130 "897",18,391,13,1,9,0,239,159 "898",13,322,6,3,3,0,191,114 "899",9,437,24,6,5,0,194,162 "900",5,197,6,4,4,1,155,96 "902",9,148,2,0,4,0,72,69 "858",0,6,0,0,1,0,26,1 "859",1,12,3,0,0,0,21,9 "861",0,6,3,0,0,0,15,7 "862",1,58,1,1,2,0,31,8 "860",0,5,0,0,0,0,4,2 "863",13,286,9,4,6,0,307,131 "864",3,81,0,2,0,0,75,23 "885",15,424,15,9,6,1,278,140 "886",19,377,9,10,6,0,340,148 "887",6,306,13,1,4,0,254,115 "873",0,26,9,0,1,0,3,5 "874",0,11,0,0,0,0,3,1 "875",0,3,0,0,0,0,0,4 "879",5,232,45,2,6,0,18,61 "880",6,252,41,3,3,0,24,93 "908",8,141,4,2,2,0,64,55 "918",16,312,14,5,6,2,213,111 "937",4,107,5,2,1,0,41,35 "938",3,140,1,1,0,0,70,30 "940",15,371,10,3,11,2,236,148 "905",13,293,9,7,4,2,251,114 "906",13,283,12,4,2,0,152,122 "907",24,469,10,2,1,0,309,156 "909",33,470,15,6,9,2,220,177 "910",15,289,10,1,2,3,135,83 "911",16,364,18,7,3,0,197,152 "912",11,340,10,1,3,1,189,99 "913",15,392,7,8,5,0,372,140 "914",14,347,11,9,4,0,168,134 "915",31,385,10,4,5,0,279,140 "916",9,352,9,4,2,0,273,122 "917",9,382,5,2,0,1,273,149 "919",12,385,12,4,12,0,211,151 "920",7,213,6,3,2,0,126,66 "921",15,402,13,7,3,1,198,189 "922",22,427,18,8,4,2,292,154 "923",17,297,11,2,2,0,150,133 "924",17,311,8,3,4,0,147,118 "925",15,358,12,6,5,0,305,169 "926",20,448,8,2,5,2,345,130 "927",4,184,2,1,0,0,262,63 "928",17,327,15,6,8,1,270,147 "929",20,377,18,4,5,2,282,152 "930",14,407,12,8,3,0,332,201 "931",14,442,13,6,3,1,333,156 "932",10,380,5,6,1,0,292,115 "933",13,186,7,4,4,0,360,72 "941",7,189,4,3,1,0,178,63 "942",16,360,10,5,1,0,272,120 "943",11,218,4,5,0,0,231,110 "944",14,270,11,7,5,0,278,132 "945",9,255,12,0,4,0,143,83 "946",12,200,6,6,1,2,203,97 "934",0,0,0,0,0,0,1,1 "935",0,0,0,0,0,0,0,0 "936",0,1,0,0,0,0,0,0 "939",8,40,4,0,1,0,40,28