Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Connect » "bug" in export
  •  
willoneal

Messages: 173
Karma: 11
Send a private message to this user
Ok, this isn't really a bug, but it is now a problem.

When you export the users list from Connect, it does a fine job of exporting all the users, and calling it a CSV file.

The exported file name ends in .csv

Only problem is it's not a CSV file. CSV stands for Comma Separated Values.

In the exported file, the separator is a semi-colon.

Which really messes with excel 2016.

The file doesn't import correctly until you change the name to .txt, and only then can you tell it the separator is a semi-colon.

Otherwise, it imports the file expecting to find commas between the values.

So, in 8.5.2, can we either get a txt file exported, or change the delimiter to a comma?

It would reduce my headache in trying to figure out why Excel 2016 won't import the exported Connect user list.
  •  
Ernesto (Kerio)

Messages: 86
Karma: 7
Send a private message to this user
Hi Will,

The file format used to export users and other data is more CSV/DSV than just CSV. DSV stands for Decimal Separator Value. CSV/DSV format is more common in Europe than in the US.

There is no formal specification (RFC, etc) for csv file formats. Typically both characters are accepted "," and ";" by most applications. This maybe just a configuration issue with MS Excel. I'll test it and let you know.

Sales Engineer | Kerio
Stay Connected Anytime, Anywhere. Discover Kerio Cloud!
Previous Topic: Kerio client uses much disk space
Next Topic: Shared Events on Shared Calendar...
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Sun May 28 16:39:43 CEST 2017

Total time taken to generate the page: 0.00844 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.