Generate a Custom Data Export that would meet the needs of importing to a database that does not already have a data profile in our system, or using a certain data value formula that does not already exist.
Navigate to your manager dashboard. Click on Settings Gear Symbol (top banner) and click Data Export.
Click on Select Profile and choose from the list provided or select Custom.
Build your custom formula by inputting preset data fields (listed below) into the Formula field.
Choose your Transaction Type, Start Date, and End Date.
Click Export Data!
Your data will be downloaded as an Excel or CSV file.
Below is the full list of data fields available, as well as the information that displays in each column when exported:
[personName] = donor’s full name
[fname] = donor’s first name
[lname] = donor’s last name
[addr] = donor’s primary street address for billing
[addr2] = donor’s secondary street address for billing
[city] = donor’s billing city
[state] = donor’s billing state
[zip] = donor’s billing zip code
[amount] = amount of donation
[email] = donor’s email input at time of donation or at donor profile creation
[tab] = a blank column
[fund] = designation for donation
[notes] = additional comments input by donor
[date] = date and timestamp in format m/d/yyyy hh:mm
[envnum] = ID saved to envelope number field in donor profile
[shortdate] = date in format of m/d/yyyy
[fundcode] = fund code saved to fund/designation under Fund Management.
[leadDate] = date in format of m/d/yyyy (same as shortdate)
[txnid] = payment gateway transaction ID
[yymmdd] = date without formatting, i.e. 171023 for a donation submitted October 23rd, 2017
[cardach] = confirms whether donation paid using card or ACH
[txntype] = confirms what payment method used for donation (online, kiosk, mobile, etc.)
[scramble] = donor’s encrypted card/bank account number with last 4 of donor’s card/bank account number
[personid] = donor ID
[phone] = donor phone number input at time of donation or at donor profile creation
[yyyymmdd] = date including full year without formatting, i.e. 20171023 for a donation submitted October 23rd, 2017
[account4] = only last 4 of donor’s card/bank account number
[fundid] = internal ID for designation/fund
[sep] = separates info by column
[space] = creates a space within the original initiated column to include proceeding information. For example, [personName][space][phone][space][state] would include the donor’s name, phone number, and state within the same column, formatted as “DonorName 888-555-4444 TN”. Use [sep] when you are ready to break to a new column.