Import list with API or import method
By Eric Chen on Wednesday, 05 November 2014
Posted in General Issues
Replies 4
Likes 0
Views 446
Votes 0
Hello, I'm new to EasySocial, so forgive me if this has been covered before.

I'm implementing EasySocial for a gamers social website, and want to be able to add a Games section to the user's profile. I'd like for users to be able to type in the name of the game, and have it in a drop down list. Ideally, similar to the way Facebook does for music and movies where you start typing in the name and it'll auto complete. There's an API out there for a games database at http://api.archive.vg/2.0/docs/Archive.search.php. Is there a way to implement this?

Or, an easier way is for me to create a multi dropdown menu with games already listed, but I don't want to type in each game separately in the admin section. Is there a database table that I can import these dropdown choices?

Thanks!
Hi,

Currently there is no "import API" to utilise but what you can do is, after you've added the multidropdown field to your profile, search for the id of the field at the table 'prefix_social_fields'. You will want to search by the SQL:



select a.id from prefix_social_fields as a

left join prefix_social_apps as b

on a.app_id = b.id

where b.type = 'fields'

and b.group = 'user'

and b.element = 'multidropdown';


With the id, just add the selection that you want to the table 'prefix_social_fields_options' where the parent_id is the field id, key is just a constant 'items' for the field multidropdown, and fill in the ordering, title, and value of your choice. Default column defines which value gets selected by default.
Jason Rey
·
Wednesday, 05 November 2014 10:54
·
0 Likes
·
0 Votes
·
0 Comments
·
This worked great! Thank you! One question I have is, I have 43,000 items in the dropdown so as expected, when modifying the profile, it takes about 30 seconds to load the page. Any suggestions on speeding this up?
Eric Chen
·
Thursday, 06 November 2014 21:20
·
0 Likes
·
0 Votes
·
0 Comments
·
maybe auto complete like in jreviews can be an option
Sunny
·
Thursday, 06 November 2014 21:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

This is actually a little complicated if you want to perform an ajax call to "retrieve" the suggestions. Unfortunately we would not be able to provide assistance with such customizations at this point of time

Perhaps in the future, an "auto complete" field like Sunny posted above would make sense.
Mark
·
Friday, 07 November 2014 00:27
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post