Download your favorite Linux distribution at LQ ISO.
Go Back > Blogs
User Name



OTRS: importing an Outlook contacts format CSV to the Address Book

Posted 06-26-2011 at 11:24 AM by catkin


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:
Attached Files
File Type: txt Outlook_CSV_to_OTRS_CSV.awk.txt (30.8 KB, 28 views)
LQ 5k Club
Posted in Uncategorized
Views 5719 Comments 0 catkin is offline

Exporting Outlook calendar as .ical/ics

Posted 05-13-2011 at 07:36 AM by catkin
Tags ical, ics, outlook


This falls into two steps: firstly exporting an Outlook calendar as .ical files and secondly turning those .ical files into a .ics file.

The technique was used with Outlook 2003 running on Windows XP (as part of a migration to Xfce's calendar, Orage). It probably works with other versions and OSes too.

Thanks and acknowledgements to BlueDevilFan who posted the original VBA macro at Experts Exchange where it is no longer visible (but may be...
LQ 5k Club
Posted in Uncategorized
Views 3026 Comments 0 catkin is offline


All times are GMT -5. The time now is 05:15 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration