Why is my must_include failing?

[richardpayne]

I am attempting to use an include file in my QlikView scripts which contains a calendar subroutine. My include line looks like:

$(must_include=..\..\..\..\INFORMATION TECHNOLOGY\RESTRICTED\QVD\Calendar_Sub.qvs);

I have also tried "MUST_INCLUDE" and "Must_Include", and I've taken care to maintain case sensitivity in my file path. "Include" also fails but, of course, does so silently.

The error I receive is:

$(MUST_INCLUDE failed: Q:\TEST\INFORMATION TECHNOLOGY\RESTRICTED\QVD\Calendar_Sub.qvs

This is the correct path to the file. What would be some reasons why my include fails?

[eduardo_sommer]

Hi,

Is this a network drive? I had a similar problem and the drive was not mapped properly. I could see the drive via Windows Explorer, but not in the script. Then, I used the wizard to insert the Include command and saw the drive was unavailable. When I clicked the drive (inside the wizard) it became available again and worked fine.

Eduardo

[Colin-Albert]

Try

$(must_include=[..\..\..\..\INFORMATION TECHNOLOGY\RESTRICTED\QVD\Calendar_Sub.qvs]); 

[richardpayne]

Yes, it is a network drive and it is available. I have it properly mapped on my PC, which I am reloading from. I cannot use a literal path, as our workflow process will move this file onto another server with the same directory structure.

All of my QVD load statements have a similar form and are working fine.

[richardpayne]

I receive the same error message, but with a "]" at the end.

$(MUST_INCLUDE failed: Q:\TEST\INFORMATION TECHNOLOGY\RESTRICTED\QVD\Calendar_Sub.qvs]

[Colin-Albert]

I believe the include is failing because of the space in the directory name

[eduardo_sommer]

I thought this coul be a problem and created a folder with spaces in the name, but it worked fine

Eduardo

[Colin-Albert]

Can you reference the folder using a UNC path?

[richardpayne]

Yes. That's interesting. I get no error when I change to UNC.

However, I will have to find a way to use relative paths, as I cannot use the UNC when this file moves through the workflow. I am currently in a development server.

*Edit: I also tried the shortened names, like INFORM~1, but this also failed.

[maxgro]

this works forme

relative and with spaces

$(Must_Include=..\downloads\incl\folder with space\include.inc);