- Posts: 59
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Import and long attribute fields
- aukevann
- Topic Author
- Offline
- Senior Member
Less
More
11 years 2 months 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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
11 years 2 months ago #92300
by DenisChenu
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.
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
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 59
- Thank you received: 2
11 years 2 months 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.
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
11 years 2 months ago #92304
by DenisChenu
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.
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
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
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 59
- Thank you received: 2
11 years 2 months 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?
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.
- Brunellaboselli74
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
7 years 2 months 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
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
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 59
- Thank you received: 2
7 years 2 months 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
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.
- Brunellaboselli74
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
7 years 2 months 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
Brunella
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
7 years 2 months ago #147518
by DenisChenu
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.
Replied by DenisChenu on topic Import and long attribute fields
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_64aukevann wrote: There are also some issues with special characters import when I make the CSV file in Office on the Mac.
www.sondages.pro/a-propos/contact-en.html for next time, but think you have my email ?Can you also help with this? How can I contact you directly?
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.