Overview
This article covers the fields available on the Donations upload template. Read more about using the Veracross Data Importer.
Fields on the Import Type Template
Prepare a comma separated value (CSV) file containing all of the following fields in any order, even if some non-required fields will contain no data. A CSV template with the field names pre-populated is available to download from the Data Importer site.
- Required fields are marked with an asterisk (*)
- Fields that can be an id or description must be existing values in the database
FIELD | COMMENT |
person_id* | Either person_id or organization is required. |
organization_id* | |
group_event_id | |
from_both | Boolean value: yes, y, 1 / no, n, 0 (defaults to “yes” if left blank) |
credit_card_type | Can be id or description |
receipt_date* | |
receipt_amount* | |
reward_fmv | The fair market value for the reward. This field must be filled out with a value above $0 if the reward type field is specified. |
payment_method* | Can be id or description (Please select "Other" if the desired option does not exist): 1: Check 2: Cash 3: Gift in-Kind 4: Credit Card (Offline) 5: Stock 6: Payroll Deduction 7: Other Property 8: Bank Transfer 9: Other 10: Credit Card (Online) 11: E-wallet – Paypal |
check_number | |
check_date | |
campaign | Can be id or description |
fund* | Can be id or description |
pledge_id | |
in_honor_of | |
notes | |
in_memory_of | |
reward_type | Can be id or description |
profile_code | Can be id or description |
job_number | Use the project number found on the General tab of a donation detail screen. |
project_cost_rev_code | Use the Project Cost/Rev Code found on the General tab of a donation detail screen. Note that this field is configurable, so you will see different options depending on your configuration. Configure them on the the System homepage. |