Moving from another database means you might have a tonne of service attendance records. We want you to retain that data so here’s how you can import it.
To view examples of how your information should be formatted, download the files below.
There are two ways to import service attendance.
|First Name||Last Name||Service Date|
Dates Horizontal is a great way to import service attendance for multiple services at once. People are marked as attending a service if they have a ‘1’ marked for the column, otherwise they are not counted towards a service.
Here’s an example of the way a CSV file needs to be formatted before importing it into your account:
|First Name||Last Name||20/06/2013 10:00AM||20/06/2013 6:00PM||27/06/2013 10:00AM|
If you want to record things such as the number of baptisms, or if your previous system only recorded the total number of people attending your services, you’ll want to import Custom Statistics. First make sure that you’ve created the statistics in Elvanto under Settings > Services. This format can take both Reporting and Note fields.
|Service Date/Time||Guests||Baptisms||Total Adults||Total Children|
|04/06/2016 08:30 AM||13||2||185||43|
|11/06/2016 08:30 AM||14||0||195||35|
|11/06/2016 06:00 PM||24||2||184||4|
To perform the import, log into your Elvanto account and navigate to the Admin Area. Navigate to Services -> Import. Once the page has loaded, select your import file to upload and then choose your date format. From here, you’re good to go! Click ‘Continue’ to start the import.
Your import file will then upload to our server. Depending on the size of your import file and the speed of your internet connection, this may take some time. From here, follow the prompts to complete the process.
Once your import is complete, you will receive a notification and a record of how many records were added.
Need us to review your import file?
Our customer service team can review your import file prior to you performing the import. Feel free to contact us at any time.