Mapping contact info: Phone numbers
You can either store phone numbers in two columns, one for the phone number type and one for the phone number, or in one column as a phone number type.
You can import as many phone numbers as you have a record of. If you have columns titled “home phone”, “work phone”, and “mobile” or “cell”, you would import these as a single column for each phone number. The column header should indicate what type of phone number is contained within it.
A phone number is required in order to create a corresponding phone number record in LGL. Only one phone number is allowed per cell in your spreadsheet.
Examples showing how to map phone number fields
Please refer to the examples below to see how to format your data in multiple cases. For each example, follow the mapping shown in the corresponding screenshots as you're mapping your own fields in the Flex Importer.
Example #1: A column for each phone number type
You wouldn’t necessarily need to normalize your phone numbers (place each type in its own column), but it’s worth noting that if you don’t do this you will need to pay careful attention to the mapping and add rules to each phone number column to tell LGL what type of phone number it is.
Example #2: Two columns for each phone number