Why my Mapping script not allow me to change the file name from MapBrand to MapBrand_ ?

[paulyeo11]

Hi All

Step 1) I have below script working fine , when i reload i don't get any error msg :-

Map_Brand_TDS:
Mapping LOAD
[Brand_],
[SubBrand_]
FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand.xlsx (ooxml,embedded labels, table is [BRAND]);

Step 2)

I try to modify the below script , on Excel file name from MapBrand.xlsx to MapBrand_.xlsx

FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand_.xlsx (ooxml,embedded labels, table is [BRAND]);

Step 3)

I get erroe msg below :-

Cannot open file 'C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand_.xlsx'

Step 4)

I go to directoru folder :-
C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\

I change the excel file name from MapBrand to MapBrand_

When i reload i still get error msg below :-

Cannot open file 'C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand.xlsx'

Which is wrong , because the load script is below :-

FROM C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\Raw Data Input\MapBrand_.xlsx (ooxml,embedded labels, table is [BRAND]);

Step 5)

I change the load script and folder name excel file to MapBRand , now it work fine.

Hope some one can advise me.

Paul Yeo

[paulyeo11]

Hi All

I make a video to sumilate my issue.

https://www.dropbox.com/s/h5q5vrtsi0ys0th/2019-11-25%2011-19-43.mp4?dl=0

Paul Yeo

[Brett_Bleess]

Paul, I did not have time to watch your recording, but in reading through your post, the one thing that stood out was you having a mismatched filename between the actual file and the load script...  Need to be sure you change both at the same time.  I could not recall if underscore was a valid character, but it appears it should be fine, and I ran a test myself on a file, and things work fine for me, so I think the issue has to do with something other than the filename... Be sure what you are specifying in the load script matches what you have as name in the directory from which you are trying to load and that should work.

I think I just figured out the issue though, here is my From statement, notice the [ ]'s around the path and filename due to spaces...

FROM
[C:\Documents\QVInstalls\Tools\Easter Egg Settings\Engine Easter Egg Integer Settings_.xlsx]
(ooxml, no labels, table is [Engine Easter Egg Integer Setti]);

Regards,
Brett

[paulyeo11 · Accepted solution]

Hi Sir

I have found the issue , it is cause by accidentally I have double entry of the above load script. And when I edit the first load script , it will not work , after I have delete the duplicate load script now it work fine. Thank you for your sharing.

-Pleasetypeyourreplyabovethisline-
Paul Yeo
Director
TDS Technology (S) P/L
WhatsApp +6593261804