Asset Tracker Versions

Number Released Notes
2.81 2023-11-30 Based on ChatGPT suggestions, streamline AT_email, files, rosters, show, util
2.80 2023-11-17 - Add "Last DB update" to AT_config
- Streamline AT_file_view
2.78 2023-11-17 - Created a git repository for AT/Sample
- In AT_form changed date fields from text to date
2.77 2023-09-16 - Moved _g_path() from AT_show to AT_util so AT_table can use it
- updated filtertable and tablesorter to the latest versions
2.76 2023-08-06 - Changed all AT roster names to singular form
- Added table-name to AT_util.g_attr() and AT_g_alias()
2.75 2023-07-14 - Clarified CRUD in Help, updated CRUD in AT_Table and AT_Form.
- Cleaned up all scripts with flake8
2.74 2023-04-17 - Apostrophes allowed in all fields saved as text (text, long, menu, checks, and radio).
- Refactored AT_email, cosmetic improvements in AT_table. AT_mirrors uses the csv module.
2.73 2023-03-10 AT_form can display apostrophes in text and long fields.
2.72 2023-02-26 - All .html files and .py files that create html pass the HTML5 validation
- For date fields changed the input type from text to date.
2.71 2023-02-22 Moved show() from AT_util to AT_show
2.70 2023-02-21 - Form+proc can handle all correct ints and floats in number fields
- Upgraded to jquery 3.6.3, jquery-ui 1.13.2, and summernote 0.8.18
2.69 2023-02-07 Added type hints to all functions. Fixed a bug in AT_form_proc.
2.68 2023-01-27 Updated jquery script to 3.6.3.slim.min and moved it from AT_form and AT_table to AT_util.
2.67 2023-01-24 Added site links to AT_config.
2.66 2023-01-20 Improvement in AT_form_proc: show changed fields in AT_audit when an instance is updated.
2.65 2023-01-13 Fixed a bug in AT_form_proc.
2.64 2023-01-10 Cleaned up AT_files.
2.63 2022-12-16 Cleanup and refactor modules.
2.62 2022-10-18 AT sends emails using kmaiwand@gmail instead of billing@highcotech.
2.61 2022-10-18 Critical bug fixes
2.60 2022-10-05 Added the 'alias' attribute to AT_meta. It is used as label in table and form instead of tag.
2.54 2022-09-30 AT_config has an entry to replace a pattern (e.g. '_') with a blank in table and form labels.
2.53 2022-09-22 Critical bug fixes
2.52 2022-09-15 Moved 'init_app' from AT_custom to AT_config
Moved g_key() from AT_form_proc to AT_util as g_keys()
2.51 2022-09-13 Bug fixes
2.50 2022-08-25 The db id in all rosters is renamed from 'key' to 'id'
The 'name' field in all rosters is renamed to 'key'
AT_db.rename_column( 'AT_meta', 'name', 'key'). Edit AT_meta to make the changes above.
2.49 2022-03-27 Adusted help.html
Renamed sample.py to home.py. home.html calls home.py
2.48 2022-01-06 AT_custom.init_app() reads the users roster names from AT_roster.
System is now the owner of AT_picks.
Updated Creating a new application section in AT_help.html
2.47 2021-11-16 Minor changes and clean ups made while upgrading Billing.
2.46 2021-09-16 Changed internal functions in all modules to start with an underscore.
2.45 2021-09-09 Extracted from AT_util 4 new modules: AT_mirrors, AT_rosters, AT_email and AT_files.
Need to change in AT_custom AT_util.create_roster() to AT_rosters.create_roster()
2.44 2021-09-05 Fixed saving/restoring files. Moved deleteFile() from AT_form_proc to AT_util.
2.43 2021-08-22 Set App Password for billing@highcotech and updated send_email() in AT_util to use it.
2.42 2021-06-11 Saving/restoring files working now, but need more testing.
2.41 2021-05-27 Added 'name' to field properties. Used for AT_util.record(). Must change AT_meta to use it!
Moved log-file.html to Data.
2.40 2021-04-29 Took version out. Fixes in AT_util, minor changes to AT_config, Reverted to help with sidebar.
2.39 2021-04-11 Minor changes to form_proc.py, custom.py, form.py and default.css.
3.38 2021-03-13 Overhauled long_text fields. Handle better locked fields.Added an entry to DB to make AT_table font size adjustable.
2.37 2021-03-07 Added an entry to DB to make AT_form font size adjustable.Added global actions to AT_config. Changed AT_custom.init_app().
2.36 2021-02-19 Changed most modules because renamed at/ to lib/
2.35 2021-02-16 Improvements to AT_login, AT_form, form-utilities-q, AT_default.css
2.34 2021-01-17 Bug fix n AT_util, and minor improvment to AT_login
2.32 2021-01-02 Minor improvement in AT_util, replaced AT_user with AT_login, bug fixes in AT_form, and improved responsiveness
2.31 4/2/2020 Fixed a bug with summernote. Fixed UTF-8 for Windows. Cosmetic improvements
2.3 3/30/2020 Replaced the home-grown editor with summernote
2.29 3/25/2020 New styled Help page, in make_table() renamed sort to sortby
2.28 3/18/2020 Fixed a minor bug. Table sort order is preserved after an update.
2.27 1/7/2020 "Changed AT_util to write the application log to a file, not the AT_message table."
2.26 12/1/2019 Fixed minor bugs:
- in AT_form multiple checks selections were not showing
- in AT_table sorting was not working.
- in AT_util fixed unlock()
2.25 9/16/2019 Deleted Time from AT_message and renamed Date to Timestamp. Fixed a bug in form_proc.
2.24 9/10/2019 Converted all strings in all py files to f-strings
2.2.3 12/19/2018 ~ Used Hamid's style for the table
2.2.2 12/15/2018 ~ Emails are sent with the app name as sender
2.2.1 12/10/2018 ~ Made changes required for Python 3: use string.format, form.getvalue(), print(), x in form
2.2.0 12/7/2018 ~ Moved AT_custom to the parent directory
2.1.9 1/22/2018 ~ Moved help from AT_help.py to AT_help.html
2.1.8 1/12/2018 ~ In AT_form.py: combined add_form() and edit_form() into make_form()
2.1.7 1/9/2018 ~ Updated sqlite3 version from 3.6.1 to 3.21.0
~ Moved the sqlite database from the at folder to its parent folder
2.1.6 1/2/2018 ~ Streamlined AT_user.py and password reset process
~ Tried to move the DB file out of at ? did not work!
2.1.5 12/16/2017 ~ Bug fix in AT_config to correctly show the reactions on the same page
~ Date format can be specified in AT_config
2.1.4 12/4/2017 ~ Used input type = number in AT_form.py
~ Created a script for migrating older databases to this format
2.1.3 11/11/2017 ~ Added password reset. Added send_email() to AT_util
2.1.2 11/9/2017 ~ Introduced authentication, added AT_user.py and AT_users (adjust meta and config, add home.html)
2.1.17 10/26/2018 ~ Improved AT_util.send_email()
2.1.16 7/21/2018 ~ Changed custom.py and form_proc.py: All custom code is called after the action (add, edit, delete instance)
2.1.15 5/13/2018 ~ AT_db.py could only be invoked in its own directory, made it location independent.
2.1.14 2/26/2018 ~ The long text editor supports removing tags surrounding a selection
2.1.13 2/7/2018 ~ Added Help to the banner and used jQueryUI
2.1.12 2/1/2018 ~ AT_util.send_email() now accepts plain text and HTML
2.1.11 1/29/2018 ~ Minimized AT_custom by moving generic stuff into form_proc and util
2.1.10 1/24/2018 ~ AT_config performs the selected action, no submit button is requied
2.1.1 10/30/2017 ~ AT_table calls AT_form using POST (parameters are not shown in the URI)
2.1.0 10/25/2017 ~ Replaced the Link data type with Long, including a simple editor (adjust user rosters)
~ used jQuery 2.2.4 in utilities~form.js and AT_form.py
~ Moved data files for user rosters out of at (adjust config and roster)
2.0.7 9/14/2017 ~ AT_config now uses AT_util.show()
~ Added a footer to index.html
~ Fixed the charset line
2.0.6 9/1/2017 ~ Fixed AT_form to allow changing files with dangling references
~ AT_config shows the results on the same page
~ Improved audit logs
2.0.5 8/25/2017 ~ Bug fixes in AT_util and HTML5 adjustments
2.0.4 7/4/2016 ~ Added a del_flag to AT_files, which is set to yes when a file in a roster is deleted.
~ All existing applications of AT can use this version without modifications
2.0.3 3/6/2016 ~ Made AT_default.css responsive for iPhone
2.0.2 8/29/2015 ~ Fixed a bug in AT_util.create_roster()
2.0.1 7/4/2015 ~ Text fields accept 8~bit characters (umlauts etc.)
2.0.0 6/26/2015 ~ Meta data for all tables is stored in AT_meta
* Renamed in AT_db.py:
* add_table() to create_table(),
* delete_table() to drop_table()