cmd.exe creating folder error

Question

Hello Everyone.!

Working on a workflow where data is in an excel file (2 columns, Name, and DOB) which create multiple excel file in a folder. However unable to get the desired result and got an error. Attached is the screenshot, Could anyone provide me a suggestion if I have missed anything?

Error 3.PNG

hiteshnpwc · Answer

@ patrick_digan

Thank you for you reply.

Attached is my workflow configuration. Could you please help me out if I am missing anything?

Error.PNG

patrick_digan · Answer

@hiteshnpwc Hello! It looks like you have a batch macro with a Run Command Tool. The Run Command tool is creating a directory specified by %Question.ControlParam.File%. When you have the macro open and you hit run, %Question.ControlParam.File% will be set equal to whatever test value you have entered in the workflow configuration tab (C:\Data\Test in my example below).

The md command will error out like you're seeing if the folder already exists. Note that when somebody runs the workflow with this macro in it, it will use the data that is sent into the upside down question mark and create folders for those paths (ie it ignores your test value). So even if you're seeing an error when testing the macro itself (because the folder already exists), the workflow will run without error so long as the folders are new.