Home » Forums » Feature requests

Product export decimal separator

Posted August 17th, 2008 by thinkpad

Is it possible add option to select the decimal separator (comma/point) to the product export function?

‹ scaleable product picture - functioning for external link $total_products$ ›

RE: Product export decimal separator

testalentimus1's picture
On August 20th, 2008 testalentimus1 said:

At the moment in product export function the decimal separator is point. The request for having also comma as a separator is added to our request database.

A hint: you should be able to change decimal separator in the excel by using "find&replace" command.

Bruno

re: product export decimal separator

On August 21st, 2008 Anonymous said:

"Find/Replace" is otherwise ok, but when excel (Finnish version) reads numbers with four digits for instance 10.66, it assumes that it is a date and shows loka.66 or 1.10.1966. How to convert that to 10,66 in Excel?

If I try to import the data from Wosbee to excel I can tell excel what is the decimal separator, but then for some reason some records continue on the next row and so the data is incorrect. Probably the problem here is html code in the fields. Solution for this could be the possibility to select the fields you want to export.

When the Wosbee csv-file is opened from excel, data goes to right columns, but numbers are not correctly handled.

Excel ain't the best CSV-file tool

On August 26th, 2008 Anonymous said:

1) Use Openoffice

There you can choose column type in open file stage. You should make all columns as "text".

2) With excel is possible one 'trick'.

- Save product export csv-file for example, "products.cxz"
- Open it
- Now Windows will ask from you, which program you should use to open it. Choose excel
- now excel will give you same kind of column type choosing window as openoffice, use text-type for all columns

With .csv files excel suppose a lot automatically and in most cases a bit wrongly

-taivo