Forum


Calc Builder Support

Calc Builder support
Forums
Public write access is disabled. Please login

calculator export csv 13.03.2018 20:10

Hi!

I exported my calculator statistics, but when open it with excel and make Text to columns the separator is comma, but my data contains number with comma and dot two.
E.g: number1 = 10,251.01

So excel make column there two.

Can I export my calculator with semicolon separator?


Thanks,
Zen11t

Re: calculator export csv 14.03.2018 10:01

Hi,
yes, you can change both the separator for fields, and also the 'enclosing' char. This can be done at

JOOMLA/administrator/components/com_calcbuilder/views/stats/tmpl/export.php

about line 17 you'll find:

$csv->set_separate_char ( ',' );
$csv->set_enclose_char ( '' );

You can change the separator char replacing the comma for anything else and/or add any enclosing char that would be added for each field.

Hope this helps, regards
Moonsoft Team
www.moonsoft.es

Re: calculator export csv 04.04.2018 18:57

Nice, thank you very much.

Zen11t
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback