Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Expression Manager: Nested Equations?

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #90521

  • Mazi
  • Portrait de Mazi
  • Hors ligne
  • LimeSurvey Team
  • Messages : 5333
  • Remerciements reçus 296
  • Karma: 249
Fred écrit:
Maybe in a future version all this masking and formatting will be baked in and a lot easier to use.
At Limesurvey 2.1 there will also be a thousand separator available. So when you set the decimal separator to "." (US number format), the thousands separator will automatically be set to "," and vice versa.

This is implemented for the numeric question types to make large numbers easier to read when inputting them.
I'm not sure if this might cause any conflicts e. g. when using EM because only the number display is adjusted while the actual storing of the value should not have changed, but if someone notices any problems, please file a bug report and post the link to the report here.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #90523

  • Fred
  • Portrait de Fred
  • Hors ligne
  • Gold Lime
  • Messages : 163
  • Remerciements reçus 5
  • Karma: 3
Mazi wrote
At Limesurvey 2.1 there will also be a thousand separator available. So when you set the decimal separator to "." (US number format), the thousands separator will automatically be set to "," and vice versa.

Yes, Denis told me a little about that. Hopefully it will work on Inputs so we don't have to do all this custom JS masking. And it can work equivalently in Expressions just for display but without saving to the database. It would be nice if we could get prefix/suffix into Equations somehow as well. I use them for $ and % signs.

This business of having to create two questions for everything is not very user-friendly for typical survey creator

What is the roadmap for 2.1 anyway? I keep hearing about it, but there's not much on the site. Maybe this could use an update :)
docs.limesurvey.org/LimeSurvey+roadmap&highlight=2.1
L'administrateur a désactivé l'accès en écriture pour le public.

Aw: Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #90524

  • Mazi
  • Portrait de Mazi
  • Hors ligne
  • LimeSurvey Team
  • Messages : 5333
  • Remerciements reçus 296
  • Karma: 249
Fred écrit:
This business of having to create two questions for everything is not very user-friendly for typical survey creator

What is the roadmap for 2.1 anyway? I keep hearing about it, but there's not much on the site. Maybe this could use an update :)
docs.limesurvey.org/LimeSurvey+roadmap&highlight=2.1

I totally agree that the two question solution is not the best case, but most surveys are not that complex and thus you can use the assessment feature for most of the simple stuff.

Nevertheless, if you have a good idea on how we can easily mass-add equations to Limesurvey questions, please write a proposal we can discuss.

As for the roadmap: A first Limesurvey 2.1 alpha release is planned for end of January. As so often, my guess would be that it will be February for a first version and maybe April/May for the stable release (just guessing).

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
L'administrateur a désactivé l'accès en écriture pour le public.

Aw: Expression Manager: Nested Equations? il y a 1 an 9 mois #90526

  • Fred
  • Portrait de Fred
  • Hors ligne
  • Gold Lime
  • Messages : 163
  • Remerciements reçus 5
  • Karma: 3
Yes, not the best.. BUT it does work! (Thank you Tom)

Mazi, if you click on my karma button so that it will finally go above zero, then I will think about this equations issue!
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Aw: Expression Manager: Nested Equations? il y a 1 an 9 mois #90527

  • Mazi
  • Portrait de Mazi
  • Hors ligne
  • LimeSurvey Team
  • Messages : 5333
  • Remerciements reçus 296
  • Karma: 249
:-)

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #90558

  • DenisChenu
  • Portrait de DenisChenu
  • Hors ligne
  • Moderator Lime
  • Messages : 6451
  • Remerciements reçus 844
  • Karma: 249
Mazi écrit:
This is implemented for the numeric question types to make large numbers easier to read when inputting them.
Hello Marcel,

I look at 2.1 code, and don't see this system, and EM function are var numRegex = new RegExp('[^-' + LEMradix + '0-9]','g'); : no thousand seperator here .

Are you sure it's in 2.1 actually ?

Denis
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #90563

  • Mazi
  • Portrait de Mazi
  • Hors ligne
  • LimeSurvey Team
  • Messages : 5333
  • Remerciements reçus 296
  • Karma: 249
Hi Denis,

this should be in 2.1 already. Please contact Sam about the details, he has coded that.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #91266

  • Fred
  • Portrait de Fred
  • Hors ligne
  • Gold Lime
  • Messages : 163
  • Remerciements reçus 5
  • Karma: 3
A follow up to one of my earlier comments. I said a couple of weeks ago...
This survey actually has over 500 of these equations, and now we are doubling the number of questions. Although the display questions don't create a column in the survey_NNN table at least. It's a good thing I am using Excel and your awesome Excel importer to create all the questions.

Actually I discovered that LS actually DOES create a column in the survey responses table for Text Display (Boilerplate) questions. This may have been introduced between 1.91 and 1.92 according to Denis? It's only varchar(1) so fortunately it doesn't take up too much room. But if you have a large survey, you may want to factor this into your estimates:
docs.limesurvey.org/General+FAQ#regarding_survey_size

It does seem a little silly to have all these empty columns in the responses. Usually sparseness is a quality you want to avoid in DB. But if Thomas White did this, I'm sure there was an excellent reason!
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #91267

  • TMSWhite
  • Portrait de TMSWhite
  • Hors ligne
  • LimeSurvey Team
  • Messages : 759
  • Remerciements reçus 82
  • Karma: 36
As far as I remember, 1.91 did also create a varchar(1) for each boilerplate question even though it could never contain anything. I left it in for backwards compatability.

However, I'd vote to remove those columns in version 2.1

/Tom
L'administrateur a désactivé l'accès en écriture pour le public.

Re: Expression Manager: Nested Equations? il y a 1 an 9 mois #91269

  • Fred
  • Portrait de Fred
  • Hors ligne
  • Gold Lime
  • Messages : 163
  • Remerciements reçus 5
  • Karma: 3
Fortunately, for the big survey I was working on, even with the extra overhead of many text display questions for equation formatting, everything worked out great so far.

I built everything in Excel, coding all the expressions using Excel formulas, concatenate, etc. There are probably 1000 expressions including equations and relevance. This took a few weeks. Then I imported it using the Tab-delimited Text import utility. The import and table build took about 2 seconds and worked perfectly. And I can run through the survey without crashing, too :)

There is absolutely no way this could have been done without Expression Manager and the Text importer!

1744 rows in text import file
1558 columns in Survey_NNN table
Question groups: 35
Questions: 1494
Answers: 102
Subquestions: 60
Question attributes: 4145

The MySQL table schema has this data, but I'm not sure how to interpret. The data length sounds too little and the max length sounds too big?

AVG_ROW_LENGTH 2468
DATA_LENGTH 2468
MAX_DATA_LENGTH 281,474,976,710,655
INDEX_LENGTH 12288
L'administrateur a désactivé l'accès en écriture pour le public.
Cet utilisateur a été remercié pour son message par: TMSWhite
Modérateurs: ITEd
Temps de génération de la page : 0.155 secondes
Donation Image