WDF/BA Updates and improvements

 Permalink
wdf/ba

 WDF/BA Updates:


- Added database column names to $rsMAIN. Now, when no records are found, the apps can export an empty file with correct column headings.
- Replaced regular string functions by their multi-byte equivalents.
- Added the number of activations and allowed total number of activations to the Serial Number API email response.
- New function : mv_array_count_keys(). This function counts the number of occurrences of a specific key in a one- or multi-dimensional array.
- New function: mv_array_sum(). This functions sums each occurrence of a specific key in a one- or multi-dimensional array.
- Improved function: mv_str_starts_with().
- GP006MNU: Added automatic filling in of a new sequence number for a new entry.
- PFD001: Added /drbd/ path to find uploaded files.
- Added ob_clean() before exporting data to Excel or CSV.
- Various code improvemnets.

WDF/BA Updates and improvements

 Permalink
wdf/ba

 WDF/BA Updates:


- Improved handling of excluded keys in GP001.
- Suggesting a default type for a new text in GP001.

- Added the possibility to get only certain file type data in fw_getFileExtensions
- Added database table column names array to the output of fw_execSQL_array, so you'll always have column names, even if the query returns no records. - Modified export_data to use the new array with column names, instead of the record set.
- Added the Webshop.stack manual to this website. - Added a Google translate button to all manuals on this website.

A change and a fix

 Permalink

 WDF/BA Updates:


- Improved CSS for subfiles


- Fixed a problem with wrong column formatting in certain situations with Excel-exports.


Improvements and fixes

 Permalink

WDF/BA Updates:


- Added a confirmation dialog to the multi-delete functionality. Now you have to confirm that you really want to delete the selected records. This of course works only in applications where multi-delete is activated.


- Preparations to replace the current encryption method to a more modern one. This is necessary because of the move from CentOS Stream to Fedora 36, which gives a totally different results with the now called 'legacy' encryption method. This change had an impact on all interactive applications, and, depending on the customer, some batch applications.


- Improved the Google Distance Calculator API call.


- Excel exports now keeps the contents of a multi-line text field together in one cell, where applicable.


- Various under the hood improvements and fixes.

Additions, fixes and changes

 Permalink

WDF/BA Updates:


- 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 additions

 Permalink

WDF/BA Updates:


- In GP004 or MD007, the 'Default Menu' button is now greyed out when there is no default menu defined.

A default menu can be defined in GP006, by using keys with prefix 'DFTMNU' followed by something you fancy, for example 'DTMNU10', 'DTMNU20', etc.. 

The alphanumeric field should contain only the name of the application, like 'gp006', and the numeric field should contain the sequence number for the order of the menu items.


- Added a 'Clear search fields' icon-button in list view, next to the 'Search' button.


- CSS changes for improved mobile display.


- For Excel exports, now we can define which names to use for column headings: the long or short ones.


- Added a password generator icon-button in MD005 next to the password field.


- Added an improved password tester to MD005, so a user can only use a good and strong password.


- Added 'Kind of customer' to MD000. You can choose from 'An own company', 'Customer', 'Supplier', 'Both (C & S)' or 'Other'. If you do not have this, or something similar, in your implementation, and you want it, contact me for a quote.


- Various under the hood changes and fixes.

Improvements, fixes and updates

 Permalink

WDF/BA Updates:


- Added parameter 'DEFAULTCOUNTRY' to GP006. It should be filled with a 2-character ISO country code, like 'NL', 'DE', 'BE', etc.. It is currently implemented in GP008, GP011, GP014, MD000 and MD001. If it does not seem to work with your implementation, your applications haven't been updated. Contact me to get a quote, if you want this.


- Exporting multi-line text to Excel, now results in each line in its own row. If you want the old functionality back, let me know.


- Now that all sites use HTTPS, I have implemented secure cookies . This ensures that you can only login via HTTPS.


- Auto-complete on tags in GP009, to make it easier to quickly add existing tags, without having to guess how they're named.


- Under the hood updates and fixes.

Various changes and additions

 Permalink

WDF/BA updates:

- Added the possibility to pass more info about the used filters in list view, to the export header.

- Fixed a formatting poblem in Excel/CSV export.

- Position of the confirmation-dialog, when deleting a record, is now a bit higher on screen.

TagEditor styling and Date calculations

 Permalink

WDF/BA updates:

- TagEditor styling: set a maximum width.

- Fixes inside the date calculation routine that could cause 'Passing null to...' errors.

- GP008/10/13: An error message was not translated into the chosen language.

- MD005W: Bug fix.

- Added automatic amount formatting of fields on Excel/CSV export.

Excel/CSV export and Tooltips

 Permalink

WDF/BA updates:

- Improved automatic formatting of date and time fields with Excel/CSV export.

- Tooltip fix: tooltip will now be hidden when you click somewhere else.


Categoriën

Archieven

On this website, Google Analytics is used to track visitor statistics. These are anonymized data about the number of visitors, which pages they visit on this site, from which regions they visit, which web browsers they use, etc..
Privacy Statement