Re: BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-08 Thread Johnny
Hi Sriram!

"Sriram ET."  writes:

>> I envisioned being able to sync my work contacts, normally managed
>> by Outlook, with my personal contacts, managed normally through
>> BBDB. Maybe having all (synced) Outlook contacts on a usb and
>> carrying around.

> How is Outlooking managing your contacts if you are running Linux? The work
> flow I have built the application for is: On Windows (where you use your
> Outlook), you can sync to a .bbdb file that can be shared through a common
> partition on Linux - and access it via Emacs when you boot into Linux, or keep
> that file on Dropbox or some such thing. You do not really need anything else
> on Windows (not even Emacs or BBDB elisp files). In other words, instead of
> carrying around a synced PST, you would carry around a synched .bbdb file. 
> Does
> that make sense?
>

Yes, it makes sense and seems reasonable. The main problem I have with
using Windows, is that it is on a corporate machine I have no control
over and extremely limited access to (I guess, a standard office
computer these days) that I have to use for work, hence contacts getting
into Outlook. Some of those, I want to have access to at home on my
Linux box. Hence the idea to keep a contacts file in pst format on a
USB-stick and sync the data at home where I can configure the necessary
applications. 

Of course, if I could configure the Windows machine that would be a
daisy! :)

-- 
Johnny

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/


Re: BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-07 Thread Sriram ET.
On Mon, May 7, 2012 at 10:48 PM, Johnny  wrote:

> "Sriram ET."  writes:
>
> > On Mon, May 7, 2012 at 12:39 AM, Johnny  wrote:
> >
> > Just need some help getting it up and running on Linux please...
> >
> > Oops :)
> >
> > Outlook support in ASynK/Gout uses the MAPI API (through the python
> bindings of
> > the excellent pywin32 package), which means it was designed to run on
> Windows.
>
> :(
>
> No plans / possibilities to get it running on Linux in the future? I
> guess a bi-directional sync on Linux may seem a little funny,


As I said PST file write APIs were not available earlier, and I have not
checked in a while. This is not a scenario that is of any interest to me.


> but I
> envisioned being able to sync my work contacts, normally managed by
> Outlook, with my personal contacts, managed normally through BBDB. Maybe
> having all (synced) Outlook contacts on a usb and carrying around.
>

How is Outlooking managing your contacts if you are running Linux? The work
flow I have built the application for is: On Windows (where you use your
Outlook), you can sync to a .bbdb file that can be shared through a common
partition on Linux - and access it via Emacs when you boot into Linux, or
keep that file on Dropbox or some such thing. You do not really need
anything else on Windows (not even Emacs or BBDB elisp files). In other
words, instead of carrying around a synced PST, you would carry around a
synched .bbdb file. Does that make sense?

-Sriram
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/

Re: BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-07 Thread Johnny
"Sriram ET."  writes:

> On Mon, May 7, 2012 at 12:39 AM, Johnny  wrote:
>  
>
> Just need some help getting it up and running on Linux please...
>
> Oops :)
>
> Outlook support in ASynK/Gout uses the MAPI API (through the python bindings 
> of
> the excellent pywin32 package), which means it was designed to run on Windows.

:(

No plans / possibilities to get it running on Linux in the future? I
guess a bi-directional sync on Linux may seem a little funny, but I
envisioned being able to sync my work contacts, normally managed by
Outlook, with my personal contacts, managed normally through BBDB. Maybe
having all (synced) Outlook contacts on a usb and carrying around.

It seems I have to get 'lookout.el' working after all... 

-- 
Johnny

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/

Re: BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-06 Thread Sriram ET.
On Mon, May 7, 2012 at 12:39 AM, Johnny  wrote:


> Just need some help getting it up and running on Linux please...
>

Oops :)

Outlook support in ASynK/Gout uses the MAPI API (through the python
bindings of the excellent pywin32 package), which means it was designed to
run on Windows. PST file write support was not available when I started
working on my project, and I am not sure if things have changed much since.

The Google - BBDB sync will work on all platforms - from the command line
for now, and through a browser based interface in the future.

Cheers.
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/

Re: BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-06 Thread Johnny
"Sriram ET."  writes:

> On Sun, May 6, 2012 at 8:54 PM, Johnny  wrote:
>
> Hi all,
>
> I have tried for some time to get lookout.el to import my contacts from
> a csv-file into bbdb, but am on the verge of giving up, so before
> finally ditching the attempts (again); Is there *anyone*
> out there that have successfully migrated .csv contacts into bbdb (bbdb
> 3), and how?
>
> I have not migrated a CSV, but...
>
> I am about 7-10 days from announcing a two way sync tool for BBDB/Outlook/
> Google Contacts, i.e. you can do bi-directional sync between any two folders
> across any two different databases. 
>
> If you are interested in trying out a bleeding edge version of my code, it is
> available at: https://github.com/skarra/Gout Documentation is very incomplete,
> but if you would like to try this out, we could talk offline and I can help 
> you
> get it set up.
>

Wow, this is what I first looked for, but found none available! I am
pulling your code now and will be excited to try it out - too long time
have I had contacts scattered in various places and it is time to bring
them all together. Clearly BBDB is the preferred tool, but a two-way
sync to Outlook is almost invaluable as this is where I have to spend
work. Altough I have deferred using google for contacts, this may
provide the wholy trinity with www-available contacts! 

Just need some help getting it up and running on Linux please...

Thanks, great initiative!

-- 
Johnny

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/


Re: BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-06 Thread Sriram ET.
On Sun, May 6, 2012 at 8:54 PM, Johnny  wrote:

> Hi all,
>
> I have tried for some time to get lookout.el to import my contacts from
> a csv-file into bbdb, but am on the verge of giving up, so before
> finally ditching the attempts (again); Is there *anyone*
> out there that have successfully migrated .csv contacts into bbdb (bbdb
> 3), and how?
>

I have not migrated a CSV, but...

I am about 7-10 days from announcing a two way sync tool for
BBDB/Outlook/Google Contacts, i.e. you can do bi-directional sync between
any two folders across any two different databases. I currently use it to
sync my contacts across Android/Outlook/BBDB, but the whole system is not
in a state where anyone can figure out all the pieces and usefully deploy
it to solve their problems. There's just a bit of typing up the loose ends.

If you are interested in trying out a bleeding edge version of my code, it
is available at: https://github.com/skarra/Gout Documentation is very
incomplete, but if you would like to try this out, we could talk offline
and I can help you get it set up.

Please note I have made an earlier release which only did Outlook <->
Google and hence I called it Gout (for Google-Outlook sync). The f_tasks
branch contains BBDB support. Release v0.2, it will be called ASynK.

Cheers,
Karra
--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/

BBDB 3 and lookout.el (importing .csv file into bbdb contacts)

2012-05-06 Thread Johnny
Hi all,

I have tried for some time to get lookout.el to import my contacts from
a csv-file into bbdb, but am on the verge of giving up, so before
finally ditching the attempts (again); Is there *anyone*
out there that have successfully migrated .csv contacts into bbdb (bbdb
3), and how?


PROBLEM: I have a lot of legacy contacts in outlook, and want to get all
this into BBDB.

TRIED SOLUTION: The best method I have found seems to be to export
from outlook to .csv format and then use lookout.el (which requires
csv.el) to import the csv-file into bbdb. After failing to import the
csv-file generated by outlook, I tried a minimal example to get the
import working as below:

1. Obtain csv.el [1] and lookout.el [2], put these in emacs load path
and include them in init.el.

2. To make lookout read the csv-file, I created a new variable in
init.el and then set the lookout-bbdb-mapping-table to use it.
,
| (defconst lookout-bbdb-mapping-table-outlook-english
|   '(
| ("firstname" "First Name")
| ("lastname" "Last Name")
| ("phones" "Home Phone")
| ("net" "E-mail Addres")
| 
| ("company" "company")
| ("addr1" "addr1")
| ("addr2" "addr2")
| ("addr3" "addr3")
| ("notes" "notes")
| ("otherfields" "otherfields")
| )
| "this is a description of the variable"
| )
`

,
| (setq lookout-bbdb-mapping-table 'lookout-bbdb-mapping-table-outlook-english)
`

3. Creating a dummy file with only one entry below row with field specifiers
,
| First Name,Last Name,Home Phone,E-mail 
Address,company,addr1,addr2,addr3,notes,otherfields
| John,Doe,+1 (555) 555 
555,john@dummy.web,johns_company,johns_addr1,johns_addr2,johns_addr3,johns_notes,johns_otherfields
`

4. Running 'lookout-create-bbdb' from emacs and pointing to this file generates
 the following errormessage 
,
| Wrong number of arguments: #[(record field contents) "Ä=ƒn   
‰ÆH)ƒÇÈ!ˆ;ƒÉÄ\"ʉƒ^
@‰  Ë—(\")Ì)!ƒO   )J>?…T))JBL‚T)CL)ˆ*A‰„%*  
*‰Æ*Iˆ*‚£Í=ƒÞ ‰ÎH)ƒÇÏ!ˆ;ƒ‹ÉÍ\"Ê
‰ƒÎ
@‰
Ë—(\")Ì)!ƒ¿   )J>?…Ä))JBL‚Ä)CL)ˆ*A‰„”*  
*‰Î*Iˆ*‚£Ð=ƒû ‰‰ÑH)C¤*‰Ñ*Iˆ*‚£Ò=ƒ  ‰‰ÓH)C¤*‰Ó*Iˆ*‚£Ô=ƒÏ  
‰ÕH)ƒ+ÇÖ!ˆ;ƒ5ÉÔ\"+ƒtʉƒs
@× ‰…WØ—(\"J)\"‰,ƒkÇÙÚÛ,Ü##ˆ)A‰„C*ʉƒ·
@‰ Ë—(\")Ì)!ƒ¨   )J>?…­))JBL‚­)CL)ˆ*A‰„}*  *-„ÅÝ-
| Õ*Iˆ*‚£Þ=ƒ~  ‰ßH)ƒâÇà!ˆ;ƒìÉÞ\"+ƒ+ʉƒ*
@× ‰…Ø—(\"J)\"‰,ƒ\"ÇáÚÛ,Ü##ˆ)A‰„ú*ʉƒn
@‰ Ë—(\")Ì)!ƒ_   )J>?…d))JBL‚d)CL)ˆ*A‰„4*  
*‰ß*Iˆ*‚£.>ƒž‰âH)žƒ•Çã\"ˆä  #ˆ‚£Çå\"ˆæ   !ˆÊ/ç   !)‡" [field 
record vector contents affix --dolist-tail-- 2 error "Affix field exists 
already" bbdb-split ...] 8 ("/usr/local/share/emacs/bbdb3/bbdb-com.elc" . 
30265) (let* ((_ (bbdb-editable)) (record (or (bbdb-current-record) (error 
"Point not on a record"))) (list (append bbdb-notes-label-list (quote (affix 
organization aka phone address mail (field "") (completion-ignore-case t) 
(present (mapcar (quote car) (bbdb-record-notes record))) init init-f) (if 
(bbdb-record-affix record) (push (quote affix) present)) (if 
(bbdb-record-organization record) (push (quote organization) present)) (if 
(bbdb-record-mail record) (push (quote mail) present)) (if (bbdb-record-aka 
record) (push (quote aka) present)) (dolist (field present) (setq list (remq 
field list))) (setq list (mapcar (quote symbol-name) list)) (while (string= 
field "") (setq field (downcase (completing-read "Insert Field: " list (if 
(member (intern field) present) (error "Field \"%s\" already exists" field)) 
...)], 1
`

5. lookout.el is using a function 'bbdb-add-new-field'  which I cannot
find in bbdb-com.el; could this be related? 


Thanks in advance for any ideas!


Footnotes: 
[1]  http://ulf.epplejasper.de/downloads/csv.el
[2]  http://ulf.epplejasper.de/downloads/lookout.el

-- 
Johnny

--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
___
bbdb-info@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bbdb-info
BBDB Home Page: http://bbdb.sourceforge.net/