Here's a script and associated SQL to import data from an Outlook contacts format CSV file into OTRS' Address Book.
They were developed and tested using:
- An Outlook contacts format CSV file generated by export from Google Mail.
- gnu awk 3.1.8 on Slackware64 13.1.
- OTRS 3.0.8 running on Debian Squeeze 64 bit using mysqld and mysql 5.1.49.
The awk script prints usage if run with the -h option.
A sample usage: