View source for VEhub Project Details

'''About'''

==Fleet efficiency and safety==

Maintaining the correct safety information across your fleet just got simpler and faster for you and your drivers. In the process of doing away with most of the paper, OBS Logistics and our strategic partner TomTom reinvented the process of keeping your fleet safe and in compliance with Driver &amp; Vehicle Standards Agency (DVSA - previously VOSA) requirements. We provide a timely capability for recording accident information, as well as knowing where your key transport resources are.

==Accessible technology==

CALIDUS VEhub runs as a straightforward App on Android devices, and specifically for TomTom followers, will deploy on all 827x series devices. This gives you an all-in-one driver-orientated dashboard device that acts as both Sat Nav and driver information centre.

==Easy access==

All your driver has to do is log on and, through a few easy steps, they can capture all the safety checking information the law requires before starting their journey. Photo capture and defect reporting make the process more consistent and accurate than paper, not to mention faster as an end to end process.

==Accident records==
If the worst happens and a driver is involved in an accident, information is best captured as soon as possible.

VEhub has a full accident logging capability, including accident scene and vehicle damage photo capture.

The format driven recording helps to ensure that the details that are required are fully captured. The accident report can then be sent back to the transport department for processing rather than waiting for the driver to return to base.

==Assets located and logged==
Add a low cost barcode scanning App to your VEhub and it becomes a rapid data capture tool. All you have to do is attach barcode labels to your fleet assets and your staff can rapidly scan them with VEhub logging the precise location and time, making tracking fast, accurate and above all easy.

==Reporting==
CALIDUS VEhub has a full suite of reports so that you can rapidly assess the condition of the fleet and take proactive action to keep your vehicles operating in optimum condition.

==Extra==
The Vehub App communicates with a WCF Service to fetch data. The Vehub App is built using the Cordova framework.

The App is available on the google play store

==Product Folder:==
\\spekefs2012\Projects\Product\VEHUB

==1. Development==
This contains the original requirements, updates and the source code for the current VeHub

==1. Original Requirements==
This contains documents laying out the original requirements for VeHub

==2. Product Updates==
This contains documents explaining product updates since the original requirements

==3. Source==
This contains source code backups and a place to put temporary code to be shared

==Quality Control==
This contains QA documents that have been put together when testing VeHub

==Quality Control - 18072017==
This contains QA documents that have been put together when testing VeHub

==Web Tools==
This contains tools obtained from the web

==2. Management==

Project Management related documentation such as handover documentation

==3. Projects==

Project Management related documentation such as project requirements

==5. Releasing==

Documentation on how to release certain parts of the project

==6. Documentation==

This contains any number of documents related to VeHub

==APK - Android==

This contains the Android Builds of VeHub

==APK - IOS==

This contains the IOS Builds of VeHub

==Source Code location==

All of the source code is housed in our web development server's Azure source control and development management system. The home page for the Vision is located here:

Visual Studio 2017(Warning: Cordova project will fail to load in Visual Studios 2019) you can view the solution locally by navigating here and cloning:
se your Aptean credentials when prompted.

There are two repos but this is the one that should be used, “VeHub”

==Git==

==Source/Version Control==

Track progress of files by creating a series of snapshots and branches which you can move back and forth between.

Why

1. Distribute file changes overtime

2. Prevent data loss/damage

3. Manage complex project structures
Created by guy who made Linux to manage Linux, The most popular source control software in the world with lots of documentation and support, and lots of integration with other applications (SourceTree, Heroku, GitHub).

Mercurial - a popular alternative to Git

==Branches==

Allow you to create a series of commits on a separate timeline without the need to taint your master branch. Be sure to do an initial commit before creating branches or you risk the master being set as one of the branches.

Pull/Fetch Requests
git pull is a Git command used to update the local version of a repository from a remote repository

==Push Requests==

The git push command is used to upload local repository content to a remote repository. Pushing is how you transfer commits from your local repository to a remote repository

==Local vs Remote Repositories==

Git will allow you to have both Local and Remote versions of your repositories, Local repositories are stored on your local computer, changes made to a local repository won’t be reflected in the associated Remote repository until a push request is sent.

Remote Repositories are available to everyone with access and changes to the remote repository can be seen at any time, and with a pull/fetch request a local repository can be created/updated with the latest changes.

==The Source Code==

The source code is a .NET Framework 4.5 Visual Studio solution.¬
This started out as a paid, externally developed application which was brought in house and developed further.

The solution contains 2 websites, 1 Cordova project and 5 C# projects

==Projects==

==VEHub.Admin==

==VEHub.Core==

The Core Project is used to contain all of the core functionality for the application, from business logic, to helper classes, this allows for greater separation and can be used to create a cross platform application.

==Calidus VEHub Device (DEV)==

The android device project, a Cordova application using JavaScript to handle the page layout and and logic.

==Emailer==

The Vehub emailer is a windows services that checks the Email table in the database and sends emails out using the details created by the system Alerts.cs.

The emails are sent via SMTP.

If an email should fail to send then email is flagged as unsent and the error is logged.

The Emailer Is Running as a service and is located here on the server

The Settings for the Emailer service are stored in the Emailer.exe.config file:

&lt;Emailer.Properties.Settings&gt;
&lt;!--Emailer Service Error Log location--&gt;
&lt;setting name=&quot;LogPath&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;C:\Services\Emailer\log\&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP From Name--&gt;
&lt;setting name=&quot;SMTP_FromName&quot; serializeAs=&quot;String&quot;&gt; &lt;value&gt;VEHub&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP From Address--&gt;
&lt;setting name=&quot;SMTP_FromAddress&quot; serializeAs=&quot;String&quot;&gt; &lt;value&gt;vehub@obs-logistics.com&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP Server--&gt;
&lt;setting name=&quot;SMTP_Server&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;10.43.0.20&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP PORT Number--&gt;
&lt;setting name=&quot;SMTP_Port&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;25&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP Requires Authentication Flag--&gt;
&lt;setting name=&quot;SMTP_RequiresAuth&quot; serializeAs=&quot;String&quot;&gt; &lt;value&gt;True&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP UserName--&gt;
&lt;setting name=&quot;SMTP_User&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;vehub&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SMTP PASSWORD--&gt;
&lt;setting name=&quot;SMTP_Pass&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;{smtpPassword}&lt;/value&gt;
&lt;/setting&gt;
&lt;!--SSL Required for SMTP--&gt;
&lt;setting name=&quot;SMTP_Ssl&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;False&lt;/value&gt;
&lt;/setting&gt;
&lt;!--How Often it checks for email--&gt;
&lt;setting name=&quot;CheckFrequency&quot; serializeAs=&quot;String&quot;&gt; &lt;value&gt;60000&lt;/value&gt;
&lt;/setting&gt;
&lt;!--Connection String--&gt;
&lt;setting name=&quot;DB_String&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;{connectionString}&lt;/value&gt;
&lt;/setting&gt;
&lt;setting name=&quot;UseChilkat&quot; serializeAs=&quot;String&quot;&gt;
&lt;value&gt;False&lt;/value&gt;
&lt;/setting&gt;
&lt;!--PDF Attachments location --&gt;
&lt;setting name=&quot;PdfAttachments&quot; serializeAs=&quot;String&quot;&gt; &lt;value&gt;C:\inetpub\wwwroot\VEHub.Service\pdf&lt;/value&gt; &lt;/setting&gt;
&lt;/Emailer.Properties.Settings&gt;

The Emailer Services uses the configuration to set up and send emails.

==Emailer Service Installation==

The services can be installed using a batch file, e.g.:
@echo off

==Location of installutil.exe==

cd C:\Windows\\Framework\v4.0.30319

==Location of Service==

sc create Emailer binpath=&quot;C:\Services\New Emailer{ServiceName}.exe&quot; pause

{|
!width="100%"|
if ERRORLEVEL 1 goto error

|}

exit
pause
:error
echo There was a problem
pause
and uninstalled using a Powershell script:
@echo off
cd C:\Windows\Microsoft.NET\Framework\v4.0.30319

sc stop {ServiceName}
sc delete {ServiceName}

{|
!width="100%"|
pause

|}

if ERRORLEVEL 1 goto error
exit
pause
:error
echo There was a problem
pause

==Poller==

The Poller service works similar to the emailer service, it checks the system for vehicles that are overdue a vehicle check then creates an email alert to be sent out.

The OverDue Poller is Running as a service and is located here on the server:

==TomTomLink==

Used to connect and interact with the TomTom elements of the application.

==VEHub.Service==

The VeHub Web Services that the device applications use to Fetch/Create/Update/Delete data through

==VEHub.UI==

This is the PC site for handling of data/account information that the devices are used to record and update.

==Vehub PDF Printer Service==

Vehub uses the PDF Printer service to generate pdf reports for gift aid.

The PDF Printer service takes in html generated by vehub and returns a pdf document.

Vehub points to the pdf service via an API endpoint.

This endpoint is stored in the config file of vehub.ui and vehub.service.

&lt;add key=&quot;PdfWebApi&quot; value=&quot;http://localhost:3001/&quot;/&gt;
The Vehub Web Portal has an endpoint that uses the razor engine to generate strongly typed html pages. The html is generated and passed on to the PdfWebApi to generate the pdf.

==Dev Environment==

The system is available for use at OBS

==Server Details==

Server name: SHARED-WEB-R
OS: Windows 2012 Standard
IP: 10.43.6.50
RDC User: SHARED-WEB-R &lt;Own User&gt;
RDC Password: &lt;Own Password&gt;
IIS Version 8.0.9200.16384

==Database==

Server name: SHARED-SQLSVR-R
OS: Windows 2012 Standard
IP: 10.43.6.51
RDC User: SHARED-SQLSVR-R&lt;Own User&gt;
RDC Password: &lt;Own Password&gt;
SQL server: Microsoft SQL Server 2012 - 11.0.5058.0 (X64) SA: sa / sa_epod13-
Epod user: epod / ePOD1234

==Live and Test Environments==

==Live==

==Server Details==

Server name: SHARED-WEB-R
OS: Windows 2012 Standard
IP: 172.183.45.50
RDC User: SHARED-WEB-R &lt;Own User&gt;
RDC Password: &lt;Own Password&gt;
IIS Version 8.0.9200.16384

==Database==

Server name: SHARED-SQLSVR-R
OS: Windows 2012 Standard
IP: 172.184.45.200
RDC User: SHARED-SQLSVR-R&lt;Own User&gt;
RDC Password: &lt;Own Password&gt;
SQL server: Microsoft SQL Server 2012 - 11.0.5058.0 (X64) SA: sa / caL1duS#
Epod user: epod / ePOD1234

==Test==

==Server Details==

Server name: SHARED-WEB-R
OS: Windows 2012 Standard
IP: 172.183.45.55
RDC User: SHARED-WEB-R &lt;Own User&gt;
RDC Password: &lt;Own Password&gt;
IIS Version 8.0.9200.16384

==Database==

Server name: SHARED-SQLSVR-R
OS: Windows 2012 Standard
IP: 172.184.45.205
RDC User: SHARED-SQLSVR-R&lt;Own User&gt;
RDC Password: &lt;Own Password&gt;
SQL server: Microsoft SQL Server 2012 - 11.0.5058.0 (X64) SA: sa / sa_epod13-
Epod user: epod / ePOD1234

==Test VeHub SMTP service is running using Telnet==

Open a command prompt as an administrator and enter the following line by line: telnet 10.43.0.20 25
helo
ehlo
MAIL
RCPT
DATA
This is a email sent via Telnet
.

QUIT
This assumes the SMTP service is still 10.43.0.20 on port 25, obviously this may change at some point. The recipient email address should be changed to one that the tester has access to.

==Google Play Store Deployment==

==Update Version Numbers==

Using Visual Studio Open the config.xml file in the solution. In the Common Tab Update the version number:

For Android builds, update the version number in the android tab:

==Do a Release Build==

Deploy the app by selecting Deploy in the context menu. Visual Studio will build an APK for the app and output this to the bin directory.

==Upload to Play Store==

The Google account that the app is registered to is:
• Google Account:
• Password: THaAw
Used for google services, like analytics, playstore , captcha etc… anything google that’s related to dev work:• Google Account:
• Password: _Liverp
Play Store upload link:
• 
T
• 

==Checking for Errors and Faults==

'''System Log Table'''

SELECT * FROM SystemLog

The Vehub emailer is a windows services that checks the Email table in the database and sends emails out using the details created by the system Alerts.cs.

The emails are sent via SMTP. If an email should fail to send then email is flagged as unsent and the error is logged.

==Vehub Custom Vehicle Checks Flag==

==Vehub Custom Vehicle Checks Flag==

VeHub Customers that had an account prior to the new registration will need to have a flag set in order to activate the custom fields functionality.

The flag enables custom fields for the device(app) and the web-portal.

When the flag is set users will be able set custom-fields and drivers will be able to use these fields on the device.

To get started you will need the Customer Code to be able to run the query.

With the customer code, Query the customers table to get the customer Id: SELECT * FROM Customer
WHERE CustomerCode ='Demo'

Once you have the Customer Id , use it to run the stored procedure uspCustomerLegacySettingSave :

To Test this, login to the web portal using the account and check the settings tab. What used to be Vehicle Check Items is now Custom Vehicle Check Items :

With the flag now set, the customer can create custom vehicle check items.

==VeHub Inaccessible Vehicle Checks Issue==

When trying to access vehicle checks the following error message is displayed: SYSTEM ERROR

Internal Server Error [500].

It is believed that this is caused when Custom Vehicle Check Templates are introduced after a customer upgrade: these don’t have Vehicle Check Items. Therefore if old &quot;vehicle check&quot; indicators are set, for instance by the use of an older version of the App, that doesn’t support the newer checks, after the upgrade causing the checking of &quot;vehicle check&quot; items which can no longer be accessed.

The proposed solution is to run a script that will set all the old indicators back to 0 for the new &quot;vehicle check templates&quot;. However if there is still a customer device operating the old &quot;vehicle checks&quot; App then the problem will occur again.

1. &quot;Vehicle check&quot; reset script

==IMPORTANT:==
• This process needs to be tested before being implemented on a live customer• Replace the Template:CustomerId placeholder in the script

{|
!width="100%"|
UPDATE VehicleCheck SET

|}

{|
!width="100%"| CkLeaks = 0, CkBattery = 0, CkTyres = 0, CkSpray = 0, CkSteering = 0, CkLoad = 0,
|}

{|
!width="100%"|
CkMirrors = 0, CkLights = 0, CkReflector = 0, CkIndicators = 0, CkWipers = 0,

|}

{|
!width="100%"|
CkWashers = 0, CkHorn = 0, CkExhaust = 0, CkBrakeLines = 0, CkCoupling = 0,

|}

{|
!width="100%"|
CkElectrics = 0, CkBrakesABS = 0, CkBodywork = 0, CkMarkers = 0, CkGlass = 0

|}

{|
!width="100%"|
WHERE TemplateId NOT IN

|}

{|
!width="100%"|
(SELECT VehicleCheckTemplateId FROM dbo.VehicleCheckItem WITH (NOLOCK)

|}

{|
!width="100%"|
WHERE CustomerId = {{CustomerId}} GROUP BY VehicleCheckTemplateId)

|}

[[Category:VEhub]]