Export feature does not export fields containing multiple values in batch

  1. Go to a constituent record and add 2 addresses
  2. Go to a constituent update batch
  3. In the addresses field notice both addresses show when clicking in it
  4. Select Export
  5. Open the file and notice the word "addresses" shows and not the actual data. 
  • Guest
  • Feb 23 2016
  • Reviewed: Need Further Info
Organization Name (Please enter full organization name) Blackbaud
Reported Version 4.0
  • Attach files
  • Guest commented
    March 12, 2019 16:24

    Our use case is data coming from BBIS. We need to save the original state of the records from BBIS before batch processing starts manipulating the data in ways we didn't intend. The most severe example is with direct debit account info supplied for recurring gifts (sponsorships). In batch, if we switch the constituent from wife to husband (where the sponsorship exists), the batch processing erases the account information from the batch row. For constituent updates and addresses, we need to check for user supplied data that is substantially different (e.g. they moved) versus basic formatting changes where we want to keep the address finder results. 

  • Maria Boyd commented
    March 11, 2019 13:20

    The value is when a section of the batch import fails.  By being to export the collection fields, you can fix whatever the problem is without having to go back to the original import file and manipulating it to have the data that is in the collection fields.

  • Admin
    Nicola Cameron commented
    March 11, 2019 10:14

    Please provide some more information regarding the requirement for batch gird export enhancement. For example,What is it used for? What additional value is added by exporting one-to-many fields from batch rather than via export? 

  • Guest commented
    November 14, 2017 18:01

    FWIW, it's not necessary to add 2 addresses to see the problem. Even a single address gets replaced by the word addresses. Same issue for phone number and email address.