Running BV from the Command Line

A Command Line interface is available to allow Batch Validation to be run from a batch file.

Please note that you cannot select subjects by Subject Label or run batch validation for a single eForm via the Command Line. If you want to use these features, you must use the BV module.

We do not recommend running two or more instances of Batch Validation from the Command Line simultaneously on the same study, because this may result in study lock conflicts. There are no known issues when running two or more instances of Batch Validation simultaneously if each instance is accessing subjects from different studies.

Column	Description
User	Current user's MACRO login user name
Pwd	User's MACRO password
Database	Name of MACRO database
Role	User role for login
Logfile	Full path of log file
Study	Name of study
Site	Site code. If 'All Sites', revalidation will be for all sites to which the current user has access with the given role
From	Subject Id of first subject to be revalidated. If '0' or missing, start at first available subject
To	Subject Id of last subject to be revalidated. If '0' or missing, finish at last available subject, otherwise To must be greater than or equal to From
Verbose	True for 'verbose' output. Any other value is for log changes only
SaveChanges	True to save changes. Any other value is to log changes without saving
CSVOutput	True to save an additional CSV output file; any other value is to exclude the CSV output
AutoUnlock	True to automatically unlock any locked data before batch validation is run
AutoRelock	True to automatically relock any auto-unlocked data after batch validation is run
AutoUnfreeze	True to automatically unfreeze any frozen data before batch validation is run
AutoRefreeze	True to automatically refreeze any auto-unfrozen data after batch validation is run

InferMed.M40.MACRO_BV.exe/BV/rde/macrotm/TEST_DB/MACROUser/C:\BVLogFiles\BVLogDemo3June13.txt/Demostudy30/All Sites/50/0/False/True/True/True/True/True/True

This will run Batch Validation as user ‘rde’ on the TEST_DB database, revalidating Demostudy30 subjects from all sites with subject IDs of 50 or greater, logging changes only (Verbose = False), saving changes, producing an additional CSV output file and unfreezing and unlocking any frozen or locked data before revalidation, then refreezing and relocking it afterwards.

If AutoUnfreeze is set to False, setting AutoRefreeze to True will have no effect. Likewise, if AutoUnlock is set to False, setting AutoRelock to True will have no effect.

The Auto Unfreeze/Refreeze options are only available if the current user has a role which includes all of the eight 'Unfreeze' and 'Freeze' data permissions, i.e. Unfreeze at subject level, Unfreeze at visit level, Unfreeze at eForm level, Unfreeze at question level, Freeze at question level, Freeze at eForm level, Freeze at visit level, Freeze at subject level.

Likewise, the Auto Unlock/Relock options are only available if the current user has a role which includes all of the eight 'Unlock' and 'Lock' data permissions.

Click here for more information on the behaviour of automatic unfreezing/unlocking.

Batch files (with extension .bat) can be created containing one or more of these lines. Each line can specify a different range of subjects, and large sets of subjects can therefore be revalidated by executing a single batch file.

For example, if the following lines of text are saved to a batch file and executed, subjects 1 to 150 for Demostudy30 will be revalidated in three batches of 50 subjects each, unfreezing/unlocking and refreezing/relocking all data.

InferMed.M40.MACRO_BV.exe /BV/rde/macrotm/TEST_DB/MACROUser/C:\BVLogFiles\BVLogDemo030613_1_50.txt/Demostudy30/All

Sites/1/50/False/True/True/True/True/True/True

InferMed.M40.MACRO_BV.exe /BV/rde/macrotm/TEST_DB/MACROUser/C:\BVLogFiles\BVLogDemo030613_51_100.txt/Demostudy30/All

Sites/51/100/False/True/True/True/True/True/True

InferMed.M40.MACRO_BV.exe /BV/rde/macrotm/TEST_DB/MACROUser/C:\BVLogFiles\BVLogDemo030613_101_150.txt/Demostudy30/All

Sites/101/150/False/True/True/True/True/True/True

Warning: When creating a batch file for multiple calls to Batch Validation, ensure that a different log file is specified for each call, otherwise the log files for earlier runs will be overwritten by later ones.