Mapping contact info: Phone numbers

NOTE: If you are exporting phone number data and re-importing it in order to bulk update it, make sure you include the LGL Constituent ID  and the LGL Phone ID in your export. When re-importing, ensure that you set up a mapping for these fields so that the bulk change you are making will occur in the correct constituent and phone number record.

Important information

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.

Required fields

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. 

Special fields

None available.

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.

Import file

Field mapping

Record Preview

Example #2: Two columns for each phone number

Import file

Field mapping

Record Preview