Import Donors from Millennium

Once the donor list is exported from Millennium, make a few adjustments to ensure that the donor list uploads successfully.

Example of Exported Donor List

By moving and re-naming a few of these columns and pasting them onto the Guest List Template, admins will be able to import this list of donors directly to your campaign.

Import Millennium donors to GiveSmart

1. Open exported Millennium donor report.
2. Delete the following columns
   • The blank Column 'C' (the one after the e-mail)
   • MN - middle name
   • SUF - suffix
   • the 2nd and 3rd H_S columns
3. Insert 4 blank columns in front of the CLIE column.
4. Cut and Paste the FNA and LNA columns into columns A and B.
5. Cut and paste the Pho column into column C. 
6. Delete the 3 blank columns after the e-mail address.
7. Insert 1 blank column after the CLIE column.
8. Rename the columns headings, which must appear exactly as shown below for the donors to be successfully imported.
   • Column A: First Name
   • Column B: Last Name
   • Column C: Phone
   • Column D: Bidder #
   • Column E: Field1
   • Column F: Field2
   • Column G: Email
   • Column H: Street
   • Column I: City
   • Column J: State
   • Column K: Zip
9. Save this report as an MS-Windows (CSV) file.
10. Visit the campaign.
11. From the Admin Navigation, select Users > Details.
12. Click the More button ("···").
13. Select Import Users from the dropdown.                                               
14. Select the file to import, then click Begin Import.
15. Select Other in the Field 1 dropdown, type in Millennium ID.
16. Check Hide from Users box.                                                              
17. Select Continue
18. A pop-up will appear showing that users have been uploaded successfully.
19. The imported donors will now appear on the View Admin > Users > Details page.