Just Sharing This Exporting EBS Pro Scan Database For Creation Of Result Lists

moonbase

Small Dish Man
Joined
Mar 29, 2004
Messages
4,370
Reaction score
4,470
Points
113
My Satellite Setup
.
My Location
UK
Hi,

I am not to sure if this topic will be of interest to many but for those with a slight inclination to tinkering with EBS Pro and using the results for scan comparisons it might be useful? The EBS Pro database containing the history of all scans can be exported from the database and setup in a spreadsheet application to provide quick comparisons between scan results.

The results database can contain hundreds of historic scans or just a few depending if the user has deleted the historic scans recently. Whatever scan results are in the database will be included in the export process. The logic of the process is as follows:

1. Locate the database file, copy it to another location and work with the copy.
2. Download and install a free SQLite viewer, I use "DB Browser for SQLite".
3. Open the DB Browser application and select "File -> Open Database" from the menu.
4. Navigate to the location where the copy of the EBS Pro database was saved and open the "data.db" file.
5. Once the data.db file has loaded, select "File -> Export Table (s) as csv files".
6. Select the "Reports" table as the table to export and click OK, clear the OK boxes and exit the DB Browser.
7. Open the csv file with a spreadsheet program and there you have it, thousands of lines of scan results in a spreadsheet for onward use.

I have attached a series of pictures below that present the process sequence. The pictures are spread across this post and the next post as they would exceed the maximum allowed on a single post. If anyone wishes to have a copy of the excel file I used to map the export results into the summary list that was used by the Pivot Table I will see if I can upload it. I might need to change to file extension to a file type allowed by the forum upload control as I am not sure if xlsx is an approved file type?
 

Attachments

  • EBS Pro Database.jpg
    EBS Pro Database.jpg
    89.4 KB · Views: 11
  • DB Browser for SQLite (01).jpg
    DB Browser for SQLite (01).jpg
    98 KB · Views: 10
  • DB Browser for SQLite (02).jpg
    DB Browser for SQLite (02).jpg
    74.6 KB · Views: 10
  • DB Browser for SQLite (03).jpg
    DB Browser for SQLite (03).jpg
    175.7 KB · Views: 11
  • DB Browser for SQLite (04).jpg
    DB Browser for SQLite (04).jpg
    184.7 KB · Views: 11
  • DB Browser for SQLite (05).jpg
    DB Browser for SQLite (05).jpg
    44.6 KB · Views: 11
  • DB Browser for SQLite (06).jpg
    DB Browser for SQLite (06).jpg
    78.7 KB · Views: 10
  • DB Browser for SQLite (07).jpg
    DB Browser for SQLite (07).jpg
    10.3 KB · Views: 10

moonbase

Small Dish Man
Joined
Mar 29, 2004
Messages
4,370
Reaction score
4,470
Points
113
My Satellite Setup
.
My Location
UK
Additional pictures attached below.

The method I used is only one option, there are probably quite a few other ways to achieve the same result.
 

Attachments

  • Excel (01).jpg
    Excel (01).jpg
    81.9 KB · Views: 11
  • Excel (02).jpg
    Excel (02).jpg
    371.6 KB · Views: 11
  • Excel (03).jpg
    Excel (03).jpg
    347.1 KB · Views: 11
  • Excel (04).jpg
    Excel (04).jpg
    506.4 KB · Views: 10

moonbase

Small Dish Man
Joined
Mar 29, 2004
Messages
4,370
Reaction score
4,470
Points
113
My Satellite Setup
.
My Location
UK
The scan results that were exported from the EBS Pro database were from different step size scans of 0.8W. It is a known issue with EBS Pro that the SNR values presented in the scan result table can be lower than the SNR values from the EBS Pro signal analyser or a satellite receiver.

I ran 1MHz, 2MHz and 4MHz step size scans on 0,8W using BLScan mode and BLScan2 mode to see if the scan mode or step sizes had any impact on the SNR values presented in the scan result table. A picture of the analysis for each step size and scan mode is attached below.

EBS Pro Step Size Scans.jpg
 
Last edited:
Top