topic Re: Extract File - Multiple file upload issues in QlikView

Extract File - Multiple file upload issues

Tue, 06 May 2014 13:25:04 GMT

I have a script which extracts information and saves it in the format that I require but the only trouble is that this only works with a single file upload. I have lots of spreadsheets to extract all with the word timetable in I should be able to just do a *timetable* command.

The command appears to work but there seems to be something wrong with the script itself and the script stalls and doesnt complete the upload

Ive attached a copy of the extract QVW and three source files

Help

PS the extract file fills in the blank lines on the left hand side this is what i need it to do

Re: Extract File - Multiple file upload issues

its_anandrjs — Tue, 06 May 2014 13:43:40 GMT

In your load script add to commands

FileBaseName as FileBaseName,

FileName() as FileName

and check how many files getting loaded

Re: Extract File - Multiple file upload issues

Tue, 06 May 2014 14:00:22 GMT

None get loaded QlikView crashes on load

Re: Extract File - Multiple file upload issues

rustyfishbones — Tue, 06 May 2014 14:05:41 GMT

It's crashing because they are not csv files, they are excel files

Re: Extract File - Multiple file upload issues

its_anandrjs — Tue, 06 May 2014 14:08:55 GMT

Then files that you provide it is xls file please check attached and use this commands in load script for check how many files loaded

Load

FileBaseName as FileBaseName,

FileName() as FileName

From Location;

Re: Extract File - Multiple file upload issues

rustyfishbones — Tue, 06 May 2014 14:11:13 GMT

Yes you can use *timetable*.xls

Re: Extract File - Multiple file upload issues

its_anandrjs — Tue, 06 May 2014 14:13:31 GMT

On the load script you can try this also

FROM

M:\GVK WIP\TMS\TT\*Timetable*.xls

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Extract File - Multiple file upload issues

rustyfishbones — Tue, 06 May 2014 14:18:50 GMT

Glenn you need to check your STORE procedure.

You have not defined it as a qvd

you have

STORE TMSData INTO TMSData.QVD;

it should be

STORE TMSData INTO TMSData.QVD(qvd);

Re: Extract File - Multiple file upload issues

Tue, 06 May 2014 15:10:52 GMT

Thanks.. missed that one, changed the line you suggested by it still doesnt work 😞

Re: Extract File - Multiple file upload issues

Tue, 06 May 2014 15:15:13 GMT

I've already got that command in

Re: Extract File - Multiple file upload issues

rustyfishbones — Tue, 06 May 2014 15:37:48 GMT

what error are you getting?, it should work now

Re: Extract File - Multiple file upload issues

Tue, 06 May 2014 16:33:37 GMT

No error message. QlikView just stalls and locks up. Its not the volume. I store far larger files with no issues