Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
kvinoth19991
Contributor II
Contributor II

Reading XML files from a folder and that XML is taken as a Input

Hello guys,
I have a scenario to be solved. Please provide solution for this.
 
I have a folder contains "30" XML files. All the XML are Nested tag files. I want to iterate each and every XML file from the folder and that iterated XML is taken as Input.
All the XML are read and values are stored in Database
Components I have used.



Folder with sample files



I used tfileList -> tfileInputXml -> xMap -> tlog
tfileList



tFileInputXml




Error Occurred:




XML File Content :
 
<?xml version="1.0" encoding="ISO-8859-1" ?>
<software description="hello" kit="" title="ert" comments="              &



To see the whole post, download it here
Labels (2)
5 Replies
kvinoth19991
Contributor II
Contributor II
Author

0683p000009MGlu.png 0683p000009MGr2.png 0683p000009MGr7.png 0683p000009MGrH.png 0683p000009MGqt.png
Anonymous
Not applicable

Please change the property XPath query in tFileInputXml_1 and write "."

Select option GetNodes.

May you indicate which field do you need extract?

Best regards,


Alfonso Borre
Skype : alfonso.borre
aborresarmiento@yahoo.es
kvinoth19991
Contributor II
Contributor II
Author

Thank you so much for the reply 0683p000009MACn.png


0683p000009MGrM.png
Is it correct ?

Still i have an issue ,


0683p000009MGrR.png

0683p000009MGrb.png

<?xml version="1.0" encoding="ISO-8859-1" ?>
<software description="hello" kit="" title="ert" comments="                      
" sia="" P1="" name="rtr" irn="4355" iddef="eds" domain="dfcx" type="44" TMA="">
  <editor iddef="ff" title="hhh" web="" name="rte" />
  <version idBase="1023" versionBase="3.1" iddef="3.1" isRef="no">
    <development>
      <language instr="--" gui="" idref="c++" comments="31%" version="" lines="1836" />
      <language instr="--" gui="1" idref="java" comments="23%" version="" lines="1764" />
    </development>
    <deployment availability="111 111 ">
      <site idref="red" date="31/01/08" />
      <site idref="ddf" date="31/01/08" />
      <platform idref="ff" date="31/01/08" />
      <platform idref="gh" date="31/01/08" />
      <platform idref="gg" date="31/01/08" />
    </deployment>
    <license manager="" daemon="">
    </license>
    <team>
      <person lastName="rtt" firstName="ff" role="cpi" company="hh" />
      <person lastName="tt" firstName="frf" role="moe" company="hh" />
      <person lastName="th" firstName="rr" role="cpo" company="hh" />
      <person lastName="hfd" firstName="jh" role="dev" company="gh" />
      <person lastName="gh" firstName="ff" role="dev" company="gg" />
      <person lastName="ff" firstName="yy" company="gg" role="g" />
      <person lastName="ff" firstName="yy" company="gr" role="g" />
    </team>
    <developments>


Description is the field i'm trying to extract

Regards,
Vinoth Kumar K
Anonymous
Not applicable

Good day
I sent the solution
Best regards,

Alfonso Borre
Skype: alfonso.borre
aborresarmiento@yahoo.es


0683p000009MGgB.jpg 0683p000009MGpW.jpg
_AnonymousUser
Specialist III
Specialist III

you forget the " " (ie ".", not .)

Regards.