vi-solutions
Software + Internet

Joomla 5 Notice

We are pleased to announce that as of January 29, 2024, all of our Joomla extensions are compatible with Joomla 5.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is now a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5!

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

Export Data problem

More
5 years 11 months ago #5892 by trail
Export Data problem was created by trail
Hi ,
When i export data, iam getting a blank CSV file.
Any suggestion?

More
5 years 11 months ago #5894 by Administrator AV
Replied by Administrator AV on topic 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
:idea: 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 :-).

:idea: 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 :-).

Moderators: Administrator AV, Administrator IV
Powered by Kunena Forum

Visforms Subscription

Visforms Extensions

Useful extensions for Visforms which enable you to integrate your forms perfectly into your website and to perform special tasks which turn Visforms into much more than just a form generator.

Info