Thanks for the thread so far - great info, as we depend on Dropbox as well.
I see the connector, and can set up and test a connection through to my Dropbox files - but the connection fails as soon as I try to use it - and asks me to authenticate again.
I've tried repeatedly, and with different browsers. I get all the way to selecting actual spreadsheet data, but on load it fails.
Any insight would be greatly appreciated, as 15 December looms near.
I seem to recall having a similar issue a while back. Eventually loaded the data as a pipe "|" delimited CSV file. Also watch for the 'codepage' setting.
SQL SELECT "DocumentType", "DocumentNumber", "OrderNumber" FROM CSV (header on, delimiter "|", quote """") "CSV_source"....
It seems to be working here for me. Only playing about with test data at the moment though.
I thought that it had disconnected once, but I now notice that each time you click to edit the connection it tells you that it needs authentication again. It's lying. Don't go into the edit connection once you have it set up.
I've got two apps I need to port to QSB which loop round hundreds of spreadsheets, that I am hoping to use DropBox for. I should be porting that this week and can post back with how I get on.
Is there anything in your Dropbox logs that indicates a problem? Do you receive an email advising of a login from a new device when connecting? If so, you need to click the button to say that you are aware of the connection, or I can imagine it might bin the link.
1. I have confirmed Dropbox sees the connector - when I log into Dropbox independently, I see the Qlik connector with full r/w/e permissions. Oddly enough, when I click on the Qlik hyperlink from within Dropbox, it sends me to the old Qlik Sense login screen, not the new Qlik Sense Business login screen - even when I set the connector up from the new portal.
2. Yes, I see that same request for authentication each time I try to edit the connector. But even if I set the connector up for the first time, and go straight to load, the load fails - and nothing is written in the code page. The old connector would insert
LIB CONNECT TO [Dropbox - xxx@xxx.com (qlikcloud_qlikid_xxx)]; after the unqualify statement
I have tried deleting the old 'qlikcloud' reference - it then fails on load from the Load Editor 'Dropbox - xxx@xxx.com not found'
3. I know the connector is at least partially working, because once I set it up, it allows me to navigate through to my Dropbox file structure to select the data... and then fails on load: 'Data could not be added to Data manager. Please verify that all data sources connected to the app are working and try adding the data again.'
You no longer need to have the user name as part of the connection in Qlik Sense Business. Also, I would be weary of having the @ symbol in the connection name - just in case.
My connection is simply called Dropbox, and because each tenant is in it's own Kubernetes container that is fine, there is no contention with everyone else's connection name.
Suggest trying a simpler connection name. Hope this works out.
Okay. I've been running in Edge on QSB for about half an hour now without disconnection. Not conclusive that it is entirely stable that way, but it looks good.
Also, I've got a Dropbox connection just like @prevailance and it works fine with the @ symbol and all. Not sure why my set up is different.
What I'm not able to do though is enumerate around all files in a folder, either using a * in the FROM statement or a FileList statement.
I can see that Qlik Web Connectors has a method for downloading a filelist:
All, thanks for your help on this. I believe I have found a solution, although a bit cumbersome:
1. I truncated the Connector name to Dropbox, as suggested - just to get rid of the @ issue
2. I have to DISABLE 'Data Profiling' in the lower right corner of the screen when viewing the Excel/CSV data in Dropbox before clicking Add Data
3. The LIB function will automatically read "LIB CONNECT TO [Operations:Dropbox];" In this case I have set up 'Operations' as one of our 'Spaces', and this application is assigned to that Space. The name 'Dropbox' is my connector name.
4. The trouble is, once the LIB is defined, it tries to pull from a path that does NOT include 'Operations'. It tries to pull from "FROM [lib://Dropbox/folder1/folder2/datasource.xlsx]" I have to manually unlock the auto generated section and correct the path to '[FROM [lib://Operations:Dropbox/...]
