XML File Changes

User avatar
Timelord
4StarLounger
Posts: 504
Joined: 23 Jul 2010, 18:36
Location: Westlake, OHIO

XML File Changes

Post by Timelord »

Hello!

I have an xml file that I need to modify and add values to. I do not have fancy software. I tried to do this in Excel and then looked at a couple different notepad type programs and I seem to not be getting the solution in my head. I have attached a sample xml file as a starting point. You can see that it lists 1 server and all the settings that go with it. I have several hundred servers that I need to list in the same way. Test2.xml is what I am starting with and I attached Test3.xml as an example of where I want to go. I need to add many, many servers so copy > paste > replace one at a time is not a good way to go. Any help is appreciated.
You do not have the required permissions to view the files attached to this post.
Who will you Inspire today?

User avatar
HansV
Administrator
Posts: 78410
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: XML File Changes

Post by HansV »

If you have the list of servers in an Excel worksheet or in a Word table, it shouldn't be too hard to write a macro to export the list to an XML file.
Best wishes,
Hans