This page describes how to setup AbusePipe.

Step 1. Download and Install TextPipe Pro

AbusePipe provides the email extraction capability, and passes data to TextPipe Pro for text processing.

TextPipe Pro is NOT included in the AbusePipe download. You need to download TextPipe Pro separately from the DataMystic web site - btn_download.

TextPipe Pro *IS* included when you purchase AbusePipe. Download it after logging in. The TextPipe Pro download link is listed underneath the AbusePipe download links.

Step 2. Configure AbusePipe

  1. On the Login tab, specify the login details for the Abuse Email Account
  2. On the Email Folders tab, specify where Abuse Emails are received. Generally this is the Default Inbox of the Abuse Email Account, but if it is a subfolder, specify it here
  3. Normally processed Abuse emails are moved to a new folder. Create a new folder if necessary (e.g. Processed), and point AbusePipe at this folder.
  4. On the Filter tab, specify (in the AbusePipe installation folder) Filters\extract.fll, included in the AbusePipe download
  5. Now Click the [Edit] button to open TextPipe Pro with Filters\extract.fll.

Step 3. Configure Internal IPs for Routers, Servers etc

In TextPipe's My Filter List, click on the [+] next to Remove internal IPs for routers, servers etc.

Click on the Replace List: Perl pattern ... filter below it.

Add the IP addresses of any servers/routers/internal equipment to the list, one per line. Set the Replace text to 'REMOVE' for every entry.

Perl regex patterns can be used e.g.


The listed IPs will not be included in any reports.

Save the filter.

Step 4. Configure The Output Location

By default, TextPipe leaves its output on the desktop in an Excel file called AbusePipe analysis results.csv.

For database output, see step XX below.


If you don't require database output, exit TextPipe, and click on AbusePipe's [Go] button to start processing.

Note: Database output allows daily, weekly and monthly reports, and other useful automation.

Step 5. Database Output...

In TextPipe's My Filter List, double click Make Excel spreadsheet on desktop to disable it (shown with a red cross through it).

Double click Insert into database to enable it (the red cross is then removed).

With database output, TextPipe generates a file AbusePipe analysis results.sql on the desktop, and then feeds this into a database.

The database is configured as C:\Program Files\DataMystic\AbusePipe\abusepipe.mdb, but you may need to alter the filter called Database Provider... if this location is not correct.

Save the filter, and exit TextPipe.


Click on AbusePipe's [Go] button to start processing.

If you have any questions, please contact us.


With the IP data in a database, you can review daily, weekly and monthly reports, map IP addresses to customers (through an IP<->customer mapping table), and even automatically generate customer Terms Of Service/Acceptable Use violation emails.