All of the exported HansaWorld files contain a header similar to this:
format 1 46 1 0 0 44 0 / codepage UTF-8 HansaVersion 8.1 2015-12-15 (build 81310400)
The second row of the header describes how flex.bi should interpret the file and it's contents
If the header is not correctly configured according to the contents of the file then the data will be imported incorrectly. For instance if the thousand separator is marked as space (32) and the file contains thousands displayed as 1,000 then flex.bi will read this data as 1. So if your data is grossly inaccurate double check the header of your file, because this is most likely the cause.
Bug in Standard ERP 8.1 2015-12-15
In HansaWorld Standard ERP 8.1 2015-12-15 version, files may be exported with wrong thousand separator code in the header.
If there are problems with your exported data formats, contact your HansaWorld consultant.
The positions and numbers of the second row describe the following:
The date sequence | Decimal separator | Import type | Existing data replacement | Row character sets | Thousand separator | Row escape character | Date separators |
m4_mdy = 0, | 46 = . | 0 = mac | 0 = replace data | 0 = Given type | 0 = no separator | 0 = none | Enter the symbol you are using as a date seperator |
m4_dmy = 1, | 44 = , | 1 = windows | 1 = don't replace data | 1 = Unicode | 32 = space ( ) | 1 = backslash (\xNN = hex byte NN, \N = symbol N, two \ = one backlash) | (Examples: "-", "/", ".") |
m4_ymd = 2, | 44 = comma (,) | 2 = < and > (<NN> = hex byte NN) | |||||
m4_myd = 3, | 45 = dash (-) | ||||||
m4_dym = 4, | |||||||
m4_ydm = 5, | |||||||
m4_hijri = 6, | |||||||
m4_persian_date = 7 |