Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Upload data in a QVW on Access Point?

Hi All,

Suppose my QVW is available on Access Point. Now I want to give access to my Users to upload few values to a List Box. For example, there is a List Box called Country with values USA,INDIA,CHINA. Now one user wants to add few more values ex: JAPAN, AUSTRALIA to the Country List Box so that other users can Export the latest data. This task should be User oriented. User should upload the latest data to the QVW file without the help of Developer.

Is it by any chance possible from Access Point (IE Plugin/AJAX), without opening the QVW file in developer mode?

If not, are there any other methodologies without touching the original QVW file, like any Input Box usage, or use of Excel Data etc etc.

Please cite some suggestions.

Regards!!!.

17 Replies
jonasheisterkam
Partner - Creator III
Partner - Creator III

You must change the Folder in the macro, if you don't have it or not enough rights on it. I don't know if you must set the options again to allow unsave macros and give them right to enter the hdd. If the first Action Dynamic Update not being pushed there is some option on Document Properties -> Server i think.

dmohanty
Partner - Specialist
Partner - Specialist
Author

Hey Jason, 

Thanks a Lot.

Got the logic from your help. Now one by one values are getting added to the List Box.

But this is happening only in Desktop Mode without reloading even. Perhaps the Macro is not functioning when the Button is clicked in the docuemnt opened from Access Point. Could you please suggest? Any regular reload required?

Could you please also let me know how to remove those inserted values from the List Box?

jonasheisterkam
Partner - Creator III
Partner - Creator III

Use it like the insert action. It will delete if you select one value in Dim1 and execute the action.

='DELETE FROM Transactions where Dim1='&chr(39)&only(Dim1)&chr(39)&'

Have you allow unsave Macro on server? My test on a server was positive.

dmohanty
Partner - Specialist
Partner - Specialist
Author

Yes Jonas,

Allow Unsafe Macros is enabled on Server. Still it didnt worked.

jonasheisterkam
Partner - Creator III
Partner - Creator III

Has youre server user write rights in the export folder? The folder is on the server not local (ServerSideExport).

The Server i used has this Setup Server Security:

Allow dynamic data update

Allow macro execution on server

Allow unsafe macro execution on server

Under Documents all options are allow

If you copy it in a other document, you must change document settings with QV-Client for Server and the macro options.

dmohanty
Partner - Specialist
Partner - Specialist
Author

Jonas,

I have all the settings enabled as you have said. Also export location is on server.

Still clueless why the Macro (Button) not working on Access Point.

Anonymous
Not applicable

My "solution" is for one value.  Anything else should involve reload, which is either EDX as Jonas Heisterkamp recommends, or frequently running scheduled reload, if possible.

You still can use a variable to enter additional value, reload, change variable value, reload, etc.  See attached example.

Regards,

Michael

dmohanty
Partner - Specialist
Partner - Specialist
Author

Thanks a lot Michael.

It helped me a lot in learning more.

Could you please also help me out in the below thread?

http://community.qlik.com/thread/98718

Regards!!