# Exporting hourly received reports **URL:** \ **Category:** ADS-B Flight Tracking\ **Created:** [December 1, 2020, 6:36pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427 "2020-12-01T18:36:16Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Dutchyb](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/dutchyb/32/136885_2.png) [@Dutchyb](https://discussions.flightaware.com/u/Dutchyb)\ **Post date:** [December 1, 2020, 6:36pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/1 "2020-12-01T18:36:16Z")
Good evening, I would like to export the hourly received reports. Would like to compare the number of planes I see. Of course I could make a print screen or something, but would like to export to Excel if possible. Does anyone know if this is possible. Or perhaps there is another option to export/save data from my feeder. Thanks ---
**Author:** ![rugomol](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/rugomol/32/113388_2.png) [@rugomol](https://discussions.flightaware.com/u/rugomol)\ **Post date:** [December 1, 2020, 7:09pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/2 "2020-12-01T19:09:23Z")
> [@Dutchyb](#): > > Excel for example [Download your statistics into MS Excel CSV format - #4 by foxhunter](https://discussions.flightaware.com/t/download-your-statistics-into-ms-excel-csv-format/69479/4) [Daily Log/E-Mail Aircraft Report directly on your RaspberryPi](https://discussions.flightaware.com/t/daily-log-e-mail-aircraft-report-directly-on-your-raspberrypi/25565) ---
**Author:** ![foxhunter](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/foxhunter/32/113733_2.png) [@foxhunter](https://discussions.flightaware.com/u/foxhunter)\ **Post date:** [December 1, 2020, 8:25pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/3 "2020-12-01T20:25:05Z")
I used the second script mentioned in the previous post for quite a while. The problem is that it counts unique aircraft only. If an aircraft passes your receiver twice but with different flight numbers (inbound and outbound), it is still counted only once. In the first link i suggested to setup a virtualradarserver which can be running on the same raspberry. This offers a database solution which logs all flights seen by your receiver. Or you can do the hardcore version: - Get the aircraft.json via cron job every few minutes and write it to a json file - Convert the json to CSV/Excel - Remove the duplicates where registration, flightnumber and datae are identical ---
**Author:** ![Dutchyb](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/dutchyb/32/136885_2.png) [@Dutchyb](https://discussions.flightaware.com/u/Dutchyb)\ **Post date:** [December 3, 2020, 2:04pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/4 "2020-12-03T14:04:50Z")
Thank you both for the reply. I have been “studying” the solutions you gave for the last two days. I am somewhat afraid to make the changes to my SD card. ( Afraid making stupid mistakes) I found an example of the VRS, but could not see the database example. As said I am interested in the hourly reports. Would that be possible in the database option in VRS? I know I have a awful lot to learn. ---
**Author:** ![wiedehopf](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/wiedehopf/32/114045_2.png) [@wiedehopf](https://discussions.flightaware.com/u/wiedehopf)\ **Post date:** [December 3, 2020, 3:26pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/5 "2020-12-03T15:26:20Z")
> [@Dutchyb](#): > > I have been “studying” the solutions you gave for the last two days. I am somewhat afraid to make the changes to my SD card. ( Afraid making stupid mistakes) Then create a new sd-card to experiment. If you’re done experimenting … switch back. ---
**Author:** ![Dutchyb](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/dutchyb/32/136885_2.png) [@Dutchyb](https://discussions.flightaware.com/u/Dutchyb)\ **Post date:** [December 3, 2020, 3:41pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/6 "2020-12-03T15:41:42Z")
Yes I know this solution, but thank you for reminding 😉 ---
**Author:** ![foxhunter](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/foxhunter/32/113733_2.png) [@foxhunter](https://discussions.flightaware.com/u/foxhunter)\ **Post date:** [December 3, 2020, 7:08pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/7 "2020-12-03T19:08:57Z")
> [@Dutchyb](#): > > As said I am interested in the hourly reports. Would that be possible in the database option in VRS? Not that i am aware of. The VRS database logs a flight/aircraft whenever it appears on the screen. So it is more a continous stream. Per default the database format is SQLite. With an appropriate tool you can export the data to e.g. Excel ---
**Author:** ![Dutchyb](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/dutchyb/32/136885_2.png) [@Dutchyb](https://discussions.flightaware.com/u/Dutchyb)\ **Post date:** [December 3, 2020, 8:24pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/8 "2020-12-03T20:24:15Z")
@foxhunter To convert the sqlite into Excel would not be a problem. There are great tools for that But I guess what I would like to “collect” is not possible. Well I could do it by hand of course. Writing down the details from the hourly reports. Will keep me busy and off the streets😉 Bu thanks anyway ---
**Author:** ![foxhunter](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/foxhunter/32/113733_2.png) [@foxhunter](https://discussions.flightaware.com/u/foxhunter)\ **Post date:** [December 3, 2020, 8:28pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/9 "2020-12-03T20:28:23Z")
The records do have several date/time stamps. You might be able to filter/group by this. If you’re interested i can share a DB file for testing purposes ---
**Author:** ![Dutchyb](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/dutchyb/32/136885_2.png) [@Dutchyb](https://discussions.flightaware.com/u/Dutchyb)\ **Post date:** [December 3, 2020, 8:47pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/10 "2020-12-03T20:47:32Z")
@foxhunter Oh that would be great. THANK you Will you it be sending here or in our other conversation! ---
**Author:** ![foxhunter](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/foxhunter/32/113733_2.png) [@foxhunter](https://discussions.flightaware.com/u/foxhunter)\ **Post date:** [December 4, 2020, 6:41pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/11 "2020-12-04T18:41:00Z")
I’ve sent you details via PN ---
**Author:** ![rugomol](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/rugomol/32/113388_2.png) [@rugomol](https://discussions.flightaware.com/u/rugomol)\ **Post date:** [December 5, 2020, 3:51am UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/12 "2020-12-05T03:51:00Z")
make backup > [@Cloning Booted RPi's microSD card on Windows PC through Network](https://discussions.flightaware.com/t/cloning-booted-rpis-microsd-card-on-windows-pc-through-network/66781): > > I have created a booted microSD card’s clone and saved the cloned image on Windows Desktop through LAN using following procedure: (1) On Windows computer, (a) created a folder rpi-clone to hold the cloned img files, (b) enabled Network Sharing, and ( c) granted sharing permission to folder rpi-clone. (2) On RPi, created a folder /home/pi/Windows-Share and mounted on it Windows shared folder rpi-clone. Mounted Windows folder rpi-clone to RPi folder /home/pi/Windows-Share ## IP address of Wind… ---
**Author:** ![Dutchyb](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/dutchyb/32/136885_2.png) [@Dutchyb](https://discussions.flightaware.com/u/Dutchyb)\ **Post date:** [December 5, 2020, 1:04pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/13 "2020-12-05T13:04:22Z")
> [@rugomol](#): > > make backup Thank you for the reply. Still learning:) Will create a backup on a USB on the Raspberry. As I am working on a Mac, things are a little bit different. ---
**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/discussions.flightaware.com/system/32/38558_2.png) [@system](https://discussions.flightaware.com/u/system)\ **Post date:** [December 5, 2021, 1:04pm UTC](https://discussions.flightaware.com/t/exporting-hourly-received-reports/71427/14 "2021-12-05T13:04:37Z")
Closed on December 5, 2021, 1:04pm UTC This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.