Quick Inventory

Inventory is usually done with special barcode readers. Such readers are not cheap so smaller companies do inventory manually. That means inventory represents costs whether for hardware or time spent to do it manually. Quick inventory offers easy and cheap option to do inventory with Android device.

In most cases users already have some kind of a database. Quick inventory doesn't want to change that. Quick inventory can help you with the data you already have.

A lot of solutions work in such way that you need to prepare data, transfer that data from your computer to the device, do inventory, transfer data back to the computer and import it back to your database. To keep things as simple as possible, Quick inventory works in so called live mode. All queries and updates are made directly to the database.


Quick inventory server

Quick inventory server is installed on the computer and represents a bridge between your database and client application. Main window will give you all the information you need. All actions are logged into this window. Through File/Wizard menu you can setup selected inventory. Wizard will guide you through the process. This is the only place where you need some knowledge. You must be able to define connection to your database and write some sql.

To setup your Quick inventory server, you need to go through few steps. In the first step you define port on which server will listen. Server uses tcp/ip protocol to communicate with the client application (make sure Quick inventory server can go through your firewall).


In the next step you must define connection to your database. Quick inventory supports native drivers to MS SQL, Oracle, MySQL, Pervasive, Interbase, SQLite,... Additionaly you can connect to your database through ADO or ODBC. Each type of connection requires different parameters.


In the next step you define fields that will be used for your inventory. Different needs require different fields. Some standard fields would be name, quantity, location, notes. Some may require serial number for example. Usually you use those fields then in the sql. For each field you must define name, caption and data type. In the sql you work with name. Caption will be used for the label in front of this field on the client. Data type will define what kind of input will be enabled on the client. You can also define if field should enable scanning, if it should keep the value after you call save on the client and if it's visible at all.

In the last three steps you must define select, update and insert sql. Select will be used to search for your asset. Update will be used when you need to update existing asset in you database. Insert will be used to insert new asset to your database. Select sentence must return fields that you defined in the third step. To use the right values in the update and insert sentences, you can use parameters or script. Parameters are words with colon prefix. For example :id in the sql sentence will be changed to the right id before sent to the database. Before sql is sent to the database, it is preprocessed meaning all script tags are replaced with the value of the script.





When you are finished with the setup, your server should start. It will inform you on which port it started and ip address to which you can connect. In case of an error you should be able to see the reason. Quick inventory server will automatically start next time you run it. Information about your setup is stored in the application data folder (for example c:\ProgramData\QuickInventory\QuickInventory.def).

Quick inventory client

Client side also wants to follow “simple is good” pattern. There is only one field required and that is id. All other fields (fields that you defined on the server) are automatically added when you connect to the server for the first time.
On the top, you have two buttons. With button scan, you can scan barcodes via built-in camera. In order to do that, you need to install BarcodeScanner (http://code.google.com/p/zxing/ ) prior to using Quick inventory. Once scanning returns some code, Quick inventory automatically executes locate on the server side for the asset with that id.



You may also manually enter id and press locate button, to locate your asset in the database.

After locate is done, application will inform you whether asset was found or not (in that case this may be new asset). If asset was found, all the fields will be populated with the right values. You can change them and when you are finished, press button save. Your data will be saved and fields will be cleared. You will be notified if asset was saved successfully.

Before you begin with you work, setup few things on the client. Under settings menu you must define ip of the server and port. You can also define that id can only use numbers, to speed up manually entering of id's.




Demo

Quick inventory works in demo mode by default. That means when ten connections to the database are made, server will stop working. You must restart server.

If you find Quick inventory usefull and you want to use it without demo restriction, you must donate (see below). 


Information

Grega Loboda
Križnarjeva pot 64
4000 Kranj

Internet: http://delphistep.cis.si/
E-mail: grega.loboda@gmail.com


download