Bonjour à tous je veux savoir quel la méthodes pour avoir les données de KOBO en excel eb temps réel sans avoir à télécharger les fichiers exporter
Hi @darata,
Welcome to the community! You could do the same by following the instructions as outlined in the support article Pulling Data Into Excel Power Query. However you may have to manually refresh
at certain intervals to see the most updated data that has reached your KoBoToolbox server.
Have a great day!
merci
PLEASE QUE SIGNIFIE : Détails : « Web.Contents n’a pas réussi à obtenir le contenu de « https://kc.humanitarianresponse.info/api/v1/data/458990.xls » (404) : NOT FOUND »
Hi @darata,
Would you mind making your data public. Doing so you should not be seeing error message again.
Have a great day!
comment le fait s’il vous plait ?
Hi @darata,
Kindly please have a look at the post which discusses how to share data publicly:
Have a great day!
the columns is xml values
can i make it lables ?
Hi @rahhal
Do you mind looking at the discussions that happened in the following topics
Stephane
thanks @stephanealoo
kc.humanitarianresponse.info
Share Data Publicly: Yes
View data in table
Value and header format: Labels
copy URL and use it in excel: ( just first 100 records !!)
0r, copy https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv
1-Data -New Query- From Other Sources - From Web
past it.
2-Refresh All - connection Properties - Refresh every 1 minutes