With a little side of applesauce...

Friday, September 12, 2008

Meeting Maker - prepare export for pushing into gmail

Here is the BASH one-liner to transform a meeting maker tab-delimited export into a pipe-delimited text file for us to parse and push up into Gmail:
cat meetingmaker_export.txt  | sed 's/\t/|/g' |  tr -d '\015' | sed 's/"//g' | awk -F\| '{print $1,$2"|"$13"|"$7,$8,$9,$10"|"$14"|"$15"|"$16"|"$4,$5,$6,$22,$23,$24,$25,$26 }' > mm_import.txt



Here is the schema for our pipe-delimited file (the numbers correspond to the columns in the meeting maker export, (which I included and numbered below)):
   1-2         13      7-10      14           15           16             4-6,22-26
contact name | email | address | phone home | phone work | phone mobile | Notes

1 - First Name
2 - Last Name
3 - Category
4 - Title
5 - Department
6 - Room
7 - Company
8 - Address
9 - City
10 - State
11 - ZIP
12 - Country
13 - Email
14 - Home Phone
15 - Work Phone
16 - Mobile Phone
17 - Pager
18 - Fax
19 - Other Phone 1
20 - Other Phone 2
21 - Other Phone 3
22 - Custom 1
23 - Custom 2
24 - Custom 3
25 - Custom 4
26 - Info

No comments: