by Vitaly, Tuesday, October 18th, 2016

IP List Generator 2.7 64-Bit Edition has been released.

Tags: IP, List, x64

by Vitaly, Tuesday, August 2nd, 2016

IMAP Checker 1.5 has been released.

What’s New

IMAP Checker 1.5 supports POP3 protocol.

Aol POP3 Settings

Domain(s): aol.com, aol.co.uk

Host: pop.aol.com
Port: 995
SSL/TLS: Implicit SSL
Authentication Type: User/Password

Gmail POP3 Settings

Domain(s): gmail.com, googlemail.com

Host: pop.gmail.com
Port: 995
SSL/TLS: Implicit SSL
Authentication Type: User/Password

Hotmail/Outlook POP3 Settings

Domain(s): hotmail.com, outlook.com

Host: pop-mail.outlook.com
Port: 995
SSL/TLS: Implicit SSL
Authentication Type: User/Password

Yahoo POP3 Settings

Domain(s): yahoo.com, yahoo.co.uk

Host: pop.mail.yahoo.com
Port: 995
SSL/TLS: Implicit SSL
Authentication Type: User/Password

Tags: POP3

by Vitaly, Tuesday, June 21st, 2016

Opt-In List Manager 1.2.78 has been released.

What’s New

New analysis feature called “Correlated Data”. It allows to keep or remove the records where data in one column or more specified columns partially or fully correlates to data in another column.

Example:

email,first_name,last_name
drewpwtm@yahoo.com,Andrew,Smallhouse

It is needed to find the records that correlate to column 1 (email) from column 2 (first name) or column 3 (last name). Consider them correlating if 3 characters in a row match. Meaning the same 3 characters or more (in the same order) are anywhere in the email address as contained in either the first name column or the last name column.

The software will take “Andrew” and split it into “and”,”ndr”,”dre”,”rew” and check for each of those in the email address. It will find a match with “dre” and therefore be a KEEP row.

If it were to not find “dre” and “rew” (it would find both) but pretend the email was khouz12345@yahoo.com instead.
Then the software would need to take “Smallhouse” and split it into “sma”, “mal”, “all”, “llh”, “lho”, “hou”, “ous”, “use” and check for those in the email address.
In the case of khouz12345@yahoo.com it would find “hou” and KEEP the record.

If both first and last name failed to find any correlation it would remove the record.

Tags: Correlate, Data, Filter, List

by Vitaly, Monday, May 16th, 2016

Opt-In List Manager 1.2.77 has been released.

What’s New

Extract And Clean->Clean Mail Lists: Capitalize First Letters.

This feature allows to capitalize the first letter of each word and lowercase the rest when words are separated by “ “ or “.” or “,” or any of those combined like “, “ “. “ etc.

Tags: Capitalize, Fields, Format, List

by Vitaly, Tuesday, April 12th, 2016

Opt-In List Manager 1.1.72 has been released.

What’s New

1. Extract And Clean: “Reorder/Remove Fields” box allows up to 40 columns instead of 20.
2. Filter/Keep Address, Join Lists and other tools allow up to 40 fields instead of 20.
3. You can specify columns range using a ‘-‘ (example: 5-10).

Tags: Columns, Fields, Reorder

by Vitaly, Friday, March 25th, 2016

Opt-In List Manager 1.1.71 has been released.

What’s New

Added option “Sort Lists”->“Count Duplicates”.

Example

Source list:

user1@gmail.com,FirstName1,LastName1
user2@gmail.com,FirstName2,LastName2
user1@gmail.com,F1,L1

Output without “Remove Duplicates“:

2,user1@gmail.com,FirstName1,LastName1
2,user1@gmail.com,F1,L1
1,user2@gmail.com,FirstName2,LastName2

Output with “Remove Duplicates“:

2,user1@gmail.com,FirstName1,LastName1
1,user2@gmail.com,FirstName2,LastName2

Tags: Count, Duplicates, Sort

by Vitaly, Monday, February 15th, 2016

Accurate regular expression to match IPv4 address:

((([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5]))\.){3}(([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5]))

Tags: IPv4, Regular Expression

by Vitaly, Friday, February 12th, 2016

Web Proxy Checker Pro 1.8.46 released.

What’s New

Added support of MySQL databases.

Format of the MySQL source path:

mysql://connection_name/table_name/column1,column2,...[delimiter]/where_statement

Format of the MySQL output path:

mysql://connection_name/table_name/column1,column2,.../value1,value2,...

You can read more about MySQL source/output path formats here: MySQL Support (AV)

Output Values

• :$host – proxy host
• :$port – proxy port
• :$type – proxy type (https, socks4, socks5)
• :$user – proxy user name
• :$pass – proxy password
• :$extip – external IP address
• :$ccode – country code

MySQL Connections

Load from MySQL Table

Save to MySQL Table

Tags: MySQL, SQL

by Vitaly, Sunday, January 31st, 2016

Opt-In List Manager 1.1.68 has been released.

It includes performance improvements of “Filter Addresses” feature.

Tags: Filter, List, Performance

by Vitaly, Tuesday, February 2nd, 2016

Opt-In List Manager 1.1.69 has been released.

What’s New

Added option “Extract And Clean”->“Convert OEM to ANSI”.

Tags: ANSI, Convert, List, OEM