Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Hi Community, I am trying to fetch data from website http://www.rushydro.ru/hydrology/informer/ , parse it and save data to excel in separate cells. How can this be done? i have attached my workbench, also can someone help with xquery?

ExcelCan you please implement XQuery, i think this will be the best way. I want to save like in attachment.

Hi @nurbek​ 

 

I changed transformer for XMLFlattener:

 

XMLFlattener 

In the FME Data Inspector you can see the attributes that I mean is important for you:

 

Attributes 

 

Thanks in Advance,

Danilo

 

 

 

Hi @nurbek​ 

 

I changed transformer for XMLFlattener:

 

XMLFlattener 

In the FME Data Inspector you can see the attributes that I mean is important for you:

 

Attributes 

 

Thanks in Advance,

Danilo

 

 

 

Hi Danilo,

 

Thanks a lot, it worked for me. But, the website where i get info has applied captcha. Now i receive errors, as a workaround i tried to save each web page as html file, how can i bulk read inside info of these web pages?

Reply


Community Stats

30,168
Posts
114,531
Replies
37,827
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.