Excel import contact template.
Columns below:
private static final int COL_FIRST_NAME = 0;
private static final int COL_LAST_NAME = 1;
private static final int COL_COMPANY = 2;
private static final int COL_TITLE = 3;
private static final int COL_MOBILE = 4;
private static final int COL_HOME_PHONE = 5;
private static final int COL_WORK_PHONE = 6;
private static final int COL_FAX = 7;
private static final int COL_EMAIL = 8;
private static final int COL_WEB = 9;
private static final int COL_ADDRESS_1 = 10;
private static final int COL_ADDRESS_2 = 11;
private static final int COL_SUBURB = 12;
private static final int COL_STATE = 13;
private static final int COL_POSTCODE = 14;
private static final int COL_MOTHER = 15;
private static final int COL_FATHER = 16;
private static final int COL_PRIMARY_CONTACT = 17;
private static final int COL_DOB = 18;
private static final int COL_ITN = 19;
private static final int COL_COACH = 20;
private static final int COL_GENDER = 21;
private static final int COL_CUSTOM_1 = 22;
private static final int COL_CUSTOM_2 = 23;
private static final int COL_CUSTOM_3 = 24;
private static final int COL_CUSTOM_4 = 25;
private static final int COL_CUSTOM_5 = 26;
private static final int COL_CUSTOM_6 = 27;
private static final int COL_MEDICAL_CONDITION = 28; // Added v7.11.
private static final int COL_MEDICAL_TREATMENT = 29; // Added v7.11.
private static final int COL_NOTES = 30; // Added v7.11.
private static final int COL_GRADE = 31; // Added v8.8.3.
private static final int COL_CUSTOM_7 = 32; // Added v8.9.1.
private static final int COL_CUSTOM_8 = 33; // Added v8.9.1.
private static final int COL_CUSTOM_9 = 34; // Added v8.9.1.
private static final int COL_CUSTOM_10 = 35; // Added v8.9.1.
private static final int COL_CUSTOM_11 = 36; // Added v8.9.1.
private static final int COL_CUSTOM_12 = 37; // Added v8.9.1.
private static final int COL_CUSTOM_13 = 38; // Added v8.9.1.
private static final int COL_CUSTOM_14 = 39; // Added v8.9.1.
private static final int COL_CUSTOM_15 = 40; // Added v8.9.1.
private static final int COL_CUSTOM_16 = 41; // Added v8.9.1.
private static final int COL_CUSTOM_17 = 42; // Added v8.9.1.
private static final int COL_CUSTOM_18 = 43; // Added v8.9.1.
private static final int COL_CUSTOM_19 = 44; // Added v8.9.1.
private static final int COL_CUSTOM_20 = 45; // Added v8.9.1.
private static final int COL_FATHER_EMAIL = 46; // Added v8.9.6.
private static final int COL_MOTHER_EMAIL = 47; // Added v8.9.6.
private static final int COL_COUNTRY = 48; // Added v8.9.9.
private static final int COL_SCHOOL = 49; // Added v9.2.7-b31.
private static final int COL_EMAIL2 = 50; // Added v13.8.0-b25.
private static final int COL_EMAIL3 = 51; // Added v13.8.0-b25.
private static final int COL_MY_TENNIS_NUMBER = 52; // Added v13.5.0-b12.
private static final int COL_EMERGENCY_CONTACT_NAME = 53; // Added v13.5.0-b12.
private static final int COL_EMERGENCY_CONTACT_PHONE = 54; // Added v13.5.0-b12.
private static final int COL_EMERGENCY_CONTACT_RELATIONSHIP = 55; // Added v13.5.0-b12.
private static final int COL_UNIFORM_SIZE = 56; // Added v13.8.0-b07.
private static final int COL_EXTERNAL_ID = 57; // Added v9.2.7-b27.
private static final int COL_PARENT_ACCOUNT_LOOKUP_FIRST_NAME = 58; // Added v9.2.8-b24.
private static final int COL_PARENT_ACCOUNT_LOOKUP_LAST_NAME = 59; // Added v9.2.8-b24.
private static final int COL_WWCC_NUMBER = 60; // Added v13.9.5-b10
private static final int COL_WWCC_EXPIRY = 61; // Added v13.9.5-b10
private static final int COL_WWCC_VERIFIED_DATE = 62; // Added v13.9.5-b10
private static final int COL_WWCC_RESULT = 63; // Added v13.9.5-b10
private static final int COL_SKILL_LEVEL = 64; // Added v14.9.4-b57COL_PARENT_ACCOUNT_LOOKUP_FIRST_NAME and COL_PARENT_ACCOUNT_LOOKUP_LAST_NAME are used to look up existing contact and set as parents account if found.