iBiz to MySQL
Description
iBiz was discontinued in 2013. This PHP script imports an iBiz directory into a MySQL database. The script is open source and has been tested on an iBiz directory containing a few thousand records.The iBiz to MySQL script does the following:
- Creates a new database on your MySQL server
- Creates tables in that database named 'Customers', 'Invoices', 'JobEvents', 'JobEventsEstimates', and 'Projects'
- Imports iBiz clients into the 'Customers' table
- Reads in an Apple 'AddressBook.vcf' file, adding phone numbers, email addresses, and postal addresses to each customer
- Imports iBiz Projects into the 'Projects' table
- Imports JobEvents and JobEventsEstimates into their respectively named tables
- Imports Invoices into the 'Invoices' table
- That's it!