User avatar
johan
GpsGate
Posts: 15401
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

FEATURE: Custom Fields

Sat May 18, 2013 5:16 pm

FEATURE: Custom Fields

We are now introducing a new way to add and manage data. We are giving you (the user) the ability to add custom fields. These custom fields can be applied to Users and POI’s. Giving you a new range of possibilities. For instance you could create a text field and use it to store registration id for a vehicle.

http://gpsgate.com/blogComment/custom_fields

Regards,
Johan

GpsGate Support

piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

RE: FEATURE: Custom Fields

Sun May 19, 2013 4:54 am

Hi Support,

I have update beta plugins Patch.3840 ver3.1.0.4726 in order to beta test Custom Fields.

I have create Custom fields, then I renamed a particular User Type.
When I want to access the User Type dialog, I got this error message "Object reference not set to an instance of an object" and the User Type dialog failed to open.


I tried with different VT application. I create Custom Fields again then I edit ABC User Type to display this new custom fields.
Still when I open Edit User (vehicle that use ABC User Type), no Custom fields shown nor in Vehicle panel (I have select check box of custom field column).

For this vehicle I decide to change from ABC User Type into Empty (Advanced) User Type, but fail to save/change and got error "EX_UPDATEDEXCEPTION".


Please help.

Best Regards,
piter197

User avatar
johan
GpsGate
Posts: 15401
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: FEATURE: Custom Fields

Sun May 19, 2013 11:18 am

Please send log files for the time period of the error to support @ gpsgate .com

You find the log files under C:\GpsGateServer\ErrorLogs

Regards,
Johan

GpsGate Support

piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

RE: FEATURE: Custom Fields

Sun May 19, 2013 12:53 pm

IIS and NMEA error log files have been sent to support, please help. Thank you.

Best Regards,
piter197

piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

RE: FEATURE: Custom Fields

Sun May 26, 2013 7:21 am

Dear Johan,

I have update to latest beta Patch.3840 ver 3.1.0.4755, still on this particular VT Application I always got this error message "Object reference not set to an instance of an object" and the User Type dialog failed to open.

Because of this, I also can not Add New User.

Please help to rectify this. I'll send my login detail to support. Thank you.

Best Regards,
piter197

User avatar
johan
GpsGate
Posts: 15401
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: FEATURE: Custom Fields

Mon May 27, 2013 11:45 am

Please send log files for the time period of the error to support @ gpsgate .com

You find the log files under C:\GpsGateServer\ErrorLogs

Regards,
Johan

GpsGate Support

piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

RE: FEATURE: Custom Fields

Mon May 27, 2013 3:13 pm

Ok, I have sent error log and screenshot.

Not only I got error when Add New User and Edit User Type in particular VT.

I also got error message "EX_UPDATEDBEXCEPTION" when try to save changes for POI Category.

This is from Error log:

2013-05-27 18:15:20.3002 | Error | 63 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1452 |
2013-05-27 18:15:20.3002 | Error | 63 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error updating database table custom_field_template (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at GpsGate.CustomFields.DAO.CustomFieldTemplateWriterDAO.Update()
at Franson.DAO.BOItem.Update()
at GpsGate.PointsOfInterest.Service.PointsOfInterestFacade.SaveCategory(Int32 iApplicationID, LocationCategoryBag category)
at GpsGate.PointsOfInterest.Service.json.PointsOfInterest.SaveCategory(Int32 appId, JsonObject jo)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Cannot add or update a child row: a foreign key constraint fails (`gpsgateserver`.`custom_field_template`, CONSTRAINT `FK_template_designer_id` FOREIGN KEY (`designer_id`) REFERENCES `custom_field_designer` (`designer_id`) ON DELETE CASCADE ON UPDATE CASCADE) (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()

2013-05-27 18:15:28.5033 | Error | 63 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1452 |
2013-05-27 18:15:28.5033 | Error | 63 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error updating database table custom_field_template (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at GpsGate.CustomFields.DAO.CustomFieldTemplateWriterDAO.Update()
at Franson.DAO.BOItem.Update()
at GpsGate.PointsOfInterest.Service.PointsOfInterestFacade.SaveCategory(Int32 iApplicationID, LocationCategoryBag category)
at GpsGate.PointsOfInterest.Service.json.PointsOfInterest.SaveCategory(Int32 appId, JsonObject jo)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Cannot add or update a child row: a foreign key constraint fails (`gpsgateserver`.`custom_field_template`, CONSTRAINT `FK_template_designer_id` FOREIGN KEY (`designer_id`) REFERENCES `custom_field_designer` (`designer_id`) ON DELETE CASCADE ON UPDATE CASCADE) (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()

2013-05-27 18:17:27.8158 | Error | 64 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1452 |
2013-05-27 18:17:27.8158 | Error | 64 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error updating database table custom_field_template (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at GpsGate.CustomFields.DAO.CustomFieldTemplateWriterDAO.Update()
at Franson.DAO.BOItem.Update()
at GpsGate.CustomFields.Service.CustomFieldsFacade.GetCustomFieldsTemplate(Int32 iApplicationID, Int32 iCustomFieldTemplateID, String strNamespace)
at GpsGate.CustomFields.Service.json.CustomFields.GetCustomFieldsTemplate(Int32 appId, Int32 iCustomFieldTemplateID, String strNamespace)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Cannot add or update a child row: a foreign key constraint fails (`gpsgateserver`.`custom_field_template`, CONSTRAINT `FK_template_designer_id` FOREIGN KEY (`designer_id`) REFERENCES `custom_field_designer` (`designer_id`) ON DELETE CASCADE ON UPDATE CASCADE) (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()

2013-05-27 18:17:32.6596 | Error | 63 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1452 |
2013-05-27 18:17:32.6596 | Error | 63 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error updating database table custom_field_template (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at GpsGate.CustomFields.DAO.CustomFieldTemplateWriterDAO.Update()
at Franson.DAO.BOItem.Update()
at GpsGate.PointsOfInterest.Service.PointsOfInterestFacade.SaveCategory(Int32 iApplicationID, LocationCategoryBag category)
at GpsGate.PointsOfInterest.Service.json.PointsOfInterest.SaveCategory(Int32 appId, JsonObject jo)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Cannot add or update a child row: a foreign key constraint fails (`gpsgateserver`.`custom_field_template`, CONSTRAINT `FK_template_designer_id` FOREIGN KEY (`designer_id`) REFERENCES `custom_field_designer` (`designer_id`) ON DELETE CASCADE ON UPDATE CASCADE) (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()

2013-05-27 18:18:16.9565 | Error | 64 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1452 |
2013-05-27 18:18:16.9565 | Error | 64 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error updating database table custom_field_template (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at GpsGate.CustomFields.DAO.CustomFieldTemplateWriterDAO.Update()
at Franson.DAO.BOItem.Update()
at GpsGate.CustomFields.Service.CustomFieldsFacade.GetCustomFieldsTemplate(Int32 iApplicationID, Int32 iCustomFieldTemplateID, String strNamespace)
at GpsGate.CustomFields.Service.json.CustomFields.GetCustomFieldsTemplate(Int32 appId, Int32 iCustomFieldTemplateID, String strNamespace)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Cannot add or update a child row: a foreign key constraint fails (`gpsgateserver`.`custom_field_template`, CONSTRAINT `FK_template_designer_id` FOREIGN KEY (`designer_id`) REFERENCES `custom_field_designer` (`designer_id`) ON DELETE CASCADE ON UPDATE CASCADE) (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()

2013-05-27 18:18:20.2846 | Error | 63 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1452 |
2013-05-27 18:18:20.2846 | Error | 63 | ExtendedRpcDispatcher.OnError | Error executing JSON method | Error updating database table custom_field_template (Franson.DAO.UpdateDBException)
at Franson.DAO.DAOBase.Update()
at Franson.DAO.DAOItem.Update()
at GpsGate.CustomFields.DAO.CustomFieldTemplateWriterDAO.Update()
at Franson.DAO.BOItem.Update()
at GpsGate.PointsOfInterest.Service.PointsOfInterestFacade.SaveCategory(Int32 iApplicationID, LocationCategoryBag category)
at GpsGate.PointsOfInterest.Service.json.PointsOfInterest.SaveCategory(Int32 appId, JsonObject jo)
ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.9]Cannot add or update a child row: a foreign key constraint fails (`gpsgateserver`.`custom_field_template`, CONSTRAINT `FK_template_designer_id` FOREIGN KEY (`designer_id`) REFERENCES `custom_field_designer` (`designer_id`) ON DELETE CASCADE ON UPDATE CASCADE) (System.Data.Odbc.OdbcException)
at Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
at Franson.DAO.DAOBase.Update()



Best Regards,
piter197

jdewitt
Posts: 108
Joined: Mon Jul 15, 2013 3:26 am
Location: USA

RE: FEATURE: Custom Fields

Mon Jul 15, 2013 3:27 am

I noticed the following minor bugs when evaluating custom fields for POIs:

1) When renaming the values of list options, it doesn't rename the values for existing POIs

2) When deleting a POI, the custom field options are not deleted from the custom_field_value table

Strid
Posts: 6
Joined: Mon Jan 07, 2013 6:33 pm
Location: Sweden

RE: FEATURE: Custom Fields

Wed Jul 17, 2013 3:51 pm

Hi,

Thank you for your feedback. I will take a look at this.

Regards,
Robin

GpsGate Support

rosol
Posts: 98
Joined: Mon Feb 13, 2012 3:11 pm

RE: FEATURE: Custom Fields

Fri Oct 18, 2013 7:48 pm

Hi,
Can I set datetime value type? For example insurance date?
Regards
rosol

User avatar
johan
GpsGate
Posts: 15401
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: FEATURE: Custom Fields

Fri Oct 18, 2013 7:52 pm

DateTime is currently not a supported data type for Custom Fields. If you want us to prioritize that your request, please contact support @ gpsgate.com for a discussion.

Regards,
Johan

GpsGate Support

gpsgate.user
Posts: 68
Joined: Mon Sep 17, 2012 6:49 am

RE: FEATURE: Custom Fields

Fri Jan 24, 2014 6:06 am

Hi,

Just want to feedback.

when adding custom field and reorder then save the workspace, and refresh the page. The custom field back again to the last order.

Regards,
gpsgate.user

User avatar
Fredrik
Posts: 1159
Joined: Fri Mar 02, 2007 1:04 pm
Location: Sweden
Contact: Website

RE: FEATURE: Custom Fields

Fri Jan 24, 2014 4:07 pm

Yes, know about the ordering bug. It's on the todo-list.

Thanks for reporting.

Regards,
Fredrik Blomqvist

GpsGate Support

sene
Posts: 113
Joined: Sun Sep 08, 2013 1:58 am

RE: FEATURE: Custom Fields

Sat Jan 25, 2014 3:03 pm

Hi Guys,

Been going over custom fields. What do the two tick box do in the custom field in POI?. I see it but they don't have any labels.

Also

1. Are custom field searchable like title and description field in POI?
2. Can they be used in Event rules/reports?.


sene

User avatar
johan
GpsGate
Posts: 15401
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: FEATURE: Custom Fields

Sun Jan 26, 2014 8:04 pm

Yes, you can use Custom Fields in Event Rules.

Yes, you can use Custom Fields in reports. Here is how:
Add "Custom Fields" to reports - topic.asp?TOPIC_ID=16446

Regards,
Johan

GpsGate Support

Return to “GpsGate Server - How to setup and use”