Hi everyone,
I've been dealing with a very frustrating issue for the past few... well months really. It only comes up now and then so it hasn't been a priority. But I would really love to figure this out if I can.
I have a notebook setup in AGOL that pulls in some data, flips it around a bit with pandas, does some aggregation, and updates an existing shared CSV item which is used as a select_one_from_file in a survey that is used by about 50 people.
Basically:
Data in as CSV -> Panda tricks -> Output to CSV -> Push to existing shared CSV item like "csv_item.update({}, data = csv_file)"
Survey123 catches the updated CSV item, downloads to device, all is well. EXCEPT...
I have this setup to run daily, I can see the history going way back months. It always run's fine without exception. However, consistently the CSV file is NOT being updated. Inevitably I get complaints from users. I review everything, no problems.
So I manually run the notebook. And it works fine. Updates the CSV item. The only difference is me running it manually.
I have no idea how to even debug this. It can be quite frustrating.
Has anyone experienced this? Barring any solutions to my particular setup and issues can anyone think of any alternative routes to share/update the CSV that might be a bit more robust?
It all seems pretty straightforward but I'm happy for any ideas or alternatives.
Thanks again!