Make it possible to load questionnaire options via the upload of a CSV file

[evilaliv3]

It should be load fields options for checkbox and selectbox from local uploaded CSV files.

It has been already identified that for loading options the file should be simply like

option
option
option
option
option
option

but the fact of referring in the idea to CSV fileds would allow in the future to implement gerarchical options like:

STATE, REGION, CITY
ITALIA, TOSCANA, MASSA
ITALIA, TOSCANA, CARRARA
ITALIA, SICILIA, PALERMO

[creativeanalyst]

Agree #2951 it is related to this. We also need to consider about cascading lookup fields. Here is an example use case mainly for use in US for standardize list of US states, counties and cities and may be zip codes also.

[creativeanalyst]

It will be nice to have admin user documentations, questionnaire sections updated if setting up of lookup type question feature is directly or indirectly implemented and available to use.

[evilaliv3]

I've remodeled the title of the ticket that is going to track the work of integration of this enhancement currently included in #4314

Status of the current implementation:

• At the moment the code has not been tested and no demo has been provided
• From the observed documentation it seems missing the format of the files to be loaded and how they are generated
• It is not clear if internationalization is considered in the implementation

Actions necessary to possibly integrate same functionality:

• Validate the implementation verifying which is the format and that the format is adequate to simplify the user loading that by ticket idea is intended to simplify the operation of loading questions.
• Validate the implementation verifying which is the behavior if the user has already loaded some options or if the user change language going to configure the translations for loaded options
• Implement client or unit tests for the feature to guarantee appropriate code coverage that could be achieved by editing the existing tests and loading the file to load the options on a question of type select box