topic Re: Include statement using UNC syntax to load from different machine in QlikView

Include statement using UNC syntax to load from different machine

Tue, 05 Nov 2013 13:40:22 GMT

Hi all,

i am encountering a problem with the include statement.

Due to our hosting setup for server distributed applications we have the requirement to manually adjust parameters in the QV applications on the server.

What i wanted to do is having a script file located on our group network drive where the application owner can adjust parameters which are used in the QVW located on the server.

The include statement i wrote is like:

$(Iinclude='\\groupnetworkdrivename\config\parameters.txt')

But it seems that the include can not handle UNC located sources and does not read the parameters.txt from the groupnetwork drive.

Any ideas?

Markus

Re: Include statement using UNC syntax to load from different machine

swuehl — Tue, 05 Nov 2013 13:49:18 GMT

UNC works for me.

Have you tried correcting the typo in include and removing the single quotes?

Re: Include statement using UNC syntax to load from different machine

jonathandienst — Tue, 05 Nov 2013 13:51:42 GMT

I use UNCs in include statements like this:

$(Include=\\myserver\Scripts\helpsheet.include.qvs);

Using V11.0 SR2, but it worked in V10 as well.

Regards

Jonathan

Re: Include statement using UNC syntax to load from different machine

Clever_Anjos — Tue, 05 Nov 2013 13:55:50 GMT

It does work, as below. I rather use "Must_include" because it generates error if the file is not found, what makes me check

///$tab Main
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';
SET DayNames='seg;ter;qua;qui;sex;sáb;dom';
$(Include=\\srvswbbi\Qlikview\Includes\Qvc.qvs);

Re: Include statement using UNC syntax to load from different machine

Tue, 05 Nov 2013 14:03:09 GMT

Hi,

thanks for the hints. I am also still investigating. Just wanted to be sure if this might be a general problem or not.

Also removing the quotes did not help to solve the problem.

Cheers

Markus

Re: Include statement using UNC syntax to load from different machine

jonathandienst — Tue, 05 Nov 2013 14:06:30 GMT

Did you remove the extra i n include as well (or was that just a copy and paste thing)?

Re: Include statement using UNC syntax to load from different machine

Tue, 05 Nov 2013 16:32:07 GMT

The typo was just a copy and paste thing.

Managed to get it running. There was a space in the string that caused the problem.

Thanks again for the hints. This reduced the potential errors i had to look after.

Cheers

Markus