PSG Gear Button - Data Export: How to create a custom profile export file from ParishSOFT Giving

How to create a custom profile export file from ParishSOFT Giving

If you do not see Data Export as an option in the Settings menu, please contact the primary Admin for your Giving Site to have your Manager Permissions updated.
  1. To go into the Data Export page, click the Gear action button in the upper right corner then select the Data Export card.
    Gear_Icon_-_Data_Export.png
  2. 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.2019-06-28_13-47-51.jpg
  3. 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.  Data-export-formula.png
  4. You can build your formula using preset data fields. Input the data fields you would like to export into the Formula fieldBelow 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.

  5. Click Save when you are satisfied with your formula.
    Save_formula.png
    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.
  6. 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 DataPlease note that any donors without an ID or Envelope number will not be able to have their contributions imported into ParishSOFT Family Suite.
    2020-06-01_16-37-11.jpg
  7. After downloading and opening the file, this is what the data looks like based on the formula above:2019-06-28_14-25-12.jpg

 

 

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request