Hi guys - thanks Youssef for tagging me - there are a few ways that ContenAdmin roles (role defined in the QMC for the user) can have access to file-based data.
If the excel data columns remain the same and the data files are updated an refreshed / replaced - you may want to use this approach:
- You can provide them with data connection Folder access (Folder is a type of data connection) - which will allow them to access folders on the enterprise server - this can be drive letters (d:\folder) and UNC (\\computer\share) - that way the files they use are always stored in one place (in that drive location) and can be updated / overwritten as if needed (this can be locked down further with security rules and windows security)
This video (slightly older interface) but still applicable:
Loading Excel and File Data (video)
- They can upload (or attach) files to an app - this actually makes the file available as an object as part of the app - they can actually use local files on their machines and attach them to a the Qlik Sense Enterprise server app they create. However if the Excel data is refreshed / updated - in order to reflect this in their app - they need to attach a new file each time and reload the data manually in the app. This is a manual step - where as the previous step can be automated with a task as new data comes into the folder location on a regular basis.
Here is an older video on the topic - but it is still applicable:
Qlik Sense - Attaching local data files
They can also use Dropbox - where they store files on a dropbox folder and use the dropbox connector to access that.
Please keep in mind all of this can be controlled via security rules - which is another topic and help is available in our online help site.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Regards,
Mike T
Qlik
Regards,
Mike Tarallo
Qlik
