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.