topic Re: File not found in QlikView

File not found

Sat, 30 Aug 2014 02:45:31 GMT

Hi All

i have executed a file with below script, File not found error pops up. Please advise to sort this issue

Directory D:\New folder\SalesOrderBook;

For each ExcelFile in filelist ('*.xlsx')

CORE:

Load

[MERCHANDISING MANAGER]AS MANAGER,

BUYER,

[SEASON CODE],

[PHASE/BUY],

[TOP CATERGORIES],

GARMENTS,

[PACK CODE/DESCRIPTION],

PROGRAM,

RANGE,

[PRODUCT DESCRIPTION],

[ITEM CODE],

[PRODUCT CODE],

[COUNTRY CODE],

COUNTRY,

[MODE-ORIGINAL],

[MODE- REVISED],

PO,

ARTICLE,

[BUYER STYLE ID],

[PACK QTY],

[NO OF PACKS],

[ORDER QTY],

[EX FACTORY ORIGINAL],

[EX FACTORY REVISED],

[IHOD/ACTUAL EX FACTORY],

[FOB PO DATE],

[REVISED FOB],

[CRD/VESSEL DATE],

[EX COUNTRY DATE],

[REVISED EX COUNTRY DATE],

NDC,

[SALES DATE],

[SALES MONTH],

[FOB-PACK],

COMMISSION,

[FOB WITHOUT COMMISSION],

[TOTAL VALUE AS PER ORDER],

[SHIPPED QTY],

[SHIPMENT VALUE],

[INVOICE NO],

[QTY VARIANCE],

[SHIPPED STATUS],

[PLANNED SMV],

[PLANNED CM],

[PLANNED TOTAL VALUE],

[PLANNED CM/MINUTE],

[PLANNED SAH],

[SALES LOCATION],

[CM PORTION FOR SALES LOCATION],

[KGL-CM],

[TLD-CM],

[TAL-CM],

[PAN-CM],

[PRODUCTION QTY KGL],

[PRODUCTION QTY TLD],

[PRODUCTION QTY TAL],

[PRODUCTION QTY PAN],

[SHIPPED QTY KGL],

[SHIPPED QTY TLD],

[SHIPPED QTY TAL],

[SHIPPED QTY PAN]

From $(ExcelFile) (ooxml, embedded labels, table is [CORE$]);

Next ExcelFile;

Re: File not found

evan_kurowski — Sat, 30 Aug 2014 04:14:46 GMT

Jayanthan Sivaloganathan wrote:

Load

...

From $(ExcelFile) (ooxml, embedded labels, table is [CORE$]);

Next ExcelFile;

Hello Jayanthan,

It looks like you may be mixing and matching syntax between .XLS and .XLSX files. I see you have a sheet reference as '[CORE$]'. Usually the '$' in the sheet reference is only used on .XLS files. When I add an extra dollar sign to an attempt to read from an .XLSX file I get an error like this:

Try switching to:
(ooxml, embedded labels, table is CORE)

Re: File not found

Sat, 30 Aug 2014 04:45:40 GMT

Hi Evan

wow, it works now .............thank you cheers..,

Jayanthan

Mafaz Jaufer

Re: File not found

engishfaque — Sat, 30 Aug 2014 04:52:27 GMT

Dear Jayanthan,

Checked to check box "Generate Logfile" and "Timestamp in Logfile Name" for debugging the script, please refer to screenshot.

Logfile will be generated in the same place where qvw file is existed.

In logfile you can easily check that what is happening with script.

Kind regards,

Ishfaque Ahmed

Re: File not found

Sat, 30 Aug 2014 04:58:59 GMT

Dear Ishfaque

Thank you for your information, its useful,

Best Regards

Jayanthan

Re: File not found

Fri, 05 Sep 2014 05:43:24 GMT

Dear Evan Kurowski

suppose If I have a macro enabled workbook,then what should I need to change in the script

Jayanthan

Re: File not found

evan_kurowski — Fri, 05 Sep 2014 06:02:44 GMT

Hello Jayanthan,

In the past I've loaded data into QlikView from macro enabled workbooks without noticing any difference in procedure from non-macro enabled workbooks.

Are you experiencing differences in data load behaviors when a workbook is macro enabled? If so, can you tell if the alteration depends on the content of macro code actually engaged?

Re: File not found

Fri, 05 Sep 2014 06:18:27 GMT

Hi Evan Kurowski

previously, i have assumed that data would not be loaded if i have converted the excel workbook into xlsm.

However,Its fine, i have loaded the data without an issue.

Sorry for the trouble

Best Regards

Jayanthan