By Derk Kremer on Sunday, 05 November 2017
Posted in General Issues
Likes 0
Views 493
Votes 0
Hey,

I like to use the geomunnity3 map for ES. Therefore I need the coordinates of the user. We have the addresses of the users but not the coordinates. Therefore we have installed the Batch Geocoder of Nordmograph. However, it doesn't work because we have not the right 'address set'.

We didn't use the address field of ES because that is one address like Rijksstraatweg 22, 9792 RA, Groningen, Netherlands.
We have seperated street, zip, city and country: see field_id 23 in the attachment.

How do I get from these values to the right 'address set'. Ofcourse we can use SQL statements to fill in the right 'address set', but we don't know which one it is.
Hey Derk,

I am really sorry for the delay of this reply as it is a weekend for us here. Hm, if the Batch Geocoder only works with the address field, you have 2 options:

1. Request the developer to make the geocoder work on specific set of fields based on the Unique Code. I think this is the best way around this.

2. The other option is to create an address field and re-create the data stored for the existing textbox fields (as address) into a value for the address field. This is much more complicated to be honest.
·
Sunday, 05 November 2017 12:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark,

Thank you for the quick response. Your message is clear. But still I have some additional questions.

In one of my profiles I've made a new address field. The user sees only the address field in total: see ES-05

This is not what we want: we like to have street, zip, city, country seperated from each other: see ES-07

In the table you can see for user 371 the fields: apparantly an address field is made with field_id 23. With an SQL query I can move data from 'our address' fields to these. But still geocoder doesn't work. Because of the standard field_id 12 (which one is not in my jos_easy_fields table.

My question is: how do I make a standard addressfield with sub fields street, (number), zip, city a user can see and fill in seperately.

I hope I've made my issue clear?

regards,
·
Sunday, 05 November 2017 17:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Derk,

I am really sorry for the delay of this reply as it is a weekend for us here. Ah, I see! You could actually change the way the field renders the form in the field settings.

Take a look at my screen shot here, http://take.ms/xOByO . This way, when the user registers, they will see this form instead, http://take.ms/BuTUG
·
Sunday, 05 November 2017 21:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark,

Thank you very much for the solution. Great!!

Everything works now: we can see the registered users on a google map and we don't need batch geocoder.

Thanks, derk
·
Monday, 06 November 2017 00:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
·
Monday, 06 November 2017 08:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post