Patron Import Sample

Notes about the Import File

• The first row in this import file contains a description of the fields, or columns of data. Examples are 'Company' and 'City'. The only benefit of using descriptive names for the column headers is to assist the column matching process. Because of the change where there can be many email accounts, phone numbers, addresses, etc. for a patron, we needed to create some special column titles that refer to columns that have special use for convenient importing or matching data.
• There are some spaces at the beginning of some fields. Work Phone in the second row has some spaces before the (714) area code. Theatre Manager will remove all extra spaces at the start and end of each field.
• Some columns have blank entries. In this case, a value for 'Address Line 2' is only present in the second row. The last two rows will be imported as blanks.
• Theatre Manager will attempt to fix data problems during import. On the last line, 'L.A. SYMPHONIC WINDS' will be converted to 'L.A. Symphonic Winds' and '818,348-2990' will be corrected to '(818) 348-2990'. The conversion will occur depending on the parameters set in System Preferences for auto-capitalization.