FrqEd Custom Database Editor

for the Spooky2 custom database

Table of Contents

Introduction

Installing FrqEd

The Database Editor

The Frequency Set Editor

The Search Dialog

The Frequency Editor

Tutorial

Create a new database

Merge two databases

Introduction

FrqEd (pronouced freaked) is a custom database editor for Spooky2 frequency sets. It can create a database, edit an existing database, merge databases, and search the Spooky2 frequency database and add Spooky2’s frequency sets to your custom frequency set. While Spooky2 already provides much of this functionality via the CSVed application, CSVed is cumbersome and difficult to use as it has no specific knowledge of the Spooky2 database parameters.

Installing FrqEd

FrqEd is delivered inside of a zip archive. Extract all the files out of the zip archive in a folder of your choosing. Then double-click frqed.html in the Windows Explorer/File Explorer.

The Database Editor

Initial State

When you open frqed.html, FrqEd starts with an empty Database Editor. The Database Editor has the following buttons:

The Frequency Set Editor

Clicking New“New” or Edit“Edit” in the Database Editor opens the Frequency Set Editor.

Frequency Set Editor

Many of the icon buttons in the Frequency Set Editor are the same as found in the Database Editor. The icon buttons at the top the editor operate on the current frequency set, the icon buttons below operate on an individual frequency. The buttons at the top of the window do the following:

Frequency Editor

Below the icon buttons are editable properties for the current frequency set. These properties include:

Frequency Editor

At the right of each of the frequencies in the frequency set are the following icon buttons:

The Search Dialog

Clicking Search“Search” in the Frequency Set Editor opens the Search Dialog.

Search Dialog

The Search Dialog has the following form elements:

The Frequency Editor

Clicking New“New” or Edit“Edit” in the Frequency Set Editor opens the Frequency Editor.

Frequency Editor

The buttons at the top of the Frequency Editor do the following:

Below the icon buttons are editable properties for the current frequency. These properties include:

Tutorial

Create a new database

In this tutorial we create a new database called My Frequencies.csv, with a frequency set Test1 with frequencies 1 Hz and 2Hz, and frequency set Test2 with a dwell of 300 seconds, containing frequencies 3 Hz with Sine wave, and a sweep 4-10 Hz with Square wave and offset 100%.

  1. In the Database Editor, click the New“New” button. You are now in the Frequency Set Editor.
  2. In the “Name” field, type Test1.
  3. Click the New“New” button. You are now in the Frequency Editor.
  4. In the “Freq” field, type 1, and then the Enter key. Typing the Enter key is equivalent to clicking the “OK” button. You are back in the Frequency Set Editor.
  5. To and the second frequency, click the New“New” button. You are now in the Frequency Editor again.
  6. In the “Freq” field, type 2, and then the Enter key. You are back in the Frequency Set Editor.
  7. Either click the “OK” button, or type the Enter key. You are now back in the Database Editor.
  8. Click the New“New” button to create the second frequency set.
  9. Type Test2 into the “Name” field.
  10. Type 300 into the “Dwell” field.
  11. Click New“New”. You are now in the Frequency Editor.
  12. Type 3 into the “Freq” field.
  13. Choose Sine in the Wave popup list. Type the Enter key. You are back in the Frequency Set editor.
  14. To and the second frequency, click New“New”. You are now in the Frequency Editor again.
  15. In the “Freq” field, type 4.
  16. In the “End Freq” field, type 10.
  17. Choose Square in the Wave popup list.
  18. In the “Offset” field, type 100, and then type the Enter key. You are now in the Frequency Set Editor.
  19. Type the Enter key. You are now in the Database Editor.
  20. Click Save“Save”. The Save Dialog is now open.
  21. Type My Frequencies into the “File name” field, then type the Enter key. Your brower, depending on how it’s configured, may require you to answer another dialog. If you answer in the positive to your browser’s query, you ought to have My Frequencies.csv in your brower’s downloads folder.

For the advanced users, steps 3 through 19 of the above tutorial can be made in far few operations. Here are those operations (starting from Step 3):

  1. In the “Frequencies” text field, type 1,2 and type the Enter key. You are now in Database Editor.
  2. Click the New“New” button to create the second frequency set.
  3. Type Test2 into the “Name” field.
  4. Type 300 into the “Dwell” field.
  5. Type 3 W1,4-10 W2 O100 into the “Frequencies” field. Type the Enter key. This returns you to the Database Editor

Merge two databases

In this tutorial we merge two different databases to create new.csv. In the frqed.zip archive are two database files, tutorial_import_1.csv and tutorial_import_2.csv.

  1. In the Database Editor, click the “Browse…” button and choose tutorial_import_1.csv from the zip archive. There are 2 frequency sets in tutorial_import_1.csv.
  2. Click the “Import…” button. This opens the Import Dialog.
  3. Click the “Browse…” button in the Import Dialog, and choose tutorial_import_2.csv from the zip archive.
  4. There are now 4 frequency sets in the database.
  5. Click Save“Save”. The Save Dialog is now open.
  6. Type new into the “File name” field, then type the Enter key. Your brower, depending on how it’s configured, may require you to answer another dialog. If you answer in the positive to your browser’s query, you ought to have new.csv in your brower’s downloads folder.