Forums

DB Read & CSV Export

sean.regehr 04 Jun, 2018
After DB Read conditions are successfully executed, the results when Exporting to CSV are including all table records and not only the filtered records by conditions.

Steps I took:
  1. I have made a simple form to Generate a Report from saved data in a table. Two fields; `Date` & `Location`.
  2. The form works as expected.
  3. The form optionally executes a Condition on the DB Read by providing a `Location` and/or `Date` (yyyy-mm-dd) successfully.
  4. I used a Debug action to verify the Results are correctly filtering by the conditions successfully.
I am not sure what is causing this issue and there are no immediate actions to edit to correct this. I suppose a custom piece of code may be necessary to sort this out but am not certain.

All of the DB Read data is being saved to Data4 model and the same model is set in the CSV Export action.

Let me know if I can provide any more information that will be useful for troubleshooting.

Thanks for looking into this.
GreyHead 05 Jun, 2018
Hi sean.regehr,

I am sending you a PM with a link to my custom CSV Export [GH] action which gives you more control over the records and columns exported.

Bob
sean.regehr 05 Jun, 2018
Thanks Bob. I look forward to giving that a try.
sean.regehr 05 Jun, 2018
Bob,

I have not received any PM from you as of yet.

Can you confirm if you have sent the PM already or provide a rough ETA of when to expect it will be made available?
GreyHead 06 Jun, 2018
Hi Sean,

Not sure what I did there - re-sent just now.

Bob

PS I found out - I wrote it but never added the link and left it un-sent :-(
HerKle 04 Jun, 2019
Hi,
I just run into the same problem: wanted to export the subscribers of a newsletter, which are shown properly in html, but receive a list of all registered users when using csv export. Is the recommended [GH] action still available?
Thx,
Herbert
healyhatman 05 Jun, 2019
[edited] Misread the request, never mind.

Are you using V5, HerKle? Or V6?
This topic is locked and no more replies can be posted.