Repeats with Google Data Studio Connector

Hi. I have sent the form definition in a private message to you and @hugh_sun.

Thank you.

1 Like

Hi, @hugh_sun :slightly_smiling_face: I hope you received the form definition I sent in August. Still not able to correctly output data using the ODK connector. The Submissions table returns all the fields in the entire form and all the child tables just return one field, the id field.
If i am not doing it right, I hope you could point me to the right direction. Thanks so much in advance.

Cheers,
Vinia

Hello Vinia, unfortunately I am no longer the manager for our team this year. A new manager will take my place and his name is Sam Levy. He will introduce himself here when he has the chance and will be your correspondent from now on. Thanks so much!

1 Like

Hi, @Vinia_Marciano My name is Sam and I am taking over as project manager for our team! We had a high turnover so most of our developers are new to ODK and we just started the process of onboarding. This is at the top of our priority list though! I will get back to you by the end of the week at the latest with an estimate of how long this will take us to address! Thank you so much for being so patient with us and we are looking forward to working with you more :slight_smile:

4 Likes

Thank you for your response, Hugh! Hope to still see you around. :slightly_smiling_face: Take care!

Cheers,
Vinia

1 Like

Hi, Sam! Warm welcome to you. Thank you for your update and for giving this a priority. Very much appreciated :slight_smile:
Good luck and hope to hear from you soon. The connector is really a great project (and ODK of course :slight_smile: ) and thanks so much to all of you for working on it.

All the best,
Vinia

1 Like

Hi! Wanted to check in on the expected timeline. It's a little bit of a hectic time as we are starting school and onboarding onto the project haha. I am estimating that it takes us about 3 weeks to finish a condensed onboarding and fully investigate this issue and add changes! If there are any time constraints you are under please let me know!

1 Like

Hi @samlevy Sam!
I hope you're doing well. Would just like to ask if you removed the ODK connector from the GDS platform? Is it just for the time being? (I hope! :slightly_smiling_face:)
Hope to hear from you soon! :slightly_smiling_face:

Cheers and take care
Vinia

@Vinia_Marciano Hi Vinia!
It is just for the time being! I made a mistake deploying a new version of the connector rather than updating the current one and we have to go through the process of resubmitting it to google :man_facepalming:t2:

This is the issue on out GitHub which has updates on the issue: https://github.com/UDub-Impact/OData-Connector/issues/27

And this is a temporary link to access the connector: https://datastudio.google.com/u/0/datasources/create?connectorId=AKfycbxMsmDvxShWuf1jctvN8B_4BKzrTXCkx1sAj2cplioeOpWgD7inx0jsnAEflDJSYuckTA

So so sorry for the confusion! We have also finished onboarding and are working on your issue! I will add more updates here as I get them!

2 Likes

Hi @samlevy Sam! Glad to hear that! I hope everybody's settled and well. Thank you for the updates and for the link. :slightly_smiling_face:

Good luck and cheers,
Vinia

1 Like

Hi @Vinia_Marciano Vinia!

Wanted to follow up again. We are still waiting for Google to republish the connector but we fixed the issue with the repeat tables along with some smaller bugs we discovered along the way. I am attaching a link to a temporary connector: https://datastudio.google.com/u/0/datasources/create?connectorId=AKfycbwvx0abeqBvCjqk_bhik1trRQ0--X_r58E2C6ncApjVLdU09bA3mTi26MixsFZXUwU with those changes (note that it will not be the one published).

I ran it using a submission I created using your form definition and it appeared to work for me but I wanted to give it to you so you could try it as well! Let me know if you run into any problems! Apologies it took longer than I anticipated!

2 Likes

Hi @samlevy Sam! This is great news! Thank you so much for the update and for working on this. Really excited to test this again. Sorry wasn't able to reply sooner. Came down with the virus, still trying to fully recover.
Will send you updates.

Thanks and cheers,
Vinia

1 Like

@Vinia_Marciano Oh no I am sorry to hear that! I hope you feel better soon! We are still working on an issue with types that occurs after editing an existing connection but we're looking forward to any feedback you have on the changes we've made so far!

1 Like

Hi there awesome job with this, sorry im just having a little trouble as below when i enter my credentials to authorize:

1 Like

Hey, @aaronsolofa Thank you so much for checking out the connector!! Apologies that you have already run into a problem! I was able to reproduce the error you had and for me, it happened when the path entered was incorrect. The path should be the OData URL for your form. (An example being: https://sandbox.getodk.cloud/v1/projects/4/forms/two-repeats.svc). It might have been that you were just entering in the server? (Ex: if you entered something like "https://sandbox.getodk.cloud/v1/" this error will occur)

If you try that suggestion and you are still having issues let me know and I can try to troubleshoot some more! In addition, the guide for the connector is in our GitHub repo here: https://github.com/UDub-Impact/OData-Connector/blob/master/connector%20guide.md in case you haven't seen it!!

1 Like

Thanks Sam, yes I have managed to fix as you suggested. Really appreciated.

1 Like

Hi, @samlevy Sam!

I have not finished testing yet because I got busy with other tasks as soon as I got well. I just started trying the connector actually. But I would like to report early that I got this error while connecting to a parent file of one of the forms in a project. Didnt get this error when I connected to the parent table of a form with the same structure in another project.

Will give more feedback as I progress :smiley:

Thank you!

Hey @Vinia_Marciano! Thank you for the feedback :slight_smile: Do you mind walking me through the process you followed to get that error? I haven't seen that one before.

Hey, @Vinia_Marciano Our connector is now live and our updates have been published! I believe we have fixed the issue you ran into, but if not please let us know!!

You can check out the post I made here: Updates to OData Connector from Central to GDS

1 Like

Oh great!! Thanks so much, @samlevy and to your team!! Will update my reports to use the published connector.
Again, thanks so much! Awesome.

<3 Vinia

1 Like