Export as csv with calculated fields

A place for users and developers of the Xataface to discuss and receive support.

Export as csv with calculated fields

Postby jvinolas » Tue Jan 18, 2011 1:24 am

Hi,

I managed to get calculated field on export_csv action. My problem is that I can't get the calculated field as a number in Calc. If I make the format with __display as 1.234,56 (using number_format()), it adds a ' in the beginning as '1.234,56, so it gets as text field. If I leave it on default number format (1234.56), then it doesn't add the ' but Calc doesn't let me change it to a number format as it does recognize the , as decimal pointer, not the dot.

Do you know how to correctly export a calculated field as a number?

Thanks in advance.
jvinolas
 
Posts: 51
Joined: Thu Apr 15, 2010 12:31 am

Re: Export as csv with calculated fields

Postby shannah » Fri Jan 21, 2011 10:16 am

This sounds like a bug somewhere. I don't think I've explicitly set it to add a ' for any values in exporting CSV. Can you show me a sample csv exported row?

What version of Xataface/PHP/MySql are you using?

-Steve
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Export as csv with calculated fields

Postby jvinolas » Tue Jan 25, 2011 1:50 am

Hi,

Sorry, my mistake in export csv. It is working perfectly.

Thanks.
jvinolas
 
Posts: 51
Joined: Thu Apr 15, 2010 12:31 am


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 24 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved