Xml File Comparison

studio

#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


#10

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

image


#11

xmlToDt.xaml (6.1 KB)


Reading xml file into dataset/datatable
#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.