Address Book contact data can be exported to a .csv file.
This allows you to export all or some contacts to an external spreadsheet,
database, etc.
To export Address
Book data:
Select Export
Data from the Address Book administration menu.
Click GO to export the entire Address Book or indicate logical
selection criteria for a portion of the Address Book.
Enter a file name
and browse for the directory to save the export file.
Click Save.
The file
is in comma-separated-variable (CSV)
format, suitable for editing or loading into another database. Export
criteria can be saved for future exports.
Notes about Date and Date/Time Fields
If you plan to export
FootPrints data to a .CSV file
for manipulation in Excel for eventual re-importing in FootPrints
(i.e., open the .CSV file in Excel for manipulation, re-save it to a .CSV
file, and then load it back into FootPrints)
you must perform certain steps if your data contains Date or Date/Time
fields:
After
you open the .CSV file in Excel, you it is displayed suitably for your
locale. For example, in the United States, the date 2003-02-14
in the import file is displayed as 2/14/03.
You
must change the format of that column by selecting Format
| Cells | Custom. Select one of the existing formats and then input
into the Type
box YYYY-MM-DD
for a date field and YYYY-MM-DD
HH:MM:SS for a Date/Time field.
Make
any additional changes desired and then save it as a .CSV file for re-importing
into FootPrints.
ISO Date Problems
If there is a date field in the Address book, export dates in the ISO format becomes a problem. There are two workarounds to this problem:
The first workaround is:
Select Administration | System | Date Format.
Change the format for the entire system to the ISO format. This requires System Administration privileges.
Export the data again.
Open the file with WordPad. The date data
should now be in ISO Format. If you view the exported file in Excel, you may find a different format than if you open it with WordPad.
If you save the file in Excel, it may change the date format without being told to do so.
Select Administration | System | Date Format and return the format to what it was before you changed it.
The second workaround is:
Open the exported data in Excel.
Highlight the entire column of any date field.
Right-click in the highlighted column and
chose "format cells".
Select Category | Highlight "Custom"
Under "Type", enter yyyy-mm-dd and then click OK.
The date format should change for the entire column.