Share My Creation ICT Asset Manager [FREE] Source Code

Ola

Download

IMPORTANT: Please run the MySQL Connection Tester Excercise First

THIS IS A LEGACY PROJECT AND WORKS WITH BVAD3 VERSION 604 AVAILABLE IN THE DOWNLOAD

Join our Telegram Channel here.

Keep Track of your ICT Assets..

Sneek Peek...

1. As an ICT Manager of your company, who did you give a laptop to/a mobile to/a headset to?
2. When is the warranty of that asset expiring?
3. When was the asset purchased? from whom? what was the invoice no?
4. Which employee has use of which company assets?
5. Track your Software Licenses e.g. Windows 10, Office 365 etc.
6. View Dashboard of your Assets
7. GPS Tracking via Check In.

You can get the source code for $40.
If you like my work and are willing to donate to support, you can do it here. ?

*The colour codes are used for charts

See how it works here...





References

BANanoVuetifyAD3
Mashy Teaches BANanoVuetifyAD3

 

[Mashiane]

We have a color drop-down to select the color codes for each of our categories and statuses..

 

[Mashiane]

We thus have a color coded Hardware Register...

Depending on the status & category colors we specified before. Nothing is hard coded.

 

[Mashiane]

We are assuming that employees should be able to request hardware etc, so we need a record of who has what or not?

 

[Mashiane]

Perhaps lets also keep details of where we source our hardware etc...

 

[Mashiane]

We should also be able to configure the different types of software categories that the ICT Asset Manager has to keep.

 

[Mashiane]

The licenses may vary from FreeWare, OpenSource, etc etc.

 

[Mashiane]

The software register, just like the hardware register has some useful information about license expiry dates across the organization..

 

[Mashiane]

As part of the BANanoVuetifyAD3 Telegram Channel, the source code for this is available for you on the channel, to test please. I would appreciate your feedback on the current work in progress.

I thank you.

 

[Mashiane]

As an asset manager you will receive requests, these could be for hardware / software. These can be approved / rejected.

 

[Mashiane]

As employees request hardware and licenses, the ICT Asset Manager will have to issue the relevant requested content..

The issuing, whilst also based on requests made, can be dynamic also. The plan is as soon as a request is approved, a new entry on the Issue Out register is created with the details of the requester.

Ta!

 

[Mashiane]

From the request screen, the ICT Asset Manager should be able to Approve / Reject requests. Once approved, the "Issue Out" records are updated indicating that a new issue should take place. Its marked Pending linked to the "Request #"

 

[Mashiane]

Anele requested Visual Studio 2017, we issue the software and license out to him. This involves updating the record with (a) license no, (b) date issued and (c) status. This closes the loop from request to issue.

 

[Mashiane]

Whilst issuing software may require entering the license details, issuing hardware should be faily easy and also update the hardware list, as hardware is linked to a serial number.

The Lenovo A is requested, approved and issued and the hardware list updated.

 

[Mashiane]

It should also be easy to issue an item and also reverse the issue.

 

[Mashiane]

A quick way to see KPI for our ICT Asset Manager, lets have some informative dashboard content... As a start, we generate a hard-ware status chart. This gives us a hardware high level based on our hardware list.

We have some hardware that is ordered and some in stock..

 

[Mashiane]

We protect the app by enabling Sign In. The ICT Manager can Sign In and an Employee can also Sign In...

ICT Manager will use [email protected] & admin as sign in credentials.

An employee can Sign In using their email address and cellphone #

 

[Mashiane]

As an employee, you have access to your Requests and Items issued to you with limited access.

 

[Mashiane]

Checking In - GPS Tracking

From time to time, employees might "check in", this will help in confirming that they still have the allocated devices with them. They can do this "check in" in their work stations.

Checking in, gets the current GPS co-ordinates when the employee checks ins.

 

[Mashiane]

How to configure the ICT Asset Manager

You are going to receive a

1. sql script file to create the MySQL database.
2. the source code for the ICT Asset Manager
3. The latest BVAD3 source code.

Step 1: Download these

Step 2: The current connection for the ICT Assets Manager has a password of root and no password. If your connection details are not the same, you need to update the Data Sources to use the new connection details.

This is done by opening the layouts and updating the connection parameters:

NB: You can also just update these parameters via code after BANano.LoadLayout. BTW, A BANanoDataSource is just a renderless custom view, i.e. a class module.

Step 3: When running the app, the most events you will see are _Create, _SelectAll, _Update, _Delete. These are callbacks that gets executed after you execute CRUD actions.
How the BANanoDataSource works, is explained in details on this thread: https://www.b4x.com/android/forum/threads/bananodatasource-a-crud-database-abstract-layer.131838/

The DataSources are working with Dynamic on. You can however turn this off so that you can use the config file for mysql. You just need to specify your DB connection parameters on the config file.

All the best.