Re: Corrupt files in XML Snapshot (kiva_ds_xml.zip)

[Martin Butt]

Hi,

Before I dig too deeply in to this, can you tell me which library you are using to parse the file with?

Cheers,

    Martin

On 17 May 2013 00:12, Jorgen Simon <si...@redbowone.com> wrote:

Hi I am trying to load the data in the XML Snapshot (kiva_ds_xml.zip) but there are several files beginning with Lenders 100.xml, 102.xml and so on that give a error.

XML Parsing Error: reference to invalid character number
Location: file:///C:/Data/DB/Kiva/lenders/100.xml
Line Number 1, Column 274581:<?xml version="1.0" encoding="UTF-8" ?><snapshot><header><total>

Help anyone?

Jorgen

--
You received this message because you are subscribed to the Google Groups "build-kiva" group.
To unsubscribe from this group and stop receiving emails from it, send an email to build-kiva+...@googlegroups.com.
To post to this group, send email to build...@googlegroups.com.
Visit this group at http://groups.google.com/group/build-kiva?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

Martin Butt | Senior Software Engineer

Kiva – Loans that Change Lives
Join us on Twitter, Facebook and LinkedIn!

[Martin Butt]

Hi Jorgen,

I found the bug, it is a problem with our XML encoder. There will be a fix in the next release. For anyone else with the problem the following regex with clean the files:

s/\&\#0*([0-9]|[12][0-9]|3[0-2]);//g

Cheers,

    Martin

On 27 May 2013 13:02, Jorgen Simon <si...@redbowone.com> wrote:

Hi

Well, I am trying to read the files into QlikView, but reading the files into any XML reader failed,

Certain files in the XML, specially the a whereabouts tag contains HTML code &#26; &#16; &#8; and so on.

I have used a  another software to clear or purges these sign from the XML and now I can read them in, Not sure if any one else can?

So for me the problem is solved.

On Friday, 17 May 2013 09:12:24 UTC+2, Jorgen Simon wrote:

Hi I am trying to load the data in the XML Snapshot (kiva_ds_xml.zip) but there are several files beginning with Lenders 100.xml, 102.xml and so on that give a error.

XML Parsing Error: reference to invalid character number
Location: file:///C:/Data/DB/Kiva/lenders/100.xml
Line Number 1, Column 274581:<?xml version="1.0" encoding="UTF-8" ?><snapshot><header><total>

Help anyone?

Jorgen

--
You received this message because you are subscribed to the Google Groups "build-kiva" group.
To unsubscribe from this group and stop receiving emails from it, send an email to build-kiva+...@googlegroups.com.
To post to this group, send email to build...@googlegroups.com.
Visit this group at http://groups.google.com/group/build-kiva?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Jorgen Simon]

Thank :-)

[Иван Горохов]

Still not fixed (

вторник, 28 мая 2013 г., 12:13:30 UTC+4 пользователь Martin Butt написал:

[Иван Горохов]

Sorry, what did you use to clean the data? Thx

вторник, 28 мая 2013 г., 0:02:13 UTC+4 пользователь Jorgen Simon написал: