How To Export Guard1 Plus 3.x Data for use with Rounds Tracker

Published: 2007-05-22

 

Last Updated: 2010-02-15

Applies To

 

Introduction

In order to view Guard1 Plus 3.x (MSDE) data remotely in Rounds Tracker, the MSDE database must be exported in MS Access format. This requires Data Maintenance Scheduler 3.02, which can create a Microsoft Access export file (which has the extension .G1P) automatically via a Windows scheduled task. For detailed information on how to create a scheduled task, refer to the file "Guard1 Plus Data Maintenance Scheduler 3.0x Instructions.doc" that is included with your Data Maintenance Scheduler program. One of the steps in creating this scheduled task is to create a command line.

 

 

More Information

Command arguments are entered in the Scheduled Task's "Run" line (Windows XP) or the "Add arguments (optional)" field (Windows Vista or 7). Command arguments require the following syntax:

M; Path; D; DF; CF (note the single space before M and following each semicolon)

Where:

  • M is the Maintenance Task to perform
    • 1 - Verify Data Integrity (compact and reindex)
    • 2 - Backup (requires Path. DF is optional (will use DF=1 if not specified). If DF is specified, you must include D=0 as a placeholder).
    • 3 - Archive (requires Path and D; DF is optional (will use DF=1 if not specified))
    • 4 - Export (DMS 3.02 only - exports data in Access (.g1p) format for use with Rounds Tracker)
  • Path is the path to an existing folder where you want the Archive or Backup file to be created. This can be a folder on the local hard drive or a network folder. NOTE: DMS 3.02 can NOT create Archives or Backups on a network folder - you must use a local path. The folder must already exist; DMS cannot create a new folder. If you choose a network folder (DMS 2.51 only), the User Account the Task is run under MUST have Modify permissions to the folder. This argument is required if M=2 (Backup) or 3 (Archive).
  • D is the number of days of data to keep in the Master Database when Archiving. All downloads older than this number will be put in the Archive file. This argument is required if M=3 (Archive) and/or you are specifying DF (File Date Format). For example, if D=90, any downloads older than 90 days will be Archived.

 

  • DF is the File Date Format used in the Archive or Backup file name.
    • 1 - mm/dd/yyyy (default – will be used if DF is not specified)
    • 2 - dd/mm/yyyy
    • 3 - yyyy/mm/dd
    • 4 - Custom File Name (valid only for M=2 (Backup)). Use this option if you want to specify the name of the Backup file. You must also include D=0 as a placeholder.

 

  • CF is the Custom File Name. This argument is required if DF=4. Correct syntax is FileName.g1p. WARNING: Using this option can result in loss of data! If a file of the same name exists in the target folder, the original file will be overwritten!

 

 

Examples

 

To create an Export file named with a mm/dd/yyyy format to the folder C:\Backups, the command line would be:

 

        "C:\Program Files\Guard1 Plus\G1PDataMaintenance.exe" 4; C:\Backups; 0; 1

 

To create an export file named with a mm/dd/yyyy format to the network folder  \\Server01\Guard1 Plus Exports, the command line would be:

 

        "C:\Program Files\Guard1 Plus\G1PDataMaintenance.exe" 4; \\Server01\Guard1 Plus Exports; 0; 1

 

To create an export file named with a yyyy/mm/dd format to the folder \\Server01\Data Exports, the command line would be:

 

        "C:\Program Files\Guard1 Plus\G1PDataMaintenance.exe" 4; \\Server01\Data Exports; 0; 3

 

 

 

 

 

 

 

 

 

 

 

 

 

Copyright © 2013-2016 TimeKeeping Systems, Inc.