Import error for csv file in outlook

[nida]

Hi,
I have exported my contacts in a csv file , file is created but when i import it into outlook following error message is displayed:

File error has encountered in csv(window) translator while initializing translator to build field map .

But when i open the csv file and save it as in CSV format again , it is imported without any error,

Following is the code to create csv File:

CSVWriter writers = new CSVWriter(new FileWriter("c:\\Contacts.csv"), ',');
writers.writeNext(header);
writers.writeAll(pda.getContacts(login_id), false);
writers.close();
can any one help me?
Thanks.

[OrangeDog]

And what package is CSVWriter in?

[nida]

it's com , r u asking about???

[pbrockway2]

> when i import it into outlook following error message is displayed:

Microsoft plays fast and loose with formats, so it quite possible that opening and saving the file again in whatever their spreadsheet app is called will result in a csv file that Outlook will use without complaining.

Some Java csv libraries (like Ostermiller's) give you an option of saving in a format that Microsoft can understand. But OD is right: you really have to say what package this CSVWriter you are using comes from. It isn't a standard Java class - so unless you say, no-one can know the first thing about it.

[gwachnitz]

Hi,
I have exported my contacts in a csv file , file is created but when i import it into outlook following error message is displayed:

File error has encountered in csv(window) translator while initializing translator to build field map .

But when i open the csv file and save it as in CSV format again , it is imported without any error,

Following is the code to create csv File:

CSVWriter writers = new CSVWriter(new FileWriter("c:\\Contacts.csv"), ',');
writers.writeNext(header);
writers.writeAll(pda.getContacts(login_id), false);
writers.close();
can any one help me?
Thanks.

I had a similar problem, in my case it was that outlook does not understand unis system EOL... so when you build the CSV text make sure to add an \r before the \n after each line.

Hope it helps!!
Germán Wachnitz

[DarrylBurke]

Three year old zombie, locking.

db

THREAD CLOSED