Append new data to existing XML for output?

Rich Wallace

I'm sure there's a very weasy way to do this, I've been running hard and
fast on several things at once and just may be at the point of overthinking
this...

I receive an incoming XML document via a string feed within a web service:

<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" />
</Product>
</Root>

I need to modify the outgoing XML to read the status of an approval check:

<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" />
<Details Name="Approved" Value="False" />
</Product>
</Root>

Once I have the True or False value from a method call, how would I modify
the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #1

Subscribe Post Reply

2616

tMan

dim dom as new XmlDocumen
dom.loadxml(yourxmlstring
dim products as XmlNodeList = dom.selectnodes("descendant::product"

For each product as XmlNode in Product
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag here. for each produc
dim tmpNode as XmlNode = dom.CreateElement("Details"
dim xAtt as XmlAttribute = dom.CreateAttribute("Name"
xatt.value = "Approved
tmpNode.attributes.append(xatt

'repeat above to add more attribute

product.appendchild tmpnod

Nex
----- Rich Wallace wrote: ----

I'm sure there's a very weasy way to do this, I've been running hard an
fast on several things at once and just may be at the point of overthinkin
this..

I receive an incoming XML document via a string feed within a web service

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /></Product></Root

I need to modify the outgoing XML to read the status of an approval check

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details Name="Approved" Value="False" /></Product></Root

Once I have the True or False value from a method call, how would I modif
the XML to add the new attributes

TI
-Ric

Nov 12 '05 #2

tMan

Nov 12 '05 #3

Rich Wallace

Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an
exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my new
line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...

dim dom as new XmlDocument
dom.loadxml(yourxmlstring)
dim products as XmlNodeList = dom.selectnodes("descendant::product")

For each product as XmlNode in Products
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag here. for each product dim tmpNode as XmlNode = dom.CreateElement("Details")
dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
xatt.value = "Approved"
tmpNode.attributes.append(xatt)

'repeat above to add more attributes

product.appendchild tmpnode

Next

----- Rich Wallace wrote: -----

I'm sure there's a very weasy way to do this, I've been running hard and fast on several things at once and just may be at the point of overthinking this...

I receive an incoming XML document via a string feed within a web service:
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>
I need to modify the outgoing XML to read the status of an approval check:
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details
Name="Approved" Value="False" /></Product></Root>
Once I have the True or False value from a method call, how would I modify the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #4

Rich Wallace

dim dom as new XmlDocument
dom.loadxml(yourxmlstring)
dim products as XmlNodeList = dom.selectnodes("descendant::product")

For each product as XmlNode in Products
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag here. for each product dim tmpNode as XmlNode = dom.CreateElement("Details")
dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
xatt.value = "Approved"
tmpNode.attributes.append(xatt)

'repeat above to add more attributes

product.appendchild tmpnode

Next

----- Rich Wallace wrote: -----

I'm sure there's a very weasy way to do this, I've been running hard and fast on several things at once and just may be at the point of overthinking this...

I receive an incoming XML document via a string feed within a web service:
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>
I need to modify the outgoing XML to read the status of an approval check:
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details
Name="Approved" Value="False" /></Product></Root>
Once I have the True or False value from a method call, how would I modify the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #5

Rich Wallace

Can anybody assist? I'm not sure where to look in MSDN or online help, I
can't seem to find what I'm looking for.

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in
message news:OP**************@tk2msftngp13.phx.gbl...

Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an
exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my new line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...
dim dom as new XmlDocument
dom.loadxml(yourxmlstring)
dim products as XmlNodeList = dom.selectnodes("descendant::product")

For each product as XmlNode in Products
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag here. for each product
dim tmpNode as XmlNode = dom.CreateElement("Details")
dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
xatt.value = "Approved"
tmpNode.attributes.append(xatt)

'repeat above to add more attributes

product.appendchild tmpnode

Next

----- Rich Wallace wrote: -----

I'm sure there's a very weasy way to do this, I've been running

hard and
fast on several things at once and just may be at the point of

overthinking
this...

I receive an incoming XML document via a string feed within a web

service:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>

I need to modify the outgoing XML to read the status of an approval

check:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details
Name="Approved" Value="False" /></Product></Root>

Once I have the True or False value from a method call, how would I

modify
the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #6

Rich Wallace

Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an
exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my new line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...
dim dom as new XmlDocument
dom.loadxml(yourxmlstring)
dim products as XmlNodeList = dom.selectnodes("descendant::product")

For each product as XmlNode in Products
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag here. for each product
dim tmpNode as XmlNode = dom.CreateElement("Details")
dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
xatt.value = "Approved"
tmpNode.attributes.append(xatt)

'repeat above to add more attributes

product.appendchild tmpnode

Next

----- Rich Wallace wrote: -----

I'm sure there's a very weasy way to do this, I've been running

hard and
fast on several things at once and just may be at the point of

overthinking
this...

I receive an incoming XML document via a string feed within a web

service:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>

I need to modify the outgoing XML to read the status of an approval

check:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details
Name="Approved" Value="False" /></Product></Root>

Once I have the True or False value from a method call, how would I

modify
the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #7

tMan

Rich:
in xml, the order of the child nodes (or attributes of a node) does not really matter. (atleast it shouldn't)
you can use the prependchild() method to append a child as a first child to a node.

google for more samples if you absolutely have to have the node at a particular position.

"Rich Wallace" wrote:

Can anybody assist? I'm not sure where to look in MSDN or online help, I
can't seem to find what I'm looking for.

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in
message news:OP**************@tk2msftngp13.phx.gbl...
Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an
exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my

new
line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...
dim dom as new XmlDocument
dom.loadxml(yourxmlstring)
dim products as XmlNodeList = dom.selectnodes("descendant::product")

For each product as XmlNode in Products
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag

here. for each product
dim tmpNode as XmlNode = dom.CreateElement("Details")
dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
xatt.value = "Approved"
tmpNode.attributes.append(xatt)

'repeat above to add more attributes

product.appendchild tmpnode

Next

----- Rich Wallace wrote: -----

I'm sure there's a very weasy way to do this, I've been running

hard
and
fast on several things at once and just may be at the point of

overthinking
this...

I receive an incoming XML document via a string feed within a web

service:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>

I need to modify the outgoing XML to read the status of an approval

check:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details
Name="Approved" Value="False" /></Product></Root>

Once I have the True or False value from a method call, how would I

modify
the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #8

tMan

Can anybody assist? I'm not sure where to look in MSDN or online help, I
can't seem to find what I'm looking for.

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in
message news:OP**************@tk2msftngp13.phx.gbl...
Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an
exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my

new
line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...
dim dom as new XmlDocument
dom.loadxml(yourxmlstring)
dim products as XmlNodeList = dom.selectnodes("descendant::product")

For each product as XmlNode in Products
dim bApproved as Boolean = GetApprovalValue() 'get your boolean flag

here. for each product
dim tmpNode as XmlNode = dom.CreateElement("Details")
dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
xatt.value = "Approved"
tmpNode.attributes.append(xatt)

'repeat above to add more attributes

product.appendchild tmpnode

Next

----- Rich Wallace wrote: -----

I'm sure there's a very weasy way to do this, I've been running

hard
and
fast on several things at once and just may be at the point of

overthinking
this...

I receive an incoming XML document via a string feed within a web

service:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>

I need to modify the outgoing XML to read the status of an approval

check:

<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details
Name="Approved" Value="False" /></Product></Root>

Once I have the True or False value from a method call, how would I

modify
the XML to add the new attributes?

TIA
-Rich

Nov 12 '05 #9

Rich Wallace

Thanks for the info.

"tMan" <tM**@discussions.microsoft.com> wrote in message
news:61**********************************@microsof t.com...

Rich:
in xml, the order of the child nodes (or attributes of a node) does not really matter. (atleast it shouldn't) you can use the prependchild() method to append a child as a first child to a node.
google for more samples if you absolutely have to have the node at a particular position.
"Rich Wallace" wrote:
Can anybody assist? I'm not sure where to look in MSDN or online help, I can't seem to find what I'm looking for.

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in
message news:OP**************@tk2msftngp13.phx.gbl...
Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my
new
line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...
> dim dom as new XmlDocument
> dom.loadxml(yourxmlstring)
> dim products as XmlNodeList = dom.selectnodes("descendant::product")
>
> For each product as XmlNode in Products
> dim bApproved as Boolean = GetApprovalValue() 'get your boolean

flag here. for each product
> dim tmpNode as XmlNode = dom.CreateElement("Details")
> dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
> xatt.value = "Approved"
> tmpNode.attributes.append(xatt)
>
> 'repeat above to add more attributes
>
> product.appendchild tmpnode
>
> Next
>
>
>
> ----- Rich Wallace wrote: -----
>
> I'm sure there's a very weasy way to do this, I've been running

hard
and
> fast on several things at once and just may be at the point of
overthinking
> this...
>
> I receive an incoming XML document via a string feed within a web service:
>
>
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>
>
> I need to modify the outgoing XML to read the status of an approval check:
>
>
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details Name="Approved" Value="False" /></Product></Root>
>
> Once I have the True or False value from a method call, how would I modify
> the XML to add the new attributes?
>
> TIA
> -Rich
>
>
>

Nov 12 '05 #10

Rich Wallace

Thanks for the info.

"tMan" <tM**@discussions.microsoft.com> wrote in message
news:61**********************************@microsof t.com...

Rich:
in xml, the order of the child nodes (or attributes of a node) does not really matter. (atleast it shouldn't) you can use the prependchild() method to append a child as a first child to a node.
google for more samples if you absolutely have to have the node at a particular position.
"Rich Wallace" wrote:
Can anybody assist? I'm not sure where to look in MSDN or online help, I can't seem to find what I'm looking for.

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in
message news:OP**************@tk2msftngp13.phx.gbl...
Works, thank you.

Is there a way to nivagiate through the doc and make sure I place it in an exact spot?

I.e:
<Root>
<Product>
<File>Order</File>
<Origin>OregonOffice</Origin>
<Details Name="Product" Value="Binder" />
<Details Name="Qty" Value="1" /> -- I want to make sure I place my
new
line after the Qty and before Mfr
<Details Name="Mfr" Value="ABC Co." />
</Product>
</Root>

Thanks again.
-r
"tMan" <an*******@discussions.microsoft.com> wrote in message
news:9D**********************************@microsof t.com...
> dim dom as new XmlDocument
> dom.loadxml(yourxmlstring)
> dim products as XmlNodeList = dom.selectnodes("descendant::product")
>
> For each product as XmlNode in Products
> dim bApproved as Boolean = GetApprovalValue() 'get your boolean

flag here. for each product
> dim tmpNode as XmlNode = dom.CreateElement("Details")
> dim xAtt as XmlAttribute = dom.CreateAttribute("Name")
> xatt.value = "Approved"
> tmpNode.attributes.append(xatt)
>
> 'repeat above to add more attributes
>
> product.appendchild tmpnode
>
> Next
>
>
>
> ----- Rich Wallace wrote: -----
>
> I'm sure there's a very weasy way to do this, I've been running

hard
and
> fast on several things at once and just may be at the point of
overthinking
> this...
>
> I receive an incoming XML document via a string feed within a web service:
>
>
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1"
/></Product></Root>
>
> I need to modify the outgoing XML to read the status of an approval check:
>
>
<Root><Product><File>Order</File><Origin>OregonOffice</Origin><Details
Name="Product" Value="Binder" /><Details Name="Qty" Value="1" /><Details Name="Approved" Value="False" /></Product></Root>
>
> Once I have the True or False value from a method call, how would I modify
> the XML to add the new attributes?
>
> TIA
> -Rich
>
>
>

Nov 12 '05 #11

Similar topics

Novice [].append Help

by: waters | last post by:

I seem to have hit a snag. I am trying to add the list (l_local) as an item in the output list (l_output). "l_local" is a modified copy of the format-list "l_format", which will be updated by...

Python

"Insert" (not append) new text segment to an existing text file

by: sm | last post by:

How to "Insert" (not append) new text segment to an existing text file? Assume that we have text file as shown below; Elvis Sofia Kylix BCB--> How to insert here? Atten BuilderX Roma

C / C++

Q/VB.NET: Append data to XML file without loading complete file?

by: Jonathan Buckland | last post by:

Can someone give me an example how to append data without having to load the complete XML file. Is this possible? Jonathan

.NET Framework

Query for records with no matching records in another table?

by: Sven Pran | last post by:

Probably the answer is there just in front of me only awaiting me to discover it, but: 1: I want to build a query that returns all records in one table for which there is no successful "join"...

Microsoft Access / VBA

Append if not already existing query question?

by: What-a-Tool | last post by:

Remember seeing a post a while back from someone who wanted to add to a table only if the data didn't already exist. Someone suggested a type of query called an "Up" something or other. Can't...

Microsoft Access / VBA

How to append records in exist XMl file?

by: Matrix | last post by:

I want to append records in a XML file,I use XMLTextWriter,but i found it only create a XML file,not append records in exist XML file.why? -------------------------------------------------...

C# / C Sharp

query to append and update?

by: MN | last post by:

I have to import a tab-delimited text file daily into Access through a macro. All of the data needs to be added to an existing table. Some of the data already exists but may be updated by the...

Microsoft Access / VBA

Import, Append/Update question.

by: mpslanker | last post by:

This is my first time posting here, so if I have made any mistakes (i.e. wrong forum area, etc) I am sorry. I have an Access database that I have to import a text file into and append it to a...

Microsoft Access / VBA

append output filename

by: vj | last post by:

I am using Borland C++. I run a program which generates output data files, say 'Voltage.dat', 'Current.dat'. I have a variable in my code (say N), and for various values of N (for each value of...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++