topic Re: Create a filename for ServerSideExportEx based on variable in QlikView

Create a filename for ServerSideExportEx based on variable

leenlart — Thu, 08 Nov 2018 11:34:01 GMT

Hello,

This seems like it should be SOOO SIMPLE but I'm pulling my hair out :

I have table that the user will choose to save using a button.

In my vbscript for the button, I am trying to modify the path and name where the ServerSideExportEx saves the file.

This works:

tb.ServerSideExportEx "D:\QlikView_documents\Developpement\1-Sources\XML\Provisions.xml" , ";" , 3 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

But I'd like to pass the path and the file name as variables.

The file name will be "Provisions_" & [year - month selected].

My file path and the year-month selected are both variables in the qwd, so I tried this :

set dateProvisions = ActiveDocument.Variables("vDateProvision")

set pathProvisions = ActiveDocument.Variables("vRepSourcesXml")

set fileName = "Provisions_$(vDateProvision).xml"

This bombs.

My next work-around was to create a variable in the qwd that saves the file name as "Provisions_"&$(vDateProvision)&".xml"

I can't get my variable to work correctly either!

In the variables menu, I set the variable to "Provisions_"&$(vDateProvision)&".xml" -- no good.

Then I tried concat("Provisions_",$(vDateProvision),".xml") -- also no good.

Does anyone have any suggestions ?

Thanks!

Re: Create a filename for ServerSideExportEx based on variable

jerrysvensson — Thu, 08 Nov 2018 12:12:44 GMT

set dateProvisions = ActiveDocument.Variables("vDateProvision")

fileName = "Provisions_" & dateProvisions.GetContent.String &".xml"

Re: Create a filename for ServerSideExportEx based on variable

leenlart — Fri, 09 Nov 2018 07:52:56 GMT

Opps, I forgot to mention that I tried that originally.

This is where my vbscript stops.

Re: Create a filename for ServerSideExportEx based on variable

petter — Fri, 09 Nov 2018 11:23:35 GMT

How does the content of the vDateProvision look like - and how does the content of dataProvisions look like exactly?

Re: Create a filename for ServerSideExportEx based on variable

jerrysvensson — Fri, 09 Nov 2018 11:40:23 GMT

I agree with Peter.

Use MsgBox dateProvisions.GetContent.String to look at the value.

Re: Create a filename for ServerSideExportEx based on variable

leenlart — Fri, 09 Nov 2018 11:48:10 GMT

In my variables I set vDateProvision to this :

And when I run my script, I get

for info DateProvision is the Date selected.

Re: Create a filename for ServerSideExportEx based on variable

leenlart — Fri, 09 Nov 2018 11:49:34 GMT

to be clear, the msgbox is showing the following:

set dateProvisions = ActiveDocument.Variables("vDateProvision")

ActiveDocument.GetApplication.MsgBox( dateProvisions.GetContent.String)

Re: Create a filename for ServerSideExportEx based on variable

jerrysvensson — Fri, 09 Nov 2018 12:10:36 GMT

So then

fileName = "Provisions_" & dateProvisions.GetContent.String &".xml"

Should work

By the way. This is incorrect:.

Set fileName = "Provisions_" & dateProvisions.GetContent.String &".xml"

Re: Create a filename for ServerSideExportEx based on variable

leenlart — Fri, 09 Nov 2018 12:54:59 GMT

I just took out the set.

It still doesn't work!

A new idea, can I set the file name directly in the tb.ServerSideExportEx line ?

I just tried this :

tb.ServerSideExportEx pathProvisions & "\" & "Provisions_" & dateProvisions.GetContent.String & ".xml", ";" , 3

But it didn't work...

Is there some way to run a debugger, or to get an error message ?

Re: Create a filename for ServerSideExportEx based on variable

jerrysvensson — Fri, 09 Nov 2018 13:32:44 GMT

MsgBox pathProvisions & "\" & "Provisions_" & dateProvisions.GetContent.String & ".xml"

Is unfortunately the only way out..

Re: Create a filename for ServerSideExportEx based on variable

jerrysvensson — Fri, 09 Nov 2018 13:33:48 GMT

Does the QlikView server account have write access to the path?

Re: Create a filename for ServerSideExportEx based on variable

leenlart — Fri, 09 Nov 2018 13:49:41 GMT

The msgbox doesn't run.

So do you think that my dateProvisions is not a string - could that be the problem?

The server does have write access, cause if I leave it as :

tb.ServerSideExportEx "D:\QlikView_documents\Developpement\1-Sources\XML\Provisions_201809.xml" , ";" , 3

It works fine.

Re: Create a filename for ServerSideExportEx based on variable

jerrysvensson — Fri, 09 Nov 2018 14:01:50 GMT

Strange

I would try:

MsgBox pathProvisions.GetContent.String

MsgBox dateProvisions.GetContent.String

Just to make sure everything is ok.

And then start adding them together one after the other. Using MsgBox

Re: Create a filename for ServerSideExportEx based on variable

leenlart — Fri, 09 Nov 2018 14:16:59 GMT

Ok, so your method helped. Thanks!

Here is the final thing that works correctly :

Sub Save_Provisions

dim dateProvisions, fileName

set tb = ActiveDocument.GetSheetObject("TB24")

set dateProvisions = ActiveDocument.Variables("vDateProvision")

set pathProvisions = ActiveDocument.Variables("vRepSourcesXml")

tb.ServerSideExportEx pathProvisions.GetContent.String & "\" & "Provisions_" & dateProvisions.GetContent.String & ".xml", ";" , 3

end sub

I was missing a .GetContent.String after pathProvisions.

Thanks so much for your help.

Re: Create a filename for ServerSideExportEx based on variable

petter — Wed, 14 Nov 2018 06:45:59 GMT

As Jerry pointed out if dateProvisions really is a variable object then dateProvisions.GetContent.String should work. But if dateProvisions is not a variable object or nil then it will fail.