Welcome!

Welcome to the Official BlackBerry Support Community Forums. This is your resource to discuss support topics with your peers, and learn from each other. New to the forum? Please visit the ‘Getting Started’ link below.
inside custom component

BlackBerry® Tour™

Reply
Visitor
tkessler2
Posts: 1
Registered: ‎01-06-2010
My Carrier: IUSACELL

Transferring or Importing Contacts from CSV file 0x80040057 error - How to fix

[ Edited ]

 

 

I recently transferred my Nokia E65 address book to my new Blackberry Tour 9630 through Intellisync. It was an arduous process. Transferring via Outlook or Google may work - but you can end up with missing fields - corrupted data, etc;  many don't want to install those apps just to use that function.


If you can get your contacts from your originating phone into a CSV file, you can manipulate them in a spreadsheet. Then you can use the ASCII importer to get them  into the BB. Here are the tricks:

1) The CSV file format must include both a comma and a delimiter (usually a quote mark)  around each field unconditionally. MS Excel 2002 will not write a CSV file this way. I was able to use Open Office Calc spreadsheet program, which writes the format flavor Intellisync needs. Other CSV editors may work too.

2) The ASCII Importer will ignore a CSV file with a trailing CR/LF sequence.  To fix, use a free hex file editor, like Frhed, to remove the last two bytes (x0D, x0F) before you import .

So here is the procedure:

1) Create a dummy contact entry in your BB with all the fields used and export it to a CSV file on your PC. This will give you a reference file with the field names your BB  may use. Most of these names are also in the  ASCII importer help file, but the best reference is your BB itself.

2) Note some fields, even though they exist, do not transfer. My User Defined 1-4 fields exist on my BB  and in the reference file, but do not export in nor out. Address3, Mobile Phone 2, and Home Fax all exist in the ref file, but not on the BB. To figure out what transfers and what doesn't for your BB, create a fully populated test entry on both device and PC. syncronize each, and look carefully at what transfers.

3) Load the originating phone CSV file into the spreadsheet on another tab. Compare the field names from your originating phone to your BB field names. In my case, my Nokia had Spanish names and my BB English...
You'll need to figure out how to map each of your originating field names to a BB column.

4) Carefully replace the data columns of the CSV reference file you pulled from the BB, with the data from your original handset, making sure you conserve the  BB field headers. You may have to consolidate data from multiple columns on your original phone data into one column on your BB data. Be careful not to put data in a column that doesn't transfer, like "Mobile Phone 2".

5) Save the edited CSV file from Open Office or other editor, then open it with the hex editor and delete the last CR/LF (x0D, x0A) bytes, then save again. The file is now ready to import into your BB.

6) Configure your synchronization settings to use your newly created file and replace the contact data in your BB

Final note: be careful about extraneous quote marks or other characters in your field data that can corrupt the import process.

Please use plain text.
JSanders
Posts: 67,258
Topics: 486
Likes: 20,541
Solutions: 5,276
Registered: ‎04-01-2008
My Carrier: Verizon • AT&T

Re: Transferring or Importing Contacts from CSV file 0x80040057 error - How to fix

Excellent post, thanks for the detailed walk-through.


1. If any post helps you please click the Like Button below the post(s) that helped you.
2. Please resolve your thread by marking the post "Solution?" which solved it for you!
3. Install free BlackBerry Protect today for backups of contacts and data.

Please use plain text.
Guru III
knottyrope
Posts: 26,485
Registered: ‎06-25-2008
My Carrier:

I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Transferring or Importing Contacts from CSV file 0x80040057 error - How to fix

Great job!

 

Hope you can make some more solutions like this again.



Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info. SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope

No Sleep Till BlackBerry 10, A BlackBerry Song by Lil E Click here to listen

See me at BlackBerry Fans Get Hands-On BlackBerry 10 Demo

Want to thank me? Buy my KnottyRope App here

Please use plain text.
Contributor
BigDan1
Posts: 23
Registered: ‎10-02-2011
My Carrier: WIND

Re: Transferring or Importing Contacts from CSV file 0x80040057 error - How to fix

thanks for this. im also getting an error message. i'll try your solution.

questions
1/ how do i export a csv file? the only export i've been able to do has been into an IPD file.
2/ what exactly is intellisync? i searched for it and didnt see any software hits, i thought it'd be something i could download. if it is, can you give me a link?
Please use plain text.