Check out the LimeSurvey source code on GitHub!

Import and long attribute fields

More
4 years 3 weeks ago #92265 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

Please Log in to join the conversation.

More
4 years 3 weeks ago #92300 by DenisChenu
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 (or search sondages pro).

Please Log in to join the conversation.

More
4 years 3 weeks ago #92303 by aukevann
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.

Please Log in to join the conversation.

More
4 years 3 weeks ago #92304 by DenisChenu
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 (or search sondages pro).

Please Log in to join the conversation.

More
4 years 3 weeks ago #92359 by aukevann
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?

Please Log in to join the conversation.

More
1 month 1 week ago #147508 by Brunellaboselli74
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

Please Log in to join the conversation.

More
1 month 1 week ago #147509 by aukevann
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

Please Log in to join the conversation.

More
1 month 1 week ago #147510 by Brunellaboselli74
Thank you very much for your quick reply! I try!
Brunella

Please Log in to join the conversation.

More
1 month 1 week ago #147518 by DenisChenu

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 (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form