Search found 4 matches

by oakview
Tue Mar 05, 2019 3:50 pm
Forum: General Discussion
Topic: Daily Report
Replies: 1
Views: 250

Re: Daily Report

Hi, I get report to show all rows then copy/paste the data into Notepad++, save as a .txt file, then import into an Access table with the field titles as report uses set. I have found that Excel corrupts ICAO numbers (4074E3 ends up as 4074000) plus it adds random characters to names (Götaverken) f...
by oakview
Tue Mar 05, 2019 3:30 pm
Forum: General Discussion
Topic: VRS and MS Access
Replies: 2
Views: 325

Re: VRS and MS Access

Hi, Firstly thank you for the help. I have downloaded/installed DB Browser for SQlite, made a copy of the main RPi's BaseStation.sqb file to mess with. As you say everything is there I need. I'm looking into ways of grabbing the time filtered aircraft data into a txt file that can be imported into A...
by oakview
Tue Feb 26, 2019 11:03 am
Forum: General Discussion
Topic: VRS and MS Access
Replies: 2
Views: 325

VRS and MS Access

Hi, I have 2 RPi receivers merging to my VRS. From this I create a daily "flights" report that I convert into a text file that I import to my Access database. After a year I now have a collection of over 15,500 aircraft and over 750,000 flights, importing the daily flights isn't a problem plus it gi...
by oakview
Tue May 29, 2018 10:54 am
Forum: Feature Suggestions
Topic: Add database record
Replies: 6
Views: 1781

Re: Add database record

I've just been trying to add the BBMF aircraft to my database and found that you can't add some aircraft. I wonder if there is a way to add them with SQL? Not that I have a clue how to do that, just throwing ideas on the table...

Dave