I've recently modified a report template and tried to upload it as a new report but I keep hitting the error message "The report template must be saved using Microsoft Excel".The template is definitely in .xlsx format (I've saved using both MS Excel online and also in Libre Office -&gt; Save as .xlsx) so I'm wondering if there is some way of getting further information into the problem with my template e.g. can you point me at the validator you are using?I've previously has no problems modifying templates and uploading like this so any help would be gratefully received.Many thanks

MyGeotab Error: The report template must be saved using Microsoft Excel

Is there a way to add a Custom Device into a database via the API?  I've tried doing this using a Set:CustomDevice and get the following issue which makes me think not?`NotSupportedException: Cannot find bridge for Geotab.Checkmate.ObjectModel.CustomDevice` I see a similar error if I try to read a CustomDevice via the API too.

Adding a Custom Device via the MyGeotab API

page-user page-user-allan-hodkinson-1929 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Hi <a href="/user/eishifun" data-id="1044" data-value="EishiFUN" data-denotation-char="@" class="text-decoration-none mention">@EishiFUN</a>​ ,Thanks so much for the quick response. Yes that is definitely the problem!I can resolve it by unzipping the .xlsx package and changing the &lt;Application&gt; field and then zipping the package back up. The upload then succeeds and the template seems to work. Many thanks,Allan

I've recently modified a report template and tried to upload it as a new report but I keep hitting the error message "The report template must be saved using Microsoft Excel".The template is definitely in .xlsx format (I've saved using both MS Excel online and also in Libre Office -&gt; Save as .xlsx) so I'm wondering if there is some way of getting further information into the problem with my template e.g. can you point me at the validator you are using?I've previously has no problems modifying templates and uploading like this so any help would be gratefully received.Many thanks

Hi Ajay,Thanks for getting back to me &amp; the info you sent over.So I'm trying the following method now (JavaScript)<code>await api.call('Add', {
 typeName: 'Device',
 entity: {
 Comment: "Testing",
 DeviceType: "CustomDevice",
 Id: "f4037aba-4d03-4482-bfe7-f73bd2f3b052",
 TimeZoneId: "Europe/London",
 ProductId: 10032 // from https://developers.geotab.com/myGeotab/guides/usingCustomTelematicsDevices#automating-tasks
 }
 });</code> Without the ProductId the request is rejected with a validation error so I have used 10032 as suggested in the docs. But now I see the error:Error: ArgumentException: DeviceType Geotab.Checkmate.ObjectModel.Device is not consistent with the Product ID 10032. The required type is Geotab.Checkmate.ObjectModel.CustomDevice. And If I try to use typeName: 'CustomDevice' , I get back to the original error:Cannot find bridge for Geotab.Checkmate.ObjectModel.CustomDevice Many thanks,Allan

Is there a way to add a Custom Device into a database via the API? I've tried doing this using a Set:CustomDevice and get the following issue which makes me think not?`NotSupportedException: Cannot find bridge for Geotab.Checkmate.ObjectModel.CustomDevice` I see a similar error if I try to read a CustomDevice via the API too.

Recent Activity

MyGeotab Error: The report template must be saved using Microsoft Excel

Adding a Custom Device via the MyGeotab API