AirNav Systems Forum
AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: 9M-ISJ on November 16, 2008, 11:07:16 PM
-
Hi,
I have been an SBS-1 user almost since their product launched, indeed it has been taken all over the world with me, but now I am very seriously thinking of switching over to RB (a number of reasons, not the least of which is the size of the unit itself)
Anyway, I have a few questions and searching the forum here hasnt entirely answered them so I was hoping you guys wouldnt mind me asking out right -
Firstly, I would very much like to carry over all the aircraft my SBS-1 has picked up into the RB system. Is this possible? Further, right back at the outset of my SBS-1 life I imported one of the 'populated' files (to input the vast majority of 'common' aircraft) and I WOULDNT want to import all of this to RB - only the examples which I have actually picked up. Is that possible, supposing that its possible to do at all!
Secondly, a very minor thing,, but is it possible to change the field on RB which shows the aircraft status from simply showing the word 'climbing' or 'descending' to show arrows pointing in the appropriate direction as per SBS-1??
Lastly, as I say I have used my SBS-1 numerous times on spotting trips. In the US I have always found that the map is all but useless - as next to nothing over there plots anyway. Is it possible to more or less get rid of the map and just have the aircraft list while using RB?? (and as an aside to this, what shows in the aircraft picture box if you are not connected to the internet - as is often the case in hotel rooms)??
Thanks
-
Hi
Thanks for your email. During the last months we got hundreds of users migrating from SBS-1 to RadarBox. In fact most of our dealers report that at the present time for each 5 RadarBox sold, SBS-1 sells 1 unit.
SBS-1 was the first mode-s receiver on the market. Anyway it didn't have any important upgrade for the last 3 years. We consider it totally outdated. One of the most important factor on this kind of products is the quality of the software and how often it gets updated. AirNav Systems has been developing flight tracking software for professional and non-professional users for the last 11 years so we can easily be trusted in this field.
Regarding hardware: RadarBox is smaller, easier to carry and reliable (metal case instead of SBS-1 plastic cover).
To start have a look at our RadarBox vs SBS-1 comparison kit on the link below:
http://www.airnavsystems.com/forum/index.php?topic=606.0
Answering your questions:
1- You can import all your old contacts on the MyLog window of AirNav RadarBox software.
2- Not possible now but added to our wish-list. You will find that at AirNav Systems we add new features resulting from users suggestions. Ask our users and you will see their feedback. We are here to develop a product that meets users needs and we will always do our best to achieve what users want.
3- You can opt to hide the map. Anyway RadarBox 2009 software comes with the possibility of downloading a NASA picture so you can plot aircraft over it. For example if you are traveling to Dallas you can click the download NASA overlay button and you will see aircraft right in the runways/taxiways/fingers at the airport. Also we do have an extensive list of airport outlines available created by our own users.
For outlines check:
http://www.airnavsystems.com/forum/index.php?topic=717.0
And to finish with RadarBox you will get outstanding support: not only from the Developing/Programming team but also from our Support (average of 6 hours in answering tickets) and our users, more and more each day.
Hope to have you with us soon!
-
Hi,
Great news and thanks for the feedback.
I have done a deal with the gentleman selling the used unit on another thread, so I will be joining the 'gang' by the end of the week with luck.
Is it easy to import my log file from SBS-1?? Also, is it possible to import more than one and not have one over write the other, but add to it?? (I went to Japan, Oz, Fiji, and LA and managed to produce a log file afresh rather than adding to my existing one - it would be nice to bring over all of those aircraft now)
Also I take it that it isnt a problem that I populated my Basestation file with all the regs from one of the started databases??
Thanks
Paul
-
Paul
You won't be disappointed, welcome to the group
Malc
-
Thanks Malc,
Still worrying about the mechanics of importing my Basestation file(s) but hey ho!!
-
Paul
As far as i am aware the import of SBS-1 data can be easily done. I'm sure I have read somewhere on this forum of how to do it.
There are much greater sages on this site than me and I'm sure they will correct me and give you any help you require if I'm wrong.
Malc
-
Hi,
I hope so, worst comes to worse I will just have a bit of trial and error. I can always roll it back and start afresh if things dont work out how I want.
Rgds
Paul
-
Still worrying about the mechanics of importing my Basestation file(s) but hey ho!!
It's very straightforward. Goto MyLog, and on the Tools menu select "Import from SQB". Select the Basestation SQB file, and it imports it. But only ONE SQB file can be imported - when you import, it deletes everything that's in the log.
If you've got several Basestation files, you'll need to combine them into a single SQB before importing - see SabreJV's posting on the Kinetic forum at http://www.kinetic-avionics.co.uk/forums/viewtopic.php?t=4446
It is possible to take aircraft records from one database and add them to another using a batch file SQL script and SQLite3.exe to drive the process. Only aircraft not in the target database will get added. Obviously it goes without saying only copies of each sqb file must be used.
SQLite3.exe can be obtained from http://www.sqlite.org/sqlite-3_4_0.zip
Create a new folder called something like c:\Merge
Into c:\merge copy the SQLite3.exe and SQLite3.dll.
Then copy or create in this folder a file named merge.bat
sqlite3.exe < merge_script.txt
pause
and a file named merge_script.txt
.echo on
attach database 'c:\merge\Merge.sqb' as Merge;
attach database 'c:\merge\Basestation.sqb' as Master;
create table Master.Merge_Aircraft as select * from Merge.Aircraft;
detach database Merge;
Delete from Merge_Aircraft where Aircraftid in (Select Merge_Aircraft.Aircraftid from Merge_Aircraft join Aircraft where Aircraft.ModeS = Merge_Aircraft.ModeS);
Update Merge_Aircraft set Aircraftid = null;
Insert into Aircraft select * from Merge_Aircraft;
Drop table Merge_Aircraft;
Pragma Integrity_Check;
Decide which database will be become your 'master' database after the merge, and copy this sqb file into c:\Merge as Basestation.sqb. The reason is this database will retain its aircraft, flights and sessions intact.
Next the database from which aircraft will be extracted is copied into c:\merge as Merge.sqb.
run the merge.bat file.
-
Cool!! Thanks for this.
Will the fact that my Basestation file(s) are prepopulated with one of the starter databases of registrations matter to RB?
(One thing I always hated about SBS-1 was that once I populated it with 'everything' it bascially killed off my chances of seeing what my unit had picked up - as it counts them all in!)
-
Hi,
Just tried to import my Basestation file, and its sort of worked.... and sort of not!
I had 40 thousand odd airframes picked up in my Basestation file, and in mylog file now I sort of have them all,, but it seems to have only brought over the fact that the frames have once (at some point - the dates seem all over the place) been picked up.
It certainly hasnt imported multiple pick ups for the same frames (take any BA plane as an example - it is in my Basestation doing hundreds of flights but is now in my Mylog just with a random date and no flight data at all).
Has anybody else had more luck at importing - I am thinking about wiping the slate clean and starting to build up a picked up database afresh with RB (but it is a bit of a shame - as I have some corkers in the Basestation data)
Gulfstream
-
Related to your problem, I'm sure our support will help you.
Just one suggestion: what about changing this post topic to "Just switched from SBS-1"? :-)
-
Hi,
It is done!
Gulfstream
-
Great. :-)
We are now having an average of 2 users upgrading from SBS-1 to RadarBox per day. I'm sure this will increase in the near future.
-
We are now having an average of 2 users upgrading from SBS-1 to RadarBox per day. I'm sure this will increase in the near future.
That's an interesting statistic - but like all statistics it begs the question "how do you know?", and in particular what do you mean by "upgrading"?
For example, it's no secret that I'm a longtime SBS-1 user - I have one of the very first batch - and for a time I was on the Kinetic beta test team (in the days when they bothered to beta-test new releases!).
But if I were subsequently to acquire a RadarBox, it would be as an adjunct to my SBS rather than a replacement/upgrade - would I nevertheless be automatically classed as an "upgrade" statistic?
As far as I can see, there are things that RadarBox does better, and/or more easily, than SBS, and equally things that SBS does which RadarBox doesn't, so I can certainly see a place for both in my computer den. For example, and correct me if I'm wrong, no-one has developed a RadarBox add-on that gives access to the raw Mode S packets, which is an essential feature when developing low-cost multilateration solutions.
Still, if RadarBox is displacing SBS to the extent being suggested, I look forward to picking up a couple more from the flood of bargain-price units on the second-hand market for my MLat network :-)
-
We do consider that RadarBox is an upgrade to our competition.
Most of our dealers and users think the same.
The reasons are well explained in the document below:
http://www.airnavsystems.com/download/anrb/AirNav%20RadarBox%20vs%20Competition.pdf
We maintain a constant contact with all the shops and that sell RadarBox. Also 90% of the users that buy the product from airnavsystems.com leave a comment on why they decided to buy RadarBox - because they had SBS-1 and that system got totally outdated. This is now widely known in this market.
Just to name a few differences:
- Support that really works: we have an average 8 hour response time on our support email and a forum that is growing at a rate 3x compared with our competition where daily interesting topics being discussed and happy users helping newbies - unlike our competition forum where posts mentioning RadarBox often get deleted. Also you will see here the programmers developers changing opinions with day-to-day users unlike Kientic crew that constantly hides from everyone.
- New versions/upgrades/implementation of customer suggestions: we have maintained a rate of an upgrade each 4 months. Kinetic/ML&S have the same - let me say it again - Spectrum like software (Basestation) for the last 3 years.
- Superior graphics with NASA overlays (BTW because of this SBS-1e has recently been advertised with screen shots of Google Earth that are not supplied in the product - we are still considering taking legal action on this if the situation is repeated);
- Network: SBS-1/ML&S spent 2 years lying to their customers about a feature that they were never be able to develop. We have it on our software.
- All in one package: no need to install 100 (some of them unreliable) addons to have the software performing as you want;
Regarding your mention to raw data/mode-s packets I don't think that is of much interest to 99.9% of the users. For the others there are AirNav Systems Professional solutions: expect some great news from this area in the next months.
And most of all we don't lie to our customers (network feature, prices, deleting forum posts, not answering phone calls and emails, rarely having the development team talking with customers, etc).
We are here to have a better product and something that makes a real difference in this market. We will continue to work to add more features to the software and turn it into a more reliable one.
We do think this is a real upgrade and again, for a technical comparison please check:
http://www.airnavsystems.com/download/anrb/AirNav%20RadarBox%20vs%20Competition.pdf
-
I really don't have any use for my SBS-1 now, and the only thing stopping me from selling it really is my tendency to keep all my old radio/computer/photography kit. I did run it a month or so back for software testing, but as I'd rebuilt my hard drive since I'd run it last, I was frankly shocked at how basic the display was. In fact, without going through all the back posts on the Kinetic forum, I couldn't honestly remember what 3rd party programs I had to install to get a usable display.
I get everything that I need and more from my RadarBox. It's running on my primary PC screen now whilst I type this using the secondary LCD monitor. I've got my alerts set up as I want, I'm uploading the screen by FTP to my website and the Network traffic is giving me the extra coverage that I need to see beyond my live range. Without going into every advantage that RadarBox gives me, the alerts, FTP upload and Network traffic are just the first things that come to mind - all standard RadarBox functions, but none of these are available with the SBS-1.
When I go back down to London on Sunday evening, I'll throw the RadarBox reciver and USB cable into my bag and plug it into my laptop and standard antenna that I keep down in my weekday accommodation. Walk in the door, fire up the laptop and I'm watching the Heathrow traffic, fantastic :-)
I'm following the thread on the SBS-1e on the Kinetic forum and as far as I can see, it doesn't seem to be generating much excitement right now. Although the receiver bit of any Mode S package is always going to be important, it's the software and the user interface that are really going to make the difference at the end of the day. RadarBox is so far ahead of the competition in this area, that it's almost unfair to compare the 2 products.
Just my opinion, but as a user of both boxes, this is how I see it.
Allocator
-
We do consider that RadarBox is an upgrade to our competition.
OK, I understand now - you're not using the word "upgrade" in the normal sense (i.e. moving from one product or service to a better one), you're including all new customers who have a choice between buying SBS and RadarBox and choose to buy RadarBox (which isn't the same thing at all). I don't dispute any of your comments about the respective products or companies, by the way.
Also 90% of the users that buy the product from airnavsystems.com leave a comment on why they decided to buy RadarBox - because they had SBS-1 and that system got totally outdated.
But I do have a problem with this statement - am I reading it correctly, 9 out of 10 people buying RadarBox from you previously had an SBS? That's hard to believe given that only a handful of forum members such as Allocator, Tarbat and a few others are recognisable from the Kinetic forum, or make any mention of having had an SBS.
Don't get me wrong, I'm not defending Kinetic or indeed seeking to knock RadarBox/AirNav, but when accusing a competitor of lying it's as well to ensure that your own statements are 100% truthful.
-
I think that's meant to say 9/10 people have looked at the SBS as an alternative and realised it was outdated.
-
I think that's meant to say 9/10 people have looked at the SBS as an alternative and realised it was outdated.
This sums up my position. I ordered RB having seen how outdated the SBS-1 appeared, but mainly because RB appeared simpler to plug in and use. I'm a technophobe and when discussing SBS-1 and ini. files and 'point your files' etc I nearly fainted!!
I'll give an honest appraisal of RB - setting up from start to finish on this forum - when it arrives1
-
On the airnavsystems.com order pages there is a check box for users to state they already have a mode-s receiver. If they check this box they usually leave a comment saying why they changed. 90pct of the users check that box and comment that SBS-1 is an outdated product without any kind of support.
-
Well make up your mind !
In two successive posts you have stated that:
a) 90% is the proportion of AirNav users who have looked at the SBS before deciding that it was outdated and buying RadarBox instead (which sounds perfectly reasonable)
and then:
b) 90% is the proportion of AirNav users who ticked the box to say that they already had a Mode S receiver (i.e. SBS) prior to buying RadarBox (which is no more believable than when you said it first time round)
-
Its b)
No need to blow it out of proportion. I know everything we say on here is scrutinized but we are human :)
-
Are Good Old DaveReid - I new I was missing something from the Kinetic forum - never wrong
-
Are Good Old DaveReid - I new I was missing something from the Kinetic forum - never wrong
On the contrary, I'm often wrong, but I've never discovered the secret to holding two contradictory opinions at the same time :-)
-
I previously owned a SBS-1 and have found the visual interface of the radar box program much easier to use and more pleasing to the eye. I managed to get up and running without reading the manual and have only referred to it when I have found it necessary to do so.
I am not certain other users will agree but in my location the radar box gives better coverage than my previous SBS-1 using the supplied mag mount antenna.
As a photographer I really like the photo image display and the ability to be notified when a particular aircraft is on-route.
I should also add how helpful members of this forum have been. Thanks!
-
Hi all, I've opted for the RB (winging its way from Maplins at this very moment @£374 incl. delivery - a week's wait for supplies to come in, but stock now available!) but I've been doing my homework, and the advantages of the RB over the SBS1, seem to be enormous - the support in here is fantastic. In the 2 quotes DaveR is picking fault with, I note one comes from ANsupport and the other from ANDevelopment, yes, they should be saying the same thing at the same time, but the fact they actually contradict/correct the comments, is to my mind at least, a demonstration of the openness and honesty which is so apparent in this forum - a major factor in me going for the RB. Paying visits to both forums, it seems certain handles crop up and will be mixing it. I don't think there's anything of malicious intent in DaveR's comments, just trying to get a 100% clear confirmation of what is being claimed, but a couple of others do seem to be over-pedantic, critical and nit-picking. These are allowed to remain on view here, but similar comments are censored and sometimes removed from the Kinetics site.
I'm 100% sure I've made the right choice, and look forward to 25/12 when I can get cracking. I won't be getting on the network, until I've got an external antenna and dedicated PC on line - I've still got to rebuild my main desk-top Athlon XP2000 with 4GB RAM, the RB dedicated PC will be Athlon 1800 with 1GB and USB2 PCI card in the loft, - both running XP - I assume these will be adequate.
-
CoastGuardJon
I am a ex SBS-1 user, and I could not agree with you more, and agree with all the other comments made on this thread about the SBS-1.
Andy
-
Hi Dave. We do have exact stats on our online orders and from them "b) 90% is the proportion of AirNav users who ticked the box to say that they already had a Mode S receiver (i.e. SBS) prior to buying RadarBox (which is no more believable than when you said it first time round)" is totally correct.
We also get many professional contacts buying RadarBox for professional purposes because, constantly, companies report Kinetic/SBS are too arrogant, not reliable and don't have any kind of support for more than 1 year.
To be honest: who cares??? We are growing, our users are happy, we keep working, this forum is full of interested people and getting busier each day.
There is no better thing to do what you love to do and all the AirNav team, fortunately, thinks like that. Let's hope 2009 brings us more surprises, starting with ShipTrax!
-
Hi Dave. We do have exact stats on our online orders and from them "b) 90% is the proportion of AirNav users who ticked the box to say that they already had a Mode S receiver (i.e. SBS) prior to buying RadarBox (which is no more believable than when you said it first time round)" is totally correct.
Thank you for that - noted.
Do you have a ballpark figure for the resulting number of SBSs which users have replaced with RadarBoxes (i.e. the 90%) ?
-
Hi Dave. We do have exact stats on our online orders and from them "b) 90% is the proportion of AirNav users who ticked the box to say that they already had a Mode S receiver (i.e. SBS) prior to buying RadarBox" is totally correct.
Thank you for that - noted.
Do you have a ballpark figure for the resulting number of SBSs which users have replaced with RadarBoxes (i.e. the 90%) ?
Hmmm, embarrassed silence ...
Don't your "exact stats" enable you to say whether the 90% of purchasers who have replaced SBS with RadarBox represent dozens/hundreds/thousands of users ? That seems a simple enough question to me.
-
Its not a embarrassed silence Dave. We were just not happy in giving an exact figure and starting a slagging match between companies.
Why would we be embarssed, do we see customers moving from RB to SBS, nope, do we see customers moving from SBS to RB, of course.
However the numbers are in Hundreds, bearing in mind we have sold nearly 2000 RBs thats a fair percentage.
-
Hi All,
Newbie here, just reading the forum for latest news , tips etc.
Came across this thread !
As an onlooker to all this, Dave Reid seems to have posted a few messages on this forum for someone who hasnt got an ANRB !!
As AirNav say who cares, lets just get on with the hobby we all enjoy.
At the end of the day its all about making the choice that suits that person best.
Regards
Phil
-
However the numbers are in Hundreds, bearing in mind we have sold nearly 2000 RBs thats a fair percentage.
OK, I'll take you at your word. I'll look out for a flood of second-hand SBSs on Ebay (there's only one being offered at the moment).
As an onlooker to all this, Dave Reid seems to have posted a few messages on this forum for someone who hasnt got an ANRB !!
I don't recall saying I that don't have an ANRB. Maybe I've got one and simply haven't needed to ask any tech support type questions :-)
Actually, on second thoughts I do have a technical question - how would you capture network flights data into a database ?
-
Dave, I'd imagine that most would keep their SBS-1 rather than sell it.
And no, there's no way of capturing network flight data into a database. But at least you get network flights with a Radarbox, whereas MapModeS has failed to materialise on the SBS-1, so NO network flights at all on the SBS-1.
-
We are now having an average of 2 users upgrading from SBS-1 to RadarBox per day. I'm sure this will increase in the near future.
That's an interesting statistic - but like all statistics it begs the question "how do you know?", and in particular what do you mean by "upgrading"?
For example, it's no secret that I'm a longtime SBS-1 user - I have one of the very first batch - and for a time I was on the Kinetic beta test team (in the days when they bothered to beta-test new releases!).
But if I were subsequently to acquire a RadarBox, it would be as an adjunct to my SBS rather than a replacement/upgrade - would I nevertheless be automatically classed as an "upgrade" statistic?
As far as I can see, there are things that RadarBox does better, and/or more easily, than SBS, and equally things that SBS does which RadarBox doesn't, so I can certainly see a place for both in my computer den. For example, and correct me if I'm wrong, no-one has developed a RadarBox add-on that gives access to the raw Mode S packets, which is an essential feature when developing low-cost multilateration solutions.
Still, if RadarBox is displacing SBS to the extent being suggested, I look forward to picking up a couple more from the flood of bargain-price units on the second-hand market for my MLat network :-)
[/quote
I think the words "but if I were subsequently to acquire a Radar Box" suggest you havent got one :-)
-
If you want access to the network data we do have a specfic details for our Proffesional customers. Please contact our sales team if you are intrested.
-
I think the words "but if I were subsequently to acquire a Radar Box" suggest you havent got one :-)
To quote Wikipedia: "the past subjunctive is sometimes used in expressing situations that are not necessarily contrary to fact"
-
As a newbie and still awaiting delivery of my ANRB having discarded any thought of SBS-1 for personal reasons, can I suggest we leave this discussion behind. Air Nav appear to provide exceptional support towards the RB and from what I've read, most people are very happy with their RB product and the level of support AirNav and their many users provide via this forum.
Lets enjoy the RB, I'm sure many SBS-1 users are happy as well, so lets move on.
Cheers Paul
-
And no, there's no way of capturing network flight data into a database.
Thanks, Chris.
Were I a RadarBox user, I'm sure that's the kind of technical challenge I wouldn't be able to resist :-)
-
Hi,
Can I go back to my last question (before a cuckoo in the nest sort of hijacked the thread...)??
I am still interested in bringing over my old Basestation data, and loading it up with my month or so of Mylog 'captures'
As I said way back in this thread I tried doing so with the ANRB built in 'import' feature and had mixed results.
I dont mind buying one of the SQL editing progs if needs be. What I want to do is simply bring over the fact that an aircraft was once picked up, I am not too bothered about how many times or doing what flights..
First thing I need to do is strip out the frames picked up from all the clutter in my Basestation file (I populated it with one of the 'one size fits all' starter databases - which I wish I hadnt)
As I say I dont mind spending on the editing prog - as long as there is a point to it!
Cheers
-
9M-ISJ, you should be able to use SQLite Maestro to export aircraft from your Basestation Flights and Aircraft tables, and import that into you MyLog Aircraft table. Just don't populate the MyLog Flights table.
Something like this:
SELECT DISTINCT
"" AS Comment,
Aircraft.Type AS AircraftTypeLong,
Aircraft.FirstCreated AS FirstTime,
Aircraft.ICAOTypeCode AS AircraftTypeSmall,
Aircraft.RegisteredOwners AS Airline,
Aircraft.ModeS,
Aircraft.ModeSCountry,
Aircraft.Registration,
"" AS ADSB,
Aircraft.LastModified AS LastTime
FROM
Flights
INNER JOIN Aircraft ON (Flights.AircraftID=Aircraft.AircraftID)
-
Hi,
And once I have done that how will an aircraft which has been picked up both by the old SBS-1 and the RB show up in Mylog?
Would SQLite Maestro be useful for tackling aircraft in my data with the short type showing as ... or would you recommend using the inhouse database editor (trying to find another longer term use for the prog to justify the outlay of sixty Dollars!)
-
Why not try the 30-day free trial of SQLite Maestro - are they still doing that?
Okay, when you import into the MyLog Aircraft table in SQLite Maestro, you would select "Insert New" only, rather than "Update or Insert".
And tackling all the "..." aircraft is easy in SQLite Maestro. For example, I regularly check for aircraft with missing details, using this query:
SELECT
aircraft.MS,
aircraft.AR,
aircraft."AT",
aircraft.AN,
aircraft.AC,
aircraft.CN,
aircraft.PT,
aircraft.LK,
aircraft.PT2,
aircraft.LK2
FROM
aircraft
WHERE
(aircraft."AT" = "...") OR
(aircraft."AT" IS NULL) OR
(aircraft."AT" = "")
Just note that you need to CLOSE Radarbox before doing updates in SQLite Maestro, to avoid database update conflicts.
[attachment deleted by admin]
-
Cool, and then once it has shown you all the a/c with the ... short type, I take it you can click into the results one by one and update it?
-
Thank you tarbat
Without knowning it you have just made my life a lot easier
tarbat
Hero Member
Posts: 870
Re: Just Switched from SBS-1
« Reply #43 on: Today at 18:03:14 » Quote
--------------------------------------------------------------------------------
Why not try the 30-day free trial of SQLite Maestro - are they still doing that?
Okay, when you import into the MyLog Aircraft table in SQLite Maestro, you would select "Insert New" only, rather than "Update or Insert".
And tackling all the "..." aircraft is easy in SQLite Maestro. For example, I regularly check for aircraft with missing details, using this query:
SELECT
aircraft.MS,
aircraft.AR,
aircraft."AT",
aircraft.AN,
aircraft.AC,
aircraft.CN,
aircraft.PT,
aircraft.LK,
aircraft.PT2,
aircraft.LK2
FROM
aircraft
WHERE
(aircraft."AT" = "...") OR
(aircraft."AT" IS NULL) OR
(aircraft."AT" = "")
Just note that you need to CLOSE Radarbox before doing updates in SQLite Maestro, to avoid database update conflicts.
--------------------------------------------------------------------------------
Cheers
Andy
-
If you want to try a SQLite editing tool there is a freeware one available at
http://sourceforge.net/projects/sqlitebrowser/ (http://sourceforge.net/projects/sqlitebrowser/)
-
Yes, sqlite browser is very useful for viewing/updating databases. You will need to be able to write SQL statements to get the most from it. See http://www.sqlite.org/ for documentation on SQLite.
The feature I use most in SQLite Maestro is the Visual Query Builder, which generates SQL statements for you based on a visual representation of the tables and their relationships. I've never written a single line of SQL myself, it's all been done with the Visual Query Builder!!
-
Hi,
I have downloaded SQLite Maestro, and it seems to have a 30 full usage trial.
We shall see how we go!
Thanks to all.... expect further questions soon! :-)
-
Hi 9M-ISJ
tarbat is the expert with SQLite Maestro, but there is a few of us who use it, so just ask, if we can help we will.
After my 30 day trial I made the purchase, at the time (Just over a month ago) it worked out to £69.90 - might be different now due to the exchange rate - but would not be without it now.
Cheers
Andy
-
Hi,
Had a quick toy with it this morning,,, managed to produce the query to show all aircraft with the ... or null type following Tarbats example.
Generally struggling with the other query to import my Basestation data though. In the screen dump Tarbat sent me it seems the two tables are linked... not sure how to do that!
-
Put both tables into the query builder, then just drag a line from the AircraftID field on one table to the Aircraft ID field on the other table (I think).