Shell Programming and Scripting

I have existing XML file as below, now based on input string in shell script on workordercode i need to create a seprate xml file
for e.g if we pass the input string as 184851 then it find the tag data from <workOrder>..</workOrder> and write to a new file and similarly next time if i pass the inout string as
184853 then it should append to the new file .. please see the New file requirement.
Can any body provide me the sample sheel script for doing the below case would be great?
-------------------------------------
Existing File:
-------------------------------------

Code:

<?xml version="1.0" encoding="utf-8" ?> 
<scbm-extract version="3.3">
<workOrderList>
<workOrder>
  <branchCode>2021:100</branchCode> 
  <workOrderCode>184850</workOrderCode> 
</workOrder>
<workOrder>
  <branchCode>2022:100</branchCode>
  <workOrderCode>184851</workOrderCode> 
</workOrder>
<workOrder>
  <branchCode>2023:100</branchCode>
  <workOrderCode>184852</workOrderCode> 
</workOrder>
<workOrder>
  <branchCode>2023:100</branchCode>
  <workOrderCode>184853</workOrderCode> 
</workOrder>
</workOrderList>
</scbm-extract>

-------------------------------------
New File
-------------------------------------

Code:

<?xml version="1.0" encoding="utf-8" ?> 
<scbm-extract version="3.3">
<workOrderList>
  <branchCode>2022:100</branchCode>
  <workOrderCode>184851</workOrderCode> 
</workOrder>
<workOrder>
  <branchCode>2023:100</branchCode>
  <workOrderCode>184853</workOrderCode> 
</workOrder>
</scbm-extract>

-------------------------------------

One of the solution would be as below..

Code:

# create a output file with the contents as
cat outfile.xml
<?xml version="1.0" encoding="utf-8" ?> 
<scbm-extract version="3.3">
<workOrderList>

Code:

#!/bin/ksh
# save as extract_xml.sh
# run script as: ./extract_xml.sh 184850

echo "<workOrder>" >> outfile.xml
WOC=$1 
grep -w -C1 "$WOC" infile.xml >> outfile.xml

If xsltproc is available to you, the following script (update.sh) will do what you want assuming that the input file is extract.xml and the output file is updated.xml.

Code:

#!/bin/bash

if test -z "$1"
then
   echo "ERROR: No command-line argument provided"
   exit 1
fi
WorkOrder=$1

[[ -f updated.xml ]] || {
   cat > updated.xml <<EOF
<?xml version="1.0" encoding="utf-8" ?>
<scbm-extract version="3.3">
   <workOrderList>
   </workOrderList>
</scbm-extract>
EOF
}

cat > updatexsl.$$ <<EOF
<xsl:stylesheet version="1.0"
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

   <!-- XSLTPROC pass in as -param name "'value'" etc -->
   <xsl:param name="woc">EMPTY</xsl:param>

   <xsl:output method="xml" indent="yes" encoding="utf-8"/>
   <xsl:strip-space elements="*"/>

   <xsl:template match="/">
      <xsl:apply-templates />
   </xsl:template>

   <xsl:template match="scbm-extract">
     <xsl:copy>
        <xsl:apply-templates select="workOrderList"/>
     </xsl:copy>
   </xsl:template>

   <xsl:template match="workOrderList">
     <xsl:copy>
        <xsl:apply-templates select="workOrder"/>
        <xsl:copy-of select="document('./extract.xml')//workOrder[workOrderCode=\$woc]" />
     </xsl:copy>
   </xsl:template>

   <xsl:template match="workOrder">
       <xsl:copy-of select = "." />
   </xsl:template>

</xsl:stylesheet>
EOF

xsltproc -param woc "'${WorkOrder}'" updatexsl.$$ updated.xml > updated.$$

mv updated.$$ updated.xml

rm -f updated.$$
rm -f updatexsl.$$

exit 0

Here is the output for the first update (184851):

Code:

$ ./update.sh 184851
$ cat updated.xml
<?xml version="1.0" encoding="utf-8"?>
<scbm-extract>
  <workOrderList>
    <workOrder>
      <branchCode>2022:100</branchCode>
      <workOrderCode>184851</workOrderCode>
    </workOrder>
  </workOrderList>
</scbm-extract>
$

and here is the output for the second update (184852):

Code:

$ ./update.sh 184852
$ cat updated.xml
<?xml version="1.0" encoding="utf-8"?>
<scbm-extract>
  <workOrderList>
    <workOrder>
      <branchCode>2022:100</branchCode>
      <workOrderCode>184851</workOrderCode>
    </workOrder>
    <workOrder>
      <branchCode>2023:100</branchCode>
      <workOrderCode>184852</workOrderCode>
    </workOrder>
  </workOrderList>
</scbm-extract>

Hi fmmurphy,

You simply awesome!!!!!!!!!!!!!

Solution what you have provided is exactly meets our requirement - Thank you for your time spent on this
As i am new to xlsproc..still trying to understand the good tool.

Could you please help us on the below case how to achieve soltuion?

Case: 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.
The output should like MODIFIED.xml
----------------------------------------------------------------------------------------------------------------
ORIGINAL.xml
----------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<ps-persistence version="12.1.3">
<scenarioList>
<scenario>
<scenarioCode>Schedule #1</scenarioCode>
<model>
<resourceCode>LIGHT</resourceCode>
<itemList>
<item type="Manufactured">
<resourceCode>431048</resourceCode>
<saleable>yes</saleable>
<startLevel>0.000000</startLevel>
<minimumLevel>0.000000</minimumLevel>
<maximumLevel>1000000.000000</maximumLevel>
<stockoutCost>100.000000</stockoutCost>
<carryingCost>5.000000</carryingCost>
<safetyStockViolationCost>20.000000</safetyStockViolationCost>
<precision>0</precision>
<modelWorkspaceTreePath>Manufacured and Saleable</modelWorkspaceTreePath>
<relaxedMinLevel>no</relaxedMinLevel>
<relaxedMaxLevel>yes</relaxedMaxLevel>
<planningUom>Each</planningUom>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList></assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
<itemList>
<item type="Manufactured">
<resourceCode>431049</resourceCode>
<saleable>yes</saleable>
<startLevel>0.000000</startLevel>
<minimumLevel>0.000000</minimumLevel>
<maximumLevel>1000000.000000</maximumLevel>
<stockoutCost>100.000000</stockoutCost>
<carryingCost>5.000000</carryingCost>
<safetyStockViolationCost>30.000000</safetyStockViolationCost>
<precision>0</precision>
<modelWorkspaceTreePath>Manufacured and Saleable</modelWorkspaceTreePath>
<relaxedMinLevel>no</relaxedMinLevel>
<relaxedMaxLevel>yes</relaxedMaxLevel>
<planningUom>Each</planningUom>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList></assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
</model>
</scenario>
</scenarioList>
</ps-persistence>

----------------------------------------------------------------------------------------------------------------
ORIGINAL.xml
----------------------------------------------------------------------------------------------------------------
<assignedAttributeList>
<assignedAttribute>
<attributeCode>CrimperType</attributeCode>
<attributeValueCode>2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>18"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM1</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Gas</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Module</attributeCode>
<attributeValueCode>ME05</attributeValueCode>
</assignedAttribute>
</assignedAttributeList>
<assignedAttributeList>
<assignedAttribute>
<attributeCode>CrimperType</attributeCode>
<attributeValueCode>2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>19"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Gas</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Module</attributeCode>
<attributeValueCode>ME05</attributeValueCode>
</assignedAttribute>
</assignedAttributeList>

----------------------------------------------------------------------------------------------------------------
MODIFIED.xml
----------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<ps-persistence version="12.1.3">
<scenarioList>
<scenario>
<scenarioCode>Schedule #1</scenarioCode>
<model>
<resourceCode>LIGHT</resourceCode>
<itemList>
<item type="Manufactured">
<resourceCode>431048</resourceCode>
<saleable>yes</saleable>
<startLevel>0.000000</startLevel>
<minimumLevel>0.000000</minimumLevel>
<maximumLevel>1000000.000000</maximumLevel>
<stockoutCost>100.000000</stockoutCost>
<carryingCost>5.000000</carryingCost>
<safetyStockViolationCost>20.000000</safetyStockViolationCost>
<precision>0</precision>
<modelWorkspaceTreePath>Manufacured and Saleable</modelWorkspaceTreePath>
<relaxedMinLevel>no</relaxedMinLevel>
<relaxedMaxLevel>yes</relaxedMaxLevel>
<planningUom>Each</planningUom>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList>
<assignedAttribute>
<attributeCode>CrimperType</attributeCode>
<attributeValueCode>2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>18"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM1</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Gas</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Module</attributeCode>
<attributeValueCode>ME05</attributeValueCode>
</assignedAttribute>
</assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
<itemList>
<item type="Manufactured">
<resourceCode>431049</resourceCode>
<saleable>yes</saleable>
<startLevel>0.000000</startLevel>
<minimumLevel>0.000000</minimumLevel>
<maximumLevel>1000000.000000</maximumLevel>
<stockoutCost>100.000000</stockoutCost>
<carryingCost>5.000000</carryingCost>
<safetyStockViolationCost>30.000000</safetyStockViolationCost>
<precision>0</precision>
<modelWorkspaceTreePath>Manufacured and Saleable</modelWorkspaceTreePath>
<relaxedMinLevel>no</relaxedMinLevel>
<relaxedMaxLevel>yes</relaxedMaxLevel>
<planningUom>Each</planningUom>
<receivingCalendarCode>Default</receivingCalendarCode>
<assignedAttributeList>
<assignedAttribute>
<attributeCode>CrimperType</attributeCode>
<attributeValueCode>2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Dia</attributeCode>
<attributeValueCode>19"</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Base</attributeCode>
<attributeValueCode>22V50FM2</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Fuel</attributeCode>
<attributeValueCode>Gas</attributeValueCode>
</assignedAttribute>
<assignedAttribute>
<attributeCode>Module</attributeCode>
<attributeValueCode>ME05</attributeValueCode>
</assignedAttribute>
</assignedAttributeList>
<timeVaryingEventList></timeVaryingEventList>
</item>
</itemList>
</model>
</scenario>
</scenarioList>
</ps-persistence>