search

groton-school / course-planning-tool

Course planning tool to distribute individual Google Sheet course plans to students and advisors based on Blackbaud registration data
GNU General Public License v3.0
0 stars 0 forks source link

Error linking spreadsheets #74

Closed battis closed 11 months ago

battis commented 1 year ago

Everyone from row 22 onward:

Error linking spreadsheets. The source spreadsheet has reached the maximum capacity for sharing and importing. Learn more

IMPORTRANGE() seems to be maxed out.

battis commented 1 year ago

I am not alone in my vexation.

Empirically, it seems to be some sort of rate-limited quota, but the rate and the quota are undocumented. The most reasonable suggestion is to schedule your own imports in GAS.

battis commented 1 year ago

Opened a new question on Stack Overflow.

battis commented 1 year ago

K.I.S.S.: just include copying the values out of the Courses by Department sheet as part of the Update workflow and move on. It's not live, but it's dealt with.

battis commented 1 year ago

The current state of play is that I'm ignoring IMPORTRANGE() issues and have simply scripted a push mechanism to distribute the course list