Hi All,

I am new to perl. am trying achive something wrt to xml file. I have input file that is an csv which has number of rows with data and have xml template file where in which i need to update the values read from csv file. am not sure where and how to update an xml file using csv file in perl. Can any one please help me out.

Input put file looks like : file name : abc.csv

protocol,host,port and commandline
SSH,-P,22 103.243.543.233,erted
SSH,-P,22 303.233.542.622,rrertd
[download]

Xml file looks like : Filename : std.xml

<!-- The following lines can be modified at your own risks.  -->
<configuration version="0.2.1.4" savepassword="True">
  <root type="database" name="WSSS" expanded="True">
    <container type="folder" name="CM" expanded="True">
      <container type="folder" name="1-AD/M" expanded="True">
        <connection type="PuTTY" name="WSSS">
          <connection_info>
            <name>WSSSS</name>
            <protocol>SSH</protocol>
            <host>20.148.24.2</host>
            <port>22</port>
            <session>Default Settings</session>
            <commandline>EEREd</commandline>
            <description />
          </connection_info>
          <login>
            <login />
            <password />
            <prompt />
          </login>
          <timeout>
            <connectiontimeout>1000</connectiontimeout>
            <logintimeout>750</logintimeout>
            <passwordtimeout>750</passwordtimeout>
            <commandtimeout>750</commandtimeout>
          </timeout>
          <command>
            <command1 />
            <command2 />
            <command3 />
            <command4 />
            <command5 />
          </command>
          <options>
            <loginmacro>False</loginmacro>
            <postcommands>False</postcommands>
            <endlinechar>10</endlinechar>
          </options>
        </connection>
</root>
</configuration>
[download]

In the above xml file, protocol,host,port and commandline tag values are updated from csv file. Output file which am looking for is :

<?xml version="1.0" encoding="utf-16"?>
<!-- ****************************************************************-
+->
<!-- *                                                              *-
+->
<!-- * PuTTY Configuration Manager save file - All right reserved.  *-
+->
<!-- *                                                              *-
+->
<!-- ****************************************************************-
+->
<!-- The following lines can be modified at your own risks.  -->
<configuration version="0.2.1.4" savepassword="True">
  <root type="database" name="WSSS" expanded="True">
    <container type="folder" name="CM" expanded="True">
      <container type="folder" name="1-AD/M" expanded="True">
        <connection type="PuTTY" name="WSSS">
          <connection_info>
            <name>WSSSS</name>
            <protocol>SSH</protocol>
            <host>103.243.543.233</host>
            <port>22</port>
            <session>Default Settings</session>
            <commandline>erted</commandline>
            <description />
          </connection_info>
          <login>
            <login />
            <password />
            <prompt />
          </login>
          <timeout>
            <connectiontimeout>1000</connectiontimeout>
            <logintimeout>750</logintimeout>
            <passwordtimeout>750</passwordtimeout>
            <commandtimeout>750</commandtimeout>
          </timeout>
          <command>
            <command1 />
            <command2 />
            <command3 />
            <command4 />
            <command5 />
          </command>
          <options>
            <loginmacro>False</loginmacro>
            <postcommands>False</postcommands>
            <endlinechar>10</endlinechar>
          </options>
        </connection>
        
<connection type="PuTTY" name="AWSA">
          <connection_info>
            <name>AWSA</name>
            <protocol>SSH</protocol>
            <host>303.233.542.622</host>
            <port>22</port>
            <session>Default Settings</session>
            <commandline>rrertd</commandline>
            <description />
          </connection_info>
          <login>
            <login />
            <password />
            <prompt />
          </login>
          <timeout>
            <connectiontimeout>1000</connectiontimeout>
            <logintimeout>750</logintimeout>
            <passwordtimeout>750</passwordtimeout>
            <commandtimeout>750</commandtimeout>
          </timeout>
          <command>
            <command1 />
            <command2 />
            <command3 />
            <command4 />
            <command5 />
          </command>
          <options>
            <loginmacro>False</loginmacro>
            <postcommands>False</postcommands>
            <endlinechar>10</endlinechar>
          </options>
        </connection>
</root>
</configuration>
[download]

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.