[TYPO3-UG US] Typo3 tx-survey_results problem

[Gary Wong]

It would seem to me that deleting the records in List view is easier (at 
least for the non-technical person) than to execute a SQL query, which 
is also dangerous to give them access to.  Not sure if you know this, 
but if you turned on one of the clipboards in List view, you can select 
multiple items and delete them all at once.  It's painless.

If you were planning on executing queries yourself (and only you) on a 
regular basis, then sure go ahead and purge the records using SQL.  You 
could also just set the deleted field to 1 and not really delete them.  
That way they won't show up in the List view but you can always get them 
back.

The best solution is to write a module to export the records and delete.

Good luck!
Gary Wong


On 5/23/12 2:51 PM, Montgomery, Matthew 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