Share My Creation ICT Asset Manager [FREE] Source Code

Mashiane

Expert

Licensed User

Longtime User

• Jul 18, 2021

• #2

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 18, 2021

• #3

We thus have a color coded Hardware Register...



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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 19, 2021

• #4

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 19, 2021

• #5

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 19, 2021

• #6

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 19, 2021

• #7

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 19, 2021

• #8

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 19, 2021

• #9

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

Expert

Licensed User

Longtime User

• Jul 20, 2021

• #10

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 22, 2021

• #11

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

Expert

Licensed User

Longtime User

• Jul 23, 2021

• #12

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

Expert

Licensed User

Longtime User

• Jul 23, 2021

• #13

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

Expert

Licensed User

Longtime User

• Jul 23, 2021

• #14

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

Expert

Licensed User

Longtime User

• Jul 23, 2021

• #15

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 23, 2021

• #16

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

Expert

Licensed User

Longtime User

• Jul 25, 2021

• #17

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 admin@ictmanager.com & admin as sign in credentials.



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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 25, 2021

• #18

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

 

Mashiane

Expert

Licensed User

Longtime User

• Jul 26, 2021

• #19

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

Expert

Licensed User

Longtime User

• Jul 27, 2021

• #20

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.

 

Last edited: Jul 27, 2021