Monitor export is not really CSV

Anmeldedatum: 06.10.2009 Beiträge: 59

It outputs semi-colon ";" instead of Comma "," Separated Values.

It's trivial to fix using any text editor, but in future maybe CSV could really be CSV?

So far I don't think I'll use this function much anyway, since:

Great idea though! Maybe it could be improved a bit, that's all.

Verfasst am: Di Feb 16, 2010 19:00

Zitat:

It outputs semi-colon ";" instead of Comma "," Separated Values.

Both versions are CSV-conform. I did optimize it for Excel 2007. Excel does autodetect only semiclon-values when opening the file directly. If i use , then you have to import the file into Excel with need to tell Excel that , is used. Interesting Detail: Outlook autodetects only , and not ; Wink

Zitat:

it doesn't cover a long enough time interval e.g. 1 hour

Sorry, this is a bug. I planned the Monitor-Graph for 400 Steps which are 30 Minutes. But i forgot to increase tha Max-Value.

Zitat:

it resets when I leave the monitors section

The monitor does block the interface every 5 seconds. It would make problems to run this process in the background the whole time (during sync, filetransfer,...)

Anmeldedatum: 06.10.2009 Beiträge: 59

I think CSV started life as "comma", and that's all that many applications can still open by default, e.g. file associations, e.g. for Office 97/XP/2003, so comma seems safer than semi-colon.

Of course almost anything can be handled by import, so it's not a big problem, but if there's a choice then maybe "," makes sense.

Or are there some cases where "," is already in the data so you prefer ";"? But what if ";" was in the date. How about tab delimited files?

I look forward to the bug fixes.

Verfasst am: Di Feb 16, 2010 21:36

I think you did not understand me. This file will be opened with Excel.
I have installed Office 2007
When i doubleclick a csv-file with ; then Excel shows it correct
When i doubleclick a fcsv-file with , then Excel shows it NOT correct

The , or ; inside the data are never a problem cause all values are quoted.

Anmeldedatum: 06.10.2009 Beiträge: 59

FJ hat Folgendes geschrieben:

I think you did not understand me. This file will be opened with Excel.
I have installed Office 2007
When i doubleclick a csv-file with ; then Excel shows it correct
When i doubleclick a fcsv-file with , then Excel shows it NOT correct

Okay, Office 2007 is really crazy (there's lots of other evidence for that). I just tried it, and Comma doesn't work by default in a *.csv file!!!! You can still use the file open dialogue, and then enable the comma delimiter option in the Text Import Wizard, but you have to do it every time.

The problem is, in older Excel versions only the genuine Comma "," works - it has always worked perfectly for 97/2000/XP/2003 versions. Those versions don't work with semi-colon ";" either! What's more, if the file is called *.csv, then even using the File Open dialogue doesn't help us - no wizard appears because the old Excel knows that only commas are allowed!

So , you can't have one *.csv file that works with both old and new?

Maybe csv should really be csv. 2007 Excel has the file open workaround, and maybe MS will fix this fault, but until then...

The best answer could be to save the CSV as *.txt, then the import wizard and options become available in any version of Excel...

Anmeldedatum: 06.10.2009 Beiträge: 59

or offer csv with "," or ";" choices at export time?

Verfasst am: Mi Feb 17, 2010 10:12

Zitat:

or offer csv with "," or ";" choices at export time?

I don't like a seperate setting for each tiny little thing. Do you know the behavior of Outlook 2010 ?

Anmeldedatum: 06.10.2009 Beiträge: 59

Sorry, I don't have access to Office 2010, but I'm shocked that 2007 gets it so wrong...

Anmeldedatum: 06.10.2009 Beiträge: 59

Reading around it seems that it's a Vista / Windows 7 Excel 2007 problem, not a problem even with Excel 2007 on XP etc. The Excel 2007 I tried was on Windows 7.

Maybe with Vista or 7 and Excel 2007 a lot of people are having problems sharing CSV with co-workers using other systems, because of the inconsistent, locale and O/S specific, handling of ";" and ",''"?

I think that now, since the arrival of Vista, the only safe way is a text file, so the Excel wizard can be used.

http://jstsch.com/post/excel_2007_handling_of_csv_files
http://blogs.msdn.com/michkap/archive/2005/09/17/470413.aspx

Verfasst am: Mi Feb 17, 2010 18:57

Zitat:

I think that now, since the arrival of Vista, the only safe way is a text file, so the Excel wizard can be used.

I don't like this solution. I will install on Win7 to check out if its working there with comma.

Anmeldedatum: 06.10.2009 Beiträge: 59

Summary:

Windows 2000/XP, Excel 97/2000/XP/2003, Default UK settings, at three employers and at home, all work perfectly with "," - it's the standard in the UK, and in the semiconductor business, for datalog files from German colleagues. Cannot open with ";" unless you call it something else (e.g. *.txt and not *.csv) so that the wizard will work.

Windows 7, Excel 2007, Default UK settings - needs ";" for double click, but can now use the wizard even with CSV files, to work with either ";" or ",".

Of course Open Office works as expected, but it lacks the power of Excel.

It's an Excel / Windows problem, but I think it's pushed you in the wrong direction.

Verfasst am: Mi Feb 17, 2010 22:38

f.e. MyPhoneExplorer does autodetect the correct seperator -> both methods work for import.
But how should we handle it for the CSV-Exports now in MPE ?
Does OpenOffice autodetect the seperator ?

Anmeldedatum: 06.10.2009 Beiträge: 59

OpenOffice Calc opens a single page Wizard when opening a CSV or similar.

The wizard defaults to comma "," (at least in my UK locale).
The preview is correct already for true CSV with "," so I can just press [OK]. It's one more step than older Excel flavours, but let's you see better what you're doing.

For not-quite-CSV files (with with semi-colon ";" delimiters) the preview is clearly wrong, but I can just enable the semicolon check box and press [OK].

Verfasst am: Do Feb 18, 2010 11:38

OK, i'll change all CSV-Exports to , in the next version

Anmeldedatum: 06.10.2009 Beiträge: 59

So, with Windows 7, Excel 2007, and default UK regional settings, I tried Save as with various formats:

Using Notepad++ I inspected the saved files and they all:

The only differences are with the line and file terminations...

I repeated the Save As excercise with Excel 2003 on Windows XP, using the same three file type choices.
Again, all three files:

So, from my perspective, comma seperator works perfectly, MS Ofiice or Open Office, old or new... Smile

As mentioned originally though, files with semicolon cause problems , they can't be opened correctly with Excel 2003 and earlier Crying or Very sad

Informationen zum Datenschutz auf dieser Website