This script get error msg :- FROM $(vRAWPath)$(vFile131)(ooxml,embedded labels, table is [AR_PMC]);

[paulyeo11]

Hi All

Below Quote working fine no error :-

SET vDevelopment = 1; //server = 0 // =1 for PY // =2 for PY sample // =3 for Xa.
IF $(vDevelopment) = 0 THEN
elseif $(vDevelopment) = 1 then
SET vRAWPath = 'C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\'; //local folder
SET vINPUTPath = 'C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\'; //local folder
SET vQVDPath = 'C:\Users\QV\Dropbox\QV_QVD\'; //server folder
SET vFile131 = 'AR_PMC.xlsx';
elseif $(vDevelopment) = 2 then
else
SET vRAWPath = 'C:\Users\Eksa\Dropbox\QV_RAW\'; //local folder
END IF

// AR COUNTRY A
Payment:
LOAD
'PMC' as SOURCE,
[Customer/Vendor Code] as [cust_id_ar],
[Customer/Vendor Name] as company_ar,
Today() - Date( Date#([AR Invoice Date], 'DD.MM.YY'), 'DD/YY/YYY') as [total number of day due],
[Outstanding w/o Tax (LC)] as total_ar
FROM [C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\AR_PMC.xlsx]
(ooxml, embedded labels, table is AR_PMC);

I try to modify the above script using PATH access.

// AR COUNTRY A
Payment:
LOAD
'PMC' as SOURCE,
[Customer/Vendor Code] as [cust_id_ar],
[Customer/Vendor Name] as company_ar,
Today() - Date( Date#([AR Invoice Date], 'DD.MM.YY'), 'DD/YY/YYY') as [total number of day due],
[Outstanding w/o Tax (LC)] as total_ar
FROM $(vRAWPath)$(vFile131)(ooxml,embedded labels, table is [AR_PMC]);

I get below error :-

Cannot open file 'C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\AR_PMC.xlsx'
Payment:
LOAD
'PMC' as SOURCE,
[Customer/Vendor Code] as [cust_id_ar],
[Customer/Vendor Name] as company_ar,
Today() - Date( Date#([AR Invoice Date], 'DD.MM.YY'), 'DD/YY/YYY') as [total number of day due],
[Outstanding w/o Tax (LC)] as total_ar
FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_RAW\AR_PMC.xlsx(ooxml,embedded labels, table is [AR_PMC])

Hope some one can advise me where i go wrong ?

Paul 

[Brett_Bleess]

Paul, I believe the issue may be trying to access C partition on a different machine, if you are running this from the server when you receive the error, but you are trying to hit a local C partition on a different machine, that is going to fail, as the server is going to look at its C partition and the folder will not exist there.  You would need to create a network file share on the local folders such that you could use the UNC path in the variables such that the server would be able to then access those locations...  I am pretty sure this is the issue, please clarify if not.

Regards,
Brett

[paulyeo11 · Accepted solution]

Hi Sir

Thank you very much for your sharing.  I already manage to solve the problem. I think the issue is due to AR_PMC raw data file i not save at correct folder.

Paul