AssetTrackDB v2.0 Update

Hello Everyone!

I just wanted to drop a quick note to say that I am making progress on v2.0. In the next week or two I will update the v2.0 demo.

At this point I hope to have it complete and ready for production by the end of the school year, lets say May 2018.

Anyway, back to coding!
-Tyler

AssetTrack DB R19 Issue & Future

R19 Issue
Earlier today I noticed a mistake I made in the R19 release that would prevent the database being updated correctly when updating from R17 or earlier. As of now this has been corrected in the R19 release. The mistake itself will not cause data loss, however continuing to use the incorrectly updated database may end up causing data loss when retiring or disposing assets.

  • If you updated from R18 to R19 there is no issue and nothing needs to be done.
  • If you updated from R17 or earlier to R19, you need to perform the update for R19 again.

The Future.
As some of you already know I have started the process of completely rewriting AssetTrackDB for version 2. I have been working on AssetTrackDB for three years now and over the course of time my PHP / MySQL skills have improved considerably. I had initially considered rewriting the code slowly as I progressed, however, this proved to be a monumental task and I spent more time fixing issues than getting anything accomplished. So the complete rewrite has started!

If you want to see the progress of v2 click here and login as:
U: admin2
P: admin

So far the progress is limited to these sections: Home, Assets > Assets, and Add > Asset.

More updates on the progress of AssetTrackDB v2 soon!

-Tyler

AssetTrackDB R19 Released!

Feb 24, 2016

R19 contains the following fixes and improvements:
-Update check now slightly more intelligent
-Expanded max length of asset names from 25 characters to 100
-Expanded max length of serials from 30 characters to 100
-Expanded max length of bar code from 15 characters to 100
-Expanded max length of model from 35 characters to 100
-Expanded max length of brand from 25 characters to 100
-Expanded max length of owner from 25 characters to 100
-Expanded max length of people from 25 characters to 100
-Fixed an issue where disposing an asset might fail under some conditions
-Added button to track asset again immediately after checking in asset
-Fixed an issue where Assets page would not display the Quick Search / Filter that is applied (IE: Form: Tablet)
-Fixed some Quick Searches / Filters not persisting across multiple pages: Use, Created By, Funding, CO Room
-Added text explaining wildcard searches to Quick Searches and Multi-Layer Search pages
-Added user preference to change the number of Recently Added Assets, Recently Tracked Assets, Recently Updated Assets on the home page
-Multi-Layer Searches will now show explanation on Asset page (IE: Multi Layer Search: name = Dell AND track.user = 16)
-Database update needed will longer show immediately after update has been performed
-Database is automatically backed up and saved in the backups directory before database update

Links on the Download / Installation / Update pages have been updated to reflect R19.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com
JSColor: http://JSColor.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

AssetTrackDB R18 Released!

Nov 18, 2015

R18 contains the following fixes and improvements:
-Minor visual improvements
-Added Purchase Date as an option on Quick Searches and Multi-Layer Searches
-Added Multiple pages to Manage People Page
-People can now have ID numbers
-People can now be edited (Name, ID)
-Add option to change user password from Prefs page
-Fixed a bug preventing bulk update actions on assets with spaces in serial numbers
-People are no longer deleted, they are disabled/hidden and information is retained for tracking info
-Quick and Multi-Layer now have the option to search for CO user
-Note this does not have to be exact, IE: adding a CO User quick search for "18" will find all assets that are checked out to users with 18 in their name
-Fixed and issue preventing saving settings under Setup > Settings
-Bar Code (AKA Asset Tags) can now contain letters
-Multiple speed fixed, most notably for Quick Searches and/or filtering from the Assets page

Links on the Download / Installation / Update pages have been updated to reflect R18.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com
JSColor: http://JSColor.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

AssetTrackDB R17 Released!

May 3, 2015

R17 contains the following fixes and improvements:
-Fixed issue that prevented custom visual settings from being reset unless custom visuals where enabled
-Bulk check out now gives option to check out to one person or multiple at the same time
-Fixed issue with custom visuals being overwritten on login page after update

Links on the Download / Installation / Update pages have been updated to reflect R17.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com
JSColor: http://JSColor.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

AssetTrackDB R16 Released!

March 3, 2015

R16 contains the following fixes and improvements:
-Fixed an issue with php errors being displayed (only showed if php was set to to display errors)
-Added reset custom to default button on Setup > Visuals
-Small changes to Setup > Site Access to make it easier to read
-Fixed issue causing menu to (slightly) change position on some pages
-Menu now underlines the name of the current page
-Fixed a bug where searches with certain characters would cause a mysql error
-Fixed issue with site access logs not sorting correctly
-Fixed issue preventing site users from being deleted if only one admin user remained. Note: Last admin user cannot be deleted
-Delete Confirmation now required before site users are deleted
-Logo text is no longer an image
-Added Logo Text Color option on Setup > Visuals
-Fixed bug preventing View Tracking by building from working

Links on the Download / Installation / Update pages have been updated to reflect R16.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com
JSColor: http://JSColor.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

Small Bug!

FYI: A small bug that prevented accessing the Settings page (Setup > Settings) was discovered in R15. I have fixed the bug and updated the R15 download. If you are already running R15 you can install the fixed version by following the normal upgrade instructions.

AssetTrackDB R15 Released!

Jan 15, 2015: AssetTrackDB R15 Released!

R15 contains the following fixes and improvements:
-Added ability to restore database from backup (See Setup > Backup)
-Non-Admin users can no longer access: Setup > (Site Access, Visuals, Asset Export, CICO Import, Asset Import, Settings, Update)
-Fixed issue preventing Checkout Info from being displayed on display.php for read only users
-Fixed an issue causing Custom2 fields drill down incorrectly on the asset_list page
-Added device info to confirm asset delete page
-Added confirm to bulk asset delete
-Files that are no longer needed with be deleted when update is run (add_asset_e.php, add_image_e.php, menu.html, report.csv, search.php, searches.php, siteaccess_a.php, siteaccess_d.php)
-Database backup is no longer stored on the server it is piped directly for download, old AssetTrackDB_backup.sql file is removed by update
-Site access logs now ordered by date, time
-Bad Username/Password now displayed on login page when incorrect login info supplied
-MySQL Error info now displayed on login page (after one login or asset check attempt)

Links on the Download / Installation / Update pages have been updated to reflect R15.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com
JSColor: http://JSColor.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

AssetTrackDB R14 Released!

Jan 8, 2015: AssetTrackDB R14 Released!

R14 contains the following fixes and improvements:
-Bulk Image added, allow one image to be applied to multiple assets
-Added PDF format for image upload
      -If ImageMagick is installed jpg thumbnail generated
-Fixed issue where copying some assets would fail
-Added ability to import asset check in / check outs. See Setup > CICO Import.
-Added ability to adjust some visual elements (header, buttons). See Setup > Visuals
-Added Changelog button under Setup
-Added ability to view tracking based on asset bar code / asset tag
-Fixed an issue preventing apostrophes from being used in tracking condition out and condition in

Links on the Download / Installation / Update pages have been updated to reflect R14.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com
JSColor: http://JSColor.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

AssetTrackDB R13 Released!

December 4, 2014: AssetTrackDB R13 Released!

R13 contains the following fixes and improvements:
-Updated to use MySQLi
-Minor Cosmetic Improvements
-Minor Bug Fixes
-Start implementation of Federal Grant tracking (nothing visual yet)
-Diagnostics page now shows PHP filesize upload limit

Links on the Download / Installation / Update pages have been updated to reflect R13.

Notes:
AssetTrackDB includes and makes use of the following projects, each with its own license, more information available on their websites.

sorttable: http://kryogenix.org/code/browser/sorttable/
jsDatePick: http://javascriptcalendar.org
jQuery: http://jquery.com

Also, a massive THANK YOU to these projects, without them AssetTrackDB would not have some of the features it has.

Pages

Subscribe to AssetTrackDB RSS