12. Importing your member list

Video Courses

All Courses

Steward: giving

About this course1. The Steward dashboard2. Sessions, and the life of a session3. Starting a session4. The entry grid and the keyboard5. Who gave it: envelopes, names and anonymous gifts6. A new donor in the middle of counting7. Payment methods, cheques and split gifts8. The counted total and the live difference9. Possible duplicates10. Saving, refreshing and two laptops11. Counters, the review and Submit12. Posting a session13. Correcting a posted gift14. Gifts in kind15. Interac e-Transfers16. Deposits and bank reconciliation17. Donors and the donor profile18. Merging duplicate donors19. Pledge campaigns20. Recurring gifts21. Online giving22. Refunds and card disputes23. Year-end CRA receipts24. Fixing and sending receipts25. Reports, imports and event revenue26. Who sees giving

Gather: services and attendance

About this course1. Gather at a glance2. Service Schedules and the calendar3. Children's rooms and who counts as a child4. Building an Order of Service5. Starting, completing and cancelling a Service6. Opening check-in7. Lookup mode: finding people fast8. New visitors and first-time visitors9. People with no date of birth10. Person Categories: who counts as a child, and the attendance breakdown11. Printing labels12. Checking in children13. Allergy and medical alerts14. Children's Pickup15. Member QR codes and Scan mode16. The family check-in code17. Express Check-in18. Clicker headcounts and Roster mode19. Many devices, and finishing check-in20. Self check-in kiosks21. Attendance records and corrections22. Absence alerts23. Attendance reports24. Events and the public calendar25. Registrations and paid events
Video Courses

Importing your member list

Flock: your people · Lesson 12 of 18

The five steps, the review that shows exactly what will happen, and what is refused.

Read it in the guide

Transcript

In this lesson, you'll import your member list from a spreadsheet: the five steps, the review that shows exactly what will happen before anything is saved, and what is refused.

Import Members takes five steps: upload the file, configure it, map the columns, review and import, and the result.

Excel, CSV or tab-separated, up to ten megabytes. Download the import template for a spreadsheet with your own statuses in a drop-down. Try with sample data walks through it without counting anything. Here is the church's file.

Configure: the sheet, whether the first row is a header, whether to skip people already here, matched by email or name, or update them. Update matches on email, then envelope number, then external ID, and writes only the columns in your file. Then the status for rows with none, and the campus.

Map Columns matches each of your headers to a field. They're matched for you, and you can skip a column. Your custom fields are offered too, and next time, the same headers are mapped the way you mapped them now.

Review runs the whole import and throws it away, so you see exactly what Import will do before anything is saved: will be created, will be updated, skipped, need review because the name matches a member, and errors.

A status your church doesn't have, an email that isn't one, or a campus that matches none of yours is an error row, never quietly changed. Every row and its reason is in the findings download. And a file over your plan's member limit is refused before anything is written.

The button now says exactly what it will do. Change any setting and it asks for the review again. An import can't be undone, and a file is imported once.

Import Complete: created, updated, skipped and errors, a Review link for each possible duplicate, and the results to download. View imported people opens the directory, where the Lindqvists now are, in one household.

The directory's export has the same columns as the template, so you can export, fix things in the spreadsheet, and import it back. An export imported back unedited changes nothing. Super Admins, Lead Pastors, Pastors and Flock Leaders can import.

That's importing your member list. Next, the onboarding pipeline.