CyberTracker Command Line
Background
Several CyberTracker features can be triggered via the command-line. This
functionality is usually intended for server side scripts that operate on the
database as a whole. To use the command line, use:
Start->Run "cmd.exe"
cd "\Program Files\CyberTracker Software\CyberTracker 3.0"
ct3 /?
Note, do not use "ct3.exe /?", because this will trigger the windows application.
Instead, just type "ct3".
"System" folders are mentioned below. These are sub-folders of "Documents\My
CyberTracker Databases\System". This folder can be opened in Explorer to see the
way data moves through the system.
System Folders
|
Staging |
Data that is waiting to be inserted into a database is placed into this folder. This folder is processed by
CyberTracker routinely, e.g. on startup, on sync, etc. If the data cannot be
uploaded into the target database for any reason, it will remain in this folder
- potentially indefinitely. |
|
Backup |
Once data has been successfully added to a database, it is moved to this
folder. If the database later becomes corrupt, it acts as a second line of
defense. |
|
CrashDump |
If CyberTracker crashes, the changes that have been made since the last save are
exported to a CTX file and placed here.
|
|
Incoming |
When files are downloaded from the internet, they are temporarily held in this
location.
|
|
Logs |
CyberTracker keeps a log of all sync operations. Check out the download.txt file
in this location to understand errors. This only affects ActiveSync and Hotsync
operations. |
|
MapCache |
Virtual Earth tiles that are downloaded from the server are placed here to improve performance. |
|
Outgoing |
Once files have been downloaded via a local sync (ActiveSync or Hotsync), they may need to
ultimately be sent to an internet server. Check out the "Send on Sync" option on
the "Database Properties" dialog. This is a holding location for them before
they are processed. |
|
Settings |
Local system settings, e.g. the current Client Profile. |
Commands
|
/DownloadPDA |
Connect to the a Windows Mobile / PocketPC PDA and download any data that is on
it. As soon as data is downloaded from the PDA, it is placed in the Staging (see
above) folder.
|
|
/DownloadURL |
Use the download settings of the associated /Database to connect to a URL.
Incoming data is placed in the Staging (see above) folder. If an
/ExportDatabase, /ExportRule and /ExportTable are also specified, then
this downloaded data will be exported. |
|
/UploadURL |
Process the Outgoing (see above) folder. |
|
/Datafile |
Specify a data file (.CTX) for use with data operations, for example as an
input for the /ExportTable mechansim. If the full path is not present, the
system will attempt to locate the file in "Documents\My CyberTracker Databases". |
|
/Database |
Specify the database to use for data operations, for example as an input for the
/ExportTable mechanism. |
|
/ExportRule |
The export rule file. The export rule file can be created by using the
"Export View" toolbar button with the "Query Editor" active. Use the "Save as
type" drop down on the File Save dialog to select "Export Rule File".
|
|
/ExportDatabase |
The target database for export operations. Must be accompanied by a /ExportRule
and /ExportTable. The input for this operation comes from a /Datafile, /Database
or /DownloadURL command. If the full path is not present, the system will
attempt to locate the file in "Documents\My CyberTracker Databases". |
|
/ExportTable |
The table name in the target database. This table must already exist and be
properly configured. See "Using Export Data Tables" in
CyberTracker Server Setup. |
|
/Studio |
Turn on all CyberTracker features and run the desktop application. |
Examples
ct3 /Database mydb.mdb /DownloadURL
Open the database mydb.mdb, get the download settings
and execute a download using the parameters in the "Database Properties" dialog.
This is equivalent to clicking the "Download" button on the "Database
Properties" dialog box.
ct3 /DownloadPda
Download all data from the currently connected Windows
Mobile device.
ct3 /Database myin.edb /DownloadUrl /ExportDatabase
myout.edb /ExportRule myrule.exr /ExportTable mytable
Open the database myin.edb and get the download
settings. Download all the files available using the parameters in the "Database
Properties" dialog. Export this data to the myTable table in the myout.edb
database. Note, myin.edb and myout.edb can be the same database.
Using this method is the preferred way of configuring a
schedule task that keeps an export table up to date, because only the newly
downloaded data is considered for export. More details on export tables can be
found here.
|