OESF | ELSI | pdaXrom | OpenZaurus | Zaurus Themes | Community Links | Ibiblio

IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Ka/pi Address Book Migration To Outlook 2003
daniel3000
post Jan 18 2008, 05:24 AM
Post #1





Group: Members
Posts: 1,002
Joined: 28-April 05
From: Germany
Member No.: 7,027



Hello,

what is the easiest and safest way to migrate KA/PI address book data to Outlook 2003?

I have tried CSV export from KA/PI, heavily modified the resulting file in a text editor removing newlines from notes etc., then imported into Excel, saved as Excel sheet, then tried to import the Excel file into Outlook. The last step crashes Outlook!

When I export another CSV from Excel and try to import the CSV into Outlook, the fields are not recognized. All data is redognized to be in the first column (as if one opens a CSV file in Excel via the "file open" menu instead of "Data / Import"...

Is there another way?

I have 450 contacts in my database and have used a lot of the more common fields (home/work addres/phone, company/role information, birthday etc.

Is synchronizing via Sharp DTM safe (i.e. can I be sure that no data is lost or assigned to Outlook fields in a wrong way)? unsure.gif

Thanks a lot

Daniel
Go to the top of the page
 
+Quote Post
tux
post Jan 19 2008, 02:46 PM
Post #2





Group: Members
Posts: 450
Joined: 12-August 03
From: Leeds, UK
Member No.: 346



QUOTE(daniel3000 @ Jan 18 2008, 01:24 PM) *
Hello,

what is the easiest and safest way to migrate KA/PI address book data to Outlook 2003?

I have tried CSV export from KA/PI, heavily modified the resulting file in a text editor removing newlines from notes etc., then imported into Excel, saved as Excel sheet, then tried to import the Excel file into Outlook. The last step crashes Outlook!

When I export another CSV from Excel and try to import the CSV into Outlook, the fields are not recognized. All data is redognized to be in the first column (as if one opens a CSV file in Excel via the "file open" menu instead of "Data / Import"...

Is there another way?

I have 450 contacts in my database and have used a lot of the more common fields (home/work addres/phone, company/role information, birthday etc.

Is synchronizing via Sharp DTM safe (i.e. can I be sure that no data is lost or assigned to Outlook fields in a wrong way)? unsure.gif

Thanks a lot

Daniel

cool.gif It is a while since I have done this so I hope my memory is serving you correctly! smile.gif You should be able to synchronise the Kapi files with the Sharp Address book if the DTM ipk from the kopi/kapi packages has been installed. BACKUP your working Kapi files first! When you get the files into the Sharp Address book you should be able to synchronise with OUTLOOK. I have done this in the past using the built in Kapi/Kopi sync. I have approx 650 records in my address book.

It was rather frustrating though: Be prepared to blank your Kapi files until you work out which is local and which is remote! That is why the backup is essential! rolleyes.gif


The sync from the Sharp address book to Outlook can also be very frustrating. The usb connection can be problematic, I blame Windows here, and Outlook seems to throw random problems into the situation.

There are various pim programs that can import the KAPI/Kopi files easily. They tend to be Linux programs but some of them can successfully export to formats that Outlook can cope with. YMMV.

Good luck.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 26th December 2014 - 09:12 PM