Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to insert a CSV within xml element tag using Python?
Top Forums Shell Programming and Scripting How to insert a CSV within xml element tag using Python? Post 303032444 by panyam on Monday 18th of March 2019 11:25:31 AM
Old 03-18-2019
How to insert a CSV within xml element tag using Python?
Hi Team,
I have a CSV file which I have to read through and needs to insert the content within an XML file using Python ONLY ( as most of the code base we have in python only). I managed to find the first part, missing how to insert to XML under "specific" tags.
Code:
cat input.csv
Host,PUBLICIP,PRIVATEIP,RAC
hactive,10.47.47.196,427.47.47.196,01
hpassive,10.47.47.197,47.47.47.197,01
hutility,10.47.47.198,47.47.47.198,01
datanode1,10.47.47.199,47.47.47.199,01
datanode2,10.47.47.207,47.47.47.207,01

Code:
import os,sys
import csv
from xml.etree import ElementTree as ET

str = ""

with open('input.csv', mode='r') as csv_file:
    csv_reader = csv.DictReader(csv_file)
    for row in csv_reader:
        str += '<Host_name="' + row["Host"] + '" Private_Addr="' + row["PRIVATEIP"] + '" Public_Addr="' + row["PUBLICIP"] + '" RACK_NO="' + row["RAC"] + '"/> \n'
    print(str.rstrip())

I want to insert the above output in to the below XML, in between <HostNames>:

Code:
                        <HostNames>
                                <Host name="node3" Pvt_IPADDR="47.47.47.197" Pub_IPADDR="10.47.47.197" RACK_NO="01"/>
                                <! --- The string I formatted , I want to put here" -->
                        </HostNames>


Note: <HostNames> tag can be any where in the config.xml and new "str" I want to put to the end of <HostNames> only.

Any help, really appreciable.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract multiple xml tag value into CSV format

Hi All, Need your assistance on another xml tag related issue. I have a xml file as below: <INVOICES> <INVOICE> <BILL> <BILL_NO>1234</BILL_NO> <BILL_DATE>01 JAN 2011</BILL_DATE> </BILL> <NAMEINFO> <NAME>ABC</NAME> </NAMEINFO> </INVOICE> <INVOICE> <BILL> <BILL_NO>5678</BILL_NO>... (12 Replies)
Discussion started by: angshuman
12 Replies

2. Shell Programming and Scripting

Find if XML element has a matching required element

I want to check if every <Part> element has corresponding <Description> in this sample XML. ....<Lot Of XML> <Inv lineNumber="2"> <Item> ... (4 Replies)
Discussion started by: kchinnam
4 Replies

3. Shell Programming and Scripting

How to retrieve the value from XML tag whose end tag is in next line

Hi All, Find the following code: <Universal>D38x82j1JJ </Universal> I want to retrieve the value of <Universal> tag as below: Please help me. (3 Replies)
Discussion started by: mjavalkar
3 Replies

4. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

5. Shell Programming and Scripting

awk command to insert a tag in XML

Hi All, I need a help on inserting a XML tag. Actual input <var> <nam>abcd</nam> <a1>.</a1> </var> if tag <a1>.</a1> is getting missed in XML like below <var> <nam>abcd</nam> </var> i need to insert wherever it is missed after <nam> tag and before </var> tag. Could anyone... (3 Replies)
Discussion started by: mohanalakshmi
3 Replies

6. Shell Programming and Scripting

XML Parse between to tag with upper tag

Hi Guys Here is my Input : <?xml version="1.0" encoding="UTF-8"?> <xn:MeContext id="01736"> <xn:VsDataContainer id="01736"> <xn:attributes> <xn:vsDataType>vsDataMeContext</xn:vsDataType> ... (12 Replies)
Discussion started by: pareshkp
12 Replies

7. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>... (9 Replies)
Discussion started by: srkmish
9 Replies

8. Shell Programming and Scripting

Pass some data from csv to xml file using shell/python

Hello gurus, I have a csv file with bunch of datas in each column. (see attached) Now I have an .xml file in the structure of below: ?xml version="1.0" ?> <component id="root" name="root"> <component id="system" name="system"> <param name="number_of_A" value="8"/> ... (5 Replies)
Discussion started by: Zam_1234
5 Replies

9. Shell Programming and Scripting

Moving XML tag/contents after specific XML tag within same file

Hi Forum. I have an XML file with the following requirement to move the <AdditionalAccountHolders> tag and its content right after the <accountHolderName> tag within the same file but I'm not sure how to accomplish this through a Unix script. Any feedback will be greatly appreciated. ... (19 Replies)
Discussion started by: pchang
19 Replies

10. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies

LEARN ABOUT OPENSOLARIS

xml::parser::style::tree

Parser::Style::Tree(3)					User Contributed Perl Documentation				    Parser::Style::Tree(3)

NAME

       XML::Parser::Style::Tree

SYNOPSIS

	 use XML::Parser;
	 my $p = XML::Parser->new(Style => 'Tree');
	 my $tree = $p->parsefile('foo.xml');

DESCRIPTION

       This module implements XML::Parser's Tree style parser.

       When parsing a document, "parse()" will return a parse tree for the document. Each node in the tree takes the form of a tag, content pair.
       Text nodes are represented with a pseudo-tag of "0" and the string that is their content. For elements, the content is an array reference.
       The first item in the array is a (possibly empty) hash reference containing attributes. The remainder of the array is a sequence of tag-
       content pairs representing the content of the element.

       So for example the result of parsing:

	 <foo><head id="a">Hello <em>there</em></head><bar>Howdy<ref/></bar>do</foo>

       would be:
		    Tag   Content
	 ==================================================================
	 [foo, [{}, head, [{id => "a"}, 0, "Hello ",  em, [{}, 0, "there"]],
		     bar, [	    {}, 0, "Howdy",  ref, [{}]],
		       0, "do"
	       ]
	 ]

       The root document "foo", has 3 children: a "head" element, a "bar" element and the text "do". After the empty attribute hash, these are
       represented in it's contents by 3 tag-content pairs.

perl v5.8.4							    2003-08-18						    Parser::Style::Tree(3)
All times are GMT -4. The time now is 01:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy