topic Filelist function using DFS file location in QlikView

Filelist function using DFS file location

sibrulotte — Thu, 11 Nov 2021 16:32:06 GMT

Hi,

I'm using a filelist funciton to retrieve file names without opening the files.

This works great with file server locations, or relative locations, but the minute I try to use a DFS file location:

For Each File in FileList('\\Fondsftq.com\Rapports\EpargnantOperationnel\SendLog_*.csv');

It breaks down. It's weird because I can use this path in a regular load function without any problems.

I'll say it right now: I can't get the files elesewhere. It isn't owned by my department, so I have no say in where they lay.

Can anyone cue me on a proper way to specify the path correctly?

Re: Filelist function using DFS file location

sibrulotte — Fri, 12 Nov 2021 21:12:42 GMT

from what I'm reading DFS is not truly suported by Qlik, so I'm even lucky to have a from that works...

Any other cues are helpfull.

Re: Filelist function using DFS file location

marcus_sommer — Sun, 14 Nov 2021 14:07:00 GMT

We have in our company a global network-share which is by the most users mapped with I:\ but the real path behind looked like:

\\<DOMAIN.NAME>\<dfsroot>\<path>

If I take the information from here literally:

Distributed File System (Microsoft) - Wikipedia

it's a DFS and I could not only load from there directly else the filelist() worked, too.

This means it seems to work in general but if I understand the information right there exists multiple implementations for a DFS so that it depends on various factors.

I think you should ask your IT to the specifics of your company-implementation and the applied rules and configurations and with it you may be more successful by investigating the matter within the community and/or the global internet (I could imagine that there are more tools/processes which may have their struggles with this kind of storage).

- Marcus

Re: Filelist function using DFS file location

sibrulotte — Tue, 16 Nov 2021 19:21:47 GMT

this is awkward... I was missing an s in my path and it had NOTHING to do with DFS or what not. lol

Sorry for wasting your time Marcus...