Welcome, Guest
Username: Password: Remember me

TOPIC: Reloading old answers from a deactivated survey

Reloading old answers from a deactivated survey 1 year 7 months ago #91780

  • hillman
  • hillman's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
Hi!
I'm a long time user of Limesurvey (from the phpsurveyor days!) and really like this software.

Unless I'm wrong, it seems to be impossible to reimport old answers from a modified survey. I needed that option, so I wrote a python script to do this work. It connects directly to the MySQL database and doesn't do any kind of sanity checks. Use at your own risks!

olihb.com/2013/01/13/limesurvey-how-to-i...d-deactivated-table/

Sorry from my broken English, it's not my first language.
The administrator has disabled public write access.

Reloading old answers from a deactivated survey 1 year 6 months ago #92912

  • unluigui
  • unluigui's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
What I do is modify the old survey DB on phpmyadmin, adding blank/dummy columns or deleting them on the "Structure" tab, according to the changes made comparing side by side each DB, then reload the old DB on the limesurvey admin page on the corresponding survey... The only problem I've found doing this is that ID numbers change due to export, but no biggie for me (Still need to find how to avoid this, but later...). Usually this takes me a few minutes to do and I do this often (New ideas pop up unexpectly some times).
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.109 seconds
Donation Image