Do you need to import Accounts into Enrollsy? Here's how!
Step 1 - Import Page
First, head to the Enroll page and click on Import on the top navigation menu.
Step 2- Upload CSV File
Click "Select CSV file" to upload your file. It will need to be saved as a CSV file to be imported.
NOTE: Make sure every row in your file has an email address, or the import will fail.
Click the Select CSV File, find your document on your computer, and click Open. Read the "Import File Hints" listed to ensure your information uploads correctly.
Click Continue to go to the next step.
Step 3 - Map Columns
Next, you will see two columns:
The first column (CSV Column Names) is the list of items on your file.
The second column (Enrollsy Column Names) lists the Enrollsy software's names.
Drag and drop the names that match from the second column to the first. As you move them, they will disappear from the Enroll Form Fields section.
Step 4 - Clean Up
The next step is the Clean Up step. Here, you mark (if any) rows that should be excluded during the import:
Rows highlighted yellow show that the Primary Account Holder's email address is already being used. During the import, any data already in that Account will be updated to match the data imported.
If any of those Accounts have the same name on the Account with the same email address, the system will show an error message (see below). This could cause issues with the import.
The rows highlighted in red are missing the required information, which will cause the import to fail.
How to Exclude Rows:
Select the row by clicking on the box on the right
Click the "Exclude" button on the right
When done cleaning up, click "Continue."
Step 5 - Add to Program/Class
Now add the Enrollees to a Program and/or Class.
Select the checkboxes beside the Enrollees (or click the top to select all).
Click the +Program/Class button to the right to add the Enrollees to a Program and/or Class.
Change the "Rows per page" at the bottom to ensure all Enrollees are assigned to a Program/Class. If you are missing some rows, you will get an error message like this:
Step 5b - Include Enrollments in Zapier
If you are using the "New Enrollment Trigger" in Zapier, check the box to include the imported enrollments at the bottom of the page:
Click "Submit" to continue, or "Go Back" to make edits.
Step 6 - Upload Results
A new window will pop up where you can select the Enrollment Period/Program/Class. Once you've assigned all Enrollees, you can click the submit button at the bottom of the page.
You will get a pop-up message showing your Upload Results that can include any combination of the following:
"Import was successful" message
Number of Accounts Updated (already existed in Enrollsy)
Number of Accounts Imported (new Accounts)
Error messages (rows of data that DID NOT get imported)
Clicking on the down arrow will show all the email addresses that were updated, imported, and/or not imported. You can view the emails of rows that didn't import due to errors and the number of accounts that did import.
At this point, you can either view imported data or import again.
Important Notes if There is an Error or You Mess Up
Important Notes if There is an Error or You Mess Up
You can usually see the error in the Console. To view this, right click on the page and select "Inspect." A window will open with tabs. Look for the "Console" tab. Click on it and look for any errors in red. Usually the error will have to do with the columns and enroll form fields not matching (in the Mapping section).
If you do mess up, please click the "Go Back" button at the bottom of the window (DO NOT refresh the page or click the browser back button!). When you get to the mapping section, click the "Cancel" button at the bottom of the window. Then you can fix your CSV and re-upload it.
If your mappings do get messed up, please do this: Right click the page, and select "Inspect.' A window will open with tabs. Look for the "Application" tab and select it. Under "Storage" on the left side, click the arrow to open "Local Storage." Next, click on "https://app.enrollsy.com." In the window under "Key," you should see in list an item named "IMPORT_COLUMN_MAPPING" with a long ID beside it. Right click that and select "Delete." Close the Inspect window and try the import again.
Step 7 - View Imported Data
If you wish to view the imported Data, click "View Imported Data." This will take you to the Classes page where you assigned the enrollments.