Search found 4 matches
- Tue Mar 05, 2019 3:50 pm
- Forum: General Discussion
- Topic: Daily Report
- Replies: 1
- Views: 409
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...
- Tue Mar 05, 2019 3:30 pm
- Forum: General Discussion
- Topic: VRS and MS Access
- Replies: 2
- Views: 497
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...
- Tue Feb 26, 2019 11:03 am
- Forum: General Discussion
- Topic: VRS and MS Access
- Replies: 2
- Views: 497
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...
- Tue May 29, 2018 10:54 am
- Forum: Feature Suggestions
- Topic: Add database record
- Replies: 6
- Views: 2055
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
Dave