Here is the format for
the Export File, it is all numeric, without any separation within the fields:
The PRECINCTO, UNIDAD,
& COLEGIO are defined all together in the Reporting Precinct. If I
put into the Export field, these 7 numbers together, then we should be able to
give them what they want for these 3 fields.
-----Original
Message-----
From: owner-rcr@dieboldes.com
[mailto:owner-rcr@dieboldes.com]On Behalf Of Talbot Iredale
Sent: Tuesday, April
23, 2002 12:57 PM
To: rcr@dieboldes.com
Subject: Re: Mirror Image MDB
linked to GEMS MDB
We have researched database
replication and have determined the following:
1. Of the
various solutions Microsoft suggests the only one that may be at all
viable is their Replication Manager. We currently do not have Replication
Manager and so it would be atleast 2 weeks before we had any real idea if this
would even work. From their documentation there is one potention problem
with using Replication Manager in that it does not do one-way replication, so
any change in the replicated database would be reflected in the master
database.
2. The other
issue with trying to use database replication is that GEMS uses unigue keys for
all records including the audit log records. Therefore if GEMS was run on both
database there would be conflicts in the Audit Log when trying to replicate.
Therefore we do not
recommend pursueing database replication.
As for Puerto Rico's desire to
produce custom reports, etc there are three option avalable to them with the
current system.
1. First choice Use export
results to export the data and then import into a new database
2. Second
choice Use the output from ResultsMonitor
as various customers have, including Montreal Quebec.
3. Third choice
User the Regional features of GEMS. Setup the 'Master'
database as a 'Regional' site, upload to this database and then using the
Regional Results Server transfer the results to the second database
("Host"). To use the option a second region "Master" needs
to be created, all the vote centers need to be set to be in this region, a user
needs to be setup to use this region and you must login as that user for
uploads. Note: currently you need to login as a "Host"
region user to be able to re-set the election.
4. Not
Recommended but possible Directly connect to the GEMS
database, as King County has.
----- Original Message -----
Sent: Wednesday, April
03, 2002 4:57 AM
Subject: Mirror
Image MDB linked to GEMS MDB
Jurisdiction: San Juan, Puerto Rico
Date
Requested: April
3, 2002
Date
Required: May 1, 2002, Actual
Election date is June 30th, but need to test and have ready by May 20th.
Puerto Rico needs a
mirrored MBD file system that linked to the protected GEMS MDB file. This MDB
must be resident on are GEMS server and it must be open and accessible by their
MIS dept. The intent is to have them integrate our results to their
existing IBM main frame and their existing reporting application
software. This is required instead of export of results that we normally
do since they have developed their own jresults type application were it needs
to be a live presentation to the press and to the public. At the same
time they hang terminals off their mainframe to allow TV, Radio, and Print
media to produce their own reports live off the main frame. The actual
layout and structure of this mirror MBD is needed ASAP since their MIS needs it
to develop the access routine to interface to said MDB.
Juan A. Rivera
Diebold Election Systems
(214) 335-3478
jrglobal@earthlink.net