topic QV Source : Facebook connector : How to get my name? in QlikView

QV Source : Facebook connector : How to get my name?

jujucts — Fri, 29 May 2015 12:00:08 GMT

Hi everybody,

Context :

I installed last QV Source 1.6.1.4

I used the "Facebook Fan Pages And Groups Connector For QlikView (v2)" connector

I got the "QVSource - Demo Facebook Application (Empty) V2.qvw"and intended to make it work for my personal account as a test.

So I could Authenticate myself thru my account and got a ticket.

I generated the QV Script and copied it into the qvw and added my auth ticket like

FacebookFanPagesConnectorV2_CheckAccessToken:

LOAD

status as CheckAccessToken_status,

reason as CheckAccessToken_reason

FROM

[http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=CheckAccessToken&appID=<my ticket auth>]

(qvx);

I modified the script according recommandations to upgrade from v1 to v2 like

replace

[http://localhost:5555/QVSource/IndustrialCodeBox_FacebookConnector/?table=Friends]

(txt, utf8, embedded labels, delimiter is '\t', msq)

[http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=Friends]

(qvx)

But running qvw, i got an error like 'name' field is not found.

So what is wrong ?

- my ticket auth ?

- path

- is the right demo.qvw ?

thank you for your help

juju

Re: QV Source : Facebook connector : How to get my name?

chrisbrain — Sat, 30 May 2015 09:07:42 GMT

Hi Juju,

I am not sure what you are doing here by changing:
[http://localhost:5555/QVSource/IndustrialCodeBox_FacebookConnector/?table=Friends

To:

[http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=Friends]

If this is documented somewhere as an upgrade can you please send the link so that I can fix it?

Out Facebook 'Personal' Connector (IndustrialCodeBox_FacebookConnector in the link above) was removed from QVSource a long time ago and I believe Facebook have even removed many of the features it relied on from their API.

Our Facebook Fan Pages Connector (FacebookFanPagesConnectorV2 in the link above) supports access to public Facebook Fan Pages and groups but it does not have a table named 'Friends' so it's not possible to make the upgrade you noted in your initial post.

As a final note - whenever you see the 'Field not found' error the best next step is to first try the request URL (the part between the square [ ] brackets) in a browser as you will often get back a more helpful error message.

Re: QV Source : Facebook connector : How to get my name?

jujucts — Tue, 02 Jun 2015 09:19:39 GMT

Hi Chris,

I used the "Facebook Fan Pages And Groups Connector For QlikView (v2)" connector

i took the available demo : QVSource - Demo Facebook Application (Empty) V2.qvw

in the script tab "Friends", this one uses

[http://localhost:5555/QVSource/IndustrialCodeBox_FacebookConnector/?table=Friends

that is the reason i replaced it by

[http://localhost:5555/QVSource/FacebookFanPagesConnectorV2/?table=Friends]

My goal is to make a test to understand how it works, and i used for that my own account.

In the future, i will intend to build a demo on my company account

By the way, what are the fees conditions to use QV source ?

Thank you

Re: QV Source : Facebook connector : How to get my name?

chrisbrain — Tue, 02 Jun 2015 15:08:47 GMT

Hi - You can request a quote via our website:
Purchase QVSource