LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Blogs
User Name
Password

Notices



Old

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

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

Hello

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

  



All times are GMT -5. The time now is 03:47 PM.

Main Menu
Advertisement

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