Events Latitude/Longitude are not bein recorded

kvallema

For some reason, the Events being created are not getting Latitude and Longitude in the backend-table. Some of the events have it, some have it filled with value 255. The event in frontend still shows the location on Google map as the address is filled (sometimes only city and country though)....so if GoogleMaps is able to show this on the map-module, then should the system not be able to also fill in the LAT and LON -fields in the table?
I would like to have the filled as I am using BI-Tools to create reports on usage of the site and the missing LAT and LON showed up in one of my events-reports.

Best regards,
Kimmo

saguaros

Hi Kimmo

Could you share the super admin account and the URL of page that the map doesn't show correctly?

p/s: the provided info doesn't work.

kvallema

This message is visible to Moderators only

hidden content

saguaros

In event settings, there is place to fill the location, which event you have LAT / LONG fields?

kvallema

I have a number of events where teh LAT LON fields are filled....and some that are not. I assumed that the system was using GoogleMaps API to populate those fields automatically.

However the event like the id=19

has a location defined as Köln, Germany and google maps shows it correctly on the frontend but the database has values 255 and 255 for the LAT and LON respectively.

I only found this out by accident as I was running some of my business intelligence tools (MicroStrategy) and was trying to map the events with the # of participants on an ESRI-Map but some events were not showing up.....then I found out that only some of the events had the LAT LON fields filled.

saguaros

Could you share the URL of page where I can see that LAT/LONG fields?

kvallema

saguaros I think these you can only see in the database directly...

saguaros

I'm still not entirely sure of how you want to achieve here, in the event of Jomsocial, it only provides option to add place, not LAT / LONG value, you want to have these fields as options also?

kvallema

The table has a field for Latitude & Longitude. This table seems to be filled with Coordinates at some times and at some times it is not...I just cannot define the logic when it is filled an when not....and when it is, by which subsystem:

CREATE TABLE xxxx_community_events (
id int(11) UNSIGNED NOT NULL,
parent int(11) NOT NULL COMMENT 'parent for recurring event',
catid int(11) UNSIGNED NOT NULL,
contentid int(11) UNSIGNED DEFAULT '0' COMMENT '0 - if type == profile, else it hold the group id',
type varchar(255) NOT NULL DEFAULT 'profile' COMMENT 'profile, group',
title varchar(255) NOT NULL,
location text NOT NULL,
summary text NOT NULL,
unlisted tinyint(1) NOT NULL,
description text,
creator int(11) UNSIGNED NOT NULL,
startdate datetime NOT NULL,
enddate datetime NOT NULL,
permission tinyint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 - Open (Anyone can mark attendence), 1 - Private (Only invited can mark attendence)',
avatar varchar(255) DEFAULT NULL,
thumb varchar(255) DEFAULT NULL,
cover text NOT NULL,
invitedcount int(11) UNSIGNED DEFAULT '0',
confirmedcount int(11) UNSIGNED DEFAULT '0' COMMENT 'treat this as member count as well',
declinedcount int(11) UNSIGNED DEFAULT '0',
maybecount int(11) UNSIGNED DEFAULT '0',
wallcount int(11) UNSIGNED DEFAULT '0',
ticket int(11) UNSIGNED DEFAULT '0' COMMENT 'Represent how many guest can be joined or invited.',
allowinvite tinyint(1) UNSIGNED DEFAULT '1' COMMENT '0 - guest member cannot invite thier friends to join. 1 - yes, guest member can invite any of thier friends to join.',
created datetime DEFAULT NULL,
hits int(11) UNSIGNED DEFAULT '0',
published int(11) UNSIGNED DEFAULT '1',
latitude float(10,6) NOT NULL DEFAULT '255.000000',
longitude float(10,6) NOT NULL DEFAULT '255.000000',
offset varchar(5) DEFAULT NULL,
allday tinyint(11) NOT NULL DEFAULT '0',
repeat varchar(50) DEFAULT NULL COMMENT 'null,daily,weekly,monthly',
repeatend date NOT NULL,
storage varchar(64) NOT NULL DEFAULT 'file',
params text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`!<

saguaros

Let me check with Jomsocial's dev team and get back to you soon.