| Author |
 Topic  |
|
|
JonasJ
Administrator
Sweden
43 Posts |
 Posted - 10/02/2009 : 10:04:40
|
Dispatcher Plugin to GpsGate Server
The Dispatcher plugin will allow you to search for your own points of interest by name, pan to and display them on the map.
You can use this plugin to see which vehicles are close to your points of interest.
How to install and run the sample - step by step:
1. Download and unzip
GpsGate Server v2.3.1 build 2076 - http://franson.com/gpsgateserver/samples/2076/Dispatcher.zip
GpsGate Server v2.3 build 1944 - http://franson.com/gpsgateserver/samples/1944/Dispatcher.zip
GpsGate Server v2.2 build 1789 - http://franson.com/gpsgateserver/samples/1789/Dispatcher.zip
GpsGate Server v2.2 build 1799 - http://franson.com/gpsgateserver/samples/1799/Dispatcher.zip
into a new folder in your GpsGate Server installation:
[install_path]\IIS\Resources\ScriptPlugins\com.GpsGate\Dispatcher
The folder should contain the following files:
BO\Category.cs
BO\CategoryReader.cs
BO\Dispatcher.cs
BO\ResultObject.cs
DAO\DispatcherCategoryReaderDAOSQL.cs
DAO\DispatcherObjectReaderDAOSQL.cs
Data\things_category1.csv
Data\things_category2.csv
csv-import.sql
Dispatcher.js
DispatcherContent.aspx
DispatcherContent.aspx.cs
DispatcherContent.aspx.designer.cs
object_marker.png
DispatcherModule.MySQL.sql
dispatchermodule.xml
dispatcherpackage.xml
dispatcher.xml
Dispatcher.dll
Move the file Dispatcher.dll to the [install_path]\IIS\bin\ folder.
2. Importing sample data into the database
Move the Data folder to a location of your choice and edit the full path to the files location in the csv-import.sql script.
Execute the csv-import.sql script in your database.
The sample data for this plugin is provided in two CSV (comma separated values) files in the folder Data:
things_category1.csv
things_category2.csv
3. Login to SiteAdmin. Go to the “Script Plugin” tab. Click on “Refresh Script Plugins”. Select "Dispatcher Window" from the drop down list, tick the checkbox for VehicleTracker and click Save to enable the plugin.
4. Running the plugin
Login to VehicleTracker. A menu named "Windows" should exist with an item named "Dispatcher". Click the
"Windows" -> "Dispatcher" menu item and the window should pop up.
Source code
The source code for this plugin may be modified and reused in any way.
Take a look in "Display Platform Kit" for how you develop your own custom Windows in VehicleTracker. Download the "Display Platform Kit" here:
http://franson.com/gpsgateserver/guide.asp
JonasJ
GpsGate |
Edited by - JonasJ on 01/15/2010 06:53:43 |
|
|
bpps
Average Member
Germany
48 Posts |
Posted - 10/04/2009 : 15:06:59
|
Hello,
first you have to execute DispatcherModule.MySQL.sql
This will create the tables.
Than you can insert your categories with the sql statements
INSERT INTO p_dispatcher_category(p_dispatcher_category_id, name, description) VALUES(2, 'Other things', 'Some other things');
and your POI's with the statement
INSERT INTO p_dispatcher_object (longitude, latitude, name, category) VALUES (xx.xx, yy.yy, yourPOI, 1);
This works with MySQL.
Regards |
 |
|
|
André
New Member
Portugal
2 Posts |
Posted - 10/30/2009 : 10:02:17
|
Good afternoon.
On build 1789 I was able to use Dispatcher, but since I've got 1799 I can't get it working. Is there any fix or something?
Regards |
|
|
|
johan
Forum Admin
Sweden
10079 Posts |
Posted - 10/30/2009 : 13:22:34
|
I have now added a link to the 2.2 build 1799 download. Please see above.
Regards,
Johan
Franson Support |
|
|
|
André
New Member
Portugal
2 Posts |
Posted - 10/30/2009 : 13:38:20
|
Thanks Johan. Works like a charm.
Regards,
André |
|
|
|
georg
Senior Member
Brazil
110 Posts |
Posted - 11/09/2009 : 05:22:50
|
| Very good application. Thank you. Just one thing. It would be very great if there is a bottom where i can show all poi´s from a selected categorie. Can you add this bottom please? |
|
|
|
JonasJ
Administrator
Sweden
43 Posts |
Posted - 11/13/2009 : 11:21:08
|
I have updated Dispatcher for GpsGate Server 2.3 build 1944 so that it is possible to get all poi's from the selected category by not specifying a text in the search textbox. Please see the link above for the download.
Regards,
Jonas |
|
|
|
georg
Senior Member
Brazil
110 Posts |
Posted - 11/16/2009 : 05:44:22
|
| Great!!!! Thank you! |
|
|
|
georg
Senior Member
Brazil
110 Posts |
Posted - 11/16/2009 : 07:55:56
|
OK, It´s shows all POI in the list of the dispatcher windows now. But what i would like to do, is to show all POI´s in the list, with just click one bottom. Is this possible?
|
Edited by - georg on 11/16/2009 08:18:08 |
|
|
|
JonasJ
Administrator
Sweden
43 Posts |
Posted - 11/16/2009 : 08:16:31
|
Did you move the file "Dispatcher.dll" into your GpsGateServer [install_path]\IIS\bin\ folder?
Regards,
Jonas |
|
|
|
georg
Senior Member
Brazil
110 Posts |
Posted - 11/16/2009 : 08:18:57
|
| Sorry, i don´t. But now is working |
|
|
|
georg
Senior Member
Brazil
110 Posts |
Posted - 11/20/2009 : 06:16:12
|
| OK, It´s shows all POI in the list of the dispatcher windows now. But what i would like to do, is to show all POI´s in the list on the map, with just click one bottom. Is this possible? |
Edited by - georg on 11/20/2009 06:16:58 |
|
|
|
GRACO
Advanced Member
549 Posts |
Posted - 12/07/2009 : 16:47:10
|
this plug in can handle different POI for different applications?
Go to Top of Page |
|
|
|
JonasJ
Administrator
Sweden
43 Posts |
Posted - 12/08/2009 : 04:07:16
|
The Dispatch plugin does not handle multiple applications, it is per site.
Regards,
Jonas
GpsGate |
|
|
|
JonasJ
Administrator
Sweden
43 Posts |
Posted - 01/15/2010 : 09:06:37
|
There is a new version of Dispatcher plugin for GpsGate Server 2.3 build 1944. Please see the link above for the download.
Changes:
Added a button for showing all search results on the map, no need to click each individual result.
Regards,
Jonas
GpsGate |
|
|
|
marcelok
Junior Member
14 Posts |
Posted - 03/05/2010 : 08:33:34
|
| I-m using GpsGate Server v2.3.1 build 2076. I can't see the customers in the list. I moved the Data folder to this location C:/Data and edited the full path to the files location in the csv-import.sql script. The two tables are empty now. I moved the file Dispatcher.dll to the [install_path]\IIS\bin\ folder. |
|
|
|
Kasimir61
Average Member
Germany
60 Posts |
Posted - 03/06/2010 : 07:11:55
|
Hi,
how are the statements for the Microsoft SQL Database.
I am a little bit confused, because - it will not execute the sql in Microsoft SQL, so i think the statements are here different..
Is there a sql file for the microsoft SQL too ??
Regards
Kasi
go ahead.. |
|
|
|
JonasJ
Administrator
Sweden
43 Posts |
Posted - 03/24/2010 : 13:54:57
|
There is currently no version for MSSQL, but if you figure out the syntax for creating the tables in MSSQL and also manage to import your data into the MSSQL database from the .csv files, it should work. So:
1. Create a corresponding file "DispatcherModule.MSSQL.sql" with correct MSSQL syntax for creating tables.
2. Add a tag next to the MySQL tag to the file "dispatchermodule.xml"
<script targetDB="MSSQL">
DispatcherModule.MSSQL.sql
</script>
3. Import the CVS data to the tables using MSSQL syntax for cvs import.
Then things should work if you then follow the Dispatch plugin installation instructions.
Regards,
Jonas
GpsGate |
Edited by - JonasJ on 03/24/2010 13:56:38 |
|
|
|
marwan
Junior Member
20 Posts |
Posted - 04/19/2010 : 18:14:52
|
I am running version 2.3.1 -2076. I installed Dispatcher for this version but when i try to import "csv-import.sql" , i get the following error:
"Data truncated for column 'longitude' at row 51". Any idea. Thanks |
|
|
|
Bolt
Average Member
Australia
31 Posts |
Posted - 07/10/2010 : 17:33:59
|
I have a GGS subscription and would like to install the dispatcher. Can it be done?
Also, how do I create POI's?
Cheers |
|
|
|
Nome
Junior Member
14 Posts |
Posted - 07/24/2010 : 22:32:04
|
I had the same problem when i tried to import. What i did was remove the extra empty lines from the end of the two csv files. Once i remove them and save it. I was able to import the two csv files using the csv-import.sql file. I was looking for row 51 but couldn't find it instead it was an empty line so i just tested by removing that empty line or row and it worked for me.
quote:
Originally posted by marwan
I am running version 2.3.1 -2076. I installed Dispatcher for this version but when i try to import "csv-import.sql" , i get the following error:
"Data truncated for column 'longitude' at row 51". Any idea. Thanks
|
|
|
|
Kasimir61
Average Member
Germany
60 Posts |
Posted - 07/31/2010 : 04:02:06
|
It is nice, work wonderful, but there is no Option to delete Points or add Points.
A nice Idea for the future was, that you can delete records and add new Points with some Informations.
A nice Idea too was, that you can click on a Vehicle become the lat/lon and a pulldown to make a choise of one of the record from list. After you have clicked become a Rpoute Planning from google from actual Position to wished point...
O.K. is much - but to add or delete a record, that was fine ;-)
Regards
Kasi
go ahead.. |
|
|
| |
Topic |
|
Digg this
Plugin: Dispatch
