QueryTool PROD 25.0.68
we have a small issue on char mishandling with fnx.sie.SieFileByType with query tool
the [¨] & [°] are not not well decoded.
see for example : “#KONTO 1114 “F�RR�DSBYGGNADER 100%”
instead of #KONTO 1114 “FÖRRÅDSBYGGNADER 100%”
we refer to this task Handling Swedish SIE files for Fortnox - 3 van sda
run the code below to reproduce:
create or replace table sie_file@inmemorystorage( FinancialYearId number, FinancialYear number, Result clob);
insert into sie_file@inmemorystorage (FinancialYearId, FinancialYear, Result)
select 27, 2025, Resultfrom fortnox.Sie.SieFileByType@fnx(4, 27);
insert into sie_file@inmemorystorage (FinancialYearId, FinancialYear, Result)
select 26, 2024, Resultfrom Fortnox.Sie.SieFileByType@fnx(4, 26);
create or replace table sie_lines@inmemorystorage as
select
f.FinancialYearId,
f.FinancialYear,
t.line
from sie_file@inmemorystorage f
join csvtable(
passing replace(f.Result, chr(13), '') -- normalize CRLF → LF
row delimiter chr(10)
column delimiter chr(9) -- dummy delimiter
columns line varchar2 position next
) t
where t.line is not null
and length(trim(t.line)) > 0;
select * from sie_lines@inmemorystorage
