I need to export devices info to Excel

Et 5 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 Shelver 5 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.

Et 5 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 Tananaev 5 years ago

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

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