anything
AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


« previous next »
Pages: [1]

Author Topic: Database export  (Read 3944 times)

0 Members and 1 Guest are viewing this topic.

oo-luc

  • New Member
  • *
  • Posts: 4
Database export
« on: June 29, 2009, 09:07:19 AM »
Hi all,


Is it possible to export data from the Database Explorer to Excel?


Luc.
Belgium
Logged

malc41

  • RadarBox Beta Testers
  • Hero Member
  • *
  • Posts: 586
Re: Database export
« Reply #1 on: June 29, 2009, 09:39:17 AM »
Luc

Yes, go into mylog, tools and 2nd item down export to CSV

Logged
15 Miles East of EGNJ

jgrloit

  • Sr. Member
  • ****
  • Posts: 271
Re: Database export
« Reply #2 on: June 29, 2009, 10:33:09 AM »
I think Luc is wanting to export the contents of a database table to Excel to update various fields, rather than export the MyLog report.

I was thinking of possibly using Excel for a grand find/replace exercise!!!!
Logged
Based in Hexham - Tyne Valley 
Best view for RB is North of a line between EGNT and EGNC  - includes OTA and Spade, to EGPH above 7500ft.   Can be TRUE mobile with Mobile Broadband feed to Network.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Database export
« Reply #3 on: June 29, 2009, 10:38:44 AM »
You can use tools like SQLite Maestro or SQLite Database Explorer to import/export from both the Navdata and MyLog databases.
« Last Edit: June 29, 2009, 10:42:19 AM by tarbat »
Logged

oo-luc

  • New Member
  • *
  • Posts: 4
Re: Database export
« Reply #4 on: June 29, 2009, 05:35:46 PM »
The aircraft section in database explorer contains more data.
It shows the full aircraft type and c/n, in mylog that's not vissable.
I want to export the full aircraft table to excel or csv.
Problem is that I can't find the database on my pc, is it hidden?

Luc.
Logged

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Database export
« Reply #5 on: June 29, 2009, 05:49:04 PM »
It's in the ANRB data folder - NavData.db3.  If you're using Vista, it will be in the Virtual Store.  You can open the database in SQLite Database Explorer, and export as CSV.
Logged

oo-luc

  • New Member
  • *
  • Posts: 4
Re: Database export
« Reply #6 on: June 30, 2009, 07:21:51 AM »
Quote from: tarbat on June 29, 2009, 05:49:04 PM
It's in the ANRB data folder - NavData.db3.  If you're using Vista, it will be in the Virtual Store.  You can open the database in SQLite Database Explorer, and export as CSV.

Many thanks tarbat.
It works perfect.

Logged
Pages: [1]
« previous next »