Allow a query of constituent id's to be populated from an Excel spreadsheet

Many times we have a list of id's in an Excel spreadsheet, and would like to create a query of these id's. They cannot be copied into the query list, but have to be entered manually. Copying directly from the column in Excel would save a lot of time.

  • Guest
  • Aug 13 2012
  • Attach files
  • Guest commented
    March 18, 2016 00:34

    I actually think this is now possible. There is some crazy workaround. I do not know how to do it but have seen it on the forums.

    Attachments Open full size
  • Guest commented
    March 18, 2016 00:34

    There is a work around but it's kind of a pain! It's Solution ID: BB124766

    https://www.blackbaud.com/kb/index?page=content&id=BB124766&actp=search&viewlocale=en_US&searchid=1317913470307

    Attachments Open full size
  • Guest commented
    March 18, 2016 00:34

    When you have the One Of selection box open, you have to click on the down arrow in the selection box to take the curser out of the first row. Then you can paste your list.

    I use the free SmartPaste tool from www.smartthing.co.uk because it adds a button to your One Of selection box that says Paste List. This makes the it obvious and easy.

    Attachments Open full size
  • Darrel Spacone commented
    March 18, 2016 00:34

    SmartPASTE is a cool workaround. Thanks.

    Attachments Open full size

Related ideas