Data Upload Frustrations

Brianna Gregg
Brianna Gregg
in Blackbaud Award Management™ & Blackbaud Stewardship Management™ Discussions

Our student information that is needed for application/scholarship review isn't in one neat banner universe and instead across multiple. Blackbaud assured us this could still be done, but three years in and we are still manually uploading our students after we pull all the data together. Does anyone have a similar situation and a way to solve it?

Tagged:

Comments

  • Karen Harant
    Karen Harant Blackbaud Employee
    Tenth Anniversary Facilitator 1 Loyalty Badge Blackbaud Staff

    Have you tried something like this to combine the spreadsheets? I don't know how to use Power Automate but came across this when looking into another question. Might check with your IT team to see if they can help.

    Power Automate (for Microsoft ecosystem)

    • Why: No-code/low-code solution, integrates well with Excel and web APIs.
    • Workflow:
      • Create a flow that triggers when files are added to a folder.
      • Use Excel connectors to read and merge data.
      • Use HTTP connector to send data via cURL-like POST request.
  • Zara Berger
    Zara Berger
    Kudos 1 Participant Facilitator 1

    We’ve faced the same issue. One approach that helped us was using automated scripts to pull data from all sources into a single spreadsheet before uploading. It doesn’t fully eliminate manual work, but it speeds up the process significantly.

Categories