Contents - Index - Previous - Next


Importing and Exporting memories


Capabilities

The Import/Export facility enables you to exchange memory information between programs that use the FTBasic format .CSV files.

The program can import up to 500 memory definitions at a time. 

The position of the Import/Export window can be saved by clicking the button Save size and position. Multiple monitors are supported.

General approach

Importing is done in two phases. The first phase performs validation on the input data, and checks there is enough space to import the records. The second phase performs the actual import. 

The program looks at the first record in the file (the header record) to check that the data looks to be in the correct format. 

If you wish to prepare your own file for import using a spreadsheet such as Excel then the easy way to get the correct header information is to Export your existing memories to a .CSV file. This will include the correct format header file as well as at least one sample memory. The format of the various fields is in this Help file section 'CSV file formats'. When you have finished editing your Excel spreadsheet then save in .CSV file format.

FTBFIG utility

A free utility called FTBFIG is available on the website which can extract frequencies from files or the Windows clipboard and produce .CSV files that can be imported.



Importing data validation

During the validation phase of an import there are messages produced in a re-sizeable window to document potential problems with the input data. If problems are detected then you are given the option to try to import as much of the file as possible.

Any record containing a non-supported operating mode is rejected.

Any record containing a frequency that cannot be supported on the radio is rejected.

The expected format of the files is given in the Help file section CSV file formats.

Import Procedure

Click the import/export button to start. The following window is shown:



Decide whether or not you wish to omit duplicate frequencies and tick the 'Omit duplicate frequencies' check-box accordingly. If the checkbox is ticked then any import record that is already anywhere in the memories grid will be rejected.

Decide whether to completely replace any existing memories you may already have in the memory grid and tick the 'Clear all before import' check-box accordingly.

Decide whether or not you want to import into the same memory numbers as are specified in the import file and tick the 'Use imported mem numbers' check-box accordingly. Any record containing a memory number higher than the maximum for the radio will be rejected. 

If you do not import using the memory numbers specified in the import file then records are placed in the first available position. The starting memory number is governed by the 'Start at mem number' field, which is initially set to 1. If you want to start importing at a particular position then enter the desired memory number.

If you only want to see the contents of the import file then click the Preview Import button. The file will be listed in a re-sizeable window.

When you are sure you have chosen the appropriate options click the Import CSV button and a standard open dialog box will be shown. Then navigate to the file you want to import and click the Open button.

If any potential problem is found when validating the data you will receive a message in a re-sizeable window. At the end of the validation process if there have been any messages issued you have the option to try to import the file or abandon the import. Otherwise the import proceeds.

Export Procedure

Export options

Decide whether you wish to omit the header record that is normally produced and tick the 'Omit header' check-box accordingly. It is not usual to tick the 'Omit header' box.

Decide whether to keep the existing memory numbers in the exported records and tick the check-box accordingly. If you do not tick the 'Keep existing mem numbers' box then the first record output has the number 1 and each subsequent record is incremented by 1.

Decide whether to export all of the memories or only those that are selected by you. If the 'Export only selected mems' check-box is not ticked then all of the memories will be exported. If the check-box is ticked then you can select as many memories as you wish. To select individual memories hold down the CTRL key and then click on the memories wanted one-by-one. To reverse a selection simply click on the memory again. To select a range of memories hold down the SHIFT key and click on the first memory, then (still holding down the SHIFT key) click on the last memory. It does not matter if you have selected Empty memories - they will be ignored when the export is performed. 

Field separator

Decide whether you wish to use the Comma or Tab character as the separator character between fields and select the appropriate radio button.

Export or Preview 

If you only want to see the contents of the export file then click the Preview Export button. The file will be listed in a re-sizeable window.

When you are sure you have chosen the appropriate options click the Export CSV button and a standard Save as dialog box will be shown. Choose a location and enter a file name, then click the Save button.

If the checkbox 'Export only selected items' is ticked

Please note that while the check-box 'Export only selected mems' is ticked the Memories menu is disabled and complete rows of cells are selected. Normal editing of memories is resumed when the check-box is un-ticked or the Import/Export window is closed.