simppa80 Posted October 26, 2011 Report Posted October 26, 2011 What I do wrong. Have tryed with designer help topic. Cant get it work. Exel wont save it with commas :( Import says "error in address line 3 ( with txt file) or when try to import csv it made blank table.. Quote
kanweas Posted October 27, 2011 Report Posted October 27, 2011 (edited) Excel 2010 has a nasty habit of replacing commas with semicolon, and remove quotes (") i csv-files. I have not found any setting to correct this, but Openoffice calc, (http://www.openoffice.org/) works, and is free. Edited October 27, 2011 by kanweas Quote
PdL Posted October 27, 2011 Report Posted October 27, 2011 Try setting your regional settings in Windows to English (US), or at least adjust the list separator symbol to comma (,). In most European countries the list separator is not a comma (,) but a semicolon (;). CXD expects to see a file with commas and not semicolons. Quote
rjensen Posted December 2, 2011 Report Posted December 2, 2011 I had the same problem.. My solution is to make one alarm in designer, -> export it, (ascii) -> open with excell -> text to columns -> make the alarms -> and save it. -> it will ask you if you want to keep the old format, to this you have to say yess. if you save it as a new format the old one will be lost. and you are ready to start all over.. This is in excel 2010 Quote
rjensen Posted December 2, 2011 Report Posted December 2, 2011 sorry this didn't work for me neither.. save as unicode.. (txt) and it it works for me. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.