TOPIC:

Hello Thiana,
The variable to be displayed in the csv file, I assume that is $ result,
and it is necessary to add it in recordmanagement.class.php so that it appears in the file generated by csv export.
Is it so?

Hello,

'The variable to be displayed in the csv file, I assume that is $ result,' --> Yes

you do not need to add anything, only to do as is explained in the example and everything should be working perfectly.

Best regards!
Mirko Antunović

Hello ,
I have implemented as you have told me. As a result I receive the total number, without specifying what is the count of each of the options selected in the form.



The result of value.php in my case only shows the number 159, which is the total number of times the form has been completed

Hello,

thank you for your feedback!
Please give me a little time to investigate the best solution, I back as soon as possible!
Thank you for your patience!

regards!
Mirko

Hello Mirko,

Using the php code that you have provided me, I see that I get the desired result like this:

<?php
define( '_JEXEC', 1 );
define( 'JPATH_BASE', realpath(dirname(__FILE__).'/' ));
require_once ( JPATH_BASE .'/includes/defines.php' );
require_once ( JPATH_BASE .'/includes/framework.php' );

$db = JFactory::getDBO();
$db->setQuery('Select Count(*) From #__facileforms_subrecords Where name="comonoshasconocido" and value LIKE "Otros"');
$otros = $db->loadResult()+1;

$db = JFactory::getDBO();
$db->setQuery('Select Count(*) From #__facileforms_subrecords Where name="comonoshasconocido" and value LIKE "A través de amistades"');
$amistades = $db->loadResult()+1;

$db = JFactory::getDBO();
$db->setQuery('Select Count(*) From #__facileforms_subrecords Where name="comonoshasconocido" and value LIKE "A través de la UPL"');
$upl = $db->loadResult()+1;

$db = JFactory::getDBO();
$db->setQuery('Select Count(*) From #__facileforms_subrecords Where name="comonoshasconocido" and value LIKE "A través de las redes sociales / Internet"');
$internet = $db->loadResult()+1;

$db = JFactory::getDBO();
$db->setQuery('Select Count(*) From #__facileforms_subrecords Where name="comonoshasconocido" and value LIKE "A través de personas de organización y ponentes"');
$organizacion = $db->loadResult()+1;

echo ('Otros: '); echo json_encode($otros)."</br>";
echo ('A través de amistades: '); echo json_encode($amistades)."</br>";
echo ('A través de la UPL: '); echo json_encode($upl)."</br>";
echo ('A través de las redes sociales / Internet: '); echo json_encode($internet)."</br>";
echo ('A través de personas de organización y ponentes: '); echo json_encode($organizacion);

?>

Being "comonoshasconocido" the name of the element and "Otros" the value of the option marked in the Check box.


I hope you can help me to tthis values to be displayed in the file generated by csv expot, i can't get it.

Greetings and thanks for your patience

Hi,

basically, the radio button and checkbox group takes values as a whole, and this is the reason why the same value is obtained during the calculation.
Currently, we are working on this (especially Mirko), and we will get back to you soon

Regards,
Tihana