Shell Programming and Scripting

<Position>
        <SKU>A/370269/10432/32D</SKU>
        <Batch>00320160501</Batch>
        <Description>Carlotta</Description>
        <Amount>1</Amount>
        <ForeignPos1>172991</ForeignPos1>
        <ForeignPos2>10</ForeignPos2>
        <Positionreferences>
          <PosReference number="1"/>
          <PosReference number="2"/>
          <PosReference number="3">0</PosReference>
          <PosReference number="4">0</PosReference>
          <PosReference number="5"/>
          <PosReference number="6">370269</PosReference>
          <PosReference number="7">10432</PosReference>
          <PosReference number="8">pearl grey</PosReference>
          <PosReference number="9"/>
          <PosReference number="10"/>
          <PosReference number="11">26 INCH</PosReference>
        </Positionreferences>
</Position>
<Position>
        <SKU>A/370269/10432/32D</SKU>
        <Batch>00520160501</Batch>
        <Description>Carlotta</Description>
        <Amount>6</Amount>
        <ForeignPos1>172992</ForeignPos1>
        <ForeignPos2>10</ForeignPos2>
        <Positionreferences>
          <PosReference number="1"/>
          <PosReference number="2"/>
          <PosReference number="3">0</PosReference>
          <PosReference number="4">0</PosReference>
          <PosReference number="5"/>
          <PosReference number="6">370269</PosReference>
          <PosReference number="7">10432</PosReference>
          <PosReference number="8">pearl grey</PosReference>
          <PosReference number="9"/>
          <PosReference number="10"/>
          <PosReference number="11">26 INCH</PosReference>
        </Positionreferences>
</Position>

#!/bin/bash

if [ $# -lt 2 ] ; then
        echo "Usage: `basename $0` <Filename> <Datafield8>"
else
        # initialize variable for filename
            file=$1

        # convert xml file in readable format
           xmllint --format $file > $file.tmp

        # split string from $2 in seperate variables
            IFS="/"
            Wert=$2
            set -- $Wert
            p9=$2
            p10=$1

        # simple sed replace but output to a new file
            sed 's@NEW@UPD@' $file.tmp > $file.tmp2
            sed 's@<PosReference number="9"/>@<PosReference number="9">'$p9'</PosReference>@' $file.tmp2 > $file.tmp3
            sed 's@<PosReference number="10"/>@<PosReference number="10">'$p10'</PosReference>@' $file.tmp3 > $file.tmp4

        # append prefix from original file name with "_script"

            new=`echo $file | sed 's@.xml@_script.xml@'`

        # check if $new is empty or not
            if [ -z "$new" ]
              then
                :
              else
                cp $file.tmp4 $new
            fi

        # delete all temporary files
            rm -f $file.tmp $file.tmp2 $file.tmp3 $file.tmp4
fi

#!/bin/bash
IAm=${0##*/}	# Grab basename of this script.

# Verify argument count.
if [ $# -lt 4 ] || [ $(($# % 3)) -ne 1 ]
then	af='file batch1 PRN9val1 PRN10val1 [batchN PRN9valN PRN10valN]...\n'
	printf "Usage: %s $af" "$IAm" >&2
	exit 1
fi

# Get input XML file pathname from arg1, verify name ends in ".xml", compute
# output file pathname, and reformat the input file into a temp file.
File=$1
New=${1%.xml}
if [ "$New" = "$File" ]
then	printf '%s: file (%s) does not end in ".xml", no changes made\n' \
	    "$IAm" "$File" >&2
	exit 2
fi
New=${New}_script.xml
TmpFile=$File.tmp
xmllint --format "$File" > "$TmpFile"

# Throw away the XML file's positional parameter.
shift

# Reformat the remaining command line arguments in groups of three to pairs of
# ctl-G separated fields with the batch number as field 1, the PosReference
# number (PRN) to be fixed as field 2, and the new value to be assigned to that
# PRN as field 3; and feed those reformatted arguments to awk along with the
# reformatted XML file to produce the desired "_script.xml" file.
while [ $# -gt 1 ]
do	printf '%s\a9\a%s\n%s\a10\a%s\n' "$1" "$2" "$1" "$3"
	shift 3
done | awk '
FNR == NR {
	ref2val[$1, $2] = $3
	next
}
/<Batch>/ {
	b = $0
	gsub("^.*<Batch>|</Batch>.*$", "", b)
	found = (b, 9) in ref2val
}
found && /<PosReference number=\"(9|10)\"/ {
	sub(/"9".*/, "\"9\">" ref2val[b, 9] "</PosReference>")
	sub(/"10".*/, "\"10\">" ref2val[b, 10] "</PosReference>")
}
1' FS=$'\a' - FS=' ' "$TmpFile" > "$New"

# Remove the reformatted (temporary) XML input file.
rm -f "$TmpFile"