topic Re: File Management - 10.3.5 - Delete files action not working for more than 1 extension in Product Forum

File Management - 10.3.5 - Delete files action not working for more than 1 extension

Neel1 — Thu, 10 Oct 2024 11:51:35 GMT

Hello - i am using BP version 7.0.0 and trying to use delete files action from latest File management VBO 10.3.5
tried with below pattern to delete only .xlsx and .csv file. getting true in Success but files not getting deleted.

"*.xlsx,*.csv"

".xlsx,.csv"

Re: File Management - 10.3.5 - Delete files action not working for more than 1 extension

JD_CPU — Fri, 11 Oct 2024 20:15:39 GMT

I'd triple check the file path and use powershell to try something like

Get-Acl *.csv | Format-Table -wrap

to verify that the BP user has Allow FullControl to the csv file you are trying delete.

Re: File Management - 10.3.5 - Delete files action not working for more than 1 extension

harish.mogulluri — Sun, 13 Oct 2024 02:54:19 GMT

HI @Neel1 - Probably you might already verified, regardless try to verify the account has access to delet to the specific folder, because recently I had similar experience due to the account I logged in doesnt have access to delete the file in the specific file in the fodler.

Re: File Management - 10.3.5 - Delete files action not working for more than 1 extension

JD_CPU — Mon, 14 Oct 2024 12:27:11 GMT

@Neel1 actually the File management VBO action's parameter must be a single file pattern.

Not a comma delimited list as shown above. The above code is literally looking for any files that match the unlikely pattern of "*.csv,*xlsx"

If you use file explorer to rename an existing file to something like "thiswill.csv,neverhappen.xlxs" the Blue Prism File management VBO will dutifully delete it using the "*csv,*xlxs" pattern. But you would not expect that file pattern to ever actually occur in the wild.

In reality you simply need to use the action twice in a row.

Use "*.xlsx" as the Pattern parameter the first time.

Then use "*.csv" as the Pattern parameter the second time to achieve your desired result.

Re: File Management - 10.3.5 - Delete files action not working for more than 1 extension

Neel1 — Mon, 14 Oct 2024 15:18:36 GMT

@JD_CPU - thank for your reply. One by one deletion is working and *. * is also working.

My post is about[ which seems to be fixed in this version as per release notes ] deleting multiple file pattern in one action and i am receiving True in Success but files not getting deleted.