Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three Google Docs (Excel) and want to upload the data into Sense, can this be done?
Hi Jose - are the documents you speak of, MS Excel documents (.xls / .xlsx files) uploaded to Google Drive?
Or are the Google spreadsheet Documents that are Excel-like?
Want to make sure before I give you a specific answer.
Thanks
Mike
Hi Jose,
Using a Web File Connection and the URL to the document - I was able to get the data into Sense. I made this URL public - so you can test:
https://docs.google.com/spreadsheets/d/12mI4rOSP6EEOLFirKeh59e86s1od1mVdAg_xhnmhuds/edit?usp=sharing
You may / will have to rename the columns to what you want - it seems to reference them as column markers.
If I learn anything new - I will post it here and let you know.
Mike
Thanks Michael, your answer helped me a lot, however I am still having issues when trying to share the qvf and trying to share the .xls file uploaded to Google Drive.
I want other users to load the data and see the changes that others made to the Excel file.
Can this be done?
Hi Jose - glad to hear it. Please see this video to learn more about sharing apps with the free version of Qlik Sense Desktop:
Qlik Sense Desktop - Sharing Apps (video)
In order to do this, each person would need a copy of Sense Desktop and a copy of the QVF file - then they can perform the reload - in the Data Load Editor (if using the public web connection for example) - to see the changes in the app.
We are thinking about this type of scenario and later this year will have a sharing service for this exact type of scenario. With certain limitations. Then you can also consider the Qlik Sense Enterprise server which allows complete online development, sharing, management and security and governance.
HTH
Let me know if you have any questions.
Regards,
Mike T
Hi Michael,
Thanks, this worked for me as well, but I needed to make the document publicly readable.
Not sure if this can be done with a secure document
Hi John Paul,
I see. At the moment, that would require a specific connector to Google Docs. Other than passing the credentials inline - which is not recommended, you are correct. I will ping our product management team and inquire about plans in this area.
Thanks for your contributions.
Mike
Google is changing their various Google Drive products to a new format.
They say "they will migrate all docs in the 2014-2015 timeframe". So it
could be tomorrow, could be in a year's time.
The old Drive format allowed for having restricted access set on a doc, and
still be able to get the doc's data via a simple http call (which could be
done from a QV load script).
In the new format only docs visible to everyone can be accessed that way
(just like you had also found out).
If you set access restrictions on a doc, for example sharing it with
certain people, or maybe with everyone in your organisation (if you have
Google docs for organisations), then the "old" way of retrieving the data
from QV's load script does no longer work.
The only way seems to be using Google's APIs to get the data.
Which is somewhat of a pain if you do it yourself... Lot's of API calls,
OAuth and similar things that needs to be taken care of.
QVSource, while being an add-on that cost money, does handle all that work
for you - and it has worked flawlessly for us so far, in this very scenario.
It would of course be nice if Google would enable the old way of geting
data from docs also in the new Drive file formats. Might be hard though, if
they made the change to improve security etc. The old way of retrieving
data was pretty insecure...
/Göran
On Tue, Nov 11, 2014 at 1:56 PM, Michael Tarallo <qcwebmaster@qlikview.com>
Thank you for the valuable information Goran and for reminding me about QVSource!
John Paul - check this out:
Here is an example of using QVSource with Qlik Sense: Qlik Sense Desktop - Using QVSource Data Connectors (video)
Note there are connectors for Google products. The video can explain how to get started.
Thanks for mentioning our Google Drive & Spreadsheets Connector which supports the following features. If you think we are missing anything please let us know!
* List the spreadsheets and their worksheets and load the contents of these spreadsheets.
* List all files on your Google Drive or only those matching your query (see below).
* List all the file revisions for a document.
* Create or update a Google Spreadsheet from a CSV file - for example you could use a store command in your QlikView/Qlik Sense load script to create a CSV file containing data from your application and turn this into a spreadsheet on Google Drive.
** Using the above feature, roll your own simple report creation and distribution services for QlikView based data using Google Apps Script (see example below).
* Download (export) the raw contents of supported docs into QlikView/Qlik Sense.
* Download any Google Drive file to your local machine.
** Note that if you have published a [https://developers.google.com/apps-script/content_service|Google Apps Script] which returns content, you can also use the connector to read the response from this script.
* List and load your Google Spreadsheets into QlikView / Qlik Sense as tables.