Tableau Community Forums

i if i don have page ,but I want  view mi Hpersonal information ??what i do ?

Just sayin'

Facebook ODBC Driver

Read, Write, and Update Facebook through ODBC

Facebook ODBC Driver - ODBC | ODBC Drivers | ODBC Connection | ODBC API

Hey Alberto! This is awesome man. Do you also know where we can find a web data connector for facebook ad manager?  We would be willing to pay for that.

Hi there,

I've been having some trouble getting this WDC up and running in my own environment. I'm not sure if this is an issue with my Facebook app, what I'm doing in my server, or with my coding.

When I attempt to connect to my WDC in Tableau, I hit "Login with Facebook" and am taken back to the starting page (pagefeedwebconnect.html). Curiously, if I try to load the page in my browser, it takes me a step further and shows me which accounts I can access a feed for.

Can I ask for some help on this? My code is hosted here.  I'm happy to provide my code, access to my Facebook app and any screenshots.

Hi Alex,

Thank you for sharing your knowledge with us.

I have read one of your blog entry which is about Facebook web data connector.

I try to apply the code you have share on Github to apply the connector in my own environment which the web server i use to host it are Tableau Server.

Just according to your algorithm, create a Facebook app, and  the site URL hosting the web data connector are Tableau Server.

Then place the App ID and my server name.

But when using Web Data Connector in Tableau Desktop, I have met one problem which I'm able to login to my Facebook account but I can't proceed to "Get Account Info" which to retrieve the list of Pages I'm associated with.

Which I also have try it with internet browser (Chrome) which have no problem except can't extract the data.

Do you have any idea what situation will cause this happen.

Hope anyone who have read this message, can give me some idea.

Thanks for reading!

Regards

SY

Hi all,

This is precisely the issue I've had with my webconnector as well. Any advice would be greatly appreciated.

Hi Alex

This is just great to work with :-)

I need the user location data as country, city, language to show on a map - and agegrups, *** etc. Do you know if it is possible to get?

Thanks for providing us with a great tool.

/Peter

Those who are having login problems check your cookies permissions

Hi Peter,

Thanks for the feedback!

It is possible to get aggregated information on your Facebook Page Users' age, location and other demographic information via the insights metric documented here:

Graph API Reference Insights Metrics /object-id/insights - Documentation - Facebook for Developers

My current Facebook connector does not collect this data though so it would require a change to the WDC.

Thanks,

Alex

Hi Alex,

I am trying to resolve the issue that the others are facing too with login and although I have tracked it down to the browsing history and the cookies I wasn't lucky to get it to work.

Can be something with authorization token? Would really appreciate your feedback

Hi Alex,

We are hosting a copy of your FB WDC locally here but we seem to keep running into issues:

We created a Facebook dev app as instructed on your Tableau Junkie site

We then modified the pagefeedwebconnect.html file as the picture shows but that was giving us an issue where it would constantly return to the "Login with Facebook" button and would never let us get to the "Get Account Info" page.

Next we attempted to use the pagefeedwebconnectv2.html page and modified the pagefeedwebconnect.js file with our App ID and Base URL.  This allowed us to access the "Get Account Info" page selection screen.  Once we made our selection and clicked "Get Page Feed."  It would start setting up the tables but after 20 seconds or so it would hang at "Executing Query" and never finish.  This issue was corrected by lowering the Limit from 250 down to 100 within the pagefeedwebconnect.js file.

Unfortunately this only appears to be pulling partial data as some of the fields are returning "null" results (Page New Likes, Page Talking About, Caption, Page Likes and Page Link.)

When I use your hosted version (http://ec2-52-10-150-250.us-west-2.compute.amazonaws.com/facebooksearch/pagefeedwebconnect.html) everything appears to be working.  I noticed the hosted version's Limit is set to 250 and we aren't getting the hanging issues.  Also I am not getting the "null" results.

Did you encounter similar problems?  Does the Facebook app need to be submitted for Facebook review before it will have full functionality?

Thank you,

Hi,

I am having the same issue as many reported previously, ie after clicking "get user Feed", Tableau seems to be collecting data but in the end, i only get a row with column titles, but zero lines.

I have been trying and trying again, but I get no data collected from FB.

Thanks for your help,

Béa

Hi,

Don't ask me why  but this morning I tried again and it worked perfectly fine....

This is great,

Have a great day everyone,

Béa

Hi Béa,

Sounds like there might be some form of intermittent bug in my web data connector. This can be quite hard to pin down, but let me know if you (or anyone else) can replicate this and I will try and take a look.

Thanks!

Alex

I am in the same situation as the others but I will give you my feedback if by any chance it can help.

While using v2 of your Web Data Connector and by adjusting the var LIMIT = 100; on the pagefeedwebconnect.js file I managed to get some data, in about 50seconds, from a page that has a relative small amount of data. The "Page New Likes" and "Page Talking About" columns where filled with "null".

When I try to fetch the data from a page that is from 2008 and with a lot of interactions the "Executing Query" process takes very long.. I have not managed to get it to complete. I will try and leave it some more time/days to see if it will finish.