Translog

TransLog Reporting Portal

TRANSLOG is an online data capture platform designed and developed by TLC for cross-border monitoring. The system currently works on either manually collected data using printed data collection sheets with the information entered into the sheets manually or more recently digital data collection using tablets by trained Enumerators strategically placed at stations both outside and inside the Border Control Area to allow accurate collection of:  

  • Vehicle arrival times at the border
  • Vehicle Registrations for tracking purposes
  • Vehicle configurations
  • OD (Origin & Destination) information
  • Commodities carried
  • Tonnage of cargo
  • Entrance times into Customs Control Area
  • Submission of documents to Customs
  • Cargo Inspections
  • Release Order times
  • Final Exit times from the border

 

The information is captured into the online platform either through manual entry by data capture or uploaded to the platform electronically from a laptop or PC, the program automatically generates a number of user friendly reports consisting of tables and graphs covering the following outputs:

 

  • Traffic volume counts by vehicle category (Day & Night Counts)
  • Arrival patterns at the border
  • Origin & Destinations of vehicles and cargo
  • Transporter Nationality of vehicles
  • Commodity or Cargo types by Customs classification
  • Detailed breakdown commodity tonnage by vehicle configuration
  • Frequency of Arrivals, Submissions and Departures
  • Distribution of Vehicle Dwell Times and comparison by Customs Pre-clearance
  • Border-crossing times by vehicle category and all vehicles
  • Border-crossing times by Customs pre-clearance and normal clearance
  • Border-crossing times by Customs Regimes i.e. SCT (Single Customs Territory), NTB (National Transit Bond), DI (Direct Import) and ER (Empty Returns)

 

PROBLEM:

 

A system was needed to convert a manual data collection method, for cross-border monitoring, to a more automated system.

 

Traditional manual data collection

red_arrow.jpg Data could easily be lost

red_arrow.jpg More susceptible to human error

red_arrow.jpgData can easily be tampered with

clipboard.jpg

Automated data collection system

 green_arrow.jpgMinimises the possibility of human error

 green_arrow.jpgMore controlled data collection

 green_arrow.jpgData is more secure (Electronic format)

cellphone.jpg

 

 

OBJECTIVES:

To be automated:

 

  • Forms
    • Form 1A
    • Form 1B
    • Form 1C
    • Form 1D
    • Form 2A

 

 

  • Surveys
    • Community Survey
    • User satisfaction survey
  • Functionality
    • Store files locally
    • Store in a usable format
    • Be able to edit stored files
    • Share/Sync files

 

 

SOLUTION:

 

Application of the Form 1A will be used for demonstration purposes:

 ia_form.jpg

  

Creating a form:

  • Create a new Entry
  • This can be done by selecting
    a New Form Entry.
  • Completing an Entry
  • Once a new Entry has been selected,
    the user fills it in.
  • Entry Options
  • Done button
  • Completes Entry
  • Save button
  • Stores Entry to be finished later
  • Discard button
  • Deletes the current Entry

create_a_form.jpg

Finalizing a form:

  • After enough Entries have been
    filled in, it is necessary to finalize
    the form
  • This can be done in the
    Form Completion section.
  • Completing a Form
  • Once a Form is selected, the user
    can start filling it in.

finalize_a_form.jpg

 

Sharing forms:

  • To share a specific form
  • This can be done by selecting the Share
    in the Communicate section.

share_a_form.jpg

 

Surveys:

  • There are 2 surveys that can be
    done (User Satisfaction – and
    Community Survey)
  • This can be done by selecting
    Surveys in the Communicate
  • Select which Survey to be done
  • Complete Survey

surveys.jpg

 

TLC is currently at an advanced stage of fully automating TRANSLOG using either barcodes or robust re-usable RFID tags and handheld scanner/readers to minimize the human error factor through manual data collection. This will also allow for reduction in the number of Enumerators required for data collection. The information collected via the handled scanners/readers from Barcodes/RFID tags can be upload either directly from the handheld device or via a laptop or PC to the cloud based platform that will automatically generate the reports thus eliminating the need for data capturers and improving the accuracy and efficiency of the system.

 

The Data Collection Device:

7” Android Tablet with 8 mega pixel rear camera and 2 mega pixel front camera, NFC (Near Field Communication), 2D Barcode Scanner and UHF RFID Scanner

 

 

data_collection_device.jpg

 

Viewing of historical projects for public consumption and client based projects will be accessible through a unique user name and password that will define the accessibility of the unique user.

TransLog Reporting Portal