Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Mass import survey

  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 years 4 months ago #209332 by riqcles
Mass import survey was created by riqcles
Hello,
I had to export several hundred questions (1100), on the list of surveys (in lss or lsa).

No problem, you can export several at once (or on several pages).


On the other hand, I had to re-import more than 400 surveys, and they have to be done one part one. :unsure:


Is it possible to develop the same possibility for the import? :)


When you develop the mass export can you also plan a mass import? (not only for surveys , but for other functionalities (ex: models)

Thank you.

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 months ago #209334 by DenisChenu
Replied by DenisChenu on topic Mass import survey
I think the same some time : not for 400, but sometimes, just for 4.

Seems a goof feature request :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 years 4 months ago #209438 by riqcles
Replied by riqcles on topic Mass import survey
Maybe we can do it with RPC-JSON ?

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 months ago #209443 by DenisChenu
Replied by DenisChenu on topic Mass import survey
Yes !!!

api.limesurvey.org/classes/remotecontrol...method_import_survey seems to know LSA

And read a directory + use the functuion i n a foreach loop seems to be «easy»
manual.limesurvey.org/RemoteControl_2_API#Example_and_helper

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
3 years 4 months ago #209449 by jelo
Replied by jelo on topic Mass import survey

riqcles wrote: Is it possible to develop the same possibility for the import? :)

I recommend to submit a feature request and post the link here.
An mass import feature via GUI and API would be fine.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 months ago #209452 by DenisChenu
Replied by DenisChenu on topic Mass import survey
> An mass import feature via GUI and API would be fine.

My opinion :
1. via GUI can be difficult because a lot of server are limited in file size. Then create a system that broke on a lot of server …
2. via API : we already have import oine by one : a loop can easily be done via the API tool

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: riqcles
The topic has been locked.
More
3 years 4 months ago #209454 by jelo
Replied by jelo on topic Mass import survey

DenisChenu wrote: 1. via GUI can be difficult because a lot of server are limited in file size. Then create a system that broke on a lot of server …

If you use server limits and common server configurations as a reason to not implement a feature, the selfhosting edition itself can be abolished.

LimeSuvey needs a filemanager per user, not per theme or survey. There needs to be an abstraction since you cannot allow users to access the real folders. To separate uploading/downloading from the generation process of files is needed to allows autoexports of reports and mass import of files. First upload all LSS via the user filemanager and than import them. That way timeouts and issues can be reduced.

The first simple step would be allow to select a local folder in the GUI to allow mass import Massimport is mostly needed when moving installations. So a simple way to define a local import/export folder would help administrators.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: DenisChenu, riqcles
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 years 4 months ago #209456 by riqcles
Replied by riqcles on topic Mass import survey
Feature is done :
bugs.limesurvey.org/view.php?id=16913

i add something more :
I noticed that when restoring an active survey , which contains backups, the backup table is not updated and users cannot resume the saved quiz.
For this detail, we consider it in the feature request, or do I make a bug?

I had to do this for example to restore access to the user.

INSERT INTO public.lime_saved_control (
scid, sid, srid, identifier, access_code, email, ip, saved_thisstep, status, saved_date, refurl)
VALUES ('10890', '524553', '40', 'FANCHE', 'a6d928652acfc9577b2bd411068f9f3c7693a1537f2433c4bc8326b2230fcf9e', '', '', '5', 'S', '202046', '5', 'S', '202046', '14:51:1 www.limesurvey.fr/index.php/524553?lang=fr ');

But if I take the case of an administrator who does not have access to the database, this action is impossible.
:)

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 months ago #209539 by DenisChenu
Replied by DenisChenu on topic Mass import survey
saved control are not inside LSA : it can be a great improvement .

New (and separate) feature request … it's the Survey Archive system, not API.

Else @jelo : you'r totally right. Sorry :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: riqcles
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 years 4 months ago #209646 by riqcles
Replied by riqcles on topic Mass import survey
Ok i make another feature.

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • riqcles
  • riqcles's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 years 4 months ago #209647 by riqcles
Replied by riqcles on topic Mass import survey

LimeSurvey version 3.22.19
OS : CentOS 7.9 / PHP 7.2.4
BDD : PostGresql 11.x /

Future LimeSurvey version 6.4.1
OS : CentOS 7.9 / RockyLinux / PHP 8.2
BDD : PostGresql 15.x
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 4 months ago #209661 by DenisChenu
Replied by DenisChenu on topic Mass import survey
Via PHP cli and Remote control :

gitlab.com/-/snippets/2051782

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: riqcles
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose