Import & Export - Children and Parents

This article is for importing users with parent and children accounts - this module will need to be enabled on your site in order for the "parent" field mapping option to be available.

This is typically done automatically for children's choirs. To learn more about parent accounts, click here.

Roles needed: Site admin


Importing Parents and Children

Go to the Import & Export page

Setting & Admin > Import & Export


Search the menu for "import" or "export"

Select what kind of information you would like to import

In this case, we'll be importing users, so we'll click the import link in the Users row.

Review the available field names and upload your csv

Required fields include: Login name, Email, First name and Last name.  You do not have to worry about the titles matching exactly. You can manually link up columns in the next step (called mapping fields).

Do not use the User ID field when uploading new users. It's used to update existing accounts only.

Because you're importing children and parents, you'll need to import the parents first, and then the children.

This is because when you import the children, you will need a column called "Parent" that will have the login name of the parent for that user.

To upload your csv, click "choose file", select a file on your computer, and then click the "proceed to file test" button.

Not sure what a csv is? Click here to read about them.


File test and manage field mapping

You should see at least a few fields mapped on the next page, showing the first ten entires of your csv so that you can verify the site is reading the csv correctly. You MUST have the Login name, Email, First name and Last name headings in the mapped fields, or none of your entries will import.

Need to map more fields? Or check fields that were already mapped?

Expand the "Manage mappings from csv to import" heading. You will see a list of the available titles, with a drop down that lists all of the headings in your csv that have not already been mapped. You can now mix and match the data as appropriate.  When you're finished, click "adjust mappings".  If you wish to reset it to its defaults (what was automatically mapped), then click "reset mappings".

Click the heading "fields that are already mapped" at the bottom of the list to view the fields that have already been mapped.

Continue checking the file test at the bottom of the page until you are satisfied with your import, and then click the "proceed with import button".


Importing rows

Once you click "proceed with import" your file will be imported in batches. If you have a lot of users (upwards of 1000) this may take a few minutes.

Once the upload has completed, you will see a report noting how many rows there were in total, the number of records created,  how many were updated, and if there were any errors.

If your import had zero errors, congratulations! You can now navigate back to the members page to see your new users!


Did you end up with some errors?

No worries, there should be a file you can download that will let you see the error for each row. The most common errors are missing required fields (noted above in the section "Review the available field names and upload your csv"), and incorrect email formatting.

You can edit the error file directly, save it, and re-upload only the entries that had errors.

If you choose to upload the entire file again, entries that already exist in the system will not be overwritten, but they will be updated.



Exporting Users

On the Import & Export page, click the "export" link across from users (over on the right hand side).

This will export all users in the system and their data into a csv file.


From the Members page

Both site admins and members can export a list of users from the members page using the "Printable roster" button.

Navigate to "Members" in the main menu. On the far top right, click the link "Printable roster". This will open a pdf of all members, including their contact information, which can then be printed.

At this time, this report is not filterable and only includes active users (no blocked users).


Want to export a select list of users?

On the Members page, select your users bly clicking ont he row to highlight them. Click the "actions" button and select "export to selected to CSV". If asked, choose to save the file. The file will download to your downloads folder, where you can open it.