DBSync can be executed in a batch mode by placing an INI file in the same directory as the dbsync application (normally c:\win32app\timsv3 on the file server) and starting DBSync with the -a command line argument. The INI file is broken into sections indicated by [ROUND#] where the # indicates the sequence number in which the action takes place.
If you are unfamiliar with how to interactively use DBSync please see the DBSync Users Guide to master this operation before trying to run a batch procedure.
Sample Command Line: dbsync.exe -a
Remember: dbsync.ini and dbsync.exe must be in the same directory.
The parameters specified on the form can be set as follows:
|
[ROUND#] |
a sequential batch round number |
|
TAB=Projects |
TAB name |
|
LogFile= |
log file name |
|
StartProjectName= |
start project name |
|
StartProjectID= |
start project ID if known |
|
StartProjectPath= |
start project path |
|
Secure= |
1 (create secure sub-project) or 0 |
|
NodeName= |
Node name must be specified for secure projects |
|
OR |
|
|
Open= |
1 (create open sub-projects) or 0 |
|
ExcludeStartProject= |
1 (Exclude start project) or 0 |
|
Action=1 |
Log Error Only |
|
OR |
|
|
Action=2 |
Log Error and Add Missing Records |
|
UserName= |
User Name |
|
Group= |
Group Name |
|
ViewLog= |
1 (show log) or 0 |
|
Pause= |
1 (wait for user response) or 0 |
The parameters specified on the form can be set as follows:
|
[ROUND#] |
a sequential number |
|
TAB=Documents |
TAB name |
|
LogFile= |
log file name |
|
SearchProjectName= |
search project name |
|
SearchProjectPath= |
search project path |
|
SearchProjectID= |
search project ID if known |
|
FileName= |
|
|
FileExtension= |
|
|
IncludeSubProjects= |
1 or 0 |
|
LimitToOneRecord= |
1 or 0 |
|
Action=1 |
Log Errors Only |
|
OR |
|
|
Action=2 |
Log Errors and move Orphan Records |
|
DumpProjectName= |
dump project name |
|
DumpProjectPath= |
dump project path |
|
DumProjectID= |
dump project ID if known |
|
OR |
|
|
Action=3 |
Log Errors and Add Missing Records |
|
UserName= |
User Name |
|
Group= |
Group Name |
|
OR |
|
|
Action=4 |
Log Errors, Move Orphan DB Records and Add Missing Records |
|
DumpProjectName= |
dump project name |
|
DumpProjectPath= |
dump project path |
|
DumProjectID= |
dump project ID if known |
|
UserName= |
User Name |
|
Group= |
Group Name |
|
ViewLog= |
1 (show log) or 0 |
|
Pause= |
1 (wait for user response) or 0 |
|
TAB=Projects |
|
LogFile=c:\win32app\timsv3\p1.log |
|
StartProjectName=BEK |
|
StartProjectPath=E:\allfiles\BEK\ |
|
ExcludeStartProject=1 |
|
UserName=Administrator |
|
GroupName=Domain Users |
|
Action=2 |
|
ViewLog=1 |
|
TAB=Documents Log |
|
File=c:\win32app\timsv3\d1.log |
|
SearchProjectName=BEK |
|
SearchProjectPath=E:\allfiles\BEK\ |
|
FileExtension={All Files} |
|
FileName= |
|
IncludeSubProjects=1 |
|
UserName=Administrator |
|
GroupName=Domain Users |
|
Action=3 |
|
ViewLog=1 |
In ROUND1, add sub-project records for projects under project BEK.
In ROUND2, add document records for files in project BEK and all of its sub-projects.