Validate and import any data into your ChMS through Next Steps via CSV import!
However you collect your information, as long as you can export it into a CSV, we can aggregate it into your database. Follow the instructions below to create a CSV Upload template you can use to import your data.
Creating a Next Steps CSV Template
To upload a CSV file into a template, select Templates from the side menu, give your template a name, and choose CSV Upload as the Template Type.
Choose your Total Response Contact Item you want all of the contacts to receive, and the New Adult and New Child Status you want all new contacts to receive.
Once you have completed your selections, click Next Step to continue.
Mapping Your CSV Column Headers to Database Fields
To map your CSV column headers to your database fields, click Add Column Header, and type or paste the title of your first CSV column header in the Column Header field*.
*note: this value must exactly match the column header text in your CSV file.
Map the column header value to your corresponding database field by selecting it from the Field Type drop-down menu.
Add more column headers and map them in the same manner by clicking the Add Column Header button and repeating the steps above.
Mapping Fields with Multiple Values
Occasionally, you may have a CSV file that contains several identical header titles, each representing a different possible value for a checkbox or multiple choice question.
In the example below, the column headers named My Decision Today could represent responses such as Prayed to Receive Christ, I Want to Join a Small Group, etc., from a contact card or a web form.
To capture the value for each entry:
- name the field according to the column header title
- select Contact Item/Attribute as the Field Type
- enter the possible value and its corresponding attribute and/or contact item
- select Add Another Checkbox to enter each additional option for the column header value
When you have mapped all of your fields, select Finish Template to save your template.
Using a CSV Template
To use a CSV Upload template, navigate to the Batches tab, and select the new template from the menu.
Name your Batch, choose the correct Service Time, verify the date, and click Create Batch to continue.
Now you have the option to upload your CSV file for processing. Drag your file into the box, and click Submit Batch to process your new CSV Upload Batch!