Hive (Home InVEntory) program.
Posted: Sun Jun 26, 2011 4:13 am
http://members.westnet.com.au/bangfeast/Files/Hive.7z
I've had this functionality in my Multibase program for years and even made a home inventory program years ago but it was basic. This one is nicer (for me at any rate).
----------------------------------------------------------------------------------------
Information
----------------------------------------------------------------------------------------
What: Simple Home Inventory utility. Much better than the one I wrote years ago.
License: Free. Can't ever be sold or distributed, just given away.
Thanks: Netmaestro for hover code and snap-to callback, Srod combobox formatting, netmaestro / Srod for the keyboard shortcut code, lots of others, Jumbuck for many hours of testing and good suggestions. (You can't buy help that good!!)
Usage: Drop it into a directory into which you have read and write access and run it. It will create directories and files as needed.
Bugs: Probably!!!! Lots!! Maybe!!! I've tried to make everything modular but some changes still require a lot of work and investigation so make suggestions and give me time. Due to health reasons, I don't want to spend days at a time sitting here.
Suggestions: Keep them clean:):)
Notes: The fading effects, borders of objects (or lack thereof) will work differently according to the operating system you use and if themes are turned on or off. This is still something that I am struggling with and will take a lot of time to solve.
I am not going to write a full help file just yet, the doctor won't let me sit for long periods of time. The program is easy enough to use and discover.
--------------------
Files
--------------------
Backup the database to a named day of the week. Backups are rotated weekly.
Show quick database statistics.
Dump all database tables to XML files. I find it useful to backup to and restore from.
Open someone else's Hive database to work with.
Switch between normal and deleted list items (Currently deprecated)
Vacuum wasted space from the database.
Exit the program.
--------------------
Mode
--------------------
Add a new mode item (Location, Category or owner)
Delete the selected mode item. (Location, Category or owner)
Edit the selected mode item. (Location, Category or owner)
Change between modes. (Location, Category or owner)
--------------------
Data
--------------------
Add a new inventory record.
Copy selected inventory records to the system clipboard.
Delete selected inventory records.
Edit the currentlys elected inventory record.
List any attachments for the current inventory record.
Tag all records in the inventory item list.
--------------------
Utilities
--------------------
Export all selected records to disk. Similar to dump but only for items table).
Print all selected items using the web control (IE or Mozilla).
Recover the record marked as deleted.
--------------------
Setup
--------------------
Fade forms in and out (This has different effects on Windows XP and Windows 7 if enabled)
Turn record save messages on or off.
Snap forms to screen borders.
Show the current time on the title bar.
TUrn form and button tooltips on or off.
--------------------
Help
--------------------
About this program.
Show the program help file (if any)
Change the keyboard shortcuts.
--------------------
Exit
--------------------
Exit this program immediately, without warning. No data is lost.
----------------------------------------------------------------------------------------
Navigating the location bar.
----------------------------------------------------------------------------------------
This bar has three main states. Locations (Rooms) mode, Categories and Owners. All functions are
available from the "Mode" button on the top of the form, a right click menu of the mouse within the
bar, the control buttons underneath it and keyboard shortcuts.
Changing between them will load all the records for the selected state and then show the details for
the first record in that list, if any.
By default, All Items are displayed for a location bar state when changed. You can also select a
state where the record is empty for that state or marked as deleted.
For instance: If the location bar is showing "Locations" and you click on "Empty Items", any items
that do not have a location (Room) in their data are displayed.
Of course, this should never happen if I have coded Hive correctly and the application shouldn't
allow you to save a record without a location.
----------------------------------------------------------------------------------------
Navigating the item list bar.
----------------------------------------------------------------------------------------
This bar has a single function, to display records.
You may add records to it, copy selected record data to the system clipboard, delete records from it
(Only marked as deleted), edit selected records and list any attachments for the currently selected
record.
A record marked as deleted (Strike through font) cannot be copied, edited or printed until it is
recovered. Recovering a record is as simple as selecting it and then using the recovery menu function
from the Utilities menu (or one of the other methods. The strikethrough is then removed to indicate this.
As with the location bar, all functions are available from the "Mode" button on the top of the form,
a right click menu of the mouse within the bar, the control buttons underneath it and keyboard shortcuts.
----------------------------------------------------------------------------------------
Navigating Drag And Drop
----------------------------------------------------------------------------------------
If you consider an item belonging to the wrong Location, Category or Owner, while the location bar
is in the correct display mode, select the offending record, keep the left mouse button help down
and drag the record from the Item List bar and drop it onto the correct Location, Category or Owner
that you want it in.
The record data will be changed and saved, the display will change to the new Location, Category or Owner and that Location, Category or Owner refreshed to show the new record in there.
----------------------------------------------------------------------------------------
Navigating the search bar.
----------------------------------------------------------------------------------------
The searchbar has two functions as well as always displaying the current location bar mode that you are in and the currentlys elected item in the item list.
One is to select the type of SQL search that you want to peform within the string you will search (At this moment, only the item name is searched, no other field), and the search box where you start typing and instant results are reflected in the list. A "Drill-down" approach, this is the one that I prefer.
Of course, money can always persuade me otherwise (grin).
The SQL search type look like this:
Equal to = ' + SearchString + '
Does not equal <> ' + SearchString + '
Greater than > ' + SearchString + '
Greater than or equal to >= ' + SearchString + '
Less than < ' + SearchString + '
Less than or equal to <= ' + SearchString + '
Starts with LIKE ' + SearchString + %'
Ends with LIKE '% + SearchString + '
Sounds like LIKE '% + SearchString + %'
----------------------------------------------------------------------------------------
Navigating the Main Details area
----------------------------------------------------------------------------------------
This area will always show some very basic information about the record that is currently selected
in the item list bar. You cannot edit anything in there.
However, if you double left click the photograph area, you can change or add a photograph to the record.
----------------------------------------------------------------------------------------
Navigating the Main Details control bar
----------------------------------------------------------------------------------------
Photo button will allow you to you change or add a photograph to the record as above.
Receipt button will allow you to find and link a receipt file to the current record. There is no
limit to the number of Receipts that you may link in this fashion and all files are copied to the
Attachments directory so that the originals are undisturbed.
Warranty button will allow you to find and link a Warranty file to the current record. There is no
limit to the number of Warranties that you may link in this fashion and all files are copied to the
Attachments directory so that the originals are undisturbed.
Note button will allow you to launch a simple note editor to add or change the note for the current record instead of having to launch the full record editor form.
File button will allow you to find and link a file to the current record. There is no limit to the number of files that you may link in this fashion and all files are copied to the Attachments directory so that the originals are undisturbed. The usual idea is for people to link drivers to computer items in the database for ease of use.
The Copy, Delete and Edit buttons mirror the same functions available from the data menu.
----------------------------------------------------------------------------------------
Navigating the totals bar
----------------------------------------------------------------------------------------
Nothing for the token human to do here but watch the total value of items in the list to be displayed and get scared at how much they spent.
Currently, only the actual total cost of the items is counted and not tax, resale etc. That may change at a later date.
----------------------------------------------------------------------------------------
Navigating status bar
----------------------------------------------------------------------------------------
Once again, nothing for the token human to do here.
If I have coded this thing right, normal status messages will be shown in black and error messages will be shown in red.
As I remember them, error messages will be added, deleted or fixed to make sense.
I've had this functionality in my Multibase program for years and even made a home inventory program years ago but it was basic. This one is nicer (for me at any rate).
----------------------------------------------------------------------------------------
Information
----------------------------------------------------------------------------------------
What: Simple Home Inventory utility. Much better than the one I wrote years ago.
License: Free. Can't ever be sold or distributed, just given away.
Thanks: Netmaestro for hover code and snap-to callback, Srod combobox formatting, netmaestro / Srod for the keyboard shortcut code, lots of others, Jumbuck for many hours of testing and good suggestions. (You can't buy help that good!!)
Usage: Drop it into a directory into which you have read and write access and run it. It will create directories and files as needed.
Bugs: Probably!!!! Lots!! Maybe!!! I've tried to make everything modular but some changes still require a lot of work and investigation so make suggestions and give me time. Due to health reasons, I don't want to spend days at a time sitting here.
Suggestions: Keep them clean:):)
Notes: The fading effects, borders of objects (or lack thereof) will work differently according to the operating system you use and if themes are turned on or off. This is still something that I am struggling with and will take a lot of time to solve.
I am not going to write a full help file just yet, the doctor won't let me sit for long periods of time. The program is easy enough to use and discover.
--------------------
Files
--------------------
Backup the database to a named day of the week. Backups are rotated weekly.
Show quick database statistics.
Dump all database tables to XML files. I find it useful to backup to and restore from.
Open someone else's Hive database to work with.
Switch between normal and deleted list items (Currently deprecated)
Vacuum wasted space from the database.
Exit the program.
--------------------
Mode
--------------------
Add a new mode item (Location, Category or owner)
Delete the selected mode item. (Location, Category or owner)
Edit the selected mode item. (Location, Category or owner)
Change between modes. (Location, Category or owner)
--------------------
Data
--------------------
Add a new inventory record.
Copy selected inventory records to the system clipboard.
Delete selected inventory records.
Edit the currentlys elected inventory record.
List any attachments for the current inventory record.
Tag all records in the inventory item list.
--------------------
Utilities
--------------------
Export all selected records to disk. Similar to dump but only for items table).
Print all selected items using the web control (IE or Mozilla).
Recover the record marked as deleted.
--------------------
Setup
--------------------
Fade forms in and out (This has different effects on Windows XP and Windows 7 if enabled)
Turn record save messages on or off.
Snap forms to screen borders.
Show the current time on the title bar.
TUrn form and button tooltips on or off.
--------------------
Help
--------------------
About this program.
Show the program help file (if any)
Change the keyboard shortcuts.
--------------------
Exit
--------------------
Exit this program immediately, without warning. No data is lost.
----------------------------------------------------------------------------------------
Navigating the location bar.
----------------------------------------------------------------------------------------
This bar has three main states. Locations (Rooms) mode, Categories and Owners. All functions are
available from the "Mode" button on the top of the form, a right click menu of the mouse within the
bar, the control buttons underneath it and keyboard shortcuts.
Changing between them will load all the records for the selected state and then show the details for
the first record in that list, if any.
By default, All Items are displayed for a location bar state when changed. You can also select a
state where the record is empty for that state or marked as deleted.
For instance: If the location bar is showing "Locations" and you click on "Empty Items", any items
that do not have a location (Room) in their data are displayed.
Of course, this should never happen if I have coded Hive correctly and the application shouldn't
allow you to save a record without a location.
----------------------------------------------------------------------------------------
Navigating the item list bar.
----------------------------------------------------------------------------------------
This bar has a single function, to display records.
You may add records to it, copy selected record data to the system clipboard, delete records from it
(Only marked as deleted), edit selected records and list any attachments for the currently selected
record.
A record marked as deleted (Strike through font) cannot be copied, edited or printed until it is
recovered. Recovering a record is as simple as selecting it and then using the recovery menu function
from the Utilities menu (or one of the other methods. The strikethrough is then removed to indicate this.
As with the location bar, all functions are available from the "Mode" button on the top of the form,
a right click menu of the mouse within the bar, the control buttons underneath it and keyboard shortcuts.
----------------------------------------------------------------------------------------
Navigating Drag And Drop
----------------------------------------------------------------------------------------
If you consider an item belonging to the wrong Location, Category or Owner, while the location bar
is in the correct display mode, select the offending record, keep the left mouse button help down
and drag the record from the Item List bar and drop it onto the correct Location, Category or Owner
that you want it in.
The record data will be changed and saved, the display will change to the new Location, Category or Owner and that Location, Category or Owner refreshed to show the new record in there.
----------------------------------------------------------------------------------------
Navigating the search bar.
----------------------------------------------------------------------------------------
The searchbar has two functions as well as always displaying the current location bar mode that you are in and the currentlys elected item in the item list.
One is to select the type of SQL search that you want to peform within the string you will search (At this moment, only the item name is searched, no other field), and the search box where you start typing and instant results are reflected in the list. A "Drill-down" approach, this is the one that I prefer.
Of course, money can always persuade me otherwise (grin).
The SQL search type look like this:
Equal to = ' + SearchString + '
Does not equal <> ' + SearchString + '
Greater than > ' + SearchString + '
Greater than or equal to >= ' + SearchString + '
Less than < ' + SearchString + '
Less than or equal to <= ' + SearchString + '
Starts with LIKE ' + SearchString + %'
Ends with LIKE '% + SearchString + '
Sounds like LIKE '% + SearchString + %'
----------------------------------------------------------------------------------------
Navigating the Main Details area
----------------------------------------------------------------------------------------
This area will always show some very basic information about the record that is currently selected
in the item list bar. You cannot edit anything in there.
However, if you double left click the photograph area, you can change or add a photograph to the record.
----------------------------------------------------------------------------------------
Navigating the Main Details control bar
----------------------------------------------------------------------------------------
Photo button will allow you to you change or add a photograph to the record as above.
Receipt button will allow you to find and link a receipt file to the current record. There is no
limit to the number of Receipts that you may link in this fashion and all files are copied to the
Attachments directory so that the originals are undisturbed.
Warranty button will allow you to find and link a Warranty file to the current record. There is no
limit to the number of Warranties that you may link in this fashion and all files are copied to the
Attachments directory so that the originals are undisturbed.
Note button will allow you to launch a simple note editor to add or change the note for the current record instead of having to launch the full record editor form.
File button will allow you to find and link a file to the current record. There is no limit to the number of files that you may link in this fashion and all files are copied to the Attachments directory so that the originals are undisturbed. The usual idea is for people to link drivers to computer items in the database for ease of use.
The Copy, Delete and Edit buttons mirror the same functions available from the data menu.
----------------------------------------------------------------------------------------
Navigating the totals bar
----------------------------------------------------------------------------------------
Nothing for the token human to do here but watch the total value of items in the list to be displayed and get scared at how much they spent.
Currently, only the actual total cost of the items is counted and not tax, resale etc. That may change at a later date.
----------------------------------------------------------------------------------------
Navigating status bar
----------------------------------------------------------------------------------------
Once again, nothing for the token human to do here.
If I have coded this thing right, normal status messages will be shown in black and error messages will be shown in red.
As I remember them, error messages will be added, deleted or fixed to make sense.