topic RE: "Get Files" action unable to detect the file in the folder in Product Forum

"Get Files" action unable to detect the file in the folder

anand060191 — Thu, 09 Mar 2023 05:40:00 GMT

Hi,

Get file action is not able to detect files (Returns output: Count - 0) even if the file exist in the folder.

Key points:

Bot is able to detect files sometimes (on-and-off) so it can't be access related issues or input parameters.
Output Parameters returns following: [Message - Blank, Success - True], Hence no clue from there
Issue is only coming in Production while running from control room (only in few runtime resources)

Any inputs or workaround on this item is highly appreciated.

------------------------------
Anand Singh
------------------------------

RE: "Get Files" action unable to detect the file in the folder

SeemaA — Thu, 09 Mar 2023 05:48:00 GMT

Hi,

What kind of files are you trying to fetching?

Please share the inputs you gave to the action stage.

Regards,

Seema A

------------------------------
Seema A
RPA Developer
Deloitte
Asia/Kolkata
------------------------------

RE: "Get Files" action unable to detect the file in the folder

John__Carter — Thu, 09 Mar 2023 10:27:00 GMT

Key point #3 suggest there might be a synchronisation issue in your logic. Is is possible the Get Files action is returning a truthful result, perhaps because files are not present at the exact moment the call is made? Could the process sometimes be calling Get Files too soon?

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: "Get Files" action unable to detect the file in the folder

SeemaA — Fri, 10 Mar 2023 07:24:00 GMT

As John addressed, it might me synchronization error too, Try capturing screenshot before you call 'Get Files' to verify this

------------------------------
Seema A
RPA Developer
Deloitte
Asia/Kolkata
------------------------------

RE: "Get Files" action unable to detect the file in the folder

anand060191 — Fri, 10 Mar 2023 07:58:00 GMT

@John @Seema

I suspected the file is not copied properly before the bot executes Get Files action. And Hence I Copy file manually few hours before I run the bot again. Yet the bot fails to detect files and returns count Zero.

What puzzles me is that, could that be due to the network connection between bot and Shared Drive(Folder)?

------------------------------
Anand Singh
Programmer Analyst III
Jabil
Penang
+60167427974
------------------------------

RE: "Get Files" action unable to detect the file in the folder

Mukeshh_k — Fri, 10 Mar 2023 10:11:00 GMT

Hi Anand Singh, is it on network path where the files are stored or a local drive where you are trying to access the files and fetch it ? Just before trying and fetching files always ensure that the Directory exists flag gets successful if not already and while fetching the files I hope you are keeping Wildcards to identify and pick the correct files.

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB
------------------------------

Re: RE: "Get Files" action unable to detect the file in the folder

Adnan3194 — Tue, 19 Nov 2024 12:22:08 GMT

Hi.. whenever i try to GET FILE action, the message is displayed. "the illegal characters in path." please guide me how to solve this issue, i am new in Blue Prism. for your reference i attached screenshots of my process

Re: RE: "Get Files" action unable to detect the file in the folder

Chakkravarthi_PR — Tue, 19 Nov 2024 13:58:30 GMT

Hi @Adnan3194 ,

Can you paste the file name here? for further understanding of what/how the file name looks

Re: "Get Files" action unable to detect the file in the folder

Adnan3194 — Tue, 19 Nov 2024 14:37:39 GMT

hi @Chakkravarthi_PR here it the name of file

Re: "Get Files" action unable to detect the file in the folder

Chakkravarthi_PR — Tue, 19 Nov 2024 15:38:55 GMT

Hi ,

The file pattern is the problem, it should be "*.xlsx" you have it as "*.xlxs" which is the incorrect file format.

File Pattern data Item, remove the double quotes i.e

Re: "Get Files" action unable to detect the file in the folder

Adnan3194 — Tue, 19 Nov 2024 15:39:06 GMT

same error is displaying

Re: "Get Files" action unable to detect the file in the folder

Adnan3194 — Tue, 19 Nov 2024 15:42:29 GMT

thank you so much @Chakkravarthi_PR for your time. matter is solved

Re: RE: "Get Files" action unable to detect the file in the folder

Mohamad_Dakkouri — Tue, 19 Nov 2024 15:43:28 GMT

@Adnan3194

You need to remove the "" from your text data item [File Pattern] so it will be *.xlsx