Author Archives: Rob Laveaux

XL Plugin version 2.0 released

Posted on by

XL Plugin has been updated to version 2.0.6. This version includes many new features:

  • Added support for pre-emptive multi-threading.
  • Added support for Apple Silicon (M1) based Macs.
  • Added new commands xlSheetRangeToCollection and xlSheetCollectionToRange.
  • Added new commands xlBookGetSheetName, xlBookMoveSheet.
  • Added support for Excel templates, see xlBookGetTemplate, xlBookSetTemplate.
  • Added support for built-in Excel cell styles, see xlBookAddFormat.
  • Added new command xlBookGetVersion.
  • Added new command xlSheetSetRangeFormat for setting the format for a range of cells.
  • Added support for working with column width and row height in pixels, see xlSheetSetColumnWidth, xlSheetGetColumnWidth, xlSheetSetRowHeight and xlSheetGetRowHeight.
  • Added support for picture links, see xlBookAddPictureAsLink.
  • Added offset parameter to xlSheetGetPicture and xlSheetSetPicture.
  • Added support for data validation, see xlSheetAddDataValidation, xlSheetRemoveDataValidation and xlSheetAddIgnoredError.
  • Added xlSheetRemoveCellComment.
  • Added xlSheetIsDate to easily test if a cell contains a date value.
  • Added support for hyperlinks, see xlSheetHyperlinkCount, xlSheetGetHyperlink, xlSheetSetHyperlink and xlSheetRemoveHyperlink.
  • Added xlSheetSetAutoFitArea, xlSheetGetSplit, xlSheetSetTabColor.
  • Added support for auto filters, see xlSheetGetAutoFilter, xlSheetApplyAutoFilter, xlSheetRemoveAutoFilter, xlAutoFilterGetRange, xlAutoFilterSetRange, xlAutoFilterCountColumns, xlAutoFilterGetColumnByIndex, xlAutoFilterGetSortRange, xlAutoFilterGetSort, xlAutoFilterSetSort, xlAutoFilterAddSort, xlFilterColumnGetIndex, xlFilterColumnGetType, xlFilterColumnCount, xlFilterColumnGetFilter, xlFilterColumnAddFilter, xlFilterColumnGetTop10, xlFilterColumnSetTop10, xlFilterColumnGetCustomFilter, xlFilterColumnSetCustomFilter, xlFilterColumnClear.
  • Added new command xlSheetGetTables.

For details see the section Version history of the documentation.

More information on XL Plugin

DynaPDF Plugin version 2.1.7 released

Posted on by

DynaPDF Plugin has been updated to version 2.1.7. This version includes various bug fixes and the following new features:

  • Added various options to DynaPDF Render Page, allowing you to clip the resulting image to the trimbox, rotate a page and hide optional content layers according to their print-state.
  • Updated DynaPDF library to version 4.0.78.230.

For details see the section Version history of the documentation.

More information on DynaPDF Plugin

DynaPDF Plugin 2.1.6 released

Posted on by

DynaPDF Plugin has been updated to version 2.1.6. This version includes various bug fixes and the following new features:

  • Fixed a bug with DynaPDF Get File Attachment.
  • Added new command DynaPDF Get Image Info.
  • Improved DynaPDF Set Field Value: it now also sets the value for all children when the field is a group of text fields.
  • DynaPDF Check Conformance now correctly sets the option to not delete embedded files when checking for ZuGFERD or FacturX conformance.
  • Updated DynaPDF library to version 4.0.72.208.

For details see the section Version history of the documentation.

More information on DynaPDF Plugin

DynaPDF Plugin 2.1.3 released

Posted on by

DynaPDF Plugin has been updated to version 2.1.3. DynaPDF Plugin is the new name of QPDF Plugin. This version includes various bug fixes and the following new features:

  • Added new command DynaPDF Get Document Fonts, which returns information on all fonts used by a PDF document.
  • Added the options “deny-all” and “deny-nothing” to DynaPDF Close Document.
  • Updated DynaPDF library to version 4.0.70.198.

For details see the section Version history of the documentation.

More information on DynaPDF Plugin

NTK Plugin 4.1.1 released

Posted on by

NTK Plugin has been updated to version 4.1.1. This version includes the following bug fixes:

  • Fixed various issues regarding pre-emptive multi-threading concurrency, that could cause a deadlock.
  • Fixed a bug in JSON Get Keys. The array would be filled starting at position 0. This has now changed to position 2.
  • Fixed a bug in MQTT Poll that could create a deadlock.
  • Fixed a bug in TCP Open, which would only appear when the verbose option was set to true and when a unresolvable domain name was used.

For details see the section Version history of the documentation.

More information on NTK Plugin

DynaPDF Plugin 2.1.2 released

Posted on by

DynaPDF Plugin has been updated to version 2.1.2. DynaPDF Plugin is the new name of QPDF Plugin.

This version includes the following new features:

  • Added new commands DynaPDF Set Page Box and DynaPDF Get Page Box.
  • Fixed an issue in DeinitProcess with check on disposable objects.
  • Fixed two bugs in DynaPDF Replace Font: the test whether the fontname parameter is a path or just a name was not working correctly.
  • Fixed a bug in DynaPDF Get Page Text. This function would return an empty string if the extract text started with a null byte (0x00).
  • Added various improvements to DynaPDF Check Conformance. Warnings should be disabled because otherwise they will be treated as errors.
  • Changed error mode so that no errors are treated as fatal. It is now only used to setup the error log.
  • Fixed a bug with DynaPDF Create Table: A table must have at least 1 column and 1 row, otherwise it cannot be used.
  • Renamed DynaPDF Add Watermark Annot, DynaPDF Create Signature AP and DynaPDF Place Signature Icon because their names were too long.

For details see the section Version history of the documentation.

More information on DynaPDF Plugin

PostgreSQL Plugin 4.1 released

Posted on by

PostgreSQL Plugin has been updated to version 4.1. This version includes the following improvements:

  • Added support for Apple Silicon based Macs.
  • Updated PostgreSQL client libraries to version 14.1.
  • Added support for JSON fields to PgSQL Row To Object and PgSQL Rowset To Collection. These are now automatically transformed into objects or collections.
  • The plugin now also uses the new non-blocking API for establishing a connection. Al operations with PostgreSQL have become non-blocking. Because of this the asynchronous query option has been removed, since it has become obsolete. In case of problems, this behaviour can be disabled through the “non-blocking” option in PgSQL Connect.
  • Added per connection time-out setting. See the connection-timeout option in PgSQL Connect.
  • The implementation of the command PgSQL Get Open Connections has changed. It now returns a collection of objects with information about the active connections.
  • When a 4D process is ending, any connections belonging to that process are now automatically closed.
  • Enhanced support for options parameter in PgSQL Connect, so that all supported options in the connection string of PostgreSQL can be used.
  • Added support for gssencmode option. The plugin automatically sets this option to “disable” in order to prevent any further error messages.
  • Fixed a bug in PgSQL Send Copy Data.
  • Fixed memory leak when running a single SQL query that returns multiple results sets, and while not retrieving unused result sets.

For details see the section Version history of the documentation.

More information on PostgresQL Plugin

MyConnect Plugin 4.0.1 released

Posted on by

MyConnect Plugin has been updated to version 4.0.1. This version includes the following improvements:

  • Added new option “non-blocking” to enable the old blocking API of MySQL. This option can be used if you are having problem with for example MySQL servers running on Azure.
  • Added new option “init-command” to set SQL statements that are automatically executed when connecting to a MySQL database or when a reconnection occurs.
  • Fixed a bug whereby connection references becoming invalid. This problem only appeared when dealing with a particular combination of multiple 4D processes and context switches.

For details see the section Version history of the documentation.

More information on MyConnect Plugin