The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: SQL string for adding token entry

SQL string for adding token entry 3 months 1 week ago #92407

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Platinum Donor
  • Posts: 37
  • Karma: 0
Given some of the issues I run into importing CSV files into LimeSurvey I decided to write a Excel Macro for this.
However, my SQL query knowledge is very limited.

Can anybody help me with an example SQL string on how to add a token entry in a token table?

Any help much appreciated.

Regards,
Auke
The administrator has disabled public write access.

Re: SQL string for adding token entry 3 months 1 week ago #92424

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Platinum Donor
  • Posts: 37
  • Karma: 0
Never mind, just found out Excel on the MAC can not write to the MySQL drivers :(
Is there a way to remove posts on this forum?
The administrator has disabled public write access.

Re: SQL string for adding token entry 3 months 1 week ago #92434

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 1973
  • Thank you received: 156
  • Karma: 80
Not sure if a normal user can. But never mind, just put [RESOLVED] or something in the title. Leave it here. It might actually be interesting for someone else that Excel on Mac can do that.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds
If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: SQL string for adding token entry [RESOLVED] 3 months 1 week ago #92442

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Platinum Donor
  • Posts: 37
  • Karma: 0
aukevann wrote:
Given some of the issues I run into importing CSV files into LimeSurvey I decided to write a Excel Macro for this.
However, my SQL query knowledge is very limited.

Can anybody help me with an example SQL string on how to add a token entry in a token table?

Any help much appreciated.

Regards,
Auke
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.183 seconds
Donation Image