Skip to main content

Translation Error message while exporting/Importing contacts from outlook using csv Format.

Problem:
You may receive a Translation Error message, telling you that a file error occurred in the translator While exporting contacts from Hotmail or Outlook.com website in CSV format and import into Outlook, Note: this error is not limited to CSV files exported from Outlook.com or Hotmail.
Translation Error:
A file error has occurred in the Comma Separated Values translator while initializing a translator to build a field map.
Outlook was unable to retrieve the data from the file "E:\Downloads\WLMContacts.csv". Verify that you have the correct file, that you have permission to open it, and that it is not open in another program.
This is the result of the exported file's Unicode encoding. When the CSV is opened in Excel, all of the comma-separated fields are shown in one cell, not one cell per field. Excel can’t detect the field separators and neither can Outlook.
Note: If you have opened the file in Excel to look at it, close it without saving.
Solution:
Open the CSV file in Notepad and use File, Save as then select ANSI from the Encoding dropdown and Save using the existing file name.
Save CSV using ANSI format
Unicode format causes error
Note:to open using Notepad when Excel is set as the default, right click on the CSV file and choose Open with... from the context menu. Choose Notepad from the menu. If Notepad is not listed, select Choose default program to open the application picker dialog. Deselect the Set as default option from the Choose program dialog before selecting Notepad.

Comments

Popular posts from this blog

Office 2013 Error "Microsoft Word has stopped working".

Problem: Office 2013 Error "Microsoft Word has stopped working". Cause: This issue could in office 2013. 1.) Abby Fine Reader 2.) Graphic Card Driver. 3) Any Third Party Addin. Solution: Method 1: 1) Look for Abbyy Fine reader in control panel. 2)Remove it from the program list. 3)Restart the computer and check the status. If you are not able to remove it update the latest Update for Abbyy Fine Reader from their website. Method 2: 1) Try to disable Graphic adapter from Device manager Locate Device Manager: Right Click on My computer-->Properties -->Device Manager. 2) Open office application. 3)Check the status. Method 3: 1)Open any office application. 2)Open file-->options--Advance. 3)Disable Hardware Acceleration. Method 4: 1)Open Event Viewer by Run Window(Crtl+R) 2) Type eventvwr.msc and look for the office error. 3) Look for faulting module and rename the file from the file location. 4) Open office application and

Setup cannot find office.en-us\dwtrig20.exe during office installation

Problem:  Setup cannot find office.en-us\dwtrig20.exe during office installation Solution: Method 1 : a) Uninstall skype form control panel. b) After installing office, re-install skype. Method 2: a) Browse disk by right clicking on it with mouse. b) Double click on setup.exe file from the same location. Method 3: Note: Take backup of your registry before modifying it.  For registry backup: open "run" >> type "regedit" >> goto "file" >> click on "export" on desktop. a) Edit the registry. HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE Delete the keys (items) you find in the OFFICE folder but not the sub-folders. This removes traces of previous installs to avoid possible conflicts when installing the new version of Office. b)HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE > DELIVERY > SOURCEENGINE > DOWNLOADS Delete the keys (items) you find here.

Error can't display online services while signing into Microsoft Account in office 2013.

Problem: Error can't display online services while signing into Microsoft Account in office 2013. Solution:     Method 1: Open any Office Application, go to File > Account Under "User Information", select Sign Out Restart Windows Open Office Application, go to File > Account > Sign In Method 2: Login into Login.live.com Update your information(Complete profile) Signout from Microsoft Account and Reboot the computer. Try Again.