Recently, I updated a form in Kobo after approximately 10,000 submissions. As part of the update, I added a new column titled “Type of Visit.” However, upon attempting to pull the data using R via the Kobo API, and even after downloading the data in Excel format and importing it into R, I observed that the entire column for “Type of Visit” was blank.
Upon further investigation, I found that sorting the data by date, from the latest to the oldest submissions, allowed the data to be imported correctly into R. This suggests that there might be an issue with how the data is organized or exported, particularly when “Apply saved export settings” is enabled, causing the new data to be placed at the end of the file rather than the beginning.
When we export in excel, data for the new column after the updated version is available and blank is for the previous form and this is right. But when I pull this excel file or if I pull the data using API from KOBO to R, the whole column is blank even if there is data available in excel.
I am reaching out to inquire if there is a possible solution to this issue. It would be greatly appreciated if you could investigate and provide guidance on how to ensure that new data is properly included and accessible through the API and Excel exports, regardless of the sorting order.