I need to pull this information via Javascript or PHP into an excel sheet on a monthly basis automatically for KPI purposes.

What method/object do I call from the MyAdmin SDK to get the current billing costs per device for all of the current devices in our account?

Hi everyone, Is there a way to get the total distance driven between two different dates (startDate and endDate) for all vehicles across multiple databases (10 different databases) one time? Maybe using Python? What/Where do I look to get this information via a Python script?

I want to Get total distance driven between two dates? (Across multiple MyGeotab databases with hundreds of vehicles)

page-user page-user-seth-pierce-1151 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Thank you, <a href="/user/jorge-pazrodriguez-1560" data-id="1560" data-value="jpaz-1560" data-denotation-char="@" class="text-decoration-none mention">@jpaz-1560</a>​ ​

I need to pull this information via Javascript or PHP into an excel sheet on a monthly basis automatically for KPI purposes.

Hi <a href="/user/ronald-perez-1094" data-id="1094" data-value="Ron-1094" data-denotation-char="@" class="text-decoration-none mention">@Ron-1094</a>​ and <a href="/user/joseph-yalenkatian-1062" data-id="1062" data-value="Joseph-1062" data-denotation-char="@" class="text-decoration-none mention">@Joseph-1062</a>​  Thanks for following up! <a href="/user/joseph-yalenkatian-1062" data-id="1062" data-value="Joseph-1062" data-denotation-char="@" class="text-decoration-none mention">@Joseph-1062</a>​, really appreciate all the input (I'm a Newbie with Python - Coding in general), but I'll definietly be spending some time over the next few days to get this done! Have a great evening guys and stay safe!

Update: I think I've been able to get the driven km by calling 'Trip', which contains the distance for the specified period. However, I'm getting an error and hoping anyone here can assist. The error is NameError: name 'client' is not defined and the code snippet is below. Thanks in advance. <code>def get_geotab_dataframe(db):
 client = mygeotab.API(username=GEOTAB_USERNAME, password=GEOTAB_PASSWORD, database=db)
 client.authenticate()
 
results = client.get("Trip", search = {"fromDate": "2020-01-01T00:00:00.000Z",
 "toDate": "2020-01-31T00:00:00.000Z"})
 
for db in GEOTAB_DATABASES:
 df = get_geotab_dataframe(db)
 
 
df = pandas.DataFrame(results)
df.to_csv("sgiodometer3.csv", encoding='utf-8', index=False)
print(df)</code>

Hi everyone, Is there a way to get the total distance driven between two different dates (startDate and endDate) for all vehicles across multiple databases (10 different databases) one time? Maybe using Python? What/Where do I look to get this information via a Python script?

Nesenās aktivitātes

What method/object do I call from the MyAdmin SDK to get the current billing costs per device for all of the current devices in our account?

I want to Get total distance driven between two dates? (Across multiple MyGeotab databases with hundreds of vehicles)