Encode error when reading script with must_include

kkmoraes — Sun, 02 Jan 2022 03:50:24 GMT

Hello everyone, I'm having problems when trying to read some files using must_include,
I would like your help to solve.

I have some generic scripts that I'm reading like this:

NaturezaDespesa: Mapping LOAD Natureza_Despesa_Cód, Item_Despesa_Nome FROM $(vLoadDadosVitor)CADASTROS_FNTDET_NATDESP_NATREC\Item_Despesa.qvd (qvd); Elemento: Mapping LOAD Elemento_Despesa_Cód, Elemento_Despesa_Nome FROM $(vLoadDadosVitor)CADASTROS_FNTDET_NATDESP_NATREC\Elemento_Despesa.qvd (qvd);

this script is in a separate .qvs, I'm reading the data as follows:

LET v04_00_carga_bd_fatos_bases_gct = '...carga_bd_fatos_bases_gct.qvs'; $(must_include='$(v04_00_carga_bd_fatos_bases_gct)');

But I'm having a problem, which I believe is related to the encode at the time of reading,
Qlik is having problems reading accented characters and it is returning an error message that the field does not exist,
because it is breaking with the character set

ex:

Cód
Ação

If I read the script directly in qvw without being via include, it works normally,
does anyone have any solution?

I'm attaching an image with the error to make it easier to understand

Thanks!

Re: Encode error when reading script with must_include

kkmoraes — Sun, 02 Jan 2022 14:54:23 GMT

For future reference, @vadimtsushko 's answer helped me
He was having the same problem, and found that he needed to convert the file into UTF-8 BOM format.

I did the same here and it worked

https://community.qlik.com/t5/QlikView-App-Dev/How-can-I-use-include-files-saved-in-UTF8/m-p/428584

topic Re: Encode error when reading script with must_include in QlikView

Encode error when reading script with must_include

Re: Encode error when reading script with must_include