batch fuzzy search for emailaddresses with Octoparse (free plan available)
In Ninox it is easy to search for certain data on some words.
It shows only the lines with results.
I did it manually, but why not automatic?
In my CRM are columns with
First name
Initials
tussenvoegsel (like 'de' Pieter de Bruin)
Last name
website
I added an extra column with domainname (extracted from the website).
You could use https://urltodomain.com/ to do so.
Then I merged 2 columns together which I am going to use for searching emailaddresses.
In Ninox I have a dataset containing emailaddresses.
Filtered out for role accounts like info@ contact@
It will ask for a login.
Go to 'Browse mode' and login to your account.
Go to options and Use cookie.
Switch Browse mode off again.
Click item:
//div[@class="table-head-search-text"]
The loop item
Enter text
//input[@class="hud-menu-search-input"]
Extract data
I choose to extract the text in the textbox (search item) and the found emailaddress with domainname.
To empty the search box
//div[@class="hud-menu-search-placeholder"]/div[1]
Task settings
Check Disable task split
In the paid plan you can run it in the cloud.
Some results.
You can tweak the settings a bit.
My average speed is about 5 / 6 searches per minute in 'Normal Mode' run locally.
You can copy the task and split the search in more parts.
Text in textbox need to be changed.
Change the text in text box by clicking on this
It opens the textbox and press confirm.
Click Apply
Now you can run more tasks at once.
Actually they have 5 plans.
Free
Basic
Standard
Professional
Enterprise
https://helpcenter.octoparse.com/en/articles/6471103-compare-all-octoparse-plans
Here it looks they have only 4
https://www.octoparse.com/pricing
The free plan is limited to 10.000 records per export.
So if you split your task up, you would be fine with the free plan.
You can only run 2 concurrent local tasks the same time in the free plan.
Reply
Content aside
- 9 mths agoLast active
- 76Views
-
1
Following