This page describes how to setup AbusePipe.
AbusePipe provides the email extraction capability, and passes data to TextPipe Pro for text processing.
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.
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.
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.
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.