We need to import payments from a payment broker through the External File interface. But the file amounts are created with the thousand separator dot (.). We have tried to remove the dot using formulas in the External File Template Details section but with no result. On all rows with high amounts the status turns to “Unpack error” and the error message is “ character to number conversion error”.
We would very much prefer to load these files without having to manipulate them before they are imported.
Please advice!