Home

BPS / WinEDS Bridge Tool User`s Manual

1. Any errors that occurred during processing are logged into a text file After processing is complete the following message is displayed 9 Click OK 10 Review the text file for errors as necessary 11 If you are importing symbolic languages refer to Appendix A 12 Click Exit to close the Bridge program Page 16 of 22 Confidential and Proprietary 5 10 2005 E BP inEDS Bri Tool i SEQUOIA S WinEDS Bridge Tool User s Guide Appendix A Importing Symbolic Languages To WinEDS a symbolic language also referred to as Unicode or a double byte character set is a language that does not support the standard ASCII character set In WinEDS symbolic languages are implemented by either creating Microsoft Word documents or bitmap objects of the election elements Importing symbolic languages using BPS is much the same as performing a mail merge in Microsoft Word The data is taken from BPS and put into a Word document as a table in Word and then merged the same as a form letter would be merged Therefore it is helpful to know mail merge functions in Microsoft Word before importing symbolic languages The significant difference between a normal mail merge and using the BPS Bridge Tool to import symbolic languages is that WinEDS requires each item to be a separate file Therefore when you import symbolic languages using BPS you will be creating many individual files what will be uploaded into the WinEDS database Note During Edge
2. The Options tab is selected automatically 5 10 2005 Confidential and Proprietary Page 17 of 22 gt BPS WinEDS Bridge Tool User s Guide SEQUOIA 2 Click Import Symbolic Languages The Language Import tab is displayed aisi ad NIH S LC I UO C vi 4 07 Language Import Symbolic language import STEPS 1 Select translation Proposal header zf 2 Prepare BPS data For language Vietnamese zf Last prep neyer gt 3 Edit merge document C BPS Proposal header vietnamese doc SA Go 4 Create images in C BPS CandImagesss S Sol _co Upload to WinEDS E _Go Upload all images Test merge on Exit Status Select the translation option then proceed through each step by clicking GO Click Exit when Finished 3 Complete steps through 5 on the screen STEP 1 Select translation From the drop down menu select the object you want to create The selections are e contest header e candidate header e contest short name for the Edge review screen e candidate short name e proposal header e proposal text STEP 2 Prepare BPS data a From the drop down menu select the symbolic language to process b Click Go Your screen flashes as data is extracted and stored in a Word document Important Be sure you have the correct options selected in steps 1 and 2 when performing steps 3 4 and 5 Images are processed based on these options not file names Page 18 of 22 Conf
3. current precinct assignments New or changed precinct names in BPS will not be assigned a location in WinEDS Note To remove all precinct location assignments uncheck the Keep Locations checkbox 5 10 2005 Confidential and Proprietary Page 13 of 22 gt BPS WinEDS Bridge Tool User s Guide SEQUOIA d Under the Special Processing section click the Verify Language Cross Reference button The Language Cross Reference screen appears Note You need only set up this screen once ES BPS gt WinEDS Import E 5 x Ay GANS LU HUU Language Crossreference WinEDS Languages WinEDS ID WinEDS name 1 Spanish 2 Chinese 3 Vietnamese 4 Tagalog Update this table only For each WinEDS Language make a BPS language crossreference RFLanguagebridge WinEDSID Mame BPS code 1 Spanish Espanol 2 Chinese 3 Vietnamese 4 Tagalog U 1 English 2 Spanish b Tagalog 7 Chinese o vietnamese Status Update XRFLanguageBridge table information Then click OK 1 Review tables on the left that contain data from WinEDS and BPS ii Create cross references using the right hand table In the example above WinEDS is setup for four additional languages Therefore four crossreference records must be created in the table on the right for each language Matching the WinEDS ID name and corresponding BPS Code records are entered on the new record line indicated by an asterisk on the grey bar on the left side
4. of the table The crossreference table enables the bridge to move BPS language data to the proper WinEDS database locations e Click OK Page 14 of 22 Confidential and Proprietary 5 10 2005 D SEQUOIA BPS WinEDS Bridge Tool User s Guide 7 Click Next The Header screen appears suene meai la x ES SENEO Miers WINEDS ballot headers l Candidate SSCS NOTE Party header Candidate To import the BPS ballot design Fields t Contest header Con Header Line PSD 2L Office Banner Header Subheader and Office Message S e your ballot headers must contain these fields Candidate header Candidate_Room_Occupation Click More Information For details Z candidate header has Occupation More Information Write In header writeIn 7 l Proposal header Prop Meas_Line_Header_Contest_Proy bd Skip PSD Assignments Process BPS 2nd Language field Print only header Prnt Legend Text bd IZ Open primary Use EMS codes IZ Add Print only contest For each party lt Back Import data Status Select ballot header options Then click Import data or Back 8 On the Header screen do the following a Select the appropriate WinEDS ballot headers Note The checkbox Add print only contest for each party appears only if the election is a primary b Check or uncheck the desired options Skip PSD Assignments When checked Political subdivisions will not be assigned to precincts Depending on the size of your county th
5. the document with the proper item in WinEDS insert the record ID field somewhere in the document The ID is an internal database field it is not the same as List Order It can be anywhere and any size and it must begin and end with two vertical bars For example for a candidate object type then insert the CANDIDATE_ID field followed by The result should look like lt lt CANDIDATE ID gt gt During upload processing the program searches for the vertical bars takes the ID number between the bars removes this data then saves the file using the ID number as part of the file name The ID is used when uploading to WinEDS For proposals use the CONTEST_ID merge field Format your document as needed to correct the page size margins fonts or other document attributes Save your document and exit Word To see how the merge will appear for all objects click Test merge This will perform a merge and open a new document A screen similar to the following appears PUREE An TT a a a a 29 9 oe Ra 22 BRE ALS e MICHAEL ANTHONY SS TRS te iF e LEONARD PELTIER S F SLI e JOHN F KERRY R PEROUTKA 28 ve AFH Shs f tH e DAVID COBB 5 ba W A e GEORGE W BUSH 18 AMARA TG E lt MICHAEL BADNARIK Bas MeSH e BILL JONES HB J HS DON J GRUNDMANN FEREARE LEE RHS 5 SRN P Aas HAE e JAMES P JIM GRAY e JERE MARSHA FEINLAND HFAA Bas VS REA RNB BARBARA BOXER REH HA Hn M SREE GERALD JERRY fE e RICHARD
6. C 7677 Oakport Street SEQUOIA ius voting systems Oakland CA 94621 Ballot Printing System BPS WinEDS Bridge Tool User s Manual Document Version 1 03 May 10 2005 Confidential and Proprietary Information gt BPS WinEDS Bridge Tool User s Guide SEQUOIA Copyright 2005 Sequoia Voting Systems Inc All rights reserved Disclaimer Sequoia Voting Systems Inc believes that this manual is accurate and reliable Sequoia Voting Systems accepts no responsibility financial or otherwise for any consequences arising out of the information in or the use of this manual The information contained in this manual is subject to change Updates may be issued from time to time This manual contains proprietary and confidential information This document was prepared by Sequoia Voting Systems and is intended for the exclusive use of its clients and licensees No part of this document may be photocopied or reproduced in any manner without the prior consent of Sequoia Voting Systems Sequoia Voting Systems does not extend any warranties by this document All product information and material disclosure contained in this document is furnished subject to the terms and conditions of a purchase or lease agreement The only warranties made by Sequoia Voting Systems are contained in such agreements Users should ensure that the use of this system complies with all legal or other obligations of their governmental jurisdictions Version Hist
7. D ONC Ker Oe T 17 5 10 2005 Confidential and Proprietary Page 3 of 22 gt BPS WinEDS Bridge Tool User s Guide SEQUOIA This page is intentionally left blank Page 4 of 22 Confidential and Proprietary 5 10 2005 E SEQUOIA BPS WinEDS Bridge Tool User s Guide About This Guide Purpose The BPS Bridge Tool User s Guide guides the user in importing BPS data into WinEDS Audience Users should have a thorough understanding of their election data especially data originating from a Voter Registration system such as Integrity or DFM Scope The BPS Bridge Tool User s Guide contains instructions for operating the Bridge Tool wizard It does not contain instructions on how to use the WinEDS BPS or Voter Registration software Related Documents WinEDS 3 0 Reference Guide BPS User s Manual BPS Help System 5 10 2005 Confidential and Proprietary Page 5 of 22 gt BPS WinEDS Bridge Tool User s Guide SEQUOIA This page is intentionally left blank Page 6 of 22 Confidential and Proprietary 5 10 2005 gt BP inEDS Bri Tool i SEQUOIA S WinEDS Bridge Tool User s Guide 1 Introduction 1 1 System Overview 1 1 1 Data Flow An export job from the Voter Registration system feeds data such as candidates contests voter registration numbers and precincts to BPS The wizard moves this data from BPS to WinEDS databases WinEDS BPS Bridge Tool Data Flow Manual input Voter Registration syst
8. POMBO 415 aS BE M MCNERNEY R Sl LL HEEM e BRIAN HOLTZ amS SLT lt CHRIS HAUGEN 4 BR G iR E ANNA G ESHOO REH TE BHK RI XBT SEE H MIKE HONDA R K L RE RAYMOND L CHUKWU 3 408 tai Rien S ST S 9 Je G2 e DOUGLAS ADAMS za RBS EH RNE LE A MCNEA 415 RER FEH e ZOE LOFGREN REH ENEMA lt MARKUS WELCH 44h Sac mSes ERMEE oh ates JOE SIMITIAN R H M 237 ALLEN M RICE Sh REME A JON ZELLHOEFER JL 105 DN RSS TLS BIE HI APRS A QRS LEB LE B So Ra SAFE MICHAEL LAURSEN h ZARE Oe Fh All SHANE PATRICK Rt Se a Ge Le Ap CONNOLLY TYS H 9 HTS re th t mi AIN A h Ne m X Ad 1 A A SS tess K Jl ae Apr Rt n dd 1 550 AL oO Ln i Col 1 REC TRK EXT OVR QJ Confidential and Proprietary 5 10 2005 D SEQUOIA 4 5 5 10 2005 BPS WinEDS Bridge Tool User s Guide h Check the results of the merge To make alterations that will affect all merge records close the document and repeat STEP 3 Edit Merge Document To change to only a few of the objects note the items needing changes You can open the individual documents after completing Step 4 Note the test merge document cannot be used for processing Do not make changes to this document since there is no way to use the data STEP 4 Create images in Create individual images a Select a folder to place the merge documents b Click Go This step performs a merge and creates a document for each object For example if you have 30 candidates in your enti
9. allot proofing Refer to the WinEDS Reference Guide Chapter 10 Tools for more information Page 22 of 22 Confidential and Proprietary 5 10 2005
10. bheader Occupation and Office Message fields in BPS are transferred to WinEDS as Ballot Header fields To import these fields from BPS follow the steps below 1 Open WinEDS and go to the System Setup screen 2 Select the Ballot Header tab 3 Open each contest header that you want to print the Banner Header and Sub Header data Microsoft Visio opens 4 Drag a Text object from the stencil to your header Select the Text tool Click on the text and rename Text to the term Banner Note Type the term exactly as it appears with the first letter capitalized 7 Repeat steps 4 and 6 to create the terms Header Subheader Occupation for candidate header only and Office Message fields The Bridge Tool program searches for these fields in the ballot headers and if found inserts the data from BPS 8 Click X to close the Visio window 9 When prompted click Yes to save changes 10 Close WinEDS 5 10 2005 Confidential and Proprietary Page 9 of 22 gt BPS WinEDS Bridge Tool User s Guide SEQUOIA This page is intentionally left blank Page 10 of 22 Confidential and Proprietary 5 10 2005 CD SEQUOIA BPS WinEDS Bridge Tool User s Guide 2 Importing Data from BPS to WinEDS Follow the steps below to import data from BPS to WinEDS 1 Start Microsoft Access 2 Open the BPSWinEDSBridgetool mdb The Logon screen appears Logon 3 Enter your BPS logon Name and Password and click OK Note If you receive a
11. cartridge creation images that are stored as Word documents are automatically converted to bitmaps For significantly faster cartridge creation it 19 recommended that you convert all Word objects to bitmaps Because this action cannot be undone you should convert Word objects only after all final proofing is complete Prerequisite to Importing Symbolic Languages WinEDS must be setup for the symbolic languages you are importing These languages should appear on the Language tab of the System Setup window prior to starting The Language Crossreference table must also be correct in the Bridge See Section 6d for more information Prior to importing symbolic languages ensure that you have already imported data from BPS into WinEDS Refer to Section 2 Importing Data from BPS to WinEDS The symbolic language import depends on data stored by the bridge during the normal import This data provides a cross reference between BPS and WinEDS databases Without this cross reference data cannot be matched or will be improperly matched Importing Symbolic Languages The following procedures are designed to import all symbolic elements at once However you may work on individual items as well For example in a typical import all candidates are processed at once If you notice that one candidate needs a minor adjustment you can edit the Word document make your changes and upload only that candidate image 1 Login to the BPS WinEDS Bridge Tool
12. database error as shown below disregard the error and click OK BpsWinkdsBridge A QDBC connection to SOL Servertlocal Failed 5 10 2005 Confidential and Proprietary Page 11 of 22 BPS WinEDS Bridge Tool User s Guide D S SEQUOIA The Database Connections screen appears BPS gt WinEDS Import mel es jr UN igori Database connections Ballot Printing System II Database links WinEDS SQL Server connection J BpsTbls ci MD Taz User ID BpsPrep CABPS CagaPrep mdb 00 El Password BpsRef EABPS BpoRetmeo SS Server Profile Database WinEDS_Profle Ea PLEASE BACKUP THE WinEDS ELECTION AND PROFILE DATABASES BEFORE STARTING M Relink databases Login Status Verify BPS and WinEDS database information then click Login 4 On the Database Connections tab do the following a Under Ballot Printing System Il Database links link to the BPS databases Click eee to browse folders b Under WinEDS SQL Server connection do the following i User ID Type your WinEDS user ID Note User ID must have full privileges to the WinEDS database ii Password Type the database password i Server Select the appropriate server Click lt s s to browse servers iv Profile Database Type or select the appropriate Profile database Click ss s to browse databases Note The Bridge Tool opens the last election used in WinEDS To open another election open the election in WinEDS
13. e rather than forming a habit of changing WinEDS after a transfer In the long run establishing a good data transfer from BPS to WinEDS will make future elections easier to setup You can run a faster transfer for testing purposes by checking the Skip PSD Assignments checkbox under the Headers tab Depending on the size of your county this will significantly reduce processing time allowing you to quickly view a test dataset You can change WinEDS data directly only after you have run the Bridge Tool for the last time Prerequisites to Running Wizard Prior to running the Bridge Tool wizard ensure you complete the following prerequisites e Ensure that your Microsoft Access workgroup information file is the same file used by BPS This should already be established if you are using BPS on the same computer as the bridge tool Incorrect workgroup files will result in security errors in the bridge tool Note For more information see the Microsoft Access Help regarding workgroup information files e Set up ballot header fields in WinEDS refer to Section 1 4 1 e Create an Election database e Ensure that at least one Edge machine exists in the WinEDS Profile screen under the Voting Machine tab e Backup the WinEDS Profile and Election database Page 8 of 22 Confidential and Proprietary 5 10 2005 E SEQUOIA BPS WinEDS Bridge Tool User s Guide 1 4 1 Setting Up Ballot Header Fields in WinEDS Optional The Banner Header Su
14. em like Integrity or DFM BPS database Paper ballots y Log File BPS WinEDS containing activity Bridge Tool and error messages o ae Calls Microsoft Word WinEDS Profile and Election Databases 5 10 2005 Confidential and Proprietary Page 7 of 22 C BPS WinEDS Bridge Tool User s Guide O 1 2 1 3 1 4 SEQUOIA 1 1 2 Database Setup The bridge program will setup most of the WinEDS databases at once Due to the interrelationships between data elements you cannot import subsets of the election database The exceptions are symbolic language and voter registration data Access Required The BPS Bridge tool application is contained in BPSWinEDSBridgetool mde The bridge links to three BPS files which are also Microsoft Access database files It also links to WinEDS Profile and Election databases which are Microsoft SQL Server databases You will need both physical and security access to these files and databases Run Frequency The Bridge Tool can be run unlimited times Each time the Bridge Tool is run it erases existing data in WinEDS before importing fresh data from BPS Therefore if you plan to run the Bridge Tool again do not make changes directly to WinEDS data it will be overwritten by imported BPS data To maintain data consistency between BPS and WinEDS you should always change BPS and re run the bridg
15. idential and Proprietary 5 10 2005 gt SEQUOIA 5 10 2005 BPS WinEDS Bridge Tool User s Guide STEP 3 Edit merge document Edit merge document to create your ballot object a Enter anew document name or click to browse for an existing document b Click Go Microsoft Word opens The document is opened and prepared as a merge document Depending on your version of Microsoft Word the merge field area on your screen will appear similar to one of the following S Document Microsoft Word File Edit Yiew Insert Format Tools Tab Dee 46ayY amp Normal Times New Roman 12 Insert Merge Field lt Insert Word Field CONTEST_ID NAME Banner Word 2000 Version Lay Documenti Microsoft Word File Edit View Insert Format Tools Table Window He Osea 6RAY 4BAS O a W TSS Final showing Markup lt Show gt p YP XP a Bj Insert Word Field lt a ie Insert Merge Field 215 Insert C Address Fields TY Database Fields Match Fields Cancel Word 2002 Version Confidential and Proprietary Page 19 of 22 BPS WinEDS Bridge Tool User s Guide L4 Form Letters1 Microsoft Word Page 1 Page 20 of 22 CD SEQUOIA Insert fields as they should appear on your ballot Note It is not necessary to insert a CheckMark the circular voting target in your objects It will appear automatically in the same position as in the English object To match
16. is will significantly reduce processing time allowing you to quickly view a test dataset Process BPS 2 Language field This option tells the bridge to process Spanish proposal data from the BPS second language fields If you have only English and Spanish languages you should check this option For multiple and non Spanish languages leave this box unchecked Proposal data will be processed using the BPS language tables instead of the second language fields Open Primary When checked the Bridge will perform several processing steps necessary for an open or selective primary Unchecked indicates a closed primary Use EMS codes Check this option to have the Bridge put EMS codes into the contest and precinct records For contests the EMS code will be placed in the Alternate Code field For precincts the Abbreviation field will contain the EMS code c Click Import Data The Processing Status screen appears 5 10 2005 Confidential and Proprietary Page 15 of 22 gt BPS WinEDS Bridge Tool User s Guide SEQUOIA Processing Status Steps C Process parties C Process precincts L Process PSDs C Process PSD assignments L Process offices L Process contests L Process candidates L Process proposals C Process ballot styles L Process rotation L Reorder list orders O Generate layouts L Process languages C Process selection codes As the import occurs the processing steps are check marked as completed
17. ory Description Software Document Release Version 072904 Final document n a 1 00 010705 Applied D Anderson s edits to Appendix A n a 1 02 051005 Tech writer Applied D Anderson s changes and inserted new n a 1 03 graphics 111804 Tech writer Added Appendix A to include instructions for n a 1 01 importing symbolic languages Page 2 of 22 Confidential and Proprietary 5 10 2005 C SEQUOIA BPS WinEDS Bridge Tool User s Guide Contents PTO OUT TNS GUTE crre E T 5 alse 5 Lee TT 5 SCOPO ee eee ee ee ee ee 5 Bice lle HR seii S rer ee eee E eee ee ee eee een erence eee ee ae 5 1 UENO GUNG TOU osc nT screener T A E AT EE EEA E E 7 1 1 System OVCIVIGW T 7 1 1 1 RT 6 Renee ee RR Ce ORE Oreo Ree EEA ER PE ee ee ene a ere eer eee ee 7 ay les Bc Te re lt 0 6 eee renee tree Meee eee er een amee een ine ire eee een emer er ee seiner eer re 8 1 2 Access Reguired cctrccnncunicuuneqticquncunieoneqnieauimaniaqunkqnrmciimetiannnennienneenimnLaniaemneenianul 8 1 3 PUNEO QUC cerise E T 8 1 4 Prerequisites to Running Wizard sese eee eee eee 8 1 4 1 Setting Up Ballot Header Fields in WINEDS Optional ccccccccsseecccccceesssseeeeeccesessseeeseeeeeeees 9 2 Importing Data from BPS to VWImnEDS sss esse ees esse esse sese es sese e nenen neee ene 11 Appendix A Importing Symbolic Languages sssssssssssssssssss cesses esse esse sss esse eee esen enes 17 Prerequisite to Importing Symbolic Languages sese eee ee eee ee eee eee eee 17 SOUN
18. prior to using the Bridge Tool Page 12 of 22 Confidential and Proprietary 5 10 2005 gt SEQUOIA BPS WinEDS Bridge Tool User s Guide 5 Click Login The Options screen appears iojxi EJEA a MMI S UC rE Options Ballot Printing System IT information lt _ WinEDS information User ID Profile database Jurisdiction Election Election database Election Cycle GENERAL ELECTION CYCLE Change Election FRIMARY options jj Special processing IZ Keep print only contests fy Keep precinct location assignments verify language crossreference IZ Add election wide PSD Import voter registration data W Make Selection Code same as precinct number Prop response set es No Y Import symbolic languages lt Back Status Verify database information and select options Then click Nest 6 On the Options tab do the following a Under Ballot Printing System II Information verify that the jurisdiction and election cycle is correct 1 To change click Change The Selection Control screen appears ii Select the desired jurisdiction and election information i Click X to close the window b Under WinEDS information verify the correct election is selected c Under Options verify that the correct options are checked and that Proposal Response set is correct Note Otherwise the bridge will attempt to reassign new precinct information from BPS with their
19. re election 30 Word documents will be created one for each candidate header Each document will be formatted the same as the test merge except that each file will contain only one object The file name consists of the object type language and record ID Warning All existing files of this type will be deleted before processing begins If you noted individual items that needed changes from Step 3 you can edit the individual Word documents before uploading them to WinEDS You must know the record ID of the objects to change Start Microsoft Word and open the documents you wish to edit STEP 5 Upload to WinEDS Upload images to WinEDS You have the option of uploading a single file or all files in the folder specified in step 4 Note The destination in WinEDS is based on the options selected in steps 1 and 2 not on the file name Upload a single file a Select the file b Click Go Upload all files a Specify the folder in step 4 b Leave STEP 5 blank c Click Upload all images All uploads overwrite existing data in WinEDS After images are uploaded the message Done is displayed Backup your databases When you are finished click Exit Converting all your images from Word documents to bitmaps in WinEDS will significantly improve the time it takes to create an Edge cartridge This task is usually done after final Confidential and Proprietary Page 21 of 22 C BPS WinEDS Bridge Tool User s Guide SEQUOIA b

BPS / WinEDS Bridge Tool User`s Manual

Contents

Download Pdf Manuals

Related Search

Related Contents