[TYPO3-UG US] Typo3 tx-survey_results problem

[Gary Wong]

That's a great idea, Michael.

Matthew, it's probably something you can teach your admins who does the 
exporting to do - creating new folder and changing the form's storage 
submission folders after they export.

Gary

On 5/25/2012 7:33 AM, Michael Cannon wrote:
> 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
>>
> _______________________________________________
> TYPO3-UG-US mailing list
> TYPO3-UG-US at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-us