Page 1 of 1

Loading data from a Xml with special characters

Posted: Mon Mar 06, 2023 10:35 pm
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

Re: Loading data from a Xml with special characters

Posted: Wed Mar 08, 2023 10:08 pm
by Lech Kulikowski
Hello,

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

Thank you.

Re: Loading data from a Xml with special characters

Posted: Sat Mar 11, 2023 3:19 pm
by rjorge99
That worked.

Thanks

Re: Loading data from a Xml with special characters

Posted: Sun Mar 12, 2023 8:44 pm
by Lech Kulikowski
Hello

You are welcome.