Reading the XML file

Help
1

Scenario: How to read the xml file. How to read author,title,price,description for each book.

XML
XML463Ă—533 14.5 KB

2

Hey @Karunakar

This has been addressed already on forum multiple times so you can take reference from their as well :slight_smile: before posting.

Import XML to Excel - #2 by aksh1yadav

Just change your xml path in the attached file and let me know :slight_smile:

image
image1027Ă—725 29.8 KB

XMl_2_Dt.xaml (7.1 KB)

Regards…!!
Aksh

1 Like
3

Hi ,

Please find below tutorials on XML data type

Thanks,
Karthik

4

How to read xm file with tags(unclosed tags) like this:

Picture1
Picture1707Ă—396 8.07 KB

5

Hi I have downloaded the project but I’m not sure where v have to give path of XML file which I want to read?

6

Hey @DEEPAK_K.S

image
image1102Ă—587 27.4 KB

Regards…!!
Aksh

7

i’m new in rpa especially uipath, can you help me, i have an xml with 3 detail but when i try your sample i just receive 1 row xlsx, i want the output is xlsx have 3 row,
xml :

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>010007193790383319/12/2019013104831092000PT TRAKTOR NUSANTARAKAWASAN INDUSTRI PULOGADUNG JL PULOGADUNG NO 32 , JAKARTA TIMUR016924722007000PT. KARYANUSA EKADAYAJL. PULO AYANG RAYA BLOK OR/1 KIP, JATINEGARA CAKUNG JAKARTA TIMUR DKI JAKARTA RAYA - 000084487998448800Faktur Valid, Sudah Diapprove oleh DJPFaktur Pajak NormalA005-0110317422ELEMENT AIR FILTER INNER *706400963576000635760063576000PIPE752800175280007528007528000SEAL1338399113383990133839913384000

csv i want :
kdJenisTransaksi,fgPengganti,nomorFaktur,tanggalFaktur,npwpPenjual,namaPenjual,alamatPenjual,npwpLawanTransaksi,namaLawanTransaksi,alamatLawanTransaksi,jumlahDpp,jumlahPpn,jumlahPpnBm,statusApproval,statusFaktur,referensi,nama,hargaSatuan,jumlahBarang,hargaTotal,diskon,dpp,ppn,tarifPpnbm,ppnbm
1,0,71937903833,19/12/2019,1.31048E+13,PT TRAKTOR NUSANTARA,“KAWASAN INDUSTRI PULOGADUNG JL PULOGADUNG NO 32 , JAKARTA TIMUR”,1.69247E+13,PT. KARYANUSA EKADAYA,“JL. PULO AYANG RAYA BLOK OR/1 KIP, JATINEGARA CAKUNG JAKARTA TIMUR DKI JAKARTA RAYA - 0000”,8448799,844880,0,“Faktur Valid, Sudah Diapprove oleh DJP”,Faktur Pajak Normal,A005-0110317422,ELEMENT AIR FILTER INNER *,706400,9,6357600,0,6357600,635760,0,0
1,0,71937903833,19/12/2019,1.31048E+13,PT TRAKTOR NUSANTARA,“KAWASAN INDUSTRI PULOGADUNG JL PULOGADUNG NO 32 , JAKARTA TIMUR”,1.69247E+13,PT. KARYANUSA EKADAYA,“JL. PULO AYANG RAYA BLOK OR/1 KIP, JATINEGARA CAKUNG JAKARTA TIMUR DKI JAKARTA RAYA - 0000”,8448799,844880,0,“Faktur Valid, Sudah Diapprove oleh DJP”,Faktur Pajak Normal,A005-0110317422,PIPE,752800,1,752800,0,752800,75280,0,0
1,0,71937903833,19/12/2019,1.31048E+13,PT TRAKTOR NUSANTARA,“KAWASAN INDUSTRI PULOGADUNG JL PULOGADUNG NO 32 , JAKARTA TIMUR”,1.69247E+13,PT. KARYANUSA EKADAYA,“JL. PULO AYANG RAYA BLOK OR/1 KIP, JATINEGARA CAKUNG JAKARTA TIMUR DKI JAKARTA RAYA - 0000”,8448799,844880,0,“Faktur Valid, Sudah Diapprove oleh DJP”,Faktur Pajak Normal,A005-0110317422,SEAL,1338399,1,1338399,0,1338399,133840,0,0

but i only get :
kdJenisTransaksi,fgPengganti,nomorFaktur,tanggalFaktur,npwpPenjual,namaPenjual,alamatPenjual,npwpLawanTransaksi,namaLawanTransaksi,alamatLawanTransaksi,jumlahDpp,jumlahPpn,jumlahPpnBm,statusApproval,statusFaktur,referensi,detailTransaksi/0/nama,detailTransaksi/0/hargaSatuan,detailTransaksi/0/jumlahBarang,detailTransaksi/0/hargaTotal,detailTransaksi/0/diskon,detailTransaksi/0/dpp,detailTransaksi/0/ppn,detailTransaksi/0/tarifPpnbm,detailTransaksi/0/ppnbm,detailTransaksi/1/nama,detailTransaksi/1/hargaSatuan,detailTransaksi/1/jumlahBarang,detailTransaksi/1/hargaTotal,detailTransaksi/1/diskon,detailTransaksi/1/dpp,detailTransaksi/1/ppn,detailTransaksi/1/tarifPpnbm,detailTransaksi/1/ppnbm,detailTransaksi/2/nama,detailTransaksi/2/hargaSatuan,detailTransaksi/2/jumlahBarang,detailTransaksi/2/hargaTotal,detailTransaksi/2/diskon,detailTransaksi/2/dpp,detailTransaksi/2/ppn,detailTransaksi/2/tarifPpnbm,detailTransaksi/2/ppnbm
01,0,0071937903833,19/12/2019,013104831092000,PT TRAKTOR NUSANTARA,“KAWASAN INDUSTRI PULOGADUNG JL PULOGADUNG NO 32 , JAKARTA TIMUR”,016924722007000,PT. KARYANUSA EKADAYA,“JL. PULO AYANG RAYA BLOK OR/1 KIP, JATINEGARA CAKUNG JAKARTA TIMUR DKI JAKARTA RAYA - 0000”,8448799,844880,0,“Faktur Valid, Sudah Diapprove oleh DJP”,Faktur Pajak Normal,A005-0110317422,ELEMENT AIR FILTER INNER *,706400,9,6357600,0,6357600,635760,0,0,PIPE,752800,1,752800,0,752800,75280,0,0,SEAL,1338399,1,1338399,0,1338399,133840,0,0

9

this is the right xml
web_ori.xml (1.6 KB)

10

Hi aksh…
downloaded your code . It gives me an error on the ReadXML method. where would I fiind that method?