How to reference CSV file hosted on the cloud using pulldata()

User Support Form Building
,
1

How do we reference a CSV file loaded on the cloud using pull data? For example, I have a CSV file using Google sheets:

https://docs.google.com/spreadsheets/d/e/2PACX-1vQLBoIZiy8LUtLNU53emDbJOjCfbb9KtBlxi-IXiVlTEwMXWDN6ccpXChdc7nkpDYnjkKGj2nq9Lu-r/pub?output=csv

I want to use pulldata() to reference that CSV file. How do I reference that file? I tried uploading to Media, but I can’t figure out how to reference it from XSLForm.

pulldata(‘nameofcsv’, ‘columnheadingtopulldatafrom’, ‘columncheckformatchingTEXT’, ‘TEXTtoCheckfo

What should we put in 'nameofcsv" for external CSV hosted on the cloud?

2

Hi Onesky,
Unfortunately there is no way to do this. I however recommend the following logical approach to doing it which requires a third party app on the phone

image
image650×726 81.2 KB

This will allow the media folder to sync with the csv on google cloud

Stephane

1 Like
3

Can we use this?

https://kc.kobotoolbox.org/api/v1/forms#import-csv-data-to-existing-form

Essentially for us to push our CSV changes into the form?

4

Hi @onesky
You may have to try this on your end using the schema I provided as an illustration and see if it will work.

Stephane

1 Like
5

@onesky
Did you get this working? I need to upload a different CSV file to the form each day.

EDIT: I did a bit of reading and I realized that this endpoint is to submit instances to a form… I need something to add form-media to a form, any idea about this?