Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
after spending 2hours to solve a problem, I'd like to know if there is a more comfortable solution.
Do you know a solution?
I've got this scipt
Load
filename() as SourceZeitnachweis_StrukturVor2017,
*
FROM
[$(varSource)Daten-Zeiterfassung\BestNr*.xlsx]
(ooxml, embedded labels);
STORE Zeitnachweis_Struktur2017 INTO ..\300-QVD\Zeitnachweis_Struktur2017.qvd (qvd);
DROP Table Zeitnachweis_Struktur2017;
In the Log of this document I only see the filename with Wildcard for each sourcefile.
How can I change the Skript to get the complete filepath in the Log?
I tried to use Trace, put can't find a solution to get the path.
I like to find the file who has the wrong permission, so that a load did not run.
In real life I found the file while trying to copy it to a test-Location.
Thanks in advance.
Benjamin
I suggest to use a filelist-loop instead of a wildcard-load - here an example: Load-a-sequence-of-qvd-files. The log should show all filenames and you could also TRACE the file-variable and furthermore apply various checks and/or ERRORMODE to skip unwanted files.
- Marcus
And how can I get the path of the file.
Like I said "I tried Trace".
I suggest to use a filelist-loop instead of a wildcard-load - here an example: Load-a-sequence-of-qvd-files. The log should show all filenames and you could also TRACE the file-variable and furthermore apply various checks and/or ERRORMODE to skip unwanted files.
- Marcus
Great solution. Thank you.