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

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