Proposal Import ID in Query

Options
Candi OHara
Candi OHara ✭
Second Anniversary Name Dropper Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion

Hi there, any tips/tricks how to build a query of Proposals and include the Proposal Import ID as a column in the output/extract? Thank you and Happy Holidays!

Tagged:

Comments

  • Daniel R. Snyder
    Daniel R. Snyder ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Candi OHara unfortunately there is not a great way to do this so when I do reporting I make my own id by concatenating a few fields together. Otherwise the only way you can export the actual id is in export and there is not a great way to limit the number output.

  • Alan French
    Alan French ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic

    @Candi OHara I can't check this as we no longer have RE (we moved to a different Blackbaud product this year) but this might be something you could do in Import if the ID field is available there - if it is, it might come out in a better layout than export. There's an import option to “create import file” which is essentially an export process; it was something I definitely under-utilised back when we had RE!

  • Candi OHara
    Candi OHara ✭
    Second Anniversary Name Dropper Photogenic First Reply
    @Dan Snyder


    Hi Dan, with you suggestion I was able to get at what I needed via Export. Happy Holidays!
  • Candi OHara
    Candi OHara ✭
    Second Anniversary Name Dropper Photogenic First Reply

    @Alan French Hi Alan, with your suggestion I was able to get at what I needed via Export. Happy Holidays!

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Alan French
    There is a proposal import that you can get individual proposal per line with proposal import id

    319dd02038dc283d2b45c8134a883f8b-huge-im
  • Alan French
    Alan French ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic

    @Alex Wong thanks for confirming, I thought there was something like that but couldn't remember. I guess it has the same issue as Export in that it's difficult to specify the exact proposals you want, but at least they come out one per row, rather than one row per constituent with their proposals across multiple columns.

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Alan French
    not sure if I understood your reply, but want to clarify anyway.

    Export: 1 constitent per row, and you will have to ask for how many proposal to export, knowing the max per constituent to do.

    Import to create an export file (using the proposal import): 1 proposal per row, constituent having mulitple proposal will have multiple rows with individual import id for each proposal on each row

Categories