Google sheet to CSV media file

Naeim · October 17, 2021, 2:13pm

I synced my kobo form with a google sheet using the steps mentioned here

kobotoolbox/kobocat-googleapps-scripts/blob/master/Working_Examples/README.md

The Update_Spreadsheet working example uses token authentication to access the kobocat API v1 allowing users to update all data from within Google Spreadsheets. The script can be run through the added menu item. 

## Known Issues:
1. This script assumes all headers are in the first row. This script does not work on blank worksheets because it compares the headers from the sheet to the information received from kobocat
1. At the moment, the entire sheet is replaced. A Future improvement would be to run through the '_id' column of the sheet, compare it to the kobocat server and only download the instances that are missing. 
1. Blank fields from the kobocat server are tagged as 'Undefined' 


## Installation:
1. Export your (blank) dataset as an XLS file
1. Navigate to Google Drive, upload the XLS file, then click Open in Google Sheets to edit it
1. Click 'Tools>Script Editor...'. If you are presented with a welcome screen, click Blank Project.
1. In a separate tab open our import script and copy the entire code to your clipboard. Choose the right file depending on your server:  For kc.humanitarianresponse.info use [this file](Update_spreadsheet_hr_info) | For kc.kobotoolbox.org use [this file](Update_Spreadsheet) 
1. Back in your Google Sheet, delete any code in the script editor and paste in the code (see previous step) into the editor.
1. Click the menu item Run>OnOpen.
1. Select the menu item File > Save all. Name your new script "Update from KoBoToolbox" and click OK.
1. Complete the authorization and run the function again
1. A new menu item will appear called 'Update from kobocat'

This file has been truncated. show original

the sheet will be updated on a daily basis
is there a way to convert the sheet to CSV and upload it back to the form so the team can get the latest update using pulldata() functions?

thanks

Kal_Lam · October 18, 2021, 2:36am

@Naeim, have you gone through our support article Dynamic Data Attachment? Maybe it should solve your issue:

Naeim · October 18, 2021, 9:31am

thank you @Kal_Lam for mentioning this,
one question, is it possible for the parent project and the child project to be the same project?
for example, I am monitoring the daily work progress in an aparment and I need hint from the already subimitted records, so I only have one project.
if it’s possible, is it the same steps I should follow??
and thank you for your painstaking efforts

Kal_Lam · October 18, 2021, 2:40pm

Yes! We will be updating our article on this soon!

Naeim · October 24, 2021, 10:38am

I am trying to get this to work on the same form but I doesn’t work.
should I change the syntax somehow? I kept the syntax the way they are in the article but I get a message that I can’t deploy the survey