Buy Now
Sign in

DB Read & CSV Export

sean.regehr , June 04 at 23:18
S
sean.regehr
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
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
S
sean.regehr
Thanks Bob. I look forward to giving that a try.
S
sean.regehr
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
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 :-(
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much