Extract automobile manufacturers name from wikipedia

UI.Vision RPA General Discussion
1

I have to crawl the automobile manufacturers name from wikipedia

Here is my json code
ChoDoiXe-Automobile-Firm-list.json (3.9 KB)

If I do not use if function in line 9, the task can not crawl the second name such as Koller of Argentina

If I use if function in line 9, the task can not crawl anything

Please give me the best code

Thank you very much!!! :heart: :heart:

2

Can you post a macro that we can run for testing?

Where is the issue? storeXpathCount?

3

Yes, I posted the running macro

My issues are if function in line 9, storexpathcount function in line 8

4

Post url page and add image to text to extract i can solve your problem

5

You can do it with my attachment macro script

6

I have looked at the page and I think this work takes a lot of time and numerous different parts of macros as the data is not sorted but is organized in a messy way in different columns (sometimes a column other times 4 columns, other times 3 columns, it takes a long time to write a good macro code.

7

Help me please !!!

8

i tried with xpath but elements were not found
so only few titles were saved.

use DOM

getElementsByTagName(‘li’)

save till Vinaxuki

9

I am so sorry all !!! The previous macro hasn’t “xpath=” in code line 17 and 26

Here is the running macro

ChoDoiXe-Automobile-Firm-list.json (4.1 KB)

10

I tried on my own with xpath
and it wasnt 100% successful

did you tried DOM/

11

Can you explain clearly

12

i tried xpath=//li

then i tried to extract all
it stopped in between

13

So, can you write the new macro to crawl them for me.

14

{
“Command”: “executeScript”,
“Target”: “var x=document.getElementsByTagName(‘li’); \n\nvar d=”";\nfor (var a=1;a<x.length;a++)\n{\nd+= x[a].textContent + “\n”;\nif (x[a].textContent ==“Vinaxuki”) break;\n}\nreturn d;",
“Value”: “data”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “${data}”,
“Value”: “!csvline”,
“Description”: “”
},
{
“Command”: “csvSave”,
“Target”: “Automobiles”,
“Value”: “”,
“Description”: “”
}

now you can modify to save one at a time

15

I have tried your logic but elements were not found

you need 2 loops
loop 1 will start with value 4
second loop will start with 1
it will be nested loop

it stopped in between as it cant find the element

16

Can you export it to json.

I paste your code to my ui macro, it can not running

17

I have attached the code.
Auto.json (600 Bytes)

1 Like