Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 8:24 am
Add a reply View Replies (10)

Resolved Select list too large?

  1. rneumann
    rneumann
  2. Support
  3. Tuesday, April 05 2016, 09:12 PM
Hi,

I'm trying to build a 'select' list in easy profile with 5760 citynames of the Netherlands.

I think the number is too large, 'cause when I try for example 500 it works. Is there maximum on this value? And how can this be changed or is there a way to make it work?

Hope to hear from you soon, thanks in advance.

Richard
  1. select
  2. value
Responses (10)
admin
admin Accepted Answer
Admin
Hi,
sorry 5000 are too many. Keep in mind that with 5000 options you will have 5000 rows of HTML code. So, in most of cases you will have timeout error.

The only way is to use 2/3 select fields (Country->Region->City or Country->City) like this video https://youtu.be/QNGiTKNbbsY

You can set something like this by get data from DB (see screenshot), for more info about this see the tips in each parameter
Attachments (1)
Schermata 2016-04-05 alle 21.34.07.png Schermata 2016-04-05 alle 21.34.07.png
  1. more than a month ago
  2. Support
  3. # 1
rneumann
rneumann Accepted Answer
Pro
Hi,

Thank you for your quick response!

The video-link doesn't work. Youtube says the video is unavailable.

Is there a way to connect this field with Google Maps, so that the info doesn't have to be provided by me? It would be nice if the person registering could choose his location through Google Maps and that there will be a map on the profile displaying the location.
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
sorry for video this forum make lowercase all links.

Is there a way to connect this field with Google Maps
No sorry.

so that the info doesn't have to be provided by me? It would be nice if the person registering could choose his location through Google Maps and that there will be a map on the profile displaying the location.
This is already possible with Google Map field type
References
  1. https://youtu.be/QNGiTKNbbsY
  1. more than a month ago
  2. Support
  3. # 3
rneumann
rneumann Accepted Answer
Pro
Thanks,

Is there a step-by-step explanation/tutorial to get it like in the YouTube-movie?
  1. more than a month ago
  2. Support
  3. # 4
admin
admin Accepted Answer
Admin
Hi,
try to see this topic: https://www.easy-profile.com/support/conditional-drop-downs.html#reply-11318

For more info about these parameter you can see the Tips
  1. more than a month ago
  2. Support
  3. # 5
rneumann
rneumann Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Support
  3. # 6
admin
admin Accepted Answer
Admin
Do I understand correctly that I have to paste this code? And in which file?
No.

- Download and install (with some SQL tools like PhpMyAdmin) example DB with City Country and States from https://github.com/hiiamrohit/Countries-States-Cities-database, in your database you will have 3 new tables.
- Create first Select field called "Country" and set Parameters as in first screenshot
- Create second Select field called "State" and set Parameters as in first screenshot
- Create third Select field called "City" and set Parameters as in third screenshot
Attachments (3)
support1.png support1.png
support2.png support2.png
support3.png support3.png
  1. more than a month ago
  2. Support
  3. # 7
rneumann
rneumann Accepted Answer
Pro
Thanks,

I think I'm almost there, but I can't seem to install the DB correctly.
Please check out the screenshot I provided.

I get that error...

Do I have to select a database from the list on the left? If so; which one?
  1. more than a month ago
  2. Support
  3. # 8
admin
admin Accepted Answer
Admin
Hi,
first you need to select your database from the left menu. Database need to be the same of Joomla
  1. more than a month ago
  2. Support
  3. # 9
rneumann
rneumann Accepted Answer
Pro
Thank you for your help!!
  1. more than a month ago
  2. Support
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.