topic Re: Problem exporting user selection in QV12 in QlikView

Problem exporting user selection in QV12

Tue, 06 Jun 2017 12:59:21 GMT

I wonder if anyone can shed light on this. I'm running QV12 without the IE plugin and want exports to Excel to include the user selection by default.

I've tried adding the statement:

SelectionStampInBIFFExport=1

to the Settings.ini file on the server but that doesn't appear to have done the job. I actually found two Settings.ini files, in different subfolders of the following on the server: Windows & ProgramData. I believe the one in ProgramData is the correct one but I've tried both just to be on the safe side.

I've ensured that I've restarted the services (all services in fact, to be absolutely sure I was restarting the right one) at each stage, but still no luck. When I go to a document on the Access Point and export to Excel I don't get the user selection.

I'm scratching my head in confusion now. Any ideas?

Thanks in advance,

Mike

Re: Problem exporting user selection in QV12

felipedl — Tue, 06 Jun 2017 20:42:56 GMT

Hi Mike,

Try checking the below setting and then export again.

If that doesn't work, try this:

Export Current Selections to Excel by Default

Regards,

Felipe

Re: Problem exporting user selection in QV12

Wed, 07 Jun 2017 07:30:23 GMT

Thanks Felipe, but I'm afraid the answer isn't quite so simple.

Its not my user preferences that are the issue, but the users. As we've moved to version 12 and are no longer using the IE Plugin the users are not able to set their own user preferences. In theory it can be set at server level, using the method I described above, but for some reason that appears not to be working for me:(

Thanks for your thoughts anyway though.

Mike

Re: Problem exporting user selection in QV12

felipedl — Wed, 07 Jun 2017 13:43:02 GMT

The link I provided should be the setting done to the server.

Export Current Selections to Excel by Default

I tried it here but had no luck with that.

Re: Problem exporting user selection in QV12

Wed, 07 Jun 2017 14:38:23 GMT

My apologies, I hadn't the link at the end of your post.

With the exception of the line about server collaboration that was the same process I'd already tried. I added that line in anyway to see if it would help - though it doesn't seem obvious that server collaboration should make a difference.

Unfortunately the result was the same - no export of the current selection.

Thanks very much for your input all the same.

Mike

Re: Problem exporting user selection in QV12

Mon, 19 Jun 2017 12:38:39 GMT

I found out the correct answer. I did need to add:

'SelectionStampInBIFFExport=1'

to the Settings.ini file, but immediately after the first line:

'[Settings 7]'

Once I'd done that it worked a treat.

Mike

Re: Problem exporting user selection in QV12

felipedl — Mon, 19 Jun 2017 13:13:53 GMT

Awsome,

Glad to know it helped.

Felipe.