How to get data in other sheet

How to?
#1

how to get data from next sheet in one page

image
image1339×680 23.5 KB

image
image1354×424 14.9 KB

Url: https://lpse.mimikakab.go.id/eproc4/lelang?kategoriId=&tahun=2022&instansiId=&rekanan=

Sitemap:
{"_id":"non_tender","startUrl":["https://lpse.mimikakab.go.id/eproc4/nontender?kategoriId=&tahun=2022&instansiId=&rekanan="],"selectors":[{"id":"name","parentSelectors":["_root"],"type":"SelectorElementScroll","selector":"td p a","multiple":true,"delay":2000,"elementLimit":1000},{"id":"kode tender","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Kode Paket') strong","multiple":false,"regex":""},{"id":"Nama Tender","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Nama Paket') strong","multiple":false,"regex":""},{"id":"Tanggal Pembuatan","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Tanggal Pembuatan') td","multiple":false,"regex":""},{"id":"Tahap Tender","parentSelectors":["link"],"type":"SelectorText","selector":"td a","multiple":false,"regex":""},{"id":"Satuan Kerja","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Satuan Kerja') td","multiple":false,"regex":""},{"id":"Metode Pengadaan","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Metode Pengadaan') td","multiple":false,"regex":""},{"id":"Pagu","parentSelectors":["link"],"type":"SelectorText","selector":"tr:nth-of-type(12) td:nth-of-type(1)","multiple":false,"regex":""},{"id":"HPS","parentSelectors":["link"],"type":"SelectorText","selector":".content > table > tbody > tr > td:nth-of-type(2)","multiple":false,"regex":""},{"id":"Jenis Kontrak","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Jenis Kontrak') td","multiple":false,"regex":""},{"id":"Kualifikasi Usaha","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Kualifikasi Usaha') td","multiple":false,"regex":""},{"id":"link","parentSelectors":["name"],"type":"SelectorLink","selector":"parent","multiple":false},{"id":"Jenis Pengadaan","parentSelectors":["link"],"type":"SelectorText","selector":"tr:contains('Jenis Pengadaan') td","multiple":false,"regex":""}]}

#2

up!

please help me to solve this problem @admin, @ viesturs

#3

@jhohantam Hi, are you looking to extract the table data in a single row? If so - that should be possible by using the 'Grouped' selector - .table-bordered > tbody > tr.

Learn more: Web Scraper << How to >> Scrape multiple values in one row

Example:

{"_id":"non_tender","startUrl":["https://lpse.mimikakab.go.id/eproc4/nontender?kategoriId=&tahun=2022&instansiId=&rekanan="],"selectors":[{"id":"name","multiple":true,"parentSelectors":["_root"],"selector":".dataTable tbody tr","type":"SelectorElement"},{"extractAttribute":"","id":"all data","parentSelectors":["link"],"selector":".table-bordered > tbody > tr","type":"SelectorGroup"},{"id":"link","multiple":false,"parentSelectors":["name"],"selector":"p a","type":"SelectorLink"}]}

#4

thx for the respons me @ viesturs ,
i mean how to get data in the next column, please help me to solve :pray:

arrow
arrow1343×671 23.9 KB

evaluasi
evaluasi1366×671 22.3 KB

peserta
peserta1356×671 16.5 KB

#5

@jhohantam It appears that it is possible to navigate through these tabs by using a 'Link' selector.

Depending on what structure you are looking to extract this data in - all of the targeted data points should be set as a 'child' for the tab link they can be found in.

Example:

{"_id":"test-2nov","startUrl":["https://lpse.mimikakab.go.id/eproc4/lelang/5419639/pengumumanlelang"],"selectors":[{"id":"kode","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"tr:contains('Kode Tender') td","type":"SelectorText"},{"id":"nama-tender","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"tr:contains('Nama Tender') strong","type":"SelectorText"},{"id":"peserta","multiple":false,"parentSelectors":["_root"],"selector":"li:contains(\"Peserta\") a","type":"SelectorLink"},{"id":"nama-peserta-1","multiple":false,"parentSelectors":["peserta"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(2)","type":"SelectorText"},{"id":"npwp-1","multiple":false,"parentSelectors":["peserta"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(3)","type":"SelectorText"},{"id":"harga-pena-1","multiple":false,"parentSelectors":["peserta"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(4)","type":"SelectorText"},{"id":"harga-terko-1","multiple":false,"parentSelectors":["peserta"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(5)","type":"SelectorText"},{"id":"hasil-link","multiple":false,"parentSelectors":["peserta"],"selector":"li:contains(\"Hasil Evaluasi\") a","type":"SelectorLink"},{"id":"hasil-nama-preserta-1","multiple":false,"parentSelectors":["hasil-link"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(2)","type":"SelectorText"},{"id":"hasil-penawaran-1","multiple":false,"parentSelectors":["hasil-link"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(7)","type":"SelectorText"},{"id":"hasil-penawaran-terkoreksi-1","multiple":false,"parentSelectors":["hasil-link"],"regex":"","selector":"tr:nth-of-type(1) td:nth-of-type(8)","type":"SelectorText"},{"id":"pemenang-link","multiple":false,"parentSelectors":["hasil-link"],"selector":"li:contains(\"Pemenang\"):nth(0) a","type":"SelectorLink"},{"id":"pemenang-nama-tender","multiple":false,"parentSelectors":["pemenang-link"],"regex":"","selector":"tr:contains('Nama Tender') td","type":"SelectorText"},{"id":"berkontrak-link","multiple":false,"parentSelectors":["pemenang-link"],"selector":"li:contains(\"Berkontrak\") a","type":"SelectorLink"},{"id":"pemenang-berkontrak-name-tender-1","multiple":false,"parentSelectors":["berkontrak-link"],"regex":"","selector":"tr:contains('Nama Tender') td","type":"SelectorText"}]}

#6

thanx @ viesturs, for the idea because its help me have an another solution. :pray: :grinning: