DOVICO - time tracking, time management, project management software and time and attendance.


Older File Formats

 

Track-IT® light

File Formats for Track-IT light v6.x
  • Track-IT light is written in C++
    There are currently two file formats being used in our Track-IT light versions 6.x
  • Track-IT light template file (*.tpl)

The file begins with a bit of header information:

Name Size

Description
Version ID 4 bytes

File Version
Header Info 25 bytes

Identifies the type of file
Number Of Items 4 bytes

The number of items in the file

From here the file continues on for (n) number of items.

Name Size Description
Project ID 4 bytes The unique id of the project
Parent ID 4 bytes The unique id of a parent (if the item has one)
Task ID 4 bytes The unique id for a task
Outline Level 4 bytes The number of level item is on (0 for root)
Display Children 2 bytes Is the project and items displayed in the list?
Target 2 bytes Percentage goal for a project (between 0 and 100)
Length of Name 4 bytes The length (in bytes) of the name to follow
Name (n) bytes Name of project/activity
Length of Description 4 bytes The length (in bytes) of the description to follow
Description (n) bytes Description of the project/activity
Length of Path 4 bytes The length (in bytes) of the path to follow
Path (n) bytes The path of the project (only in MSProject)

Note the following for the above:
1) The path will only be used in MSProject files that are linked with MSProject
2) The Outline Level, and Parent ID are used for displaying items in a control like the Tree View control

The file format for the transaction file (*.trs) is as follows:

Name Size Description
Version ID 4 bytes Version ID of file format
Header Info 25 bytes Description of file (Transaction File)

From here comes the data records:

Name Size Description
Project ID 4 bytes The unique id of the project tracked.
Task ID 4 bytes The unique id of the activity/task tracked.
Date 11 bytes The date of the transaction in format (12/30/9999)
Start Time 6 bytes The time the transaction started in format (23:00)
End Time 6 bytes The time the transaction ended (23:30)
Sent 4 bytes Was the transaction sent to MSProject or Track-IT pro?
Length of Description 4 bytes The length (in bytes) of the description to follow
Description (n) bytes The description of the transaction

The trans.dat file, is a list of transactions that other programs can read.  This transaction file can be linked with MSProject.

Name Size Description
Version ID 4 bytes The version of the file format
Header Info 25 bytes The description of the file

And now for the raw data

Name Size Description
Length of name 4 bytes The length (in bytes) of the resource name to follow
Name (n) bytes The name of the resource for this particular transaction
Project ID 4 bytes The unique id of the project tracked.
Task ID 4 bytes The unique id of the task/activity tracked
Date 11 bytes The date the transaction was recorded in format (12/30/9999)
Start time 6 bytes The time the transaction started in format (23:00)
End time 6 bytes The time the transaction finished in format (23:59)
Length of Description 4 bytes The length (in bytes) of the description to follow
Description (n) bytes The description of the transaction recorded.

 

Track-IT light template file (*.tpl)

  1. The file starts off with the phrase "ATrack-IT Pro Template File ..." and spaces fill the rest of this phrase. This phrase is 62 chars long and is used to identify the file as a track-it file.
  2. The following 4 bytes (long) are the number of projects in the file.
  3. The following 4 bytes (long) are the number of activities in the file.
  4. After this the 4 bytes (long) of the project ID.
  5. The project name follows the project ID, and it is 21 bytes (chars) long.
  6. After the project name is the project description which is 61 bytes (chars) long.
  7. The above three pieces of information occur for n number of projects.
  8. Now the activities start with an activity ID which is 4 bytes (long)
  9. Activity name follows and is 21 bytes (chars).
  10. Activity Description is 61 bytes(chars).
  11. The above 3 pieces of information occur for n number of activities.
  12. After the activities are done, the file format goes as follows for n number of activities.
  13. Project ID - 4 bytes (long)
  14. Activity ID - 4 bytes (long)
  15. This is done so you know which projects link with which activities. The link works like this: [Project ID (4 bytes)->Activity ID (4 bytes)].

 

Track-IT light template file (*.trs)

  1. Date 11 bytes
  2. Start Time 6 bytes
  3. Sent and other info 11 bytes
  4. End Time 6 bytes
  5. Project ID 4 bytes
  6. Activity ID 4 bytes
  7. Description 61 bytes
    File repeats this format for each entry

 

Track-IT® pro v2.x-3x

  • Track-IT pro is written with power builder with a Foxpro Database backend (*.DBF file format). This format is ODBC compatible. When Track-IT light is used with Track-IT pro it automatically uses the 2.x Track-IT light file format.
  • Exporting information in Track-IT pro: All reports can be exported in a variety of formats . See Exporting
  • Track-IT pro v 3.0 database schema
  • The first field in all tables, are the unique key for each table. ID's for each table start at 100, and work their way up.
  •  The PURGE field determines if that record will be taken to the new database, or deleted.

 The version table handles Track-IT pro updates, and is not useful for reporting

VERSION
  • VERSION
  • NUMBER
  • NAME
  • MAXPRJ
  • MAXACT
  • MAXACTPR
  • PRJLEN
  • ACTLEN
  • DESCLEN
  • NAMELEN

The TRANS table is probably the most important table of all. It stores the time transactions for each employee

TRANS
  • TRANS
  • ESTIMATE
  • PROJECT
  • ACTIVITY
  • EMPLOYEE
  • DEPT
  • MANAGER
  • LEADER
  • DATE
  • TIMEIN
  • TIMEOUT
  • TIMEWORK
  • DESC
  • BILLABLE
  • APPROVED
  • ARATE
  • ERATE
  • ECOST
  • ERROR

The TABLE table contains information about the next unique id for each table. Not useful in reporting.

TABLE
  • NAME
  • NEXTID
  • LOCK

The SECURITY table contains the security information for the database, and determines what users have access too.

SECURITY
  • SECURITY
  • NAME
  • DESC
  • DEFAULT
  • TS
  • PROJECT
  • ESTIMATE
  • CLIENT
  • ACTIVITY
  • DEPT
  • EMPLOYEE
  • PRJTYPE
  • ACTGRP
  • NEWDB
  • OPENDB
  • BACKREST
  • CIEPROF

The PROJECT table contains all the projects, what client a project belongs too, the leader of the project, its type, and its billing type etc.

PROJECT
  • PROJECT
  • CLIENT
  • EMPLOYEE
  • PRJTYPE
  • OUTSIDE
  • NAME
  • ACR
  • DESC
  • SDATE
  • EDATE
  • STATUS
  • COSTTYPE
  • COST
  • EFFDATE
  • HASEST
  • PURGE

The PRJTYPE table is used to group projects, and activities.

PRJTYPE

  • PRJTYPE
  • LINKID
  • NAME
  • DESC
  • PURGE

The PRJACTS table is the information that is contained within the Project/Assigned to tab. It contains all assignments on all projects for all employees.

PRJACTS

  • PRJACTS
  • PROJECT
  • EMPLOYEE
  • ACTIVITY

The PHONE table contains all phone numbers stored in Pro. The LINKTYPE determines which category it belongs in. (Project, Activity, etc)

PHONE

  • PHONE
  • LINKID
  • LINKTYPE
  • NUMBER
  • DESC
  • DISPLAY

The NOTE table contains all notes stored in Pro. The LINKTYPE determines which category it belongs in. (Project, Activity, etc)

NOTE
  • NOTE
  • LINKID
  • LINKTYPE
  • CONTENTS
  • DATE

The EXPENSE table contains estimated expenses that belong to projects.

EXPENSE
  • EXPENSE
  • PROJECT
  • ESTIMATE
  • EST_DESC
  • ACTUAL
  • ACT_DESC

The EXPACT table contains actual expenses belonging to projects.

EXPACT
  • EXPACT
  • PROJECT
  • USERID
  • DATE
  • PONUMBER
  • INVOICE
  • AMOUNT
  • TAXES
  • MARKUP
  • DESC

The ESTIMATE table contains all records for assignments in projects that have estimates.

ESTIMATE
  • ESTIMATE
  • PROJECT
  • ACTIVITY
  • EMPLOYEE
  • DEPT
  • MANAGER
  • LEADER
  • HOURS
  • NEWHOURS
  • ERATE
  • ECOST
  • ARATE
  • BILLABLE
  • DATE
  • DESC

The EMPLOYEE table stores all employee information for Track-IT pro.

EMPLOYEE

  • EMPLOYEE
  • DEPT
  • SECURITY
  • STATION
  • OUTSIDE
  • LNAME
  • FNAME
  • DWH
  • DPW
  • RATE
  • COST
  • SDATE
  • EDATE
  • USERID
  • PASSWORD
  • EFFDATE
  • UNITTYPE
  • PURGE

The DEPT table stores team information for Track-IT pro

DEPT
  • DEPT
  • EMPLOYEE
  • OUTSIDE
  • NAME
  • EFFDATE
  • PURGE

The CLIENT table stores client information for Track-IT pro

CLIENT
  • CLIENT
  • OUTSIDE
  • NAME
  • ACR
  • CONTACT
  • PURGE

The BILLING table contains billing information for invoices, and payments.

BILLING
  • BILLING
  • PROJECT
  • DATE
  • TYPE
  • NUMBER
  • CHECKNO
  • AMOUNT
  • DFROM
  • DTO
  • FILENAME
  • U1
  • U2
  • U3
  • U4
  • LTAX
  • ETAX

The ADDRESS table keeps track of all Addresses within Track-IT pro.

ADDRESS
  • ADDRESS
  • LINKID
  • LINKTYPE
  • DESC
  • LINE1
  • CITY
  • PROVINCE
  • POSTAL
  • DISPLAY

The ACTIVITY table has all activities that would be assigned to projects in Track-IT pro.

ACTIVITY
  • ACTIVITY
  • PROJECT
  • PRJTYPE
  • OUTSIDE
  • NAME
  • ACR
  • ARATE
  • DESC
  • EFFDATE
  • BILLABLE
  • PURGE