Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Band Plan for importing
30-07-2019, 03:25 PM,
#1
Band Plan for importing
Following on from the discussion "Setting up a new statistic for DXCC-FT4" by Marc ON6CC, in which we learnt that if you would like this stat or one like it you can either create it or wait for it in the next version, here is a full band plan that can be imported to Swisslog. A band plan is not absolutely necessary because, as Jordi points out, Swisslog can detect some modes for dupe checking if the mode is mentioned in DX Spot comments. However, having the correct frequencies defined will ensure correct dupe checking. 

The band plan here is this one (click to enlarge):

   

After it has been imported, you can edit and delete entries from it to suit yourself. Use the Edit>Edit the bandplan menu in Swisslog.

To make the import, it is necessary so far as I know to use MS Access. Jordi may interject with an alternative method for those without Access. 

To use MS Access, download and save the attachment to a convenient folder. Unzip it to reveal BANDPlan.txt

.zip   BANDPlan.zip (Size: 734 bytes / Downloads: 11)
Open your log database in MS Access. 
Ensure that the BANDPlan Table is not open.
In Access, go to the top menu entry: External Data.
Click on New Data Source and select: From File>Text File. Click OK.
For File name, navigate to where you saved BANDPlan.txt and then click OK.
Use the Import Text Wizard this way: Next > Next > Next > select: No primary key and Next > Finish > Yes to overwrite existing table > Close

When you next open Swisslog, the band plan will be in operation.

73 de Erik.
Reply
30-07-2019, 05:30 PM, (This post was last modified: 31-07-2019, 10:53 AM by EA3GCV.)
#2
RE: Band Plan for importing
Very nice tutorial Erik! However, I need to inform all users some points before trying to perform this:

- This is only intented for users having knowledge in MS Access. The Swisslog database is very complex and can be corrupted easily if you don't know what you are doing! Perform this at your own risk!
- Do a backup copy of your database before performing this! In case of problems you can revert your database.

A very easy and safe way to implement this band plan would be by using the band plan editor of Swisslog itself (Edit / Edit the Bandplan). There you can safely add/edit/delete entries with no risk to corrupt your database. Of course it needs some time to add this complete band plan but all users can do it with no risk. But always do a backup copy first!

Best 73
Jordi, EA3GCV
Current developer of Swisslog
Reply
08-08-2019, 04:52 PM,
#3
RE: Band Plan for importing
Hello,

Just let you know that in next Swisslog version 5.99c, this band plan will be included when creating a new database. Also will be included in the default empty database for new installations.

Thank you very much Erik for this very complete band plan.

Best 73
Jordi, EA3GCV
Current developer of Swisslog
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)