I am having an issues pulling data from a KML(google's version of xml) in pentaho spoon.

I'm currently using Build version 4.2.1GA

Currently, I am having an using with the encoding. The KML(sample has been attached) is denoted at UTF-8 however, spoon says otherwise.

while trying to preview the data and locate the xpath I am receiving an " Invalid byte 1 of 1-byte UTF-8 sequence."

I've been able to pinpoint what it doesn't like and the it is the "x8B" within the KML files that is located in the CDATA.

Is there anyway around this or another method to reading this file. Specifically, I will be sending the KML file links through a stream to this step.



thoughts?


thank you so much in advanced.

KML file sample.zip