Location co-ordinates
By Dave Logic on Wednesday, 22 January 2014
Posted in General Issues
Replies 7
Likes 0
Views 781
Votes 0
Hi,

Does ES store the User address / postcode etc as longitude / lattitude values in MySQL ? I have found the table 'xxxx_social_locations' which stores the co-ordinates for Stories, Albums, Photos but can't find anything for users / addresses.

Regards,

Dave
Hello Dave,

Hm, I kind of remembered adding this in the field but it's actually stored in the fields data table. Take a look at the address field app as it is supposed to geocode it when a user enters their address when they save their profile.
Mark
·
Thursday, 23 January 2014 00:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark wrote:

Hello Dave,

Hm, I kind of remembered adding this in the field but it's actually stored in the fields data table. Take a look at the address field app as it is supposed to geocode it when a user enters their address when they save their profile.


Hi Mark

I can see the social_fields_data table however this stores only the address in textual form. Isn't there anywhere where the actual co-ordinates are stored?

Dave
Dave Logic
·
Thursday, 23 January 2014 00:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hm, it looks like we have commented this out. Not too sure why but if you want you can uncomment it in the address field.
Mark
·
Thursday, 23 January 2014 00:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark wrote:

Hm, it looks like we have commented this out. Not too sure why but if you want you can uncomment it in the address field.


May I ask exactly where this is commented out ?

Dave
Dave Logic
·
Thursday, 23 January 2014 01:08
·
0 Likes
·
0 Votes
·
0 Comments
·
apps/fields/user/address/address.php at line 137 onwards
Mark
·
Thursday, 23 January 2014 02:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark wrote:

apps/fields/user/address/address.php at line 137 onwards


Hi mark,

Many thanks

Dave
Dave Logic
·
Thursday, 23 January 2014 08:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

The feature is not implemented yet hence the code is commented out for future expansion purposes. We are expecting to have a map feature in the address in the future versions of EasySocial.
Jason Rey
·
Thursday, 23 January 2014 09:48
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post