How to create a custom profile export file from ParishSOFT Giving
-
To go into the Data Export page, click the Gear action button in the upper right corner then select the Data Export card.
- This process will allow you to generate a Custom Data Export
- to import to a database that does not already have a data profile in our system
- with a certain data value formula that does not already exist
Click the Select Profile drop-down and choose Custom.
- This will generate a new formula field that allows you to make your own data formula based on the information you or your database needs.
- You can build your formula using preset data fields. Input the data fields you would like to export into the Formula field. Below is the full list of data fields available, as well as the information that displays in each column when exported to .csv:
[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 time stamp 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.
- Click Save when you are satisfied with your formula.
In the example above, we entered the data fields [personName], [email], [city], [zip],[amount], and [date] to generate the name of the donor, the email of the donor, the city of the donor, zip code of the donor, the amount of the donation, and the date of the donation. [sep] is input between each field to separate each field into its own column in the .csv file. - Once you've finished composing your Formula, choose your Payment Type and Payment Method, with Start and End Date. Choose whether to include or not include Donors with blank IDs or Envelope numbers and then click Export Data. Please note that any donors without an ID or Envelope number will not be able to have their contributions imported into ParishSOFT Family Suite.
- After downloading and opening the file, this is what the data looks like based on the formula above: