topic filename is changed in schedule in Product Forum

filename is changed in schedule

KristianHolm1 — Wed, 07 Oct 2020 09:46:00 GMT

Hi Blueprism somehow the filename is changed to Test_07\10\2020.txt from Test_07102020.txt when you run it in the scheduler.

Is it blueprism or server/setup who change the date to a fileformat that is wrong.?

Have attached an example and description on the error

Greetings

------------------------------
Kristian Holm
RPA programmer
PenSam (Pension Company)
Copenhagen Denmark
------------------------------

RE: filename is changed in schedule

PatrickAucoin — Wed, 07 Oct 2020 14:14:00 GMT

Hi Kristian,

I think that Today() expression is returning a different result. Running it in studio, it is resulting in 07-10-2020, but from the control room, you are getting 07/10/2020. So, a calc stage to remove the dashes does not do anything. You are getting an error when you try to save the file because those backslashes look like a path, but that file path does not exist.

Instead of a calc stage to get the date in the desired format, try using the Format Date action from Utility - Date and Time Manipulation. Still use Today() for the value of the Date Time input, and for your case "ddMMyyyy" for the format.

Let me know if that works!

------------------------------
Patrick Aucoin
Senior Product Consultant
Blue Prism
------------------------------

RE: filename is changed in schedule

KristianHolm1 — Wed, 07 Oct 2020 18:45:00 GMT

Hi Blueprism when you using the format date from Utility - Date and Time object then it is working in the scheduler.

Greetings

------------------------------
Kristian Holm
RPA programmer
PenSam (Pension Company)
Copenhagen Denmark
------------------------------

RE: filename is changed in schedule

NileshJadhavBP — Thu, 08 Oct 2020 14:52:00 GMT

Hi Kristian,

Have you run scheduler from same machine ?

You can add below logic in your process

if found "\" then replace with "_" or blank (input will be 23\10\2010 – Output will be 23_10_2010 or 23102010 according to your condition)
If found "-" replace with "_" or blank (input will be 23-10-2010 – Output will be 23_10_2010 or 23102010 according to your condition)

Note - Use instr function with calculation stage

I hope it will help you.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
------------------------------