In This Article:

    FAQ: Update Existing Group With Existing Constituents From a Spreadsheet With the Advanced Query Wizard

    In This Article:

      Add multiple, existing constituents to the same Group at the same time from an external data source, using the Advanced Query Wizard. This process allows you to use the features in the Advanced Query Wizard Post-Query Options (Global Update) without needing to import the information into Salsa CRM. For example, the Executive Director wants a draft list of Gala attendees in an Excel spreadsheet. The director intends to use a subjective system to remove Constituents from the spreadsheet manually, and you want to easily update a Group in Salsa CRM with the director's final list.

      1. Export any CRM report or query results to a spreadsheet. Make sure there is a column for Constituent Number.
      2. Make changes to the spreadsheet by deleting rows corresponding to the constituent you don't want.
      3. Save your spreadsheet as a Comma Delimited or CSV file type before you begin this process.
      4. Delete all columns but the Constituent Number column.
      5. Save it again.

        NOTE: the imported data source must contain only the Constituent Number of everyone in the data set to use this process.

      6. Select the Reports menu from the top tool-bar 
      7. Queries menu.
      8. Select Advanced Query Wizard. The Advanced Query Wizard window opens into Step 1: Select Query Type.
        AQWstep1.png
      9. Open another data source 
      10. Select Open existing comma-delimited ("CSV") file.
      11. Select the Choose File button to select the file to use for your update.
      12. Select the Next button. You are taken to Step 3 of the Advanced Query Wizard, which shows the contents of the CSV file.
      13. Select the Next button. You are taken to Step 4 of the Advanced Query Wizard, which contains Post-Query Options.
      14. Select the Global Update button.
      15. There are two options at this point:
        • Assign to Group allows you to assign all selected constituents to a group.
        • Remove from Group allows you to remove all selected constituents from a group.
        • Other options on this screen are not legitimate for this scenario.
          globalupdate.png
      16. Select the Group to which you will assign all records or from which you will remove all records
      17. Select the OK button to exit this screen. At this point, the group is updated with the spreadsheet constituents (or removed from said group).
      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request

      Comments

      0 comments

      Article is closed for comments.