Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: SQL string for adding token entry

SQL string for adding token entry 1 Jahr 5 Monate her #92407

  • aukevann
  • aukevanns Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: SQL string for adding token entry 1 Jahr 5 Monate her #92424

  • aukevann
  • aukevanns Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 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?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: SQL string for adding token entry 1 Jahr 5 Monate her #92434

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2569
  • Dank erhalten: 292
  • 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!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Re: SQL string for adding token entry [RESOLVED] 1 Jahr 5 Monate her #92442

  • aukevann
  • aukevanns Avatar
  • OFFLINE
  • Senior Lime
  • Beiträge: 51
  • Karma: 1
aukevann schrieb:
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.146 Sekunden
Donation Image