WDF/BA Updates and improvementsSun, Apr 30 2023 Permalink
- The key combination ALT/OPTION-ENTER now also works in EDIT-mode and puts the focus on the 'Submit'-button. This allows for quick and almost keyboard-only data entry.
- In listview, you can now use the arrow keys to select a record. The page will automatically scroll up or down when you reach the botoom or top. Hit ENTER to open the selected record in VIEW-mode, the hit ALT/OPTION-ENTER + ENTER to start EDIT-mode.
- Fixed a bug with the user's account expiration date.
- Improved the country-selection drop down menu contents, now that country codes have subcountry codes, like 'IT-21', 'US-AK', etc.. in GP008/11/14, MD000/1/2/5.
- Various other fixes and improvements.
Changes, additions and updatesTue, Jan 31 2023 Permalink
- Faster searching on the date in GP000, PFD000 and PFD001.
- Added the name, and a description, of the cron job to GP002.
- GP002 now also shows if the job is actually running or not, by showing a red number next to Yes/No in column 'Running'.
- Added a function 'mv_checkVATID', which checks a VAT-ID format and then at VIES.
- Added the hostname to the HEAD section of each app.
- Added a 'Log All' switch, which overrides the log level when on a development server, or for a super user on any server.
- Added Chamber of Commerce, Bank data and Payment Term to MD001, and removed it from MD000, where applicable.
- Moved variables used in both interactive and batch applications into a single file.
- Added system variable 'DEFAULTCOUNTRY' (GP006) to GP008, GP011, GP014, MD000 and MD001.
- Added currency data (name, abbreviation, symbol, decimal separator) to countries (GP007).
- Added currency variables, which are read from 'countries', initially with variable 'DEFAULTCOUNTRY'.
- Formatting masks are now formatted after reading currency data.
- Added VAT or GST data (type, high/middle/low %, valid from date) to countries (GP007).
- Added a new function 'mv_generateSerialNumber' to generate a serial number that can be en-/decoded in PHP and Xojo (and other languages if needed).
- Changed database tables and columns from latin1 to utf8. All tables and columns are now utf8.
- Various CSS and Code improvements, and bug fixes.
Improvements and changesFri, Sep 30 2022 Permalink
- Timeout of application and 2FA: when logged in via 2FA, the application now times out after 12 hours of inactivity. Note: this can be overridden by the web browser, which can put the inactive tab or window to 'sleep', which means that nothing runs on that page anymore, until it is activated again.
- Improved the Google GPS API call & GP014: remove cq. replace UTF-16 characters or certain ranges of extended UTF-8 characters from a street name.
- GP000: Improved search on short dates/times, like '2022-09-12 05'.
- GP010: Widened the text display of the task description.
Additions, fixes and changesTue, May 31 2022 Permalink
- GP014: New! CO2 emission calculation added. To comply with new regulations, you can now see how much CO2 will be output for a certain from/to address combo. The mean emission value per 100 Km can be set in GP006, by adding a key named 'GEMCO2' and give it a numeric value for the emission in Kg per Km. The formula to calculate the mean value is:
((Liter/100 Km * Kg(C + O2)) / 100)
With a mean value of 2,392 Kg per 100 Km, and a usage of 8 liters gasoline for 100 Km, the formula becomes:
((8 * 2.392) / 100) = 0,19136 Kg per Km
Source: wijkopenautos.nl magazine
- New! A Two Factor Authentication (2FA) module can now be added to your implementation of WDF/BA. It can do 2FA via email and/or text messages (regular SMS). For use with email, you will need an email address + all settings (username, password, mail server, ports) which needs to be configured in WDF/BA to send emails with. For SMS, you wil need an subscription with an SMS provider. WDF/BA 2FA module currently supports MessageBird and Clickatell for sending via SMS. If you want, or need, 2FA for your business, contact me for a quote.
- Added 'scroll into view', which scrolls the list view page to the last examined record, if known to the application. The last examined record has a light blue background.
- Added a new file name cleaning function to clean the names of uploaded files. The following characters are:
- replaced : ü by u, ç by c, etc. if possible.
- removed : all non-ascii characters
- removed : "'~`;:\/()
- replaced by a - : &
- replaced by a _ : spaces
- Added Excel / CSV export for TinyMCE text data. Images will not be exported, only text.
- Improved height calculation of text areas.
- Various under the hood improvements and fixes.
Various changes and additionsThu, Jun 24 2021 Permalink
- Various under the hood changes and bug fixes.
- Added a modal 'Processing' dialog for interactive processes that might take a while.
- MD005: Added a link next to the username, to the menu editor GP004/MD007
- I did a hacking course and harnessed the framework some more to prevent hacking.
- GP014: Get GPS coordinates via Google, and store them in the distance table. If you want to use this functionality with other addresses, contact me for a quote.
Mac OS X
Apr 2023 (3)
Mar 2023 (2)
Feb 2023 (1)
Jan 2023 (1)
Dec 2022 (1)
Nov 2022 (1)
Oct 2022 (1)
Sep 2022 (1)
Aug 2022 (1)
Jul 2022 (2)
Jun 2022 (1)
May 2022 (1)
Apr 2022 (1)
Mar 2022 (1)
Feb 2022 (1)
Jan 2022 (1)
Dec 2021 (1)
Oct 2021 (1)
Sep 2021 (1)
Aug 2021 (1)
Jul 2021 (1)
Jun 2021 (1)
May 2021 (1)
Apr 2021 (1)
Jan 2021 (1)
Dec 2020 (1)
Nov 2020 (2)
Oct 2020 (1)
Sep 2020 (6)
Aug 2020 (4)
Jul 2020 (4)
Jun 2020 (7)
May 2020 (4)
Apr 2020 (3)
Feb 2020 (3)