upload csv of recipients

They would like the ability to import a list of early award recipients from Hobson's connect, and have them be awarded in AW upon import.  These applicants do not have to submit the General Application and are to be awarded right away.  Since they have already been awarded, they do need to apply or be reviewed, and it then becomes tedious for them to award these applicants  within AW.  

  • Deleted User
  • Feb 4 2016
  • Reviewed: Voting Open
Client Name "shard name" ndsu, msu, wisc, vt, sdsu
User IT Admin, System Admin
Functional Unit Imports, Awards
  • Attach files
  • Admin
    Carrie Goldberger commented
    July 19, 2019 14:59

    SDSU mentioned a similar scenario -

    • Some scholarships are managed outside the system, we get a spreadsheet with finalists - want to move them to a new category via an import or API

  • Maxwell Russell commented
    May 07, 2019 16:59

    MSU is also requesting functionality to batch import awards per Carries note.

  • Deleted User commented
    October 05, 2018 17:58

    See similar use case from Virginia Tech (VT)

    Batch importing awards: there are occasions in which our departments work from spreadsheet to coordinate their scholarship awarding. For example, our College of Engineering made over 500 scholarship awards at one time during our prospective awarding cycle for 18-19. This would have been much easier to import into BBAM via spreadsheet instead of manually posting through application grids.

    We are requesting the ability to upload a spreadsheet to make bulk awards into different opportunities in the system. Some departments use spreadsheets because they may be combining information from another data set that is not currently in BBAM (and may never be). Spreadsheets may also be easier to use when they have a defined population but are trying to determine the best way to award to that population from multiple different scholarship fund accounts (portfolios). Uploading the resulting spreadsheet into BBAM instead of manually assigning awards from each opportunity’s grid view would be a big timesaver.

  • Deleted User commented
    September 04, 2018 21:36

    Please add WISC to this enhancement. From Keith: I’m referring to existing opportunities in the system that are awarded to students.

     

    For example, we’d want to bring in $1,000 for Fall for Jim, Johnny, etc. rather than create the awards in the system. I know that you can bring in $$$ for Institutional Commitment in spreadsheets, but I wasn’t sure if there was an option to do bulk awarding via upload.