Batch Run

From mtab wikisupport
Revision as of 16:49, 2 August 2018 by Mtabadmin (Talk | contribs)

Jump to: navigation, search

The Batch Run feature allows users to select multiple saved tabs, load and run the data, and export the data into spreadsheets with one click.


The benefit of Batch Run is that it saves a significant amount of time by eliminating the need to individually load each tab, type a filename for each spreadsheet, and then export one by one.


Batch Run allows users to initiate a very large number of tabs to run and export in the background. This allows users to save time to spend on other tasks. After Batch Run completes, each tab will have been run and the results exported to corresponding spreadsheet files. The most typical format being XLSX. Batch Run supports all spreadsheet file formats that can be exported with mTAB: XLSX, XLS, XML, HTML, CSV, and tab-delimited TXT.


How Batch Run Works

Batch Run starts in the My Tabs panel, where you will see all of your currently saved tabs listed.


Batchrun1.png

Using either [Ctrl-Click] or [Shift-Click] keyboard commands, select all of the Saved Tabs you would like to run.

Batchrun2.png

Click on the bottom section of the Run (lightning bolt) icon.
You'll see additional Run options. Click the Batch Run icon.


Batchrun3.png

Instead of using the icons, after selecting and highlighting the Saved Tabs, you can also right-click anywhere in the My Tabs window and a menu will appear.
The Batch Run option will appear at the bottom of the menu.

Other batch-run file-name-imput.jpg

Clicking on this option brings up a dialog, which allowa you to select the directory where the resulting XLS files will be placed as they are output. Each file will automatically be given the same name as the tab from which it ran, making it easy to identify each tab's output.


Another tool that is available is having mTAB place some kind of prefix before the file name of each output file. This would allow the insertion of a common phrase, date or any other identifying information by the user. Simply type it into the File Name box in the dialog.


Once the Batch Run process is complete, mTAB checks to see if any problems occurred and, if so, displays a dialog to point these out to you. A copy of this detailed problem log is also saved to the same directory as your output files, for future reference.

Other batch-run results-warnings-errors.jpg