Export Data problem

trail
Autor
Offline

Mehr

6 Jahre 4 Wochen her #5892 von trail

Export Data problem wurde erstellt von trail

Hi ,
When i export data, iam getting a blank CSV file.
Any suggestion?

Administrator AV
Offline

Mehr

6 Jahre 3 Wochen her #5894 von Administrator AV

Administrator AV antwortete auf Export Data problem - Bug in Visforms 3.12.3 beta

Hi,
i guess you are using Visforms 3.12.3 beta

I just learned a few days ago, that there is a bug with the data export in Visforms 3.12.3 beta. I have already fixed it and it will be released with the next Visforms release.

The bug is easy to fix, because only 3 lines of code in one file are involved.

Open the file administrator\components\com_visforms\models\visdatas.php

Replace the code at line 408 - 410

Code:

$where = ' and c.includefieldonexport = 1';
$where .= (!(empty($params->exppublishfieldsonly))) ? ' and c.published = 1' : ''; 
$where .= " and c.typefield NOT in('submit', 'image', 'reset', 'fieldsep', 'pagebreak')";

with

Code:

$where = ' includefieldonexport = 1';
$where .= (!(empty($params->exppublishfieldsonly))) ? ' and published = 1' : '';
$where .= " and typefield NOT in('submit', 'image', 'reset', 'fieldsep', 'pagebreak')";

This should fix the problem.

If you are not using Visforms 3.12.3 beta, maybe you have not set up the export properly (record sets are not published and you have enabled the export option "published records only" or something like that). In this case please check out the documentation in order to set up the export properly: vi-solutions.de/en/documentations/visfor...rms/314-save-results

Regards,
Aicha

I recommend you the new and up-to-date documentation for Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-)

Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-)

Moderatoren: Administrator AV, Administrator IV

Joomla 5 Mitteilung

Forum

Export Data problem

Visforms Subscription

Visforms Erweiterungen