LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 11-20-2010, 04:56 PM   #1
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Rep: Reputation: 0
Angry Evolution Address book import from Thunderbird - mapping problem!


This has been driving me absolutely nuts. I'm about to throw something but I won't because it's all too expensive I'm trying to import my old Thunderbird address books into Evolution 2.28.3. I've exported them as .ldif files. When imported into Evo, certain fields go missing. These include First Name and Street Address details. Kind of important, huh? I also tried exporting and importing in CSV format. Whoa! Big mistake; the fields were screwed-up even worse. What gives? Why does this have to be so incredibly difficult??? Does anybody have any suggestions? Please bear in mind that although I've been playing from the Command Line, I'm still a relative newbie and would cetainly appreciate some hand-holding. Thanks in advance.
 
Old 11-20-2010, 05:06 PM   #2
impert
Member
 
Registered: Feb 2009
Posts: 282

Rep: Reputation: 53
Quote:
This has been driving me absolutely nuts.
It did to me to. I gave up and typed everything in manually. Only took three nights - I don't have many friends. Now I'm considering going back to Thunderbird - but there's one thing holding me back: the address book.
 
Old 11-20-2010, 05:32 PM   #3
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Original Poster
Rep: Reputation: 0
Partial Salvation

Too many damn trees for the forest. I discovered my problem: During Evo's import process, one is given a choice of which CSV format one wishes to import. Yes, yes, there is only one format but, there are a couple of choices. I chose "Mozilla". This apparently lets Evo choose the proper mapping. Slick. I would have preferred to import .ldif files since I *think* that this format may allow contact photos to also be imported (yes/no?). However, this format is still fraught with holes since certain fields are left behind (I know because I opened one of the .ldif files with gedit and verified that all of the data were in fact, there)
 
Old 11-20-2010, 10:44 PM   #4
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Original Poster
Rep: Reputation: 0
Red face Evo CSV import. What's the hang-up??

I've given up on trying to import my Tbird address books as .ldif files. My first file imported as a (mozilla format!) csv was a tiny 28kb file which imported within seconds. I have 2 additional books that are close to 2 MB each. It's been a few hours since I started to import the first. Is this normal? Is there a way to do this faster? The original .ldif imports of these two large files was very fast (albeit important details went missing).
 
Old 11-21-2010, 06:22 AM   #5
impert
Member
 
Registered: Feb 2009
Posts: 282

Rep: Reputation: 53
I wish I could help. If you succeed, here's a bonus question: how to you get either thunderbird or evolution to print out the names and phone numbers of your contacts in a form that you can leave beside the telephone? Exporting to an Oo spreadsheet would be nice.
 
Old 11-21-2010, 08:44 AM   #6
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Original Poster
Rep: Reputation: 0
Talking

Quote:
Originally Posted by impert View Post
... how to you get either thunderbird or evolution to print out the names and phone numbers ....
Ah, ha: A question which I can answer! Simply highlight the Address Book of your choice, select File and then, select Print. Can't be any easier! Oh wait, yes it can: Select your address book and then, hit CTRL P. Now, if I could only get my Tbird address books to import properly...
 
Old 11-21-2010, 04:48 PM   #7
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Original Poster
Rep: Reputation: 0
Unhappy Evo csv import : Limited by large file size?

As mentioned earlier, my small csv import worked like a charm. However, it didn't turn out so good with the bigger file. Once the data finally finished importing, the resultant field population was a big cluster f@#k.
I found an old script that apparently takes Tbird tab-delineated files and converts them into Evo-friendly vcards. I was able to run the script and obtain a resultant file. Not sure if Evo will bite, though. I'm about to try it now...

Last edited by heviiguy; 11-21-2010 at 04:50 PM. Reason: additional comment
 
Old 11-21-2010, 06:41 PM   #8
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Original Poster
Rep: Reputation: 0
The script didn't work properly either. The result was corrupt.

Next on the agenda is to re-export the TBird Address Books in CSV format and open them in OpenOffice to check their structure. If all is well, I'm going to make a dummy contact in Evo, export it in CSV format and open it in Open Office to see its header structure. Then, I'll change the headers in the TBird CSV files to correspond with those in the Evo file. Probably have to do a few concatenations but, that will be the least of my concerns. The next step should be obvious; I'll import the cleaned-up CSV files into Evo. Hopefully by then, Bob will be my uncle.
 
Old 11-22-2010, 07:57 AM   #9
heviiguy
LQ Newbie
 
Registered: Jul 2010
Distribution: Ubuntu 10.04
Posts: 19

Original Poster
Rep: Reputation: 0
Cool Eureka

An utter pain, this was. However, all seems to be well now.

Lessons learned:
  • Ensure that one's data is good
    • trying to convert garbage to treasure is fruitless
  • Read the dialogue boxes carefully
    • select the proper format!
  • Patiently wait for large imports to complete (ie, leave the damn box alone until the resource meter indicates that it has finished!)

Whereas the .ldif import from T'bird to Evo is almost useless (unless one can live without crucial data), the CSV import does, in fact, seem to work. My initial CSV files were somehow corrupted. When I tried to import them, of course, the garbage came along with it. Converting these files to a different format in an attempt to clean them up obvioulsy doesn't work either.

In the end, I simply returned to my T'bird backup and started the export process once again, this time being very careful. Lo and behold, it worked. Today, Bob is indeed my uncle.
 
Old 11-22-2010, 12:31 PM   #10
impert
Member
 
Registered: Feb 2009
Posts: 282

Rep: Reputation: 53
Good to hear you got it sorted out.
Quote:
Simply highlight the Address Book of your choice, select File and then, select Print.
I'm pretty sure that's what I did (it was a while ago). Only trouble was all the longer nos got truncated - there seemed to be a fixed field length that was too short. Anyway, I'm not worried about it now.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
import address book in ldap prashantbhushan Linux - Networking 0 01-24-2007 05:51 AM
Gnome evolution import address book from old version stefane321 Linux - Software 1 10-23-2006 08:37 AM
How to automatically add an address to the address book in Thunderbird royeo Linux - Newbie 2 09-04-2006 03:51 PM
How do import evolution address book into kmail ? coolamit78 Linux - Software 3 10-04-2004 08:35 AM
import address book from outlook to mozilla ?? georges Linux - Software 1 08-17-2004 04:39 PM


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

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