You are not logged in.
I'm using TOS 3.0.0r18993 on a Windows Vista x64 Business SP1 system. My Talend project is in Java and I'm quite a newbie using TOS.
Well, I spend now several hours here in this forum, but I couldn't find a usefull hint for my problem. As I am reading values from an SQL Database (that contains ID, name, zip, telephone and email as VarChar), I would like to get the missing city name by accessing an URL, in this case "http://ws.geonames.org/postalCodeSearch?country=de&maxRows=1&style=short&postalcode=<ZIP>"
I figured it out how to read ot iteratively XML Files from this URL by using the tFetchFile Operator. But as far as I can see it does not really help me here, as I have to read in those files later step by step.
What I get are some XML Files, stored in a temporary folder...but how could I access them later, if the Name is <ZIP>.xml? If I want to compare the ZIP code later and get the city name - how could that be done best?
My other question is, if and how I could access the URL directly and process the XML File in a way that I can directyl read the missing city name and insert it in the data flow. Would the WebServiceInput helpfull in that case? And how can I integrate it later, e.g. in a tMap component?
can u tell me the solution if u have any since i am lso trying to import from url the xml into my desk from this site http://sws.geonames.org/3020251/about.rdf
i have to dovvload from url in the form of
3020252.xml .... o on
okay, I do not really have a solution how you can do it with the Talend Operators. But what I did is, that I coded some lines of Java (XML Parser, you find really good examples in the web) and used this Java function in the tMap operator. That was the easiest way do get the information you need, from the xml file.