topic Re: Dropbox connector for Qlik Sense Business in Connectivity & Data Prep

Dropbox connector for Qlik Sense Business

CDM — Thu, 03 Oct 2019 08:37:34 GMT

Hello,

Is it me, or the Dropbox connector is missing in Qlik Sense Business?

Thanks for your support

Re: Dropbox connector for Qlik Sense Business

stevedark — Tue, 08 Oct 2019 22:59:35 GMT

Hi,

It's not just you. I've found it's not there for me either. It's an odd omission given some of the other connectors which are there. The straight Web connector is also conspicuous by it's absence.

All is not lost though, as you can use the REST connector and a link to the file generated from Dropbox.

Right click on a file in Dropbox and select Copy Link.

In Sense click Create Connection and select REST.

Paste the URL in the URL box, and edit the end of it so that it reads dl=1 (rather than 0).

Give the connection a name and click Create.

You can then use the Select Data icon on the connection to load from that file.

This would be a pain, as you would have to have a separate connection for each file in DropBox, but WITH CONNECTION can deal with this. You can point a script to a different file by amending the URL in the script, like this:

SQL SELECT
"Customer",
"Date",
"Ticket No",
"Task",
"Hours",
"Who"
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION
(URL "https://www.dropbox.com/s/xxxxxxxxxxxxxxxx/customertickets-prior3months.csv?dl=1");

This will then load from a different URL to the one you created the connection with. Obviously you will need to hand-craft the select part and file format specifiers as you change the file this way.

It's not an ideal solution (the authentication with DropBox was much simpler) but it does work.

I suspect that the issue is that as the new Cloud Business is hosted somewhere different they need to go through the process of being able to authenticate with DropBox again. Hopefully this will be done soon and we can be back to full functionality.

Cheers,
Steve

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

Re: Dropbox connector for Qlik Sense Business

CDM — Wed, 09 Oct 2019 05:48:21 GMT

Thanks a lot for your fully response.

By the time a proper connector will be setup, I will go this way.

Have a good day.

Cheers.

Cyrill

Re: Dropbox connector for Qlik Sense Business

stevedark — Wed, 09 Oct 2019 07:12:32 GMT

Hi Cyrill,

I spotted a post later on last night saying that they are trying to get it working, and it will be with us in the next couple of months.

Good to know it's not been intentionally dropped.

Have a great day yourself.

Re: Dropbox connector for Qlik Sense Business

robert99 — Sun, 20 Oct 2019 21:58:09 GMT

Hi Steve

I tested this and it doesn't work

What are the other setting. Maybe these are not correct

https://www.dropbox.com/preview/********/Tesseract%20Excel/AbsenceReport.csv?dl=1

I had role=personal on the end and took this out and replaced with dl=1

The other setting are shown below

Thanks

Re: Dropbox connector for Qlik Sense Business

robert99 — Sun, 20 Oct 2019 21:56:38 GMT

@stevedark

Re: Dropbox connector for Qlik Sense Business

stevedark — Sun, 20 Oct 2019 22:07:27 GMT

Hi,

The word preview in the URL makes me think that this URL is to show the file on the dropbox site, rather than a straight download. Is there another option for copying a link?

When you use the link it should download the file, rather than showing it in the browser.

Good luck,

Steve

Re: Dropbox connector for Qlik Sense Business

robert99 — Sun, 20 Oct 2019 23:08:07 GMT

Hi Steve

Thanks for your reply

When I used web file connector to connect to Dropbox I didn't get private in the address. So something is different now

But Ive done some more work and still haven't been able to connect

Ill keep on trying for a bit.

Thanks Robert

Re: Dropbox connector for Qlik Sense Business

stevedark — Mon, 21 Oct 2019 06:57:29 GMT

The method I mentioned was just using the REST connector, not a specific Web File Connector. The URL was generated by right clicking on the file in File Explorer and selecting Copy Dropbox Link.

Hope that helps.

Re: Dropbox connector for Qlik Sense Business

robert99 — Mon, 21 Oct 2019 07:51:57 GMT

Hi Steve

Yes I know.

But before the Dropbox connector was released for QSCB I used the web File connector (I think) to connect to Dropbox.

From memory I got the address like you got (s not private etc)

So something is different.

Its not a big thing for me as I was only testing this out of interest as I hadn't used the Rest connector before

I might do a bit more investigation when time permits

Thanks Robert

Re: Dropbox connector for Qlik Sense Business

robert99 — Tue, 22 Oct 2019 20:19:10 GMT

So I got it to work

I had to use the 'Copy Dropbox Link' for the file in the dropbox folder on my computer

For some reason using the cloud didn't work (as it did before as I never had the files on my desktop)

So thanks to Steve for this solution

Re: Dropbox connector for Qlik Sense Business

stevedark — Tue, 22 Oct 2019 20:35:37 GMT

Great news! Thanks for updating back to the forum.

Let's hope they fix the connector soon (I have a client with 150+ files) as the work around is only helpful if you can copy a link for each file easily.

Steve

Re: Dropbox connector for Qlik Sense Business

johngouws — Wed, 23 Oct 2019 02:27:03 GMT

Hi @stevedark and @robert99 . This is going to be a busy section over the next few months!

Will this solution also be able to work with QVDs as well?

Thanks.

Re: Dropbox connector for Qlik Sense Business

stevedark — Wed, 23 Oct 2019 07:08:11 GMT

I've not tried, but I see no reason why it would not work.

Re: Dropbox connector for Qlik Sense Business

johngouws — Thu, 24 Oct 2019 02:50:04 GMT

Interesting. I stored the same data as in the QVD, to a piped delimited file. I does not seem to be able to 'translate' the QVD but the piped delimited file no problem.

Re: Dropbox connector for Qlik Sense Business

johngouws — Thu, 24 Oct 2019 04:30:59 GMT

Thanks for this solution. I had to use csv's for now, but it is an very good option for now.

Re: Dropbox connector for Qlik Sense Business

johngouws — Tue, 29 Oct 2019 04:36:13 GMT

Hi @stevedark and @robert99 .

I used your solution for testing and it worked great. I tried reloading the App this morning and received a 'redirect not allowed' error. Also tried with a new connection and got the same error. I finally got Business to buy-in but they wanna see current data in a demo. Are you able to see if your solutions still reloads. I still have 19 days of the trial left so that should not be an issue.

Thank you very much.

Re: Dropbox connector for Qlik Sense Business

robert99 — Tue, 29 Oct 2019 07:06:43 GMT

Hi John

Its also not working with me. For the same reason you got

Re: Dropbox connector for Qlik Sense Business

johngouws — Tue, 29 Oct 2019 07:06:02 GMT

Hi Robert,

Thanks for checking. I can't believe it. What is really annoying is that I just managed to sell this idea to Business. Now it looks like something has changed or disabled.

I am starting so wonder why this is called Qlik Sense 'Business'?

Re: Dropbox connector for Qlik Sense Business

robert99 — Tue, 29 Oct 2019 07:10:42 GMT

Contact support. They are usually quick at getting back

The other option to allow the demo is to update the file. Although I have had issues uploading all but the smallest files