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 10: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, 24 views)
LQ 5k Club
Posted in Uncategorized
Views 4520 Comments 0 catkin is offline

On The Road - 2

Posted 06-25-2011 at 05:10 PM by Hevithan
Updated 06-25-2011 at 05:12 PM by Hevithan

Have you ever been to Los Banos?

If you have been to a Mexican restaurant, You'll remember the sign Banos from The Bathrooms. Los banos itself is a city, However the part of it that Interstate 5 runs through (below)

Is nothing. Imagine before that truck, is a freeway ramp. Up this ramp you expect there to be civilization ... That's why it is there.
Posted in Uncategorized
Views 4167 Comments 1 Hevithan is offline

On The Road in America - Part 1

Posted 06-25-2011 at 09:41 AM by Hevithan

Well since this blog option is available, I may as well utilize it.

I was thinking I would chronicle my time I spent hitch-hiking the grand ole US. Roughly 4 years, in which I saw plenty of states, met tons of people, and did things most people have only read about or dreamed.

During this tour of adventures I was banned from National Monuments, stuck on a mountain at 11,000 feet with no more then a $20 tent from wal-mart, spent $3,000 dollars at a convinence
Posted in Uncategorized
Views 4278 Comments 1 Hevithan is offline


Posted 06-24-2011 at 03:44 AM by peonuser
Updated 06-28-2011 at 02:20 AM by peonuser

Set up a tftp server on a K2-500 running Debian squeeze.

Went to redboot install dd-wrt on an old airlink ar430w. Did it before on another unit without a hitch with using a different set of instructions. This time it foobarred. Do not think the router is totally bricked, but will have to make a jtag cable to try to fix it. Think I have a max232 chip around here somewhere.

Wished I had just spent time coding tonight. At least the soon to be discontinued router was only...
Posted in Uncategorized
Views 482 Comments 0 peonuser is offline

My Motorcycle

Posted 06-24-2011 at 02:24 AM by tailinlinux

Posted in Uncategorized
Views 3046 Comments 1 tailinlinux is offline


All times are GMT -5. The time now is 01:52 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration