Import Fields with Special Meaning

You can use any of the special fields below when you do your import process. They will match up with fields in the database such as lookup data or phone numbers.

The import routines will automatically create new values into Code Tables for the special meaning fields during the import process. In most cases, there is no need to prepopulate code table values that will be used.

The exception is gPaymentMethod - all payment methods must be created prior to using them.

Patron Information
  • gPatronType - patron type - individual, company, staff, etc. Code Table "Patron Type".
Patron Contact Information
  • gPhoneHome - patron home phone number
  • gPhoneWork - patron work phone number
  • gPhoneCell - patron mobile phone number
  • gPhoneFax - patron fax phone number
  • gEmailHome - patron home email address
  • gEmailWork - patron work email address
  • gWebsite - patron work website URL

Some special fields that will "update" the field, rather then add new contact information to the patron account

  • gPrimaryPhone - Patron primary phone number
  • gPrimaryEmail - Patron primary email address
  • gPrimaryFax - Patron primary fax number
  • gPrimaryWeb - Patron primary web site URL
Patron Marketing Information
  • MKT_C_SEQ - REFER to special field for matching patron numbers on import
  • gC_AGE_CODEresult - Marketing age code
  • gC_MKT6result - Marketing field #6
  • gC_MKT7result - Marketing field #7
  • gC_MKT8result - Marketing field #8
Volunteer/Personnel Information
  • gC_ACTIVEresult - Marketing Volunteer Status
  • gMktVol1Result - Volunteer Popup field #1
  • gMktVol2Result - Volunteer Popup field #2
  • gMktVol3Result - Volunteer Popup field #3
  • gMktVol4Result - Volunteer Popup field #4
  • gMktVol5Result - Volunteer Popup field #5
  • gMktVol6Result - Volunteer Popup field #6
  • gMktVol7Result - Volunteer Popup field #7
  • gMktVol8Result - Volunteer Popup field #8
  • gMktVol9Result - Volunteer Popup field #9
  • gMktVol10Result - Volunteer Popup field #10
Patron Donor Information
  • gDonorGivingCapacity - Marketing Donor Giving Capacity
  • gDonorMovesStatus - Marketing Donor Moves Management Status
Patron Mail Lists
  • PM_SHORT_NAME and gName1 through gName15 - are up to 16 mail list columns. If you want to import any mail list, then you must have ONE column called PM_SHORT_NAME.
    • The contents of the field indicate which mail list to which the patron will be added.
    • You can comma separate the mail lists to add to a patron such as list1,list2,list3 and/or
    • You can have multiple columns in your import file named 'gName1' through 'gName15'. In those columns, you can have blanks or mail lists to which you want people added (eg list1 or list2, etc.)
    • In this way, you can use up to 16 columns to specify a lot of mail lists to add a patron to, either many in one column separated by commas, or in separate columns if that is more clear for you.
Ticket/Donation/Member Data - Orders
  • I_ORD_REASON_BUY_RESULT - Order reason "Why did Patron Buy?", Code Table "Order Reason to Buy".
  • gSource - Delivery Method - ticket handling status.
    • 0 = Hold for Pickup/Taken
    • 1 = Mail to Patron
    • 2 = Hold for WillCall
    • 3 = Hold @ Door for Coupon
Ticket Data - Tickets
  • gTixUsed - Patron Attended - flag to indicate if patron attended the performance.
    • attended = indicate that patron attended the performance
  • gAttendedReason - description for the Patron Attended or Not Attended Reason. Code Table "Course Attendance Reasons".
Donation Data - Donations
  • gDonor1Field - Donor Popup field #1
  • gDonor2Field - Donor Popup field #2
  • gDonor3Field - Donor Popup field #3
Donation Data - Campaigns
  • gAccount - Account number to assign to new donation campaigns
Member Data - Memberships/Passes
  • gMember1Field - Member Popup field #1
  • gMember2Field - Member Popup field #2
  • gMember3Field - Member Popup field #3
Member Data - Member/Pass Types
  • gAccount - Account number to assign to new member/pass type
Ticket/Donation/Member Data - Payments
  • gPaymentMethod - Payment Method. Matching "Payment Code" in code table "Payment Methods". All payment methods must be created prior to using them.
  • gOrigin - Payment Source - location of where the payment originated.
    • 0 = Internet/Web Sales
    • 1 = Telephone Order
    • 2 = Mail Order
    • 3 = Patron Present
Diataxis: