×

iFour Logo
 

Data Transfer for Fleet systems

About Customer

Customer is a leading service provider of state-of-the-art, highly integrated, transportation software solutions and administrative services in Canada and US. Customer also offers transportation booking features to third-parties to fetch and store data appropriately.

Challenge

The customer is providing transportation software solution and administrative services using a software that was built years ago using legacy technology VB6. The legacy software is full of bugs and incapable to cope up with new generation technology. System does not manage data appropriately adding frustration to customer as he has to do this manually. The customer realized the need of re-engineering legacy software using new technology with robust and new features.

Data Transfer for Fleet systems - 01

Technology Used

Technology
Window Service

Type

Technology
ASP.NET (C#) Framework 4.0

Programming Language

Technology
Microsoft SQL Server 12

Database Management Server

Technology
window

Architecture

Technology
Open XML, Crystal Report

Client Technology

Technology
SVN

Version Control

Data Transfer for Fleet systems - 02
Data Transfer for Fleet systems - 03

Get In Touch With Us

We encourage you to contact us with any questions or comments you may have.

image
  • Automation of data extraction from third party third transportation service providers like CMT, MKC, ICABBI, MT Data, VTS and CTS

  • Calculation of fees and charges of fleet rides automatically

  • On demand Bill and Invoice generation

  • Provides appropriate driver statement and invoice through email

  • Automatic database backup and restoration

  • Effective memory usage by deleting existing backup after specific period of time

  • Error logs tracking made easy by Audit trail of all activities performed and log generation

  • "Auto Email Error log management" to email the logs of the events with errors

  • Online remote connection web services and off line data import process to import data from different third parties

  • Run on demand completion of events to complete events manually

  • User friendly "SQL Compiler" to compile SQL script

image Conclusion/Results

With the reliable and robust solution provided by iFour Technolab, customer was able to import the data from various transportation solution provider and calculate the fees and charges in no time without any hassles. Sustainability and consistency of a system made it possible to book number of rides at a time. Revamped system made database back up and restoration easy.

 

Related case studies

 

What do our clients say

iFour Testimony - Jan Marteen Kops
iFour Testimony - David Stewart
iFour Testimony - Matthew Bellgrove
iFour Testimony - Darren Fisher
iFour Testimony - Gavin Kretzschmar
iFour Testimony - Carlos Hernandez
iFour Testimony - Jeroen Van Megchelen
iFour Testimony - John Schenk
iFour Testimony - Tim Grant
iFour Testimony - Jan Entjes
iFour Testimony - Michael
 
Blog Our insights
19 CEO Dashboard Examples for Business Leaders

20 February 2025

Kapil Panchal

19 CEO Dashboard Examples for Business Leaders

Let's rewind to the 1990s. Data used to be stored on servers and CEOs relied on basic tools to make optimal decisions. No dashboards, nothing. When you use Power BI with a solid...

How to Export Power BI Data to Excel

31 January 2025

Kapil Panchal

How to Export Power BI Data to Excel

Imagine walking into a meeting where critical decisions need to be made—fast. You need clear, flexible data that you can analyze on the spot. But what if your insights are locked inside...

8 Powerful Data Storytelling Examples for CTOs

30 January 2025

Kapil Panchal

8 Powerful Data Storytelling Examples for CTOs

Clear insights mean smarter decisions, and this is what data storytelling does. It helps you speak a language that you quickly understand. Like for example, you are a CTO dealing with...