Importing Unregistered Users from a Spreadsheet

This will allow you to import into PrayerLink® a .CSV File (spreadsheet format file) containing the names and contact information for unregistered users. Unregistered users are people who have not already been added to your PrayerLink® system either by an Administrator or by the self-registering process.

Their username and password will be generated by the program during the Import process. The username will be their Firstname_Lastname while the password will be just their Firstname.

The .CSV File MUST have lines like the following example:








** Note: The header column names must be exactly as shown.

Exact Column Names

Here is an exact list of the column names that you can copy-paste:
username
password
first name
last name
member/employee id#
address1
address2
city
state
zip code
verified
usertype
phone
cell phone
email address
Instructions

** Very Important: Avoid putting any commas in name, number, or other text.

All phone numbers can be in one of three formats. (example: (555) 555-3540 or 555-555-3540 or 5555553540)

All dates should be mm/dd/YYYY (example: 12/21/2012) but other formats are acceptable, such as Oct 3, 2012.

When mapping or creating your .CSV File document for importing, it must match the pictured example above. Fields may be left blank if no data is available for import.

Columns do not have to be in this order; they can be in any order.

The Envelope Number field is for Envelope Numbers of Contributions.

** Note: There is a "Test" Checkbox in the Import dialog. It is wise to use the Test Checkbox the first time you do an Import. This will reveal any errors you may have in your input spreadsheet. After the Test successfully completes, you can be confident that your Import will succeed.


"CAA Product Help" from CAA Ministries at Support@CAAsoftware.com or 404-551-4230