Casino City's Gaming Business Directory 2022 Edition CD User Guide

2022 Edition Casino City’s GAMING BUSINESS DIRECTORY CD Casinos, Racinos, Card Rooms, Bingo Halls, Horse Tracks, Dog Tracks, Offtrack Betting Facilities, Casino Cruises, Cruise Ships and Property Owners Steven Bloom, Editor A Casino City Press Publication GamingDirectory.com  CasinoCityPress.com

Copyright © 2022 by Casino City Press. All rights reserved. Cover photo provided courtesy of SAHARA Las Vegas, Las Vegas, Nevada. Published by Casino City Press. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under the terms of the License Agreement. Requests to the Publisher for permission to make copies of any part of this publication not authorized under the terms of the License Agreement should be addressed to: Permissions Department Casino City Press 33 Needham Street Newton, Massachusetts 02461 Voice: +1.617.332.2850 Fax: +1.617.964.2280 e-mail: permissions@casinocitypress.com Casino City ® is a registered service mark of Casino City Press. This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. It is sold with the understanding that the publisher is not engaged in rendering professional services. If expert assistance is required, the services of a competent professional person should be sought. Although every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions. Neither is any liability assumed for damages resulting from the use of the information contained herein. Casino City Press appreciates feedback concerning the contents of this publication. Comments can be sent via email to comments@casinocitypress.com. Please be sure to include both the name of the publication and your contact information. A companion online service is available at GamingDirectory.com and a companion print edition is also available. The online service provides continuously updated information and both the CD and online service offer data used in the preparation of print edition of the publication in digital format. For more complete information about our publications and online services please visit our website at CasinoCityPress.com. Casino City’s Gaming Business Directory CD ISSN 1553-6831 ISBN 978-1-60627-179-7 Casino City’s Gaming Business Directory ISSN 1553-6823 ISBN 978-1-60627-178-0 Printed in the United States of America First Printing: May 2022 10 9 8 7 6 5 4 3 2 1

Casino City’s Gaming Business Directory CD 3 Contents Contents ...........................................................................................................................................3 Figures..............................................................................................................................................4 Tables ...............................................................................................................................................4 Preface..............................................................................................................................................5 Introduction......................................................................................................................................6 CD User Interface ............................................................................................................................7 CD Data Table Names and Descriptions .........................................................................................8 CD Files and Folders .......................................................................................................................9 GamingDirectory.com ...................................................................................................................11 Microsoft Word Mail-Merge .........................................................................................................12 Using Microsoft Query with Microsoft Word Mail-Merge ...........................................................13 Importing Contacts into the ACT! Contact Manager ....................................................................14 Importing Contacts into the GoldMine Business Contact Manager ..............................................17 Importing Contacts into Microsoft Outlook ..................................................................................21 Importing Contacts into WinFax Pro .............................................................................................23 Gaming Property Cross-References...............................................................................................25 Appendix A: Data Table Column Summary and Row Order ........................................................29 Appendix B: Data Table Column Descriptions .............................................................................31 Appendix C: Telephone Numbers .................................................................................................37 Appendix D: Department Responsibility Categories.....................................................................37 Appendix E: Games .......................................................................................................................38 Appendix F: Short Title Abbreviations..........................................................................................40 Appendix G: Microsoft Word Mail-Merge Template File Specifications.....................................41 License Agreement ........................................................................................................................43

4 Casino City’s Gaming Business Directory CD Figures Figure 1: Gaming Business Directory CD User Interface Home Page............................................7 Figure 2: Default GoldMine Import File Profile for ASCII Files..................................................18 Figure 3 : User Interface Property Cross-Reference Page .............................................................25 Figure 4 : User Interface Size Cross-Reference Page (Gaming Machines) ...................................26 Figure 5 : User Interface Property Type Cross-Reference Page (Casino-Hotels) .........................27 Figure 6 : User Interface Property Profile Page (Encore Boston Harbor) .....................................28 Tables Table 1: CD Table Names and Descriptions....................................................................................8 Table 2: CD File and Folder Contents .............................................................................................9 Table 3: Mapping Gaming Business Directory Columns to ACT! Fields.....................................16 Table 4: Mapping Gaming Business Directory Columns to GoldMine Fields..............................19 Table 5: Mapping Gaming Business Directory Columns to Microsoft Outlook Fields ................22 Table 6: Mapping Gaming Business Directory Columns to Phonebook Fields ............................24

Casino City’s Gaming Business Directory CD 5 Preface The new 2023 editions of Casino City's Gaming Business Directory, Casino City's Gaming Business Directory CD and the GamingDirectory.com online service have all been completely revised. Since publication of the last edition, we have reviewed and updated every section of the directory. The result is print and CD editions of the 2022 directory that include thousands of changes in gaming industry property and owner contacts. As current information has become more critical and as the volume of information we gather has continued to grow, we have responded by expanding and differentiating the information in our GamingDirectory.com online service. We now provide detailed information online covering the history of property openings and closings in the wake of the coronavirus pandemic. And changes in the executive suite are at an all-time high, increasing the importance of access to updates and revisions to the static information published in the CD and print versions of the directory. Our GamingDirectory.com online service now includes nearly 30,000 executive contacts and provides direct links to well over 15,000 executive contact LinkedIn® profile pages. As with previous editions of Casino City's Gaming Business Directory, this print edition provides a concise version of the international gaming properties section, with full property and contact details available online. The creation of the new 2022 editions of Casino City's Gaming Business Directory, Casino City's Gaming Business Directory CD and the GamingDirectory.com online service, including all the underlying databases and processes, was a massive effort involving many disciplines by a team of very dedicated people. We're proud of the effort put forth by every employee of Casino City Press. Steve Bloom, Vice President of Engineering, has overall responsibility for the software engineering efforts required to create the new editions of the directory, CD and online service, including database design, data-entry applications and data extract procedures, in addition to managing the design and layout of the book and CD. Andrea Mullaney created the cover artwork for the directory and CD. Paul Mogilevsky was a major contributor and primarily responsible for book production. Bowman Healey had overall responsibility for the data collection and update efforts that are reflected in the new edition of the directory. Other content development team members include, Carol Heller, Michael Zadig and Nick Mariano. Simply stated, the new edition of the directory and CD would not exist without the dedication of all of the contributing staff. Finally, we'd like to thank you, our customer. It is your words of encouragement and appreciation, your suggestions and your overwhelming acceptance of our products that make this effort both worthwhile and possible. Michael A. Corfman Sylvia F. Corfman Chief Executive Officer Chief Operating Officer Casino City Press Casino City Press

6 Casino City’s Gaming Business Directory CD Introduction Casino City’s Gaming Business Directory CD provides in-depth information about the gaming industry worldwide. Gaming properties, property owners and executive contacts are all included. Detailed information on more than 9,000 gaming properties is provided, including comprehensive coverage of casinos, card rooms, racinos, horse tracks, casino cruises and cruise ships in more than 150 countries worldwide, plus dog tracks, jai-alai frontons, bingo halls and off-track betting facilities in North America. Almost 1,000 gaming property owners are identified together with the more than 5,000 properties they collectively own and operate. More than 28,000 gaming property and property owner executive contacts are included. Contacts are classified into 40 departments, including senior management, casino operations, finance, legal counsel, compliance, internal audit, risk management, public relations, marketing, player development, slots, table games, poker, keno, bingo, sportsbook, racebook, racing operations, mutuels, simulcasting, cage, hotel, retail operations, food, beverage, human resources, security, surveillance, facilities, property design, purchasing, MIS, conventions, special events, entertainment and wardrobe. All this information is provided in both Excel spreadsheets and comma-separated values format files. The information can be used for a variety of purposes, including targeted direct-mail campaigns; fax broadcasts and importing into software such as GoldMine, ACT!, Microsoft Outlook and WinFax Pro. Sample Microsoft Word mail-merge template files for both letters and mailing labels are included. Casino City’s Gaming Business Directory CD also includes the current and 34 previous editions of the print version of Casino City’s Gaming Business Directory as PDF (Portable Document Format) files. You can view or search these documents on your PC using the Adobe Acrobat Reader.

Casino City’s Gaming Business Directory CD 7 CD User Interface All the information available on Casino City’s Gaming Business Directory CD is accessible through an easy-to-use interface. The interface operates using a standard Web browser and provides direct single-click access to all features from the CD home page. The layout of the CD user interface home page is shown in Figure 1. Figure 1: Gaming Business Directory CD User Interface Home Page The CD home page features four major functions: 1. Access all data files provided on the CD and associated documentation. 2. View and search any print edition of Casino City’s Gaming Business Directory on your PC. 3. Use GamingDirectory.com to perform customized searches and download updated data files. 4. Create mailing labels and letters using templates and Word mail-merge. Each area links to pages of more detailed information, and additional links are provided to information on importing data, the complete user guide, related products, terms of use and contact information. On a Windows personal computer, the interface is launched automatically when Casino City’s Gaming Business Directory CD is inserted into the CD drive. If you want to use the interface on an Apple or other non-Windows computer, you must open the index.html file located in the CDInterface folder on the CD.

8 Casino City’s Gaming Business Directory CD CD Data Table Names and Descriptions The names of the five data tables provided on Casino City’s Gaming Business Directory CD and an overview of the contents of each data table are provided below in Table 1. Appendix A provides a complete listing of the columns included in each data table. Appendix B provides detailed descriptions of the information provided in each column. Each of these tables is provided in both Excel and comma-separated values formats. Information about the specific formats provided and where they are located on Casino City’s Gaming Business Directory CD is included in the CD Files and Folders section of this manual. Table 1: CD Table Names and Descriptions GamingProperties contains one row for each gaming property included in Casino City’s Gaming Business Directory. Properties covered include casinos, card rooms, racinos, horse tracks, dog tracks, jai-alai frontons, casino cruises and cruise ships. Available information for each property can include: property name; mailing and physical addresses; hours; main, fax and toll-free telephone numbers; games offered; restaurant, entertainment venue and attraction names; number of gaming machines, table games, poker tables and bingo seats; whether there is a sportsbook and racebook or simulcasting; casino and convention square footage; number of hotel rooms or cabins, restaurants, entertainment venues, parking spaces and employees; website and e-mail addresses; whether or not the property is affiliated with a Native American tribe or First Nation; the type of property; and a principal property contact name and title. The principal property contact provided is typically the general manager. GamingPropertyContacts contains one row for each gaming property contact. The contacts are classified by department responsibility. Contact name and title are provided, as well as complete information about the property with which the contact is affiliated. A responsibility order is provided based on the contact’s title. PropertyOwners contains one row for each gaming property owner included in Casino City’s Gaming Business Directory. Available information for each owner can include: owner name; mailing and physical addresses; main, fax and toll-free telephone numbers; number of gaming properties owned; stock symbol for publicly traded owners; website and e-mail addresses; whether or not the owner is a Native American tribe or First Nation; and a property owner contact name. PropertyOwnerContacts contains one row for each gaming property owner contact. The contacts are classified by department responsibility. Contact name and title are provided as well as complete information about the property owner with which the contact is affiliated. A responsibility order is provided based on the contact’s title. PropertyOwnerProperties contains one row for each gaming property owned by a property owner included in Casino City’s Gaming Business Directory. Property owner name is provided as well as complete information about the gaming property with which the owner is affiliated.

Casino City’s Gaming Business Directory CD 9 CD Files and Folders The information contained on Casino City’s Gaming Business Directory CD is organized into a number of folders. Most of the folders contain a complete set of the data included on the CD in a specific data format. There are also several portable document format (PDF) files contained in the root folder. Table 2 documents the contents of the folders and the files in the root folder. Table 2: CD File and Folder Contents File or /Folder Name Description UserGuide.pdf The user documentation for the 2021 edition of Casino City’s Gaming Business Directory CD as a portable document format file formatted for duplex printing on 8½-by-11-inch paper. GBD2022.pdf The 2022 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBD2021.pdf The 2021 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBD2020.pdf The 2020 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2019.pdf The winter 2019 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2018.pdf The summer 2018 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2018.pdf The winter 2018 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2017.pdf The summer 2017 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2017.pdf The winter 2017 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2016.pdf The summer 2016 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2016.pdf The winter 2016 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2015.pdf The summer 2015 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2015.pdf The winter 2015 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2014.pdf The summer 2014 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2014.pdf The winter 2014 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2013.pdf The summer 2013 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2013.pdf The winter 2013 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2012.pdf The summer 2012 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2012.pdf The winter 2012 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2011.pdf The summer 2011 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2011.pdf The winter 2011 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2010.pdf The summer 2010 print edition of Casino City’s Gaming Business Directory as a portable document format file.

10 Casino City’s Gaming Business Directory CD File or /Folder Name Description GBDWinter2010.pdf The winter 2010 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2009.pdf The summer 2009 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2009.pdf The winter 2009 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2008.pdf The summer 2008 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2008.pdf The winter 2008 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2007.pdf The summer 2007 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2007.pdf The winter 2007 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSummer2006.pdf The summer 2006 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDFall2005.pdf The fall 2005 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDWinter2005.pdf The winter 2005 print edition of Casino City’s Gaming Business Directory as a portable document format file. GBDSpring2004.pdf The spring 2004 print edition of the Gaming Business Directory as a portable document format file. GBDSummer2003.pdf The summer 2003 print edition of the Gaming Business Directory as a portable document format file. GBDFall2002.pdf The fall 2002 print edition of the Gaming Business Directory as a portable document format file. GBDFall2001.pdf The fall 2001 print edition of the Gaming Business Directory as a portable document format file. Autorun.inf Configuration file that automatically launches the user interface for Casino City’s Gaming Business Directory CD when it is inserted into the CD drive of a personal computer using Windows. /CommaSeparatedValues Comma-separated values (also known as CSV and ASCII format) versions of the data tables. The names of the five files in the folder are of the form DataTableName.txt. /Excel Excel spreadsheet versions of the data tables in Excel Strict Open XML Spreadsheet format. The names of the five files in the folder are of the form DataTableName.xlsx. /Templates Four sample Word mail-merge templates in Word 2000 (version 9.0) format. Three of the templates are for mailing labels of various sizes and the fourth template is a sample letter. Further information on the contents of the template files can be found in Appendix G. /CDInterface The files comprising Casino City’s Gaming Business Directory CD user interface.

Casino City’s Gaming Business Directory CD 11 GamingDirectory.com The gaming industry is very dynamic. Our dedicated research team tracks gaming industry changes and makes daily updates to our databases to reflect those changes. If current information is of value to your business, then access to updates before publication of the next print and CD edition of Casino City’s Gaming Business Directory will be important to you. GamingDirectory.com provides online access to our complete database of gaming properties, gaming property contacts, property owners and property owner contacts. Two levels of access are available: • GamingDirectory.com corporate subscriptions provide full access to our most current information to the number of individuals licensed within the organization during the subscription term. • GamingDirectory.com professional subscriptions provide the same information and services as corporate subscriptions, but usage is restricted to a single designated individual. With GamingDirectory.com, you can easily produce customized reports based on a large variety of criteria. Gaming properties can be selected by geographic location or by the number of slot machines, table games, poker tables, bingo seats, hotel rooms, restaurants, entertainment venues, employees and more. Executives can be selected by department and by level of responsibility as indicated by their title. You can review the reports online, print them or download the information directly to your personal computer. GamingDirectory.com subscribers also have the option of showing changes in executive contacts over time and requesting e-mail alert notification when changes occur. Alerts can be tailored on an individual basis to specific types of executives at specific types of gaming properties, and each user can control the frequency of alert notification. You can download the comma-separated values versions or Microsoft Excel versions of the GamingProperties, GamingPropertyContacts, PropertyOwners and PropertyOwnerContacts tables using GamingDirectory.com. If you have a GamingDirectory.com subscription, the information you download will include all available updates. If your Gaming Business Directory CD was acquired as part of our corporate or professional subscription service, then you are authorized for the corresponding subscription-based access to GamingDirectory.com. If you purchased the CD by itself or as part of a book and CD only package, GamingDirectory.com access is not included. Information on upgrading your level of GamingDirectory.com access is available by contacting our sales department. Your user name for the GamingDirectory.com service is your e-mail address. If you do not yet have a password, you can register at the GamingDirectory.com website and select a password of your choice. Once you are authenticated as an authorized user, you will be granted appropriate access using the password you have selected.

12 Casino City’s Gaming Business Directory CD Microsoft Word Mail-Merge One common use of Casino City’s Gaming Business Directory CD is the production of mailing labels or letters for executive contacts. Word mail-merge is designed to perform both of these tasks, and you will find sample Word mail-merge template files on the CD that should help simplify the process. Information about the sample mail-merge template files can be found in Appendix G. This section documents how to perform a mail-merge with Microsoft Word 2000. If you want to create mailing labels, template files are provided for Avery 5160 style labels (30 1by-25/ 8-inch labels per sheet), Avery 5161 style labels (20 1-by-4-inch labels per sheet), and Avery 5162 style labels (14 11/ 3-by-4-inch labels per sheet). Open the template file Avery5160Labels.doc, Avery5161Labels.doc or Avery5162Labels.doc contained in the Templates folder. Then select Mail Merge on the Tools menu to open the Mail Merge Helper dialog box. Since you have already opened a mailing label template file, you can go directly to step two and click on Get Data and then on Open Data Source. Select the data table file you wish to use to create mailing labels and click OK. In step three, you merge and format the labels. As part of this step you may select the Query option to choose which contacts to use. The Query option allows you to sort or select records according to criteria you specify. For example, you can select properties with a certain minimum number of table games or hotel rooms. If you want to specify more complex criteria, such as selecting contacts with particular departmental responsibilities, you must use a more sophisticated query tool like Microsoft Query, whose usage is explained in the next section. To create a letter, follow a process similar to the one outlined above for mailing labels, but use the file SampleLetterTemplate.doc. After selecting the appropriate data source for your letter, edit the contents of the sample letter so it has the contents you desire before performing the merge. You can easily delete the body of the letter and type or copy and paste new material from other documents. You can use any of the columns in the selected data table to customize your letter. For example, you can insert the first name of the recipient into a sentence in the body of the letter to make it more personal, or you can include specific information about the property, such as the number of gaming machines, in your letter. Word uses the term “field” to refer to data table columns. Use the Insert Merge Field button on the Mail Merge tool bar to insert columns from the data table. Your letter can also include different words or sentences based on the value of columns in the data table. Just press the Insert Word Field button on the Mail Merge tool bar and select the If…Then…Else… option. Sometimes you may want to create letters or mailing labels for a group of executives that you cannot easily specify using the information on the CD and the Query facility provided by Word. In this situation consider using GamingDirectory.com to create a custom data extract to use with Word mail-merge that contains just the executives you require. The GamingDirectory.com data selection facilities are designed to handle certain types of executive selection criteria not easily specified using Word Query options and the information available on the CD.

Casino City’s Gaming Business Directory CD 13 Using Microsoft Query with Microsoft Word Mail-Merge Using Microsoft Query with Word mail-merge enables you to easily construct sophisticated queries to select an appropriate set of Gaming Business Directory data. Select Mail Merge on the Tools menu to open the Mail Merge Helper dialog box, click on Get Data under Step Two after setting up the main mail-merge document, and then click on Open Data Source. The Open Data Source screen will appear. Click on the MS Query button to select data using the Microsoft Query tool. Microsoft Query is an optionally installed component of Microsoft Office, so you will only be able to use it if it has been installed. The first screen presented by Microsoft Query is the Choose Data Source screen. If the Gaming Business Directory data you are using is in comma-separated values format, you must select “<New Data Source>” and click OK. Data downloaded from GamingDirectory.com is always in comma-separated values format. The Create New Data Source screen will appear if you select <New Data Source>. You must provide a name for the data source, select “Microsoft Text Driver (*.txt, *.csv)” and click Connect. The ODBC Text Setup screen will then be presented. Uncheck “Use Current Directory” and press the Select Directory button to open the Select Directory screen. Select the drive where the directory containing the data is located, select the folder containing the data, and click OK to close the Select Directory screen. Click OK to close the ODBC Text Setup screen and then click OK to close the Create New Data Source screen. On the Choose Data Source screen, select the newly created data source name if you have created a new data source for comma-separated values data. Select MS Access Database to use Access database files on the CD or select Excel Files to use Excel spreadsheets on the CD. Click OK once you have chosen a data source. If you indicate a database or spreadsheet data source, a Select Database or Select Spreadsheet screen will appear. Select the drive where the database or spreadsheet is located, select the folder containing the database or spreadsheet, select the specific database file or spreadsheet if required, and click OK. The Query Wizard Choose Columns screen will now be displayed. Select the Gaming Business Directory table you wish to use, click the “>” button to select all columns in the table, and click Next. The Query Wizard Filter Data screen is displayed. Select a column to be used to filter the data. For example, select the Responsibilities column within the GamingPropertyContacts table if you wish to select contacts based on departmental responsibility. Next, select an operator such as “Contains” and enter a value such as “Security.” To specify additional criteria for the same column, simply select “and” or “or” depending on whether either or both criteria must be satisfied, and specify the criteria, such as “Contains,” “Security or Surveillance.” Thus you can easily request contacts that have either Security or Surveillance responsibilities. To filter based on another column, select it and specify the desired criteria. Once all criteria are specified, click Next. The Query Wizard Sort Order screen will appear. Specify any desired sort order and click Next. The Query Wizard Finish screen will be displayed. We recommend checking “View data or edit query in Microsoft Query” before pressing the Finish button if you have specified a query involving multiple columns.

14 Casino City’s Gaming Business Directory CD Importing Contacts into the ACT! Contact Manager You can import data provided on Casino City’s Gaming Business Directory CD and data downloaded from the GamingDirectory.com website into the ACT! contact management system. This section outlines the data import process for the ACT!2000 version of this software. First, you should select the data you wish to import into ACT! If you only wish to import a portion of the contacts contained in one of the Gaming Business Directory files, you must first use a tool other than ACT! to create a file that includes just the contacts you want to import. If you want to import a portion of the GamingProperties, GamingPropertyContacts, PropertyOwners or PropertyOwnerContacts tables, then we recommend using the GamingDirectory.com website to select and download the appropriate information. Using GamingDirectory.com you can easily select contacts based on a variety of criteria including geographic location, department and type of gaming facility. Once you have Gaming Business Directory data ready to import you should open the ACT! database into which the contacts are to be imported. If you want to create a new database for the contacts, use the ACT! menu system to select File > New > ACT Database and provide a name for the new database. If you want to import contacts into an existing database, we recommend you create a backup copy of the database before proceeding so you can restore the original database if necessary. Open the ACT! database, select File > Backup, provide the name of the location where the backup .zip file should be saved, make sure all of the Options tab items are checked, and click Start. You can restore the ACT! database to the backup version by selecting File > Restore, providing the location and name of the backup .zip file, and clicking Start. When ACT! is importing contact records into a new empty database and it encounters a match with the first and last name of a previously imported contact, it normally prompts you to determine if the new contact should be merged with the existing contact record, added as a separate contact record, or skipped and not added. When importing Gaming Business Directory contacts into a new database we recommend that you disable these duplicate checking prompts so that all contacts are added automatically without any intervention. Use the ACT! menu system to select Edit > Define Fields > Advanced Tab and uncheck the “Enable duplicate checking” option for a newly created database. If you have previously imported contacts from the GamingProperties, GamingPropertyContacts, PropertyOwners or PropertyOwnerContacts tables into ACT!, we recommend using the PropertyId, OrganizationId and ContactId values for duplicate checking when importing subsequent updates downloaded from GamingDirectory.com. Use the ACT! menu system to select Edit > Define Fields > Advanced Tab. In the drop-down lists under the heading “Match duplicates using,” select the ACT! field used to hold PropertyId or OrganizationId in the “Match on” drop-down list. Next select the ACT! field used to hold ContactId in the first “Then on” drop-down list and select <None> in the second “Then on” drop-down list. You use the ACT! import wizard to add Gaming Business Directory contacts to an ACT! database. Use the ACT! menu system to select File > Data Exchange > Import. You will then be prompted for the type and name of the file to be imported. If you are importing contact data downloaded from the GamingDirectory.com website, you should select a file type of “Text - delimited” since the file being imported is in comma-separated values format. If you are importing contacts from the CD, you should either select a file type of “dBase III-V” and use the dBase III format files

Casino City’s Gaming Business Directory CD 15 provided in the dBase folder on the CD or select a file type of “ACT! 3.x, 4.x, or 2000” and use the ACT!2000 files provided in the ACT folder on the CD. There are a variety of factors that will dictate whether it is better to use the dBase III or ACT!2000 version of the data when importing data from the CD. You can only use the ACT!2000 version of the data if it contains all of the information you wish to import. ACT! has limitations on the number of fields so the ACT! version of the data does not contain as much information as the dBase III version of the data. Appendix D documents the limitations on information available in the ACT!2000 version of the data. Additionally, you cannot import data from an ACT! database when it is only available read-only, as is the case for files on the CD. This means you must first copy ACT! files from the CD to your computer’s hard drive and change their file attributes so they are no longer read-only before you can import data from them. There are two advantages to importing data from an ACT! database. First, the mapping of fields is simpler. Second, the issues that can arise when importing phone numbers with country codes into ACT! described later in this section are avoided. Once you have specified the file type and file name to import click Next. You should be careful not to click Finish at this point. On the next Import Wizard screen, check Contact Records. If you have selected a file type of “Text - delimited” you should also click Options and uncheck the “Yes, import the first record” option. This prevents the comma-separated values header record from being imported as a contact record. Clicking Next takes you to the subsequent Import Wizard screen. Check the “Don’t use predefined map” option on this screen and click Next. You should now be presented with the Import Wizard Contact Map screen, which you must use to specify how to map Gaming Business Directory column names (shown in the left column) to ACT! fields (shown in the right column). Table 3 shows the names of the Gaming Business Directory columns used in Text-delimited and dBase input formats and the corresponding ACT! field names. When the names do not match exactly, you must explicitly define the mapping. For example, you should locate PostalCode in the first column, click the right column for that row, and select Zip from the dropdown list showing all ACT! fields. This will map the PostalCode input column or field to the Zip ACT! field. When importing from an ACT! database the fields shown in Table 1 will already match directly to the ACT! field names. The mappings shown in Table 3 are suggested mappings. In some cases you may want to alter the mappings if the suggested use does not match your normal use of the fields. For example, the Phone and E-mail provided for Gaming Business Directory contacts are for the company, and not for the individual contact. If you normally keep personal phone or e-mail addresses in the ACT! Phone and E-mail Address fields, then saving company information in these fields may be inappropriate. Doing so would make it hard to merge new Gaming Business Directory contact data into existing contact records since the normal merge process would then replace older personalized data with newer company data for an individual contact. You must decide if you would rather import the TitleLong column or the more compact Title column into ACT! as the Title field. We generally recommend using the shorter Title column. Please note that the columns shown in the table are not present in all Gaming Business Directory files. For example, the PhoneExtension column is only present in the Suppliers and SupplierContacts tables. You can also import additional columns listed in Appendix A or C that are not shown in Table 3, into ACT! Generally, additional columns should be mapped to ACT!’s user defined fields. You

16 Casino City’s Gaming Business Directory CD should import any columns that will be useful to you in your interaction with the contacts you are importing. We recommend that you import the PropertyId or OrganizationId and ContactId columns into ACT! We will change the name of a property contained in the Company field to match a newer preferred property name. Similarly, the name of an individual can change due to a change in marital status or a spelling correction. If the PropertyId or OrganizationId and ContactId fields are included in your ACT! Database, then subsequent updates can be merged based on the more stable PropertyId or OrganizationId and ContactId values. Please note that importing telephone numbers may work differently than you would expect. ACT! will frequently add a country code to the beginning of an imported telephone number based on the contact’s country, even if a country code is already present in the telephone number. When this occurs, the country code will be duplicated at the beginning of the imported telephone number. Once you have completed the field mappings, click Finish. The data will then be imported into the existing or newly initialized ACT! database. The time required to complete the import will vary based on the number of contacts being imported. Normally only a few minutes are required, but importing a large file such as GamingPropertyContacts, which contains more than 20,000 contacts, may take over an hour. After the import is complete, be sure to restore any settings you altered for duplicate checking to the values in effect before the import was performed. Table 3: Mapping Gaming Business Directory Columns to ACT! Fields Text – delimited Column Name dBase Column Name ACT! Field Name Company Company Company Address1 Address1 Address 1 Address2 Address2 Address 2 Address3 Address3 Address 3 City City City State State State PostalCode PostalCode Zip Country Country Country Phone Phone Phone PhoneExtension PhoneEx Phone Ext. Fax Fax Fax TollFree TollFree Alt Phone TollFreeExtension TollFreeEx Alt Phone Ext. StockSymbol StockSymbl Ticker Symbol WebSite WebSite WebSite Email Email E-mail Address Salutation Salutation Salutation FirstName FirstName First Name LastName LastName Last Name Title Title Title TitleLong TitleLong Title

Casino City’s Gaming Business Directory CD 17 Importing Contacts into the GoldMine Business Contact Manager You can import the data provided on Casino City’s Gaming Business Directory CD and data downloaded from the GamingDirectory.com website into the GoldMine Business Contact Manager. This section outlines the data import process for version 5.7 of this software. First, you should select the data you wish to import into GoldMine. If you only wish to import a portion of the contacts contained in one of the Gaming Business Directory files, you must first use a tool other than GoldMine to create a file that includes just the contacts you want to import. If you want to import a portion of the GamingProperties, GamingPropertyContacts, PropertyOwners or PropertyOwnerContacts tables, then we recommend using the GamingDirectory.com website to select and download the appropriate information. Using GamingDirectory.com you can easily select contacts based on a variety of criteria including geographic location, department and type of gaming facility. Once you have Gaming Business Directory data ready to import, you should open the GoldMine database into which the contacts are to be imported. If you want to create a new database for the contacts, use the GoldMine menu system to select File > New Database, provide a name for the new database, and click Next. On the “Create GoldMine Database” screen, verify that “Create a new contact database” is checked, check “Create empty tables,” specify the directory path where the new database will be stored and click Next. Fill in the “Database Access” screen as appropriate, click Next, and finally, on the “Creating Database Files” screen, click Finish. GoldMine will create and open the new database. If you want to import contacts into an existing database, we recommend you create a backup copy of the database before proceeding so you can restore the original database if necessary. Although GoldMine does not provide a built-in backup utility, a discussion of backup strategies is provided in the GoldMine Help Index under “backing up data.” You can create a backup by copying all files of type *.D* in the folder where the existing database is contained. You can restore the GoldMine database to the backup by restoring the saved files. You use the GoldMine import wizard to add Gaming Business Directory contacts to a GoldMine database. Use the GoldMine menu system to select Tools > Import/Export Wizard > Import Contact Records. Always select “Import a new file.” If you are importing contact data downloaded from the GamingDirectory.com website, you should select a file type of “ASCII File” since the file being imported is in comma-separated values format. If you are importing contacts from the CD, you should select a file type of “DBF File” and use the dBase III format files provided in the dBase directory of the CD. Once you have specified the file type and file name, click Next. Provide the name of the file to be imported and click Next. The Import File Profile screen will now be displayed. If you are importing an ASCII File, the screen will appear as shown in Figure 2 below. You should provide meaningful labels for the columns in the input file that you plan to import into GoldMine before clicking Next. To change a Label Name, right-click on the label name, enter the new label name, and click OK. Label names must be 10 or fewer characters in length. The values shown in “Preview Record: 1” match the column names shown in Appendix A. When these names are 10 or fewer characters in length, we recommend using these values. When they are more than 10 characters in length, we recommend substituting the shorter column names shown in Appendix C.

18 Casino City’s Gaming Business Directory CD Figure 2: Default GoldMine Import File Profile for ASCII Files After you click Next on the “Import File Profile” screen, the “Field Mappings” screen will be presented. You must use this screen to specify how to map Gaming Business Directory column labels (shown in the left column) to GoldMine fields (shown in the right column). Table 4 (on page 14) shows the names of the Gaming Business Directory column labels and the corresponding GoldMine field names. For each label name shown in Table 4 that appears in the left column, first click on the label name in the left column, then click on the corresponding GoldMine field name in the right column, and finally press the “Map to GM” button to complete the association. The GoldMine Contact field should consist of the full contact name, so you must double click on the Contact field, enter one of the expressions shown in Table 4 for Contact, and press the OK button. The mappings shown in Table 4 are suggested mappings. In some cases, you may want to alter the mappings if the suggested use does not match your normal use of the fields. For example, the Phone and Email provided for Gaming Business Directory contacts are for the company, not for the individual contact. If you normally keep personal phone or e-mail addresses in the GoldMine Phone1 and E-mail Address fields, then saving company information in these fields may be inappropriate. Doing so would make it hard to merge new Gaming Business Directory contact data into existing contact records, since the normal merge process would then replace older personalized data with newer company data for an individual contact. You must decide if you would rather import the TitleLong column or the more compact Title column into GoldMine as the Title field. We generally recommend using the shorter Title column. Please note that the columns shown in the table are not present in all Gaming Business Directory files. For example, the PhoneEx column is only present in the Suppliers and SupplierContacts tables. You can also import additional columns listed in Appendix A or C that are not shown in Table 4, below, into GoldMine. Generally, additional columns should be mapped to GoldMine’s user-

Casino City’s Gaming Business Directory CD 19 defined fields. You should import any columns that will be useful to you in your interaction with the contacts you are importing. We recommend that you import the PropertyId or OrganizationId and ContactId columns into GoldMine. We will change the name of a property contained in the Company field to match a newer preferred property name. Similarly, the name of an individual can change due to a change in marital status or a spelling correction. If the PropertyId or OrganizationId and ContactId fields are included in your GoldMine database, then subsequent updates can be merged based on the more stable PropertyId or OrganizationId and ContactId values. Table 4: Mapping Gaming Business Directory Columns to GoldMine Fields GoldMine Field Column Label or Expression Company Company Address1 Address1 Address2 Address2 Address3 Address3 City City State State Zip PostalCode Country Country Phone1 Phone Ext1 PhoneEx Fax Fax Phone2 TollFree Ext2 TollFreeEx Web Site WebSite E-mail Address Email Dear FirstName LastName LastName Title Title or TitleLong Contact trim(FirstName) + “ ” + trim(LastName) Contact trim(Salutation) + “ ” + trim(FirstName) + “ ” + trim(LastName) Once you have completed the field mappings, click Next. You will be presented with the “Save Profile” screen. Click Next on this screen, and you will be presented with the “Ready to Import” screen. Click Finished on this screen, and the GoldMine Process Monitor window will appear and show the status of the import process. If you imported an ASCII File, then the initial record containing the column names will have been imported into GoldMine as a contact record and should be deleted. Use the GoldMine menu system to select Lookup > Company. Enter the value “Company” as the company name you are looking for to locate the initial record. Once the initial record is selected as the current contact record, use the GoldMine menu system to select Edit > Delete Contact. Make sure all items are selected, and click Delete. When GoldMine imports contact records, it always creates a new contact record for each imported contact. This is done even if the contact has the same name, company name, address, and phone number as an existing contact record. After the import is complete, you can merge previously

RkJQdWJsaXNoZXIy NDIzMTA=