You are here: Chapter 7: Configuration and Administration > Address Book Administration > Populating the Address Book > Create the Data File

Create the Address Book Data File

You can import data into a FootPrints Address Book from a flat text file in CSV (Comma Separated Value) format. This file must be formatted according to certain rules, and it must follow the Address Book's schema. You can import up to nine fields from your CSV file to the FootPrints Address Book. You can also map your fields to the FootPrints Address Book Fields.

Example

The CSV file example below contains a header line (LAST NAME, etc.) and fields separated by commas:

LAST NAME, FIRST NAME, EMAIL, USER ID, PHONE, SITE

Smith,Bob,[email protected],12345,212-555-1234,Woodbridge

Jones, Mary, [email protected],45678,813-227-4500,Tampa

Verify Your CSV File Format

  1. Review the FootPrints Address Book schema.

    Below is a screenshot of the default schema, which you can view from Administration | Address Book | Schema.

  2. Verify that your CSV file has the following formatting:

Next Step: Load External Data into the Address Book

Related Topic: Optional Features for Address Book Imports