Contents - Index - Previous - Next


CSV Memory file format


The first record of a CSV file is a header record. Note that commas (,) between the words may also be semi-colons (;) if the operating system is running in a non-US or non-UK locale. 

The program uses the first separator in the header record to determine whether the decimal point in the subsequent records is expected to be a comma (,) or a period (.), and whether the field separator character is expected to be a comma (,) or semi-colon (;). 

If a semi-colon (;) is found as the first field separator in the header record then the program expects the RX Freq and TX Shift/Freq to use a comma (,) as the decimal point, and the field separator character to be a semi-colon (;).

If a  comma (,) is found as the first field separator in the header record then the program expects the RX Freq and TX Shift/Freq to use a period (.) as the decimal point, and the field separator character to be a comma (,). 

CTCSS tone frequencies always use a period (.) as the decimal point.

Problems with Import of CSV files will occur if these conventions are not followed.

The program will import CSV files with either convention for separator and decimal point, performing the conversion appropriate to the locale in use. Export will always produce CSV files according to the locale in use - i.e. if you are using a period (.) as the decimal point then the field separators will be commas (,) and the decimal points will be periods (.); if you are using a comma (,) as the decimal point then the field separators will be semi-colons (;) and the decimal points will be commas (,).

Header Record format

Memory, RX Freq, RX Mode, Shift, TX Shift/Freq, TX Mode, CTCSS/DCS, Tone/Code, Show, Name, Scan, Group, Description

Individual Field Format

Memory optional, numeric, integer between 1 and 200 for FT-817, FT-817ND, FT-857, FT-857D, FT-897 and FT-897D; between  1 and 78 for FT-847

RX Freq mandatory, numeric, MHz with up to 5 decimal places

RX Mode mandatory, character, one of FM AM USB LSB CW CWR PKT DIG (FT-817) or FMN FM AMN AM USB LSB CWRN CW CWR CWN for FT-847, not case sensitive 

Shift mandatory, character, one of Simplex Plus Minus Split, not case sensitive

TX Shift/Freq mandatory, numeric, MHz with up to 5 decimal places. If the Shift is Split, then this is a transmit frequency, otherwise this is a transmit offset from the receive frequency. For Simplex operation set the value to the standard repeater offset for the band, or for Plus or Minus set this to the desired repeater offset.

TX Mode mandatory for Split shift, else not specified. Values as for RX Mode

CTCSS/DCS optional, character, one of DCS, CTCSS Enc+Dec, CTCSS Enc. Case sensitive

Tone/Code Mandatory if CTCSS/DCS is specified, else not specified. Character, A valid CTCSS tone or DCS code. The FT-817, FT-817ND, FT-857, FT-857D, FT-897 and FT-897D support more tones and codes than the FT-847! Any comma (,) found is replaced with a period (.)

Show optional, character, one of Name Freq, not case sensitive, default set to Freq

Name optional, character, up to 8 characters, if not specified then field Show set to Freq regardless of any other setting for Show

Scan optional, single character, Y or N, include(Y)/exclude(N) from a scan, forced to upper case

Group optional, single character A to Z or 0 to 9, memory group, forced to upper case, default set to 0

Description optional, up to 100 characters, not case sensitive but must not contain any of the field separator characters.