Is it possible to directly upload or export data from Excel to the ODK central server? We want to combine some of the massive data sets that have already been collected (in excel) with the data in ODK central server

I answered a similar question here. Take a look. [image] Import data from a csv file Support For loading the exact same data for reporting, you'll need to manually enter the data as a new form submission or use the API to programmatically import those records. You can also…

Not any known or documented process. I would love to see some bulk upload option but its not easily possible because of the database structure in central.

@Syed_Muhammad_Qadeer How are you . If our developers took it seriously, I don't believe it would be too difficult. On the data structure, just to ensure that the excel data set is in the same format as the one on the server, including all headers. Regards

@yanokwa How are you The data set is too big, and we cannot be able to enter manually. I liked when you said, ‘you are currently laying the groundwork to make that possible in the future’ and this very well noted. We are waiting for that functioning and longitudinal tracking capabilities (and two-w…

See https://odkcentral.docs.apiary.io/#reference/submissions/submissions/creating-a-submission . We'll be adding submission creation to pyODK as well, but no ETA on when that'll ship.

If you know how to use R, you could try my solution here... [image] Bulk population of a new form with data from csv file Showcase @Syed_Muhammad_Qadeer If you come up with a solution using python or similar please post an example here! Taking this approach is going…

Is it possible to directly upload or export data from Excel to the ODK central server?

Support

yanokwa November 16, 2022, 5:55pm 4

I answered a similar question here. Take a look.

1 Like