Welcome, Guest
Username: Password: Remember me

TOPIC: SQL string for adding token entry

SQL string for adding token entry 1 year 5 months ago #92407

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 51
  • Karma: 1
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 1 year 5 months ago #92424

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 51
  • Karma: 1
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 1 year 5 months ago #92434

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2568
  • Thank you received: 291
  • Karma: 106
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] 1 year 5 months ago #92442

  • aukevann
  • aukevann's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 51
  • Karma: 1
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.
Moderators: ITEd
Time to create page: 0.099 seconds
Donation Image