I need to export devices info to Excel

Et4 years ago

Hi there. I want to add a device but have a suspicion that somewhere an IMEI was duplicated before capturing into TRACCAR. Now when i want to capture a device it seems the IMEI was already captured before. Is there a function to export all devices (IMEI, Registration, Cell and other info) from web platform so that i can check all devices IMEI in Excel?

Tony Shelver4 years ago

We pull device changes from the API or (all devices) directly from the database, using a python program. From here we update our own DB.

If you have direct access to the database, you could run an SQL statement or use a front end database editor (depending on the DB) to extract this data to file (some support straight to Excel).

We also use the python openpyxl library to directly write formatted / calculated / subtotalled reports to Excel files.

Takes a little programming if you go the python route, not difficult if you have some knowledge of python.

Et4 years ago

Thank you. Can you add in the reporting section devices and then device info and status? I mean for a future release? For now i requested an export from SQL from IT.

Anton Tananaev4 years ago

There's an API that can give you all devices.

As for adding a new report, please use GitHub for feature requests.