Dec 16, 2025, 2:51:59 PM
|
Sweet Home 3D Forum » List all forums » » Forum: New versions » » » Thread: Sweet Home 3D 6.0 » » » » Post: Re: Sweet Home 3D 6.0 |
Print at Dec 16, 2025, 2:51:59 PM |
| Posted by okh at Sep 28, 2018, 8:33:00 AM |
|
Re: Sweet Home 3D 6.0 1 - CSV export ... Am I doing it the wrong way? Hi Hans, .csv export import is unfortunately always tricky. I tried LibreOffice and Gnumeric too, both under Win, the file with both .tsv and .csv extensions. And I tried my preferred way, just to copy-paste the list from SH3D to a spreadsheet. LibreOffice will import .csv and .tsv (in my case I need to set the import to US English to get , and . interchanged to my standard, locale). LO will not recognise my local non-euro currency, so all currency fields are read as text. Copy-Paste from SH3D to LO gave the same result, but is a lot faster for me. Gnumeric will not separate .csv columns automatically, but will interpret the file correctly if it has a .tsv extension. In this case I do not have to worry about , and . as my Gnumeric installation ignores my locale and sticks with US standard anyway. Copy and paste also works nicely, but again the currency fields are read as texts. However, I am not surprised at this behaviour. As pointed out, the .csv format has limitations (but is also very tidy). And I think SH3D .csv behaves pretty much like all other .csv exports (I frequently import huge .csv files with e.g. meteorological data, outboard engine data / gps-logs). But .csv exports are always a bit of a bother. There is usually some silly string (knots, °C etc.) in the .csv rows that will mess with the import. My remedy for this is usually to go via a text-editor and do a search-replace to fix the characters spreadsheets cannot deal with, and then paste into the sheet. Three-character currency denominations are a special pain as they might appear part of furniture names as well, which means some special attention to the search-replace. Now, I agree that SH3D .csvs are not perfect, but .csvs hardly ever are. And I am not sure it is possible to solve all different issues that may arise with .csv (or actually tab separated files). So instead of changing the .csv format at the risk of creating new problems, it might be better to stick with the simple. Except, there may be a fix for the currency: Either to separate currency to a separate column (i.e. an extra tab between currency and number, but that would not match the format in the furniture list). Or have user defined currency/currencies, so I could remove the currency symbol altogether, and/or use the generic ¤. As I am used to the workaround, the issue does not really bother me, but I took the liberty of putting remove currency symbol / user defined currency in feature requests 890 as that might be of some help. ok |
|
|
Current timezone is GMT Dec 16, 2025, 2:51:59 PM |