LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Blogs > catkin
User Name
Password

Notices

Uncategorized Entries with no category
Old

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

Posted 06-26-2011 at 10: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, 14 views)
LQ 5k Club
Posted in Uncategorized
Views 2824 Comments 0 catkin is offline
Old

Script to prepare a Thunderbird PAB export for gnokii to write to Nokia series 40

Posted 05-19-2011 at 03:47 AM by catkin
Updated 06-26-2011 at 09:40 AM by catkin (Version 0.2 of the script)

Hello

Here's a script to prepare a Thunderbird Address Book LDIF export for gnokii --writephonebook to write to a Nokia Series 40. The usage is something like:
Code:
cat /tmp/TB.PAB.ldif \
  | prepare_ldif_for_gnokii.awk \
  1>/tmp/ldif.prepared \
  2>/tmp/prepare_ldif_for_gnokii.log
cat /tmp/ldif.prepared \
  | gnokii --writephonebook --overwrite --memory-type ME --ldif \
  2>/tmp/gnokii.stderr
The script:
Code:
#!/usr/bin/awk
...
LQ 5k Club
Posted in Uncategorized
Views 1098 Comments 0 catkin is offline
Old

Fixing locale en_GB to give Monday as first day of the week

Posted 05-13-2011 at 06:54 AM by catkin
Updated 05-19-2011 at 03:30 AM by catkin (Was fixing the "ain't broke" and doing so badly)

Entry deleted -- it was fixing the "ain't broke" and doing so badly.
LQ 5k Club
Posted in Uncategorized
Views 583 Comments 0 catkin is offline
Old

Exporting Outlook calendar as .ical/ics

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

Hello

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 1507 Comments 0 catkin is offline
Old

Script to filter an Orage export .ics file for gnokii to write to Nokia series 40

Posted 05-12-2011 at 06:21 AM by catkin
Updated 06-26-2011 at 09:51 AM by catkin (Update, version 0.1 to 0.2)

Hello

This script is a workaround for gnokii not being able to set recurrence when loading calendar events to Nokia Series 40 phones. It is designed to work with data exported from Xfce's Orage calendar. It is at an early test stage, please report any problems via comments to this blog entry.

More specifically this script:
  • Works with a subset of RFC 5545 as seen in Orage 4.6.1 export files. In its GUI, Orage only supports BYDAY; it does not support BYMONTH, BYMONTHDAY,
...
Attached Files
File Type: txt filter_orage_ics_for_gnokii-0.2.awk.txt (37.6 KB, 1 views)
LQ 5k Club
Posted in Uncategorized
Views 906 Comments 0 catkin is offline

  



All times are GMT -5. The time now is 12:43 PM.

Main Menu
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