This topic aims to discuss using DriveWorks with different regional settings.
This will also detail what the limitations are and provide recommendations and workarounds where applicable.
Two functions have been added to the DriveWorks-SpecificationPowerPack that will help users experiencing this behavior:
You will find below a non exhaustive list of known issues related to running DriveWorks on a system with regional settings using something different than point decimal separators.
DriveWorks imports data from external applications as strings, the data isn't formatted but is imported as is.
This means that if an external application uses commas as decimal separators, this data will be imported in DriveWorks using commas instead of points.
This can be experienced with:
DriveWorks can store data into Specifications but also in created files or in databases.
This data can then be used by DriveWorks or by external applications.
It is important to know that if your system is using commas as decimal separators, exporting data using DriveWorks can be affected and may not produce the expected results.
DriveWorks can use data stored in Specifications or data from files or databases.
There can be issues if this data is stored with comma separated formatting.
We would recommend making sure that static imported data is converted using point decimal separators when possible, as this will eliminate the need to convert numbers each time they are used.
Then you can use functions like NumberLocal to display values on your Forms or in Documents using your regional settings number formatting.
Unfortunately, regarding dynamic data such as queried data, there are no built-in solutions to convert the number formatting and you may encounter problems.
Another thing to keep in mind is that exporting numbers to an existing DriveWorks Table containing comma separated values will export them as point separated numbers, so you may end up with inconsistencies in number formatting.
Two functions are included in the DriveWorks Specification Power Pack:
These functions allow numbers to be converted from one culture to another. They can be used to convert comma separated values to point separated values in order to perform DriveWorks calculations, drive models or export documents but can also be used to display values in specific cultures formatting.
These functions can be used in the scenarios described above.