Examples for the rts log-db command

The log-db command supports the following subcommands:

• export – Exports the contents of the rts.db file to a .csv file.

• import – Imports data from a .csv file into the rts.db file.

• purge – Deletes data from the rts.db file and exports the deleted data to the specified file.

The --filepath-server option specifies the .csv file that contains the logging data that you want to import, export, or purge. If an absolute path is not specified, the software assumes the file path is relative to the \Logs folder.

The --from-date and --to-date options limit which rows are exported or purged. Both are optional. When you do not specify these options, the software uses the earliest and latest dates in the Logging database (rts.db), respectively. The log-db import command does not support these options.

You can determine the format of the .csv file by exporting the rts.db file and then using the resulting .csv file as a template.

If you encounter an error when you run these commands, check the .txt file in the Logs\RtsWebUI_logFile folder for more information.

Example 1

rts log-db export --filepath-server myLogData.csv --from-date "1/1/2021 9:00 AM" --to-date "1/1/2021 11:00 AM"

• Exports data from the Logging database (rts.db) to the myLogData.csv file in the \Logs folder. This example exports only the data in the timeframe starting at 9:00 AM and ending at 11:00 AM on January 1, 2021.

Example 2

rts log-db import --filepath-server C:\RTSLogs\myLogData.csv

• Imports the data from the myLogData.csv file in the C:\RTSLogs folder into the Logging database (rts.db).

Example 3

rts log-db purge --filepath-server C:\RTSLogs\myOldLogData.csv --from-date "2/1/2023 9:00 AM" --to-date "3/1/2023 9:00 AM"

• Deletes all data from the Logging database (rts.db) in the timeframe starting at 9:00 AM on February 1, 2023, and ending at 9:00 A.M. on March 1, 2023. The deleted data is exported to the myOldLogData.csv file in the C:\RTSLogs folder.