Forums

Hi,
​
We have a form on a site that is using the CSV Export option (which we've gotten working with Greyhead's help), but now we've seem to hit another problem.
​
When exporting to the csv, the csv itself won't go any further than 200 records. This seems to be a limitation within Chronoforms itself and not on the server side of things.
​
Is there a way that we can work around this? We don't need to necessarily save to the same file, but I've noticed that when attempting to save to a different csv file (even with records from a different database table) it won't go over that 200 record limit.
​
Any assistance you could provide would be appreciated.

Hi directivemsp ,
​
I don't know of any specific limit at 200 records but you can sometimes hit server limits when trying to work with large tables. A few years ago I solved something similar in an earlier version of CF by running a loop that read say 100 records, added them to a CSV file on the server, then read the next 100 records until everything was exported and saved.
​
Bob

That sounds like it might be a viable option for our problem. How would we get that setup, exactly? I assume it would be some configuration of the DB Read action.

Hi directivemsp,
​
I took a quick look in my files and can't immediately see the code I used. I think that it was done in Custom PHP rather than DB Read actions. Before I go hunt further I wondered if a simpler solution might be for you to try the Excel Plugin that is available from MySQL. If you are looking to import into Excel and your database allows remote access that might be better all round???
​
Bob

The client in question is requesting specifically that the data gathered be sent into a CSV, so for the sake of the client being happy, I'm not entirely sure that the Excel plugin would be our solution.
​
Would I be able to send you login credentials to have a poke around the site to get a better idea of what our options are?

Hi directivemsp,
​
Does the client want *all* of the data - every time the form is submitted, once a day, on request? Hard to see the logic some times.
​
By all means PM me the site URL, the form name, and a SuperAdmin login and I'll take a quick look, but not sure that I will find anything.
​
Bob