Opt-In Software Blog

Opt-In List Manager 1.3.95

by Vitaly, Thursday, December 12th, 2019

Version 1.3.95 of the Opt-In List Manager has been released.

What’s New

Extracting emails from the various sources has been improved. Now it can extract emails from:

  • Archive files. Supported formats (file extensions): ZIP, JAR, EXE (self-extracted archives), TAR, GZ, TGZ, CAB, BZ2, TBZ.
  • XLSX files (Microsoft Excel Open XML Format Spreadsheet).
  • XLS files (Excel 97/2003).

oilm-archive-processing

Tags: Archive, GZIP, TAR, XLS, XLSX, ZIP

MaxMind DB Reader for Delphi

by Vitaly, Friday, October 25th, 2019

The MaxMind DB file format is a database format that maps IPv4 and IPv6 addresses to data records using an efficient binary search tree.

MaxMind provides variety APIs for lookup IP information in their database: for C, C#, Go, Java. But, unfortunately, API for Delphi is missed. MMDB Reader project solves this omission.

Tags: Delphi, Geo IP, IP, MaxMind, MMDB, Reader

Double-asterisk

by Vitaly, Friday, September 21st, 2018

New versions of Copy Manager and ZIP Manager support the double asterisks in source patterns.

The double asterisk (**) followed by backslash (\) will cause to recursive inclusion of files from all subdirectories.

Example. Directory structure:

path\f1\
path\f1\a1\
path\e2\
path\e2\a1\
path\e2\b2\

Pattern path\*\*.txt matches *.txt files in subdiretories path\f1\ and path\e2\ (but NOT in path\, path\f1\a1, path\e2\a1\, path\e2\b2\).

Pattern path\**\*.txt matches *.txt files in path\ and in all subdirectories (path\f1\, path\f1\a1\, path\e2\, etc.).

Pattern path\f**\*.txt matches *.txt files in all subdirectories of path\ starting with f: path\f1\, path\f1\a1\ (but NOT in path\, path\e2\, etc.).

Pattern path\**\a1\*.txt matches *.txt files in path\f1\a1\ and path\e2\a1\.

Tags: Double-asterisk

RegExp List Generator

by Vitaly, Wednesday, December 21st, 2016

RegExp List Generator 1.16 has been released.

What’s New

1. New option: “Don’t output Columns that start with @”.

This option is useful for generate values that are used in several columns.
For example, if you want to generate the user name as a combination of the first name, last name, or initials, you can do that this way:

Columns:

@FI=[A-Z]
FirstName=%%=@FI%%[a-z]{5,12}
@LI=[A-Z]
LastName=%%=@LI%%[a-z]{5,15}
Username=(%%=@FI%%|%%=FirstName%%)[._-]?(%%=@LI%%|%%=LastName%%)

Example of the Output:

FirstName,LastName,Username
Bpeeahda,Gbkdtl,B_G
Hnnbov,Hocadrtjzyx,HnnbovHocadrtjzyx
Hojbxuinx,Okalcywmpxsczwjn,H-Okalcywmpxsczwjn
Pfrezeezto,Vkkagdqnobo,P.V
Dkncdbdkiatl,Uwcicfbo,DkncdbdkiatlUwcicfbo
Mkqyehiqxgdwp,Hqbbuaf,Mkqyehiqxgdwp-H
Buefvilfxyjyr,Uybtxynfiha,Buefvilfxyjyr-Uybtxynfiha
Amlbvlak,Jgmyurg,AmlbvlakJ
Moxmemuh,Abbmpfwkpg,M_A

2. Generate SQL Insert Statements.

Example of the generated SQL Insert Statements:

INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Xjbusbgffhgo','Zyzcmng','XZ');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Bcgdhbxsdxgnd','Kvcxgkrkbzg','Bcgdhbxsdxgnd.Kvcxgkrkbzg');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Umklpw','Crpehsl','UCrpehsl');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Subcwhyx','Gxjkfyrcc','Subcwhyx_Gxjkfyrcc');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Symupexprzm','Sossuifnbgieighh','SymupexprzmS');

3. Save, Load or Delete stored Columns

Tags: SQL

IMAP Checker 1.5

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

Correlated Data

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.

oilm-capitalize-tn

Tags: Correlate, Data, Filter, List