Welcome to the LimeSurvey Community Forum

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

Fields have custom name when stored in database.

  • hakbar
  • hakbar's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago #185766 by hakbar
Fields have custom name when stored in database. was created by hakbar
Hi,

I query from the database.

The fields come back in the format as shown below.

111111X2X9SQ004_SQ003

Is it possible to name these.

For example.

change the name to be Question1.
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 10 months ago #185768 by tpartner
Replied by tpartner on topic Fields have custom name when stored in database.
No, not without major (complete) hacking of the core code.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The following user(s) said Thank You: hakbar
The topic has been locked.
  • gabrieljenik
  • gabrieljenik's Avatar
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
4 years 10 months ago #185773 by gabrieljenik
Replied by gabrieljenik on topic Fields have custom name when stored in database.
Agree. Still, you could create a view for that table. Can you tell more about the use case?
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Checkout our Reporting Solutions and our plugin shop at www.encuesta.biz .

[img
The following user(s) said Thank You: hakbar
The topic has been locked.
  • hakbar
  • hakbar's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago #185776 by hakbar
Replied by hakbar on topic Fields have custom name when stored in database.
I am currently exporting the data from a MYSQL database and creating an xml file.

When I create the tags I use the keys I.e fields names.

This results in me creating an XML file with very confusing tags.

An example of some tags.

<21661X9X24SQ004_SQ001>Y</21661X9X24SQ004_SQ001>
<21661X9X24SQ004_SQ002>Y</21661X9X24SQ004_SQ002>
<21661X9X24SQ004_SQ003></21661X9X24SQ004_SQ003>

Would be useful to be able to name fields, so easier to cross reference.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 10 months ago - 4 years 10 months ago #185783 by DenisChenu
Replied by DenisChenu on topic Fields have custom name when stored in database.
Hi,

2 solutions
1. Use ExpressionManager : gitlab.com/SondagesPro/RemoteControl/rcA...olHandler.php#L49-60
2. Use a plugin helper : gitlab.com/SondagesPro/coreAndTools/getQ...eyCodeHelper.php#L69

You can try the API json export too …
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.
Last edit: 4 years 10 months ago by DenisChenu.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source