Refresh extract #8
Comments
|
Hello @123andy (and apologies for the summer-holiday-related delay). Did you work this one out? I've never seen Tableau on a Mac, but on my Windows machine (Tableau 2018.1.9) when I open a workbook saved a while ago and go to the Data Source tab down in the bottom left it prompts me to re-enter my token, and I then get the option to update the data. I also then get a refresh button in the top left toolbar: A project XML query is expected when generating a data source schema. I used the XML so it could be done with a single API call rather than using separate ones for data dictionary, events, event/form mappings, repeating event/instrument config etc. I wouldn't expect to see that call if it's just trying to (re-)read the data. That should just use Export Records. I'm sorry if this is not helpful. I actually never use Tableau myself except for developing the connector! |
|
I think the tableau connector has some issues with refresh. I haven’t dug into the code. In one project I gave up and just saved the full csv export to a common file and referenced by tableau project off the csv. Then when I want to update I overwrite the csv and tableau does its thing. I’d love to fix this though as it is a potential great add-on for long-term studies.
…-A
________________________________
From: Luke <[email protected]>
Sent: Tuesday, February 12, 2019 5:43 PM
To: lsgs/redcap-tableau-wdc
Cc: Andy Martin; Mention
Subject: Re: [lsgs/redcap-tableau-wdc] Refresh extract (#8)
Hello @123andy<https://github.com/123andy> (and apologies for the summer-holiday-related delay). Did you work this one out? I've never seen Tableau on a Mac, but on my Windows machine (Tableau 2018.1.9) when I open a workbook saved a while ago and go to the Data Source tab down in the bottom left it prompts me to re-enter my token, and I then get the option to update the data.
[image]<https://user-images.githubusercontent.com/7444426/52680262-f2160600-2f8b-11e9-9317-2027102c27ea.png>
I also then get a refresh button in the top left toolbar:
[image]<https://user-images.githubusercontent.com/7444426/52679658-ddd10980-2f89-11e9-9a77-ab0f41ca256b.png>
A project XML query is expected when generating a data source schema. I used the XML so it could be done with a single API call rather than using separate ones for data dictionary, events, event/form mappings, repeating event/instrument config etc. I wouldn't expect to see that call if it's just trying to (re-)read the data. That should just use Export Records.
I'm sorry if this is not helpful. I actually never use Tableau myself except for developing the connector!
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHHase8tDM0rZ5T_iyvWLE1pRVcl7Rqyks5vM23FgaJpZM4aRfZe>.
|
|
That's a shame you had to resort to that. I wonder if that problem occurs with other web data connectors as well - i.e. is a Tableau thing, rather than something to do with this particular one? Do you use any others?
Luke
…________________________________
From: Andy Martin <[email protected]>
Sent: Thursday, 14 February 2019 12:10
To: lsgs/redcap-tableau-wdc
Cc: Luke; Comment
Subject: Re: [lsgs/redcap-tableau-wdc] Refresh extract (#8)
I think the tableau connector has some issues with refresh. I haven’t dug into the code. In one project I gave up and just saved the full csv export to a common file and referenced by tableau project off the csv. Then when I want to update I overwrite the csv and tableau does its thing. I’d love to fix this though as it is a potential great add-on for long-term studies.
-A
________________________________
From: Luke <[email protected]>
Sent: Tuesday, February 12, 2019 5:43 PM
To: lsgs/redcap-tableau-wdc
Cc: Andy Martin; Mention
Subject: Re: [lsgs/redcap-tableau-wdc] Refresh extract (#8)
Hello @123andy<https://github.com/123andy> (and apologies for the summer-holiday-related delay). Did you work this one out? I've never seen Tableau on a Mac, but on my Windows machine (Tableau 2018.1.9) when I open a workbook saved a while ago and go to the Data Source tab down in the bottom left it prompts me to re-enter my token, and I then get the option to update the data.
[image]<https://user-images.githubusercontent.com/7444426/52680262-f2160600-2f8b-11e9-9317-2027102c27ea.png>
I also then get a refresh button in the top left toolbar:
[image]<https://user-images.githubusercontent.com/7444426/52679658-ddd10980-2f89-11e9-9a77-ab0f41ca256b.png>
A project XML query is expected when generating a data source schema. I used the XML so it could be done with a single API call rather than using separate ones for data dictionary, events, event/form mappings, repeating event/instrument config etc. I wouldn't expect to see that call if it's just trying to (re-)read the data. That should just use Export Records.
I'm sorry if this is not helpful. I actually never use Tableau myself except for developing the connector!
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHHase8tDM0rZ5T_iyvWLE1pRVcl7Rqyks5vM23FgaJpZM4aRfZe>.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHGXyqX0t4dWmgF2464cG7290GqNWcupks5vNLd4gaJpZM4aRfZe>.
|
|
I haven’t played with them. I’m guessing it is an option in the javascript. There is a ton of stuff you can do there when you go deep in the docs – I read about it a year or so ago and was excited to try and make something work and then it fell off the table….
…-A
From: Luke <[email protected]>
Reply-To: lsgs/redcap-tableau-wdc <[email protected]>
Date: Thursday, February 28, 2019 at 3:01 PM
To: lsgs/redcap-tableau-wdc <[email protected]>
Cc: Andy Martin <[email protected]>, Mention <[email protected]>
Subject: Re: [lsgs/redcap-tableau-wdc] Refresh extract (#8)
That's a shame you had to resort to that. I wonder if that problem occurs with other web data connectors as well - i.e. is a Tableau thing, rather than something to do with this particular one? Do you use any others?
Luke
________________________________
From: Andy Martin <[email protected]>
Sent: Thursday, 14 February 2019 12:10
To: lsgs/redcap-tableau-wdc
Cc: Luke; Comment
Subject: Re: [lsgs/redcap-tableau-wdc] Refresh extract (#8)
I think the tableau connector has some issues with refresh. I haven’t dug into the code. In one project I gave up and just saved the full csv export to a common file and referenced by tableau project off the csv. Then when I want to update I overwrite the csv and tableau does its thing. I’d love to fix this though as it is a potential great add-on for long-term studies.
-A
________________________________
From: Luke <[email protected]>
Sent: Tuesday, February 12, 2019 5:43 PM
To: lsgs/redcap-tableau-wdc
Cc: Andy Martin; Mention
Subject: Re: [lsgs/redcap-tableau-wdc] Refresh extract (#8)
Hello @123andy<https://github.com/123andy> (and apologies for the summer-holiday-related delay). Did you work this one out? I've never seen Tableau on a Mac, but on my Windows machine (Tableau 2018.1.9) when I open a workbook saved a while ago and go to the Data Source tab down in the bottom left it prompts me to re-enter my token, and I then get the option to update the data.
[image]<https://user-images.githubusercontent.com/7444426/52680262-f2160600-2f8b-11e9-9317-2027102c27ea.png>
I also then get a refresh button in the top left toolbar:
[image]<https://user-images.githubusercontent.com/7444426/52679658-ddd10980-2f89-11e9-9a77-ab0f41ca256b.png>
A project XML query is expected when generating a data source schema. I used the XML so it could be done with a single API call rather than using separate ones for data dictionary, events, event/form mappings, repeating event/instrument config etc. I wouldn't expect to see that call if it's just trying to (re-)read the data. That should just use Export Records.
I'm sorry if this is not helpful. I actually never use Tableau myself except for developing the connector!
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHHase8tDM0rZ5T_iyvWLE1pRVcl7Rqyks5vM23FgaJpZM4aRfZe>.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHGXyqX0t4dWmgF2464cG7290GqNWcupks5vNLd4gaJpZM4aRfZe>.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub<#8 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AHHasVgAc4A0vpxs2vSrOxVzNZGBvBJnks5vSF-mgaJpZM4aRfZe>.
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hey Luke,
I'm on a mac using latest tableau. I made a connection - all works fine. I pull data. Now, i reopen the file and try to refresh the data. I've tried just about everything and all that is happening is that it is executing a project_xml api query... Any ideas how to refresh a WDC extract? Am I missing something? I had to revert to an export to file for this project where I have to produce frequent updated reports...
-A
The text was updated successfully, but these errors were encountered: