Custom CiviCRM 1.4 import script

This script was to import contact and payment data for a client. The $n and $p variables have the column names for the CSV files the data comes from. To protect the client, the contact and payment files arn't included. The sort script is intended to remove duplicate contact information, then import second, from the command line.

ISACware IMail SMTP access control

IPSwitch IMail 8.1/8.2 SMTP server has an Access Control list option in the SMTP Security tab. They don't have a tool that makes it easy to do bulk importing of IP network blocks. To make matters worse, the file where the Access Control option stores addresses is in a binary format, as smtpd32.acc, making it nearly impossible to just edit manually.

This script uses documentation from IPSwitch to generate a new smtpd32.acc file for your installation of IMail 8.1 in the proper format from the popular email blacklist sites, Okean and Blackholes.us. You could also create your own custom list of network blocks to enter into a custom smtpd32.acc file if you put it in either the Okean or Blackholes.us file format. Simply use this script to generate a new smtpd32.acc file, place it in the main IMail installation directory (C:\IMail for a default IMail installation), and restart your SMTP service.

PHP required.

Timeshare For Sale By Owner

Timeshare For Sale By Owner is a company in Orlando, FL that helps timeshare owners resell or lease timeshares and points. It's largely a cold-calling, telemarketing business. They had a Microsoft Access database they used to keep track of several thousand sales and customers. I was hired to convert their Access database to a LAMP platform. The conversion script is available, but the rest is left out to protect the client's information and processes.

This is the first time I used COM and Microsoft Jet in PHP. The script does several million loops during its execution and sucks up a lot of memory. If this script were used for more than a single one-time conversion, it could do with a bit of optimizing.

I heard a rumor, after I left, their regular tech guy denormalized the database structure I created because he didn't like table join queries, so the script is probably no longer representative of what they're using now.

myBackware

These scripts were developed to create SQL dump files for basic disaster recovery of small MySQL installations. They are capable of creating local, compressed snapshots and/or mail a copy of the SQL dump to a remote email server in a compressed, GPG (public key encryption) format.

Software development for version 1.0 was sponsored by Advanced Automation Inc.