A Command Line interface is available to allow Batch Validation to be run from a batch file.
Subjects are revalidated in order of study/site/subject ID.
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.
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.
Errors arising from invalid Command Line parameters (e.g. missing parameter, invalid user name or database, or non-existent study) will be written to a log file in the MACRO Temp folder. The error log file name will be of the form:
BVCLyyyymmddhhmmss.log
where yyyymmddhhmmss represents the timestamp of the error. If more than one error log is written within a second, the file names will have additional numeric suffixes.