Xml File Comparison

Help
1

Hi,
I am trying to compare two xml files where under one parent tag we can have multiple child tags.
Please suggest how can I do that because using string function it will need a lot of coding effort to accomplish this thing.

Thanks,
Anjali

2

@anjalimishra,
if you load UiPath.Excel.Activities pacakage then you will have following activities to use for XML.
image

hope my inputs are useful

3

Hi,
How I can use these activities to compare my xml files?

thanks,
Anjali

4

Hi,
I dont get xml activity, instead having excel activities downloaded.

Thanks,
Anjali

5

You need a design to compare

6

As stated earlier in my ask, if I go one after another tag it will take a lot of time.
So please suggest a simpler way to do the same.

Thanks,
Anjali

7

Could you please let me know you want to compare parents nodes or child nodes?

8

Set xmlDoc1 = CreateObject(“Msxml2.DOMDocument”)
xmlDoc1.load(“C:\Filepath\file1.xml”)’file 1

Set xmlDoc2 = CreateObject(“Msxml3.DOMDocument”)
xmlDoc1.load(“C:\Filepath\file2.xml”)’file 2

Compare in if else condition.

Hope this logic useful for you

9

If no other way try DataSet and see if you are able to compare(datatable columns) easily with that.

image
image369×539 15.1 KB

image

10

Hi,
I am getting below error
“Dataset does not have a public instance method name ‘ReadXml’”

image

11

xmlToDt.xaml (6.1 KB)

12

This is done for one XML file how can we achieve this for two or more XML files in the same workflow?

13

in UiPath using which activities we can achieve this?

Thanks,
Anjali

14

On the activities type “Assign” you will get assign activity. Please use that to create

15

Hi,
Assign activity can be used for
Set xmlDoc1 = CreateObject(“Msxml2.DOMDocument”)
then how can i do
xmlDoc1.load(“C:\Filepath\file1.xml”)’file 1??

16

Try in the same Assign activity

17

Hi,

I wanted to ask I’ve already installed UiPath.Excel.Activities (version 2.0.6526.16321), however, the activities like ‘Get XML Nodes’ and ‘Get XML node attributes’ were still unavailable. I;m using the UiPath Community Studio version 2017.1.6522. How do I make the activities like ‘Get XML Nodes’ and ‘Get XML node attributes’ available?

Thanks.

18

Can you share your manage package screenshot showing Excel Activities package.

19

@anjalimishra have you found the solution?