Thursday 22 August 2024

Depot, Geography & Location Terminology Updates

Depots have traditionally represented various physical points such as warehouses, ports, terminals, and airports, where consignments are picked up or delivered. To better reflect the diverse range of these physical points, we are renaming Depots to Locations. This change is purely terminological, with no impact on functionality. You can still assign GPS coordinates for precise locations if needed.

In line with this update, the Depot Type master data field will be renamed to Geo Data. This field will now accommodate any type of geographical location when added to the workflow data. You can select this Geo Data type using the drop-down menu present when editing the field. Additionally, the Custom Filter field remains available for TrakIT Support to further refine selections.

The previous Location field, which allowed place lookups using Google, will now be renamed to Google Places.

GPS Location of Assets and Users is now renamed to Position.

We apologize for any inconvenience this change may cause, but we believe it better aligns with the evolving data requirements in TrakIT.

Here is a summary of the renamed fields:

Old Field New Field
Depot Location
Geographical Location     Geo Data
Location Google Place
Asset/User GPS Location Position


For any questions or concerns, please contact TrakIT Support.





Thursday 15 August 2024

Connect TrakIT with Power BI, Tableau, Google Data Studio and other Dashboarding tools

With the recent update of TrakIT, you can now use your TrakIT installation as a real-time data source for Dashboarding software such as Power BI, Tableau, Google Data Studio and many more.





Configuring the Data Source

TrakIT does not allow direct connections to its database. However, TrakIT can expose any information via a web API endpoint that can be used to retrieve information from specifically designed query reports.

The API endpoint must be in the following syntax:

https://trakit.[yourcompany.com]/api/public/queryreport?APIKey=[YourKey]&RepID=[ReportID]&AsFile=true

Replace the highlighted parts above with the correct information. Please connect with the TrakIT Support team to obtain your API Key and Report ID. The "AsFile" parameter allows you to directly get the report in the designed format (xlsx, csv or txt). If set to false, the API responds with Json format data.

Please note that the above endpoint is accessible from the web to anyone who has the URL and hence must be kept strictly confidential.


Embedding the Dashboard in TrakIT

If the dashboard software you use has the capabilities for embedded dashboards, please let us know the embedded Url for your dashboard and we can include the dashboard in any internal dashboard page in TrakIT.


For any questions or concerns, please contact TrakIT Support.