Import and long attribute fields

More
4 years 8 months ago #92265 by aukevann
aukevann created the topic: Import and long attribute fields
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 8 months ago #92300 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 8 months ago #92303 by aukevann
aukevann replied the 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.

Please Log in to join the conversation.

More
4 years 8 months ago #92304 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
4 years 8 months ago #92359 by aukevann
aukevann replied the 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?

Please Log in to join the conversation.

More
9 months 3 days ago #147508 by Brunellaboselli74
Brunellaboselli74 replied the 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

Please Log in to join the conversation.

More
9 months 3 days ago #147509 by aukevann
aukevann replied the 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

Please Log in to join the conversation.

More
9 months 3 days ago #147510 by Brunellaboselli74
Brunellaboselli74 replied the topic: Import and long attribute fields
Thank you very much for your quick reply! I try!
Brunella

Please Log in to join the conversation.

More
9 months 3 days ago #147518 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now