Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

XML tag replacement from different XML file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting XML tag replacement from different XML file
# 1  
Old 01-25-2011
XML tag replacement from different XML file
We have 2 XML file 1. ORIGINAL.xml file and 2. ATTRIBUTE.xml files, In the ORIGINAL.xml we need some modification as <resourceCode>431048</resourceCode>under <item type="Manufactured"> tag - we need to grab the 431048 value from tag and pass it to database table in unix shell script to find the model name and in our case the model number 22V50FM1, then we have to search in ATTRIBITE.xml file under <assignedAttributeList> tags, if found we have to copy the entire structure <assignedAttributeList> details and replace in ORIGINAL.xml file for the tag <assignedAttributeList></assignedAttributeList> under the resource code 431048.

Output shoudl be like MODIFIED. xml file
-------------------------------------------------------------
ORIGINAL.xml
--------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<ps-persistence version="12.1.3">
<scenarioList>
<scenario>
<model>
<resourceCode>LIGHT</resourceCode>
<itemList>
<item type="Manufactured">
<resourceCode>431048</resourceCode>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList></assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
<itemList>
<item type="Manufactured">
<resourceCode>431049</resourceCode>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList></assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
</model>
</scenario>
</scenarioList>
</ps-persistence>
------------------------------------------------------------------------
ATTRIBUTE.xml
-----------------------------------------------------------------------
<assignedAttributeList>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>18"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM1</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Gas</attributeValueCode>
</assignedAttribute>
|</assignedAttributeList>
<assignedAttributeList>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>19"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Electric</attributeValueCode>
</assignedAttribute>
|</assignedAttributeList>
-------------------------------------------------------------
MODIFIED.xml
--------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<ps-persistence version="12.1.3">
<scenarioList>
<scenario>
<model>
<resourceCode>LIGHT</resourceCode>
<itemList>
<item type="Manufactured">
<resourceCode>431048</resourceCode>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>18"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM1</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Gas</attributeValueCode>
</assignedAttribute>
| </assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
<itemList>
<item type="Manufactured">
<resourceCode>431049</resourceCode>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>19"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode> Electric </attributeValueCode>
</assignedAttribute>
| </assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
</model>
</scenario>
</scenarioList>
</ps-persistence>
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. Shell Programming and Scripting

Update particular tag in a XML file

Below is the content in my XML file <name>XXX</name> <eventType>Uptime</eventType> <eventType>Delay</eventType> <eventType>Delay</eventType> <name>YYY</name> <eventType>Uptime</eventType> <eventType>Delay</eventType> ... (12 Replies)
Discussion started by: Viswanatheee55
12 Replies

4. Shell Programming and Scripting

Extracting the tag name from an xml file

Hi, My requirement is something like this, I have a xml file that contains some tags and nested tags, <n:tag_name1> <n:sub_tag1>val1</n:sub_tag1> <n:sub_tag2>val2</n:sub_tag2> </n:tag_name1> <n:tag_name2> <n:sub_tag1>value</n:sub_tag1> ... (6 Replies)
Discussion started by: Little
6 Replies

5. UNIX for Dummies Questions & Answers

GREP for a tag in XML File

I have 2 XML Data files with a tag named PARTICIPATION_TYPE and i am trying to grep for that and getting unique values. However one of the xml data file data is not aligned properly like below. File 1: (works fine when i do grep) grep "PARTICIPATION_TYPE" file1.xml | sort -u Data: ....... (3 Replies)
Discussion started by: Ariean
3 Replies

6. HP-UX

XML tag name content replacement

Hi, Need to replace an XML tag name contents, please provide any suggestions. Scenario is : <abc_def>Value_some_content</abc_def> Expected output : <abc:def>Value_some_content</abc:def> We have many tag with different names & contents in a file or a string. Please help on the... (3 Replies)
Discussion started by: periyasamycse
3 Replies

7. Emergency UNIX and Linux Support

Trying to parse a xml file for only one tag

I have a xml file in where I need to parse only a particular tag and print the output in the shell script. Here is the tag info in the xml file <dp:file> This is dp file output </dp:file> Output should be printed as This is dp file output. Please help.Thank you. (5 Replies)
Discussion started by: chandu123
5 Replies

8. Shell Programming and Scripting

Extract XML tag value from file

Hello, Hope you are doing fine. I have an log file which looks like as follows: Some junk text1 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: Some jun text 2 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: ... (3 Replies)
Discussion started by: srattani
3 Replies

9. 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

10. Shell Programming and Scripting

Changing particular tag value of xml file

Hi All, I have number of xml file like : ______________________________________________________ <?xml version="1.0" standalone="no"?> <!-- Created by Symology Ltd on 13/02/2012 - USER_BATCH_ID 0011091684 --> <!-- RECIPIENT_URL: HTTP://194.168.0.81:3408 --> <EToNrequest ... (7 Replies)
Discussion started by: krsnadasa
7 Replies
Login or Register to Ask a Question