Welcome to the LimeSurvey Community Forum

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

Import and long attribute fields

  • aukevann
  • aukevann's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 1 month ago #92265 by aukevann
Import and long attribute fields was created by aukevann
Standard the attribute fields in LimeSurvey are 255 characters.
For one of our attributes this is too short and I manually change it in the SQL database to 1024.
However, when I import a list of tokens into the token table, using CSV files, it cuts off after about 300 characters. Does anybody know a way around this, I can manually add the content to this attribute but it is too much work.

Regards,
Auke
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 1 month ago #92300 by DenisChenu
Replied by DenisChenu on topic Import and long attribute fields
Speed way : why not doing it via phpMyAsmin or another webdatabaseadmin

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.
The topic has been locked.
  • aukevann
  • aukevann's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 1 month ago #92303 by aukevann
Replied by aukevann on topic Import and long attribute fields
Thanks.
We need to import e-mail addresses, attributes and names using CSV files to automate some of the work setting out large surveys. So we can't do this via phpAdmin. Also switching between the various tools is extra work.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 1 month ago #92304 by DenisChenu
Replied by DenisChenu on topic Import and long attribute fields
You can import CSV file with phpMyadmin.

Maybe the admin user don't have access to phpMyAdmin, but seems the easiest way actually.

Else, you can contact directly some dev at www.limesurvey.com/ (or contact me, if you want i have a look).

Denis

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.
The topic has been locked.
  • aukevann
  • aukevann's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 1 month ago #92359 by aukevann
Replied by aukevann on topic Import and long attribute fields
Hi Denis,

Yes I have access to the phpMyAdmin.
There are also some issues with special characters import when I make the CSV file in Office on the Mac. Can you also help with this? How can I contact you directly?
The topic has been locked.
More
7 years 1 month ago #147508 by Brunellaboselli74
Replied by Brunellaboselli74 on topic Import and long attribute fields
Hello aukevann,

I am dealing with a problem similar to yours. I need to import attribute fields that contain more than 255 characters. Have you found a way to do it? Is it possible? Di you contact DenisChenu? Was he able to help?
Thank you very much!
Kind regards,
Brunella
The topic has been locked.
  • aukevann
  • aukevann's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
7 years 1 month ago #147509 by aukevann
Replied by aukevann on topic Import and long attribute fields
Hi Brunella,

Once you have created the Token Table, you need to change the length of the attribute directly into your MySQL database.

Cheers,
Auke
The topic has been locked.
More
7 years 1 month ago #147510 by Brunellaboselli74
Replied by Brunellaboselli74 on topic Import and long attribute fields
Thank you very much for your quick reply! I try!
Brunella
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 1 month ago #147518 by DenisChenu
Replied by DenisChenu on topic Import and long attribute fields

aukevann wrote: There are also some issues with special characters import when I make the CSV file in Office on the Mac.

You didn't need me for this, you surely need a better tools for your document : www.libreoffice.org/download/libreoffice-still/?type=mac-x86_64

Can you also help with this? How can I contact you directly?

www.sondages.pro/a-propos/contact-en.html for next time, but think you have my email ?

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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose