Load from google drive

[Anonymous]

Hi,

How to load file from google drive into Qlikview.

[jaimeaguilar]

Hi,

Give it a try to QV source, it can help you to connect to plenty of web platforms including google drive,

www.qvsource.com/

regards

[Clever_Anjos · Accepted solution]

If you´re using Google Sheets

1) File / Publish into your Google Sheet

2) Google will generate a link. Copy it

3) Into QlikView Script, there´s a button "Web Files", use that link to open your document

[julian_rodriguez]

Hello Clever,

Your answer is interesting, but I can't get the file contents...

I get an error saying  "Cannot open HTML File".

I have tried Web Page, Txt and csv options but without any result.

How did you did that?

[Clever_Anjos]

Well, it seems to work here, we use it a lot check this url (please remove all spaces), i´ve used google to shorten it

http : // goo . gl / XpYPrx

[julian_rodriguez]

I really don't know why it doesn't works... your link is working, i get a CSV file.

But if I try to get it from the script, the Qlikview wizard doesn't recognize it.

Do you have the extraction script for this file?

Sorry but I'm really interested on this kind of solution...

Thanks in advance,

[stevedark]

Hi Clever,

That is a CSV, rather than a full Google spreadsheet.  It's good to know that this works though!

QV Source is probably the simplest way to connect to Google spreadsheets directly.

My company is a re-seller, if you would like a quote please get in touch:

http://www.quickintelligence.co.uk/qvsource/

Steve

[stevedark]

You need to use the Web Files button and use the Wizard there.  It will generate this script:

LOAD

     *

FROM

[http://goo.gl/XpYPrx]

(txt, utf8, embedded labels, delimiter is ',', msq);

Steve

[Clever_Anjos]

GoogleData:
LOAD
  RowNo()                                                                            as GoogleData.Avaliacao,
  timestamp(timestamp#(trim(Timestamp),'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') as GoogleData.DataHora,
  date(timestamp#(trim(Timestamp),'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY')               as GoogleData.Data,
  [Nome do Consultor] as GoogleData.NomedoConsultor,
  [Gestor SWB] as GoogleData.GestorSWB,
  [Nome do Avaliador] as GoogleData.NomedoAvaliador,
  [Considerações finais] as GoogleData.ConsideracoesFinais,
  autonumberhash128(RowNo(), date(timestamp#(trim(Timestamp),'MM/DD/YYYY hh:mm:ss'),'DD/MM/YYYY')) as Chave.Avaliacao
FROM [https://docs.google.com/spreadsheet/pub?hl=en&hl=en&key=0Augcl9bj_QQJdGlCMThXY0k5eHBjaVNNX1Byak1FVWc...]
(txt, utf8, embedded labels, delimiter is ',', msq);

[Clever_Anjos]

My another answer is beeing moderated, because has a link. It must show up in a few minutes