The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:
Passwort vergessen? Benutzername vergessen?
  • Seite:
  • 1

THEMA: SQL string for adding token entry

SQL string for adding token entry 3 Monate 2 Wochen her #92407

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

Re: SQL string for adding token entry 3 Monate 2 Wochen her #92424

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

Re: SQL string for adding token entry 3 Monate 2 Wochen her #92434

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

Re: SQL string for adding token entry [RESOLVED] 3 Monate 2 Wochen her #92442

  • aukevann
  • aukevanns Avatar
  • OFFLINE
  • Platinum Donor
  • Beiträge: 37
  • Karma: 0
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.
  • Seite:
  • 1
Moderatoren: DenisChenu, ITEd
Ladezeit der Seite: 0.166 Sekunden
Donation Image