Before you start
- Make sure that you've already created a merit template to send to your recipients.
- Have your bulk merit data organized into columns on a spreadsheet so it can be easily saved into a pre-formatted .csv file and uploaded to Merit.
How it works
Step 1: Go to the Organization Portal and navigate to the Automate merits folder on the left. At the top or in the center of the page, click the Automate merits tab.
Step 2: Create a connector by selecting where you store your recipients' information.
- Click on Spreadsheet from my computer.
Step 3: Name your connector to represent the merits that will be sent from this connector.
- Type the name in the Connector name box.
- Click Next, upload a file.
Create a .csv file that includes all of the fields associated with that merit template, as well as fields that need to be filled out.
Step 4: Fill in your .csv file with your member information. Do not delete the column headers or the .csv file may not import appropriately.
Invalid date format
All date fields must be of the format YYYY-MM-DD. E.g. "2020-05-14" for May 14 2020. Formatting the date any other way will cause a read error.
Step 5: Once you have completed your file, make sure that it's saved as a .csv file.
Drag or click to upload your spreadsheet.
Click Finish creating connector.
Step 6: Select the Map a template button in the connector you just created.
Step 7: Merit then directs you to Select a template and map your column headers with the fields found on the merit template. Once the .csv file is successfully mapped, click Create mapping.
Step 8: The page will return to the Automate merits screen, and a window will pop up that asks you to send merits. Click Send merits to complete the process or Cancel to go back.
Step 9: The connector will now show the file as Syncing. The length of this process will depend on the size of your file.
Once this process is complete, the Syncing will change to Sync complete.
See any error messages after sync?
Learn about possible errors here: