[TYPO3-UG US] Typo3 tx-survey_results problem

[Michael Cannon]

Matthew,

One alternative is to create a new storage folder for the responses every
few months. This way you can keep them, but not deal with them during
normal exports.

Michael
--
Michael Cannon
The TYPO3 Vagabond <http://typo3vagabond.com/>
Germany +49 (0)160 574 1973 • US +1 617 539 6072

Lifestyl.us <http://lifestyl.us/> • healthy passionate living




On Wed, May 23, 2012 at 9:51 PM, Montgomery, Matthew <
Matthew.Montgomery at wesley.edu> wrote:

> Good afternoon,
>
> I have been working with the installer of our website that is in Typo3 and
> we have a few forms setup on there that use the form storage folders and
> questionnaire menu item.  My concern to the installer was that over time
> these submissions from our users will grow to be quite large and our admins
> that are exporting the form results are becoming very tired of the
> thousands of records to go through to filter out which ones they want.
> It has been proposed that we purge the results every few months so we
> begin with no entries and have a much smaller number of records to work
> with.
>
> The installer of the site said to simply go to the list view and remove
> the results for each form.  This is a very cumbersome process and
> continually ask myself, why would anyone do this? And there has to be a
> better way.  I have phpmyadmin installed on the web server and have direct
> access to the database and I have found the tx_survey_results table.  Why
> can I not just purge those results for all of our forms? We don't need to
> keep that data indefinitely once we export anyway.
>
> I look forward to anyone's response on this, I am dying to get this
> resolve and to have a workable solution.
>
> Thanks
>
> Matthew T. Montgomery
> Network & System Administrator
> Wesley College
> 120 North State Street
> Dover, DE 19901
> United States
> _______________________________________________
> TYPO3-UG-US mailing list
> TYPO3-UG-US at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-us
>