Multi Drop-down List

Can this extension be used to save a number of selected keywords in comma separated format in the database? I am testing this extension but all the keywords stored and shown are saved in the database with ‘line breaks’?

Any help would be much appreciated.

Yes, they are stored in the database with line breaks so that it doesn’t break if any of the options have commas in them. If you’re looking to alter the display on the template you can always use the separator=”, ” attribute?

Problem is that the data that is already saved in the database field is comma separated, not line-break separated. So if I have the following in a database field:

data1, data2, data3

Can I have these show in the Multi-Drop-down List as one per selection using separator=”, ” attribute:

data1
------
data2
------
data3

unfortunately it must be separated by line breaks in the db for the field to work. however you could just run a simple mysql update to fix your data:

update exp_weblog_data set field_id_xxx=replace(field_id_xxx, ",", "\r")

of course if you’re not proficient with MySQL be sure to back up your database first as there is no undo for an ‘update’ call.

Thanks for clearing that up Mark. I’ll go ahead and give your suggestion a try.

I attempted to install this and am getting an error and can’t login to my control panel. I posted in the ‘How To’ forum as well – sorry for the duplicate …

The error reads:

Unable to load the following extension file:

ext.multi_drop_down_list.php

Here’s what I did:

1. Downloaded ext.multi_drop_down_list_111 from here:

http://www.ellislab.com/forums/viewthread/38370/

I (accidentally) uploaded both the ext. file and the lang. file in my extensions directory.

2. Went to my control panel and enabled extensions, and then attempted to enable the multi_drop_down extension. Then I got some error I can’t remember, so I thought I better look up how to install extensions … but first I removed both files from my server. Then I put the lang. file in the language dir, and the ext. file in the extensions dir, and then I just keep getting “unable to load” errors as noted above.

3. I then searched my desktop for another version of this extension which I’ve used successfully in the past. I found it (ext.multi_relationship_104), and tried putting those files on my server. But that didn’t change anything and still can’t get into my CP.

How do I undo this damage? I am running v1.5.2.

Thanks,

Kelly

you should be able to fix this by just placing the multi-drop-down-list file back on the server in the system/extensions folder. or if you have access to PHP you can manually disable the extension by running the following query:

DELETE FROM exp_extensions WHERE class = 'multi_drop_down_list'

Of course editing MySQL directly is risky so make sure you back up your database first as a general caution.

That hasn’t worked for some reason. I will see if I can find PhPmyAdmin on my host. (I don’t really know what I’m doing).

Awesome, I’m all fixed. Thanks for your help.

great! glad it worked out.

Works like a charm!! Thanks! 😊

I installed this extension successfully, created custom multi-select fields, but when I try to publish a weblog I can only choose one selection–just like the the original drop down list

1. Is there something else (configuration-wise) other than installing the extension that I need to do?
2. Is there any actual documentation for this extension other than the forum posts?

@django6 – have you created a new multi-select field? what shows up when you create the new field? Is it a normal select list?

I did create two multi selected fields. They show up as lists in the weblog publish page, which surprises me since I was expecting a drop-down. What am I doing wrong?