Saturday, December 12, 2015

How to broadcast email using mail merge in Mozilla Thunderbird

Download Mozilla Thunderbird and install it


Install Mozilla Thunderbird
For first time users, you need to set up your default email account in Thunderbird. Here are expanded tutorials on Automatic Account Configuration and Manual Account Configuration on Mozilla support.
If you’re using Thunderbird as your default e-mail client, proceed to the Mail Merge download and installation.
1. After downloading the Mail Merge file “mail_merge-3.10.1-sm+tb.xpi,” launch Thunderbird. You may set it as your default email client or skip the integration.
Set Thunderbird as default.
2. Click Tools and choose “Add-ons,” and it will direct you to the “Add-ons Manager” tab. See the gear icon adjacent the Search bar, and click the drop-down menu.
Thunderbird Add-ons Manager
3. Choose “Install Add-on from File,” and open the Mail Merge file that you previously downloaded; restart the email client for the changes to take effect.
Restart Thunderbird for the changes to take effect.
Mail Merge is beneficial for those who have been building their e-mail contacts in a spreadsheet. In this tutorial, here’s what it looks like.
1. Create a spreadsheet and save it as a .csv file (e.g. mtelist.csv based on screenshot) if you don’t have one.
Create a spreadsheet and save it as dot-csv file.
2. Make sure that the columns are filled up with names and email addresses. Choose “Save as” for the file and click OK. Never mind the warning in the dialog box; proceed to the next step.
Ignore the Compatibility check recommended warning.
1. Click the “Write text” icon and create a new message. You may also add more recipients manually in the “To” field.
2. When writing, always include the text you want to use from the CSV file you saved previously with double brackets, e.g. {{Name}}. See A1 on the spreadsheet above.
Include text from CSV file with double brackets.
3. Once you finish writing the draft, go to File and select Mail Merge. Set the Mail Source to CSV, the Delivery Mode (Send as Draft, Send Later, and Send Now), the Format (HTML or Plain) and if you have attachments.
Go to File and select Mail Merge.
4. Click Browse to upload the CSV file from the directory where you have saved it and click OK. Mail Merge will run, and it will send your message according to the Delivery Mode.
You can check if the messages are sent in the Sent folder. If you have set the Delivery Mode as Send Later, then they will be automatically saved in Outbox under Local Folders. Keep in mind that the text inside the double brackets should be the same text or name of the column labeled in the CSV file you have saved. See A1 on the spreadsheet above. The CSV option works well; however, when I tried to do it via Address Book, I keep on getting errors.
Let us know how it works on your side and feel free to share other ways to create mail merge.

Friday, December 11, 2015

Enable Oci8 in Mac

Installation

This procedure is tested on Mac OS X 10.8 with Developpers tools installed (xCode).
PHP 5.4 installed with Homebrew.

Preparation

Download the following files from Oracle website (yes, you need to create an account and accept terms):
Create and unzip all theses files into a the directory `/usr/local/instantclient/11.2.0.3/`.
This directory will looks like:

.
├── BASIC_README
├── SQLPLUS_README
├── adrci
├── genezi
├── glogin.sql
├── libclntsh.dylib.11.1
├── libnnz11.dylib
├── libocci.dylib.11.1
├── libociei.dylib
├── libocijdbc11.dylib
├── libsqlplus.dylib
├── libsqlplusic.dylib
├── ojdbc5.jar
├── ojdbc6.jar
├── sdk
│   ├── SDK_README
│   ├── demo
│   ├── include
│   ├── ott
│   └── ottclasses.zip
├── sqlplus
├── uidrvci
└── xstreams.jar


Create symlinks


ln -s /usr/local/instantclient/11.2.0.3/sdk/include/*.h /usr/local/include/
ln -s /usr/local/instantclient/11.2.0.3/sqlplus /usr/local/bin/
ln -s /usr/local/instantclient/11.2.0.3/*.dylib /usr/local/lib/
ln -s /usr/local/instantclient/11.2.0.3/*.dylib.11.1 /usr/local/lib/
ln -s /usr/local/lib/libclntsh.dylib.11.1 /usr/local/lib/libclntsh.dylib

Test with sqlplus instantclient

I recommand to install Oracle Server with a VirtualBox VM preinstalled.
/usr/local/bin/sqlplus oracle/oracle@192.168.2.2

Install extension with pecl


pecl install oci8
If the script prompt you to provide the path to ORACLE_HOME directory, respond with:

instantclient,/usr/local/lib
And your are done, normally pecl will automatically load the extension in your `php.ini`. If not, add the following line to your `php.ini`:

extension=oci8.so
Restart your HTTP Server and test.
Enjoy (or try to…) !

Troubleshooting

Cannot find autoconf. Please check your autoconf installation and the
$PHP_AUTOCONF environment variable. Then, rerun this script.
ERROR: `phpize' failed
Solution :

Run this command. First run this command to make sure your mac can run command brew
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew install autoconf