Hello CommunityI starting to use the database MyqGeotab API Adapter and Api OPtimizer and have a couple of questions about the data model.1.- In the Optimizer db I have the [DiagnosticsT] with the [DiagnosticCode] which is really useful for our case, but I want to link them to he corresponding RuleiD and cannot see how to relate this code within the db.  2.- I want to use the user groups to classify the exceptionevents, in the users table there's no information about the user groups, where is this information in the db? Thanks in advance for your help

Data model MyGeotab API Adapter &#x2F; Optimizer

Data model MyGeotab API Adapter / Optimizer

I'm trying to add new drivers but allways get this error message, no way to find out what's the problem, any help?Error adding user: 'TORO MELLA, RODRIGO'WebServerInvoker exception in a call to 'Add': GenericException An undefined exception has occurred. Please contact support for further assistance Thnks

Error adding drivers with MyGeotab SDK

page-user page-user-jordi-vera-1874 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Hi SteveD, thanks but one basic question, the ExceptionEvents table of the Adapter is the Statusdata table in Optimizer, is rigth?Even this I'm not able to find the driver and deviceid of an entry of the statusdata table, the following query allways shows driver and deviceid blank SELECT StatusDataT.DriverId, StatusDataT.DateTime, StatusDataT.DeviceId  FROM [GeotabO].[dbo].[DiagnosticsT]  left join StatusDataT on [DiagnosticsT].[id] = [DiagnosticId] left join DiagnosticIdsT on [DiagnosticsT].[GeotabGUID] = [DiagnosticIdsT].[GeotabGUID] left join FaultDataT on FaultDataT.DiagnosticId = [DiagnosticsT].[id] where [DiagnosticsT].[DiagnosticCode] = '479'    code 479 --&gt; (Brake fluid level is low) Thanks

Hello CommunityI starting to use the database MyqGeotab API Adapter and Api OPtimizer and have a couple of questions about the data model.1.- In the Optimizer db I have the [DiagnosticsT] with the [DiagnosticCode] which is really useful for our case, but I want to link them to he corresponding RuleiD and cannot see how to relate this code within the db.  2.- I want to use the user groups to classify the exceptionevents, in the users table there's no information about the user groups, where is this information in the db? Thanks in advance for your help

Hello, this what I do, but I get a generic error without any detailed message.If I remove the username then I get an error that username is missing but if I put it then get a generic errorPlease find attached the json I useThanks<a href="/forum/plugins/gcs-uploads/files/069N3000008gKCDIA2.json" target="_blank"> 069N3000008gKCDIA2.json</a>

I'm trying to add new drivers but allways get this error message, no way to find out what's the problem, any help?Error adding user: 'TORO MELLA, RODRIGO'WebServerInvoker exception in a call to 'Add': GenericException An undefined exception has occurred. Please contact support for further assistance Thnks<img src="/forum/plugins/gcs-uploads/files/069N3000008fFBNIA2.png" alt="error_geotab_osoft" />

Recent Activity

Data model MyGeotab API Adapter / Optimizer

Error adding drivers with MyGeotab SDK