Outlook not taking imports
I have a client that has non-domain administrators unable to import CSV or XLS files into their contacts in Outlook while in their Terminal Server session. I am able to take the same files and import them, without fail, as the admin or as a member of the domain administrators group.
Until about 6 weeks ago users were able to import without any challenge. I suspect an update on the Exchange server; but do not know how to vet that information. The Terminal Server is running Server 2008 R2 with Outlook 2003. Exchange is 2007.
Errors:
1. An error has occurred in the Microsoft Excel Translator while getting the contents of a file system.
The Microsoft Excel File <file location on terminal sever> hos no named ranges. Use MS Excel to name the range of data you want to import (click ok to dismiss).
2. A file error has occurred in the translator while trying to establish a filed map.
Unexpected error (53) occurred (click okay to dismiss)
Until about 6 weeks ago users were able to import without any challenge. I suspect an update on the Exchange server; but do not know how to vet that information. The Terminal Server is running Server 2008 R2 with Outlook 2003. Exchange is 2007.
Errors:
1. An error has occurred in the Microsoft Excel Translator while getting the contents of a file system.
The Microsoft Excel File <file location on terminal sever> hos no named ranges. Use MS Excel to name the range of data you want to import (click ok to dismiss).
2. A file error has occurred in the translator while trying to establish a filed map.
Unexpected error (53) occurred (click okay to dismiss)
Last Comment
ASKER
As administrator or a member of the administrators group, in Terminal Server is how we tested the import of the files into Outlook. The mechanics of how the file is imported have not changed. The user goes through the same process to import the contacts into Outlook as before, but this time getting the afore mentioned errors.
You are saying that the permissions have changed on the user so they can no longer import the files into Outlook?
Would a recent terminal server update (server 2008 R2) have made the change.
You are saying that the permissions have changed on the user so they can no longer import the files into Outlook?
Would a recent terminal server update (server 2008 R2) have made the change.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It was not quite as cut and dry as creating new user profiles on the TS. There was a GP issue that prohibited the creation of user profiles, so they were only getting Temp profiles when they logging back in. The GP was pointing to one AD server that did to have the correct GP, so it would not run. The GP were not replicating between the primary and secondary AD servers. I had to clean out the registry of the user.bak registry entries on the terminal server, and then rename the user profiles on the Terminal and AD server that hosted the roaming profiles. Once I did all that, the profiles re-created on the TS and AD servers when the users logged on. I configured Outlook and moved over users file from the .olds I renamed. Only then was the user able to import and map the CSV file.
Exchange
Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.
213K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
When you got it working for yourself, did you do this on your local PC?
Or did you also try it in terminal server?
I Also think the issue may be more related to the Named Range or ODBC settings / setup on the terminal server
http://support.microsoft.com/kb/196743