Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Ren0vatio
2014-03-12T16:37:42Z
Hi Guys

I`m looking for a solution... I have *.xml files in one directory C:\XML\
I would like to export specific data from files that has *IE123* in the filename, and save resault in txt file.
How can I do it?
Sponsor
Forum information
Support
2014-03-12T21:01:10Z
With the list files Task you can list files by your specified wild card. Then it depends exactly what you mean with "Extract". What exactly do you want to do with the files once identified?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Ren0vatio
2014-03-13T10:53:36Z
First of all thank you Henrik for quick reply!
Each *IE529*.xml file has similar construction, I would like export/copy specified data from all *IE529*.xml files to one *.txt file.
In example , VisualCron has to find "DATA1" section in xml file and copy everything after "DATA1" to txt file.
This are my first steps with VisualCron, I found some manuals regarding xml files http://www.visualcron.co...ask_xml___read_nodes.htm  but ii didn't work... maybe there is another solution?
Support
2014-03-13T13:04:07Z
Basically it should work with the following:

1. create a list files Task identifying and listing your files
2. create a Read node Task, use the following value for the file: {LOOP(CurrentValueX)}
3. create a loop on that Task and use this in the for each: {TASK(PrevTask,StdOut)}

Then you need to create the XPATH query. I suggest you test this with an existing file first.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Ren0vatio
2014-03-18T13:32:41Z
Filtering looks fine, but I have problem with reading xml node.
First, I've tried to use XML browser with no luck.
My xml files have namespaces, so I've tried to use below tutorial:
http://www.visualcron.co....aspx?g=posts&t=2624 
I did exactly that same, and only information I get is error
Ren0vatio attached the following image(s):
Support
2014-03-18T13:38:53Z
Originally Posted by: Ren0vatio 

Filtering looks fine, but I have problem with reading xml node.
First, I've tried to use XML browser with no luck.
My xml files have namespaces, so I've tried to use below tutorial:
http://www.visualcron.co....aspx?g=posts&t=2624 
I did exactly that same, and only information I get is error



Could you send all details including original XML to support@visualcron.com?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2014-04-17T13:57:51Z
I had no problems browsing the XML file you sent. What exact XPath query do you want to use? (screenshot in forum is different from the XML you sent.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top