Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sibrulotte
Creator III
Creator III

Filelist function using DFS file location

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?

3 Replies
sibrulotte
Creator III
Creator III
Author

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.

marcus_sommer

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

sibrulotte
Creator III
Creator III
Author

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...