View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004989||SUMo||Bug||public||2018-06-30 15:48||2019-05-18 09:57|
|Target Version||5.9.x||Fixed in Version|
|Summary||0004989: Excel Export Error|
|Description||When I click Export to Table excel opens generated file as common text with one column rather than CSV.|
UTF-8 to be used.
sumo_csv.png (49,936 bytes)
sumo_csv.png (49,936 bytes)
||If you open a CSV file made by another software, do you get different result ?|
Of course. Even given your export I just select column A, copy it to new text file and save it with csv extension. Then open this file and it opens correctly.
P.S. I found what's the problem. You generate file export.csv with UTF-16 LE encoding and Excel don't recognize it as correct csv file.
1. I found that is may be Excel bug and there is a trick to ignore it - use tab separator instead of semicolon -
I confirm that it works for me.
2. You can use UTF-8 instead.
3. Or if you use interop library you can try command Workbooks.OpenText
I couldn't reproduce the described behaviour with SUMO version 220.127.116.115 as I don't have a working copy of Excel installed. As far as I remember Excel, its behaviour with that kind of data should be the same as LibreOffice Calc. And I couldn't reproduce the described behaviour with LibreOffice Calc version 18.104.22.168.
LibreOffice Calc opens an import filter for CSV and asks for configuration of the import filter based on guessed analysis of opened import CSV file. In order to configure the import filter a deeper knowledge of the export table format used by SUMO is needed and NOT yet documented, even not in French. At least I could not yet find it. Where do I find this export format documented which is used by SUMO?
I agree that UTF-8 is preferred character encoding for western languages and alphabets over UTF-16. I'm not aware that CSV supports supplying such an information as opposed XML. You may take a look at the data sets and exports of the network of central banks. They offer export of their data sets in tables in formats CSV and XML. Further I agree that using either the tab character or even better the non-printable field separate character would make the export file even more portable and less error prone. Semi-colon may appear in version information fields and then create problems in the CSV format unless properly quoted by SUMO.
It seems to me appropriate to specify the export format more precisely in the SUMO submenu of tools->export. I recommend using menu text such as "table export in CSV format with separator ';' " instead of only "table file".
With the versions of SUMO and LibreOffice Calc, I could import the SUMO export file almost correctly after reading this issue with the provided details of separator and CSV format. The sole problem appearing is the above mentioned missing quoting.
||It is almost year passed for such easy task. When it will be done?|
||You see the answer to your question. This issue is already scheduled and implementation has not yet begun. All this is expressed by the fields target version and state (of the issue). A look up of the specified target version in the road-map (using road-map button above left) show you a current schedule estimation of mid October 2019.|
||Wolf, who are you? Why you answer to my question instead of author?|
@wolf is a user with a very good understanding of the product and the support workflow.
As he mentionned, the issue is "batched" but not on the next release (but to be implemented in current branch).
|2018-06-30 15:48||demos||New Issue|
|2018-06-30 15:48||demos||File Added: sumo_csv.png|
|2018-07-01 11:39||Kyle_Katarn||Assigned To||=> Kyle_Katarn|
|2018-07-01 11:39||Kyle_Katarn||Status||new => feedback|
|2018-07-01 11:39||Kyle_Katarn||Note Added: 0002980|
|2018-07-01 16:12||demos||Note Added: 0002981|
|2019-04-22 01:06||wolf||Note Added: 0003247|
|2019-04-22 11:49||Kyle_Katarn||Relationship added||related to 0005437|
|2019-04-22 11:50||Kyle_Katarn||Status||feedback => acknowledged|
|2019-04-22 11:50||Kyle_Katarn||Target Version||=> Short term|
|2019-04-22 11:50||Kyle_Katarn||Description Updated||View Revisions|
|2019-04-22 11:51||Kyle_Katarn||Target Version||Short term => 5.9.x|
|2019-04-22 11:53||Kyle_Katarn||Relationship added||related to 0004998|
|2019-04-22 11:53||Kyle_Katarn||Tag Attached: export|
|2019-05-17 07:36||demos||Note Added: 0003321|
|2019-05-17 18:59||wolf||Note Added: 0003328|
|2019-05-18 05:17||demos||Note Added: 0003331|
|2019-05-18 09:57||Kyle_Katarn||Note Added: 0003333|