Loading data from a Xml with special characters

Stimulsoft Reports.JS discussion
Post Reply
rjorge99
Posts: 12
Joined: Tue Feb 28, 2023 6:24 pm

Loading data from a Xml with special characters

Post by rjorge99 »

I'm trying to load data from a Xml, but because it has some special characters, I cant make it show right. I read the documentation but still cant make it work. Any ideas ?

The special characters I mean are: á, Á, é, É, etc.

A sample of the xml is the next one:

Code: Select all

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
	<repfinaltmp>
		<fechabitacora>08/09/2022 01:52:59 PM</fechabitacora>
		<evento>Cambios</evento>
		<modulo>Sistema</modulo>
		<cve_docum>23</cve_docum>
		<pantalla>Catálogo de usuarios</pantalla>
		<rep_fol>1</rep_fol>
		<refe_docu2/>
		<ffecha1/>
		<ffecha2/>
		<version>1</version>
		<usua_bitac>1</usua_bitac>
		<nombreusu>JOSE - PÉREZ GONZÁLEZ</nombreusu>
		<cve_depto>1</cve_depto>
	</repfinaltmp>
	<repfinaltmp>
		<fechabitacora>08/09/2022 01:54:26 PM</fechabitacora>
		<evento>Cambios</evento>
		<modulo>Sistema</modulo>
		<cve_docum>5</cve_docum>
		<pantalla>Conversaciones</pantalla>
		<rep_fol>40</rep_fol>
		<refe_docu2/>
		<ffecha1/>
		<ffecha2/>
		<version>2</version>
		<usua_bitac>1</usua_bitac>
		<nombreusu>JOSÉ - PÉREZ GONZÁLEZ</nombreusu>
		<cve_depto>1</cve_depto>
	</repfinaltmp>
	</repfinaltmp>
</VFPData>
Thanks
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Loading data from a Xml with special characters

Post by Lech Kulikowski »

Hello,

Please try to remove "encoding="Windows-1252"" from your XML.

Thank you.
rjorge99
Posts: 12
Joined: Tue Feb 28, 2023 6:24 pm

Re: Loading data from a Xml with special characters

Post by rjorge99 »

That worked.

Thanks
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Loading data from a Xml with special characters

Post by Lech Kulikowski »

Hello

You are welcome.
Post Reply