You can import data into a BMC FootPrints Service Core 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 BMC FootPrints Service Core Address Book. You can also map your fields to the BMC FootPrints Service Core Address Book Fields.
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,bsmith@widget.com,12345,212-555-1234,Woodbridge
Jones, Mary, mjones@widget.com,45678,813-227-4500,Tampa
Below is a screenshot of the default schema, which you can view from Administration | Address Book | Schema.
Required fields: Last Name, First Name, Email Address, and User ID. (The field "User ID" is the Primary Key and must be included as one of the fields to be imported.)
- Optional: A header line with header names in uppercase, such as the example above (for ease of identification when mapping the fields)
- Data (or a placeholder for optional fields) must be present for each field.
- The fields for each contact must be separated by a comma “,”
- The system new line separator (i.e., the result of pressing “Enter”, “Return”, “^M”, etc.) should appear at the end of each record (Contact)
- The fields can be in any order in the CSV file
- CSV files can wrap on multiple lines, with double-quotes, and with commas as the separator
- The Checkbox data type can be loaded. The value for checked is "on"; for unchecked use either a null field or "off".
Next Step: Load External Data into the Address Book
Related Topic: Optional Features for Address Book Imports