[resolved] Exception in component tFileInputExcel_1
Hello Guys, I am trying to load the data from the XLS files inside sub directories to MYSQL. Basically there is a parent directory and inside that there are many sub directories in which XLS files are stored. i am getting below error. Starting job Mult_file at 02:52 11/08/2016. connecting to socket on port 4054 connected Exception in component tFileInputExcel_1 java.io.FileNotFoundException: C:\Users\Dinesh\Desktop\Investment\Input Files\XLS\Dec_15 (Access is denied) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.<init>(Unknown Source) at java.io.FileInputStream.<init>(Unknown Source) at test1.mult_file_0_1.Mult_file.tFileList_1Process(Mult_file.java:1619) at test1.mult_file_0_1.Mult_file.runJobInTOS(Mult_file.java:2788) at test1.mult_file_0_1.Mult_file.main(Mult_file.java:2645) disconnected Job Mult_file ended at 02:52 11/08/2016.
In tFILELIST_1 the directory path is set to "C:/Users/Dinesh/Desktop/Investment/Input Files/XLS" Please note that i am able to load all the excels from a directory if sub directories are not there. ie , if i define directory path as C:\Users\Dinesh\Desktop\Investment\Input Files\XLS\Dec_15 in tFileLIST_1. Please help. System : Windows 7 64 Bit Thank, Vanijyagyan
Are you setting a file mask in tFileList? If not, it is probably returning every file in the directory tree. Limiting it to *.xls and/or *.xlsx might do the trick.
Thanks cterenzi. I tried the approach you suggested but it didnt work. However i am able to resolve this issue by setting Filelits Type to "Files". Earlier it was set to "Both" Thanks, VG
If the issue is closed, could you please click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.
