Using Excel template files for data output in Server
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have set up some workflows which make use of .bat files in order to take a copy of a template Excel file which contains pivot tables and formatting and paste it to a new location with a reporting period as a suffix to the file name, the workflow will the output data to this file.
This works great in Designer, but when attempting to run in Server, the .bat file will not run.
"The external program "Runthis.bat" returned an error code: 1 (ToolId: 11)"
Is there a solution to this, or are .bat files not compatible with Server? If this is the case, are there any other methods to write to a renamed template file, other than the end user manually creating the file prior to running the workflow?
Thanks
Solved! Go to Solution.
- Labels:
- Error Message
- Output
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have found a solution to this: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Copying-a-template-file/td-p/9... for anyone interested.