How can you setup your Visual Automator job (Classic) so your exports will process one at a time instead of at once.
I have multiple exports for a single Monarch Sever Job using Visual Automator and I need each export to save to the same file name but different tabs. I have setup each export to have a different named tab in the same spreadsheet and have selected when output file exists "Add Data". Problem is the Exports all kick off at the same time and try to write to the same file at the same time. This causes 1 or more exports to error out and not complete since one of the exports is in the middle of writing to the same file. I do not see an option to run these in any order so one finishes prior to the next one kicking off like you can in the desktop version of Monarch.
Best Answer
-
Hi Billy,
Nice to meet you. Yes as you can see your current process is what I like to call being run 'concurrently'. In other words, each export is trying to run in parallel so it's accessing the same excel file to write the output.
What you want is what you've described; A process that will run 'sequentially'. All you have to do is line that up like this, exporting to the same file. First table will be set to 'overwrite', then the subsequent ones set to 'Add Data'.
Hope this helps. I'm planning to add some short bite size videos on the Essentials of Automator, I will let you know when they are available here in the user community. In the mean time please don't hesitate to ask questions.
1
Altair EmployeeAnswers
-
Hi Billy,
Nice to meet you. Yes as you can see your current process is what I like to call being run 'concurrently'. In other words, each export is trying to run in parallel so it's accessing the same excel file to write the output.
What you want is what you've described; A process that will run 'sequentially'. All you have to do is line that up like this, exporting to the same file. First table will be set to 'overwrite', then the subsequent ones set to 'Add Data'.
Hope this helps. I'm planning to add some short bite size videos on the Essentials of Automator, I will let you know when they are available here in the user community. In the mean time please don't hesitate to ask questions.
1 -
Baba, thank you for your response and that worked. Have a great day.
1