Search found 139 matches

Go to advanced search

by ClausAnd
Mon Apr 03, 2017 7:01 pm
Forum: GpsGate Server - How to setup and use
Topic: GPSGate Server only tracks one device at a time
Replies: 5
Views: 2532

Re: GPSGate Server only tracks one device at a time

the source/tracker address looks odd (192.168..).
by ClausAnd
Sat Apr 01, 2017 1:27 pm
Forum: GpsGate Server - How to setup and use
Topic: FIX: Franson NMEA Service or IIS crashes.
Replies: 3
Views: 3656

Re: FIX: Franson NMEA Service crashes.

so you consider it 'safe' to upgrade server to 5.7.17?
by ClausAnd
Fri Mar 31, 2017 8:38 pm
Forum: GpsGate Server - How to setup and use
Topic: FIX: Franson NMEA Service or IIS crashes.
Replies: 3
Views: 3656

Re: FIX: Franson NMEA Service crashes.

any change support for newer / more recent versions of MySQL (server)?
by ClausAnd
Thu Mar 02, 2017 6:48 pm
Forum: GpsGate Server - How to setup and use
Topic: MySQlL - self/sub query (left join)
Replies: 4
Views: 2385

Re: MySQlL - self/sub query (left join)

Kind of solution found:

Added another query to the report and uses the second query as a SELECT sub-query in the main query. Not a LEFT JOIN, but close.

(wonder how performance will be)

/claus
by ClausAnd
Wed Mar 01, 2017 9:55 pm
Forum: GpsGate Server - How to setup and use
Topic: MySQlL - self/sub query (left join)
Replies: 4
Views: 2385

Re: MySQlL - self/sub query (left join)

That is possible - but as one reports is intended to show counts/totals of other reports / events i would prefer to include the data as subquery / left joins to avoid future inconsistency and reduce maintenance. I just can't figure out why any attempt to do so results in errors, as the syntax - to t...
by ClausAnd
Wed Mar 01, 2017 8:54 pm
Forum: GpsGate Server - How to setup and use
Topic: MySQlL - self/sub query (left join)
Replies: 4
Views: 2385

MySQlL - self/sub query (left join)

Hi guys I have multiple events that I would like to combine into a single report. I try to modify the main query to report count and sum from some sub-queries, but have can't figure out the correct syntax. The main data is read from eventprovider01 - some data have to be complementet from another ev...
by ClausAnd
Tue Feb 14, 2017 9:55 pm
Forum: GpsGate Server - How to setup and use
Topic: End Expression in script
Replies: 14
Views: 6804

Re: End Expression in script

Maybe session.user.unlink?
by ClausAnd
Tue Feb 14, 2017 9:27 pm
Forum: GpsGate Server - How to setup and use
Topic: End Expression in script
Replies: 14
Views: 6804

Re: End Expression in script

Then it makes sense that the timer is working (counting). So basicly you want to know how to logoff the driver?
by ClausAnd
Tue Feb 14, 2017 9:02 pm
Forum: GpsGate Server - How to setup and use
Topic: End Expression in script
Replies: 14
Views: 6804

Re: End Expression in script

Events may be triggered by incoming tracker data or a timer event - which unfortunately has a granularity of minimum one day. Is it possible to have the tracker send idle messages (i.e every 15 min)? Another workaround could be to schedule a lot of identical events firing at different time of day ea...
by ClausAnd
Tue Feb 14, 2017 5:46 pm
Forum: GpsGate Server - How to setup and use
Topic: End Expression in script
Replies: 14
Views: 6804

Re: End Expression in script

How? Then You just haves to do the sign off after the timer expires and finish the event by returning false. How do You handle if the vehicle becomes active during timer period?
by ClausAnd
Tue Feb 14, 2017 4:56 pm
Forum: GpsGate Server - How to setup and use
Topic: End Expression in script
Replies: 14
Views: 6804

Re: End Expression in script

Don't know how you made the timer or how to do the driver sign off. Delayed events are not an option as the delay relates to the end conditions. I'll be back after some testing.
by ClausAnd
Tue Feb 14, 2017 3:54 pm
Forum: GpsGate Server - How to setup and use
Topic: End Expression in script
Replies: 14
Views: 6804

Re: End Expression in script

Make a script.

Rather than having it as and end condition have it as a start condition and logout the driver before returning false. While pending return true.
by ClausAnd
Sun Feb 05, 2017 11:51 pm
Forum: GpsGate Server - How to setup and use
Topic: 'Global' events, copy events, and vehicle specific input parameter
Replies: 0
Views: 1280

'Global' events, copy events, and vehicle specific input parameter

This may be a developer topic, but that thread seems a bit 'inactive'. 1) I have established rather complicated reporting data thru event scripts and several corresponding reports. The reports select the proper data based on the event GUID as a report is closely linked to a script (learned it from t...
by ClausAnd
Sun Jan 08, 2017 10:09 am
Forum: GpsGate Server - How to setup and use
Topic: FEATURE: Mobile (major update).
Replies: 322
Views: 166891

Re: FEATURE: Mobile (major update).

I second husky - especially with tablets in landscape mode. Lots of space is wasted.

/claus

Go to advanced search