Page 1 of 2

FEATURE: Custom Fields

Posted: Sat May 18, 2013 5:16 pm
by johan
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

RE: FEATURE: Custom Fields

Posted: Sun May 19, 2013 4:54 am
by piter197
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

RE: FEATURE: Custom Fields

Posted: Sun May 19, 2013 11:18 am
by johan
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

RE: FEATURE: Custom Fields

Posted: Sun May 19, 2013 12:53 pm
by piter197
IIS and NMEA error log files have been sent to support, please help. Thank you.

Best Regards,
piter197

RE: FEATURE: Custom Fields

Posted: Sun May 26, 2013 7:21 am
by piter197
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

RE: FEATURE: Custom Fields

Posted: Mon May 27, 2013 11:45 am
by johan
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

RE: FEATURE: Custom Fields

Posted: Mon May 27, 2013 3:13 pm
by piter197
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

RE: FEATURE: Custom Fields

Posted: Mon Jul 15, 2013 3:27 am
by jdewitt
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

RE: FEATURE: Custom Fields

Posted: Wed Jul 17, 2013 3:51 pm
by Strid
Hi,

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

Regards,
Robin

GpsGate Support

RE: FEATURE: Custom Fields

Posted: Fri Oct 18, 2013 7:48 pm
by rosol
Hi,
Can I set datetime value type? For example insurance date?
Regards
rosol

RE: FEATURE: Custom Fields

Posted: Fri Oct 18, 2013 7:52 pm
by johan
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

RE: FEATURE: Custom Fields

Posted: Fri Jan 24, 2014 6:06 am
by gpsgate.user
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

RE: FEATURE: Custom Fields

Posted: Fri Jan 24, 2014 4:07 pm
by Fredrik
Yes, know about the ordering bug. It's on the todo-list.

Thanks for reporting.

Regards,
Fredrik Blomqvist

GpsGate Support

RE: FEATURE: Custom Fields

Posted: Sat Jan 25, 2014 3:03 pm
by sene
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

RE: FEATURE: Custom Fields

Posted: Sun Jan 26, 2014 8:04 pm
by johan
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