Data Upload Frustrations

Brianna Gregg

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?

Karen Harant

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

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.