CSV HowTo » History » Revision 11
Revision 10 (Daniel Clemmensen, 03/14/2019 11:43 AM) → Revision 11/15 (Daniel Clemmensen, 03/14/2019 11:55 AM)
h1. How to use CSV files
{{>toc}}
h2. Introduction
It is important to note that CSV stands for "Comma Separated Values" and is a method of _encoding_ and not a strict file format. Any kind of record data can be stored in a CSV file, which is why spreadsheet applications such as Microsoft Excel and LibreOffice Calc support it. If you create a CSV file without a specific format, CHIRP will not be able to extract the needed data from it,
h2. A Clean Start
If you want to get an empty CHIRP-compatible CSV file, the easiest way is to let CHIRP create one for you. Here are the approximate steps for creating an empty file, editing it in an external editor and opening it back up in CHIRP:
# Start CHIRP
# Go to *File* > *New* to create an empty CSV file
# Add a memory to the first row, by entering a frequency such as *146.52*
# Go to *File* > *Save As* to save the template file to something ending with a *.csv* extension
# Open the file in your spreadsheet or external application of choice, make edits and save
# Re-open the file in CHIRP to validate that the format is still correct, by going to *File* > *Open* and choosing your file
# Optionally use *File* > *Import* to import the contents of your CSV file into another radio image
h2. Tips To Avoid Breaking The Formatting
CHIRP relies on the CSV file's formatting to be intact in order for it to read and understand the data inside the file. Observe the following rules to ensure that CHIRP can continue to read the file:
# You must maintain the header row in its original format so that CHIRP knows which column corresponds to which value
# You may re-order the columns as long as the header row matches
# You may delete columns for which there are sane defaults and CHIRP will assume those defaults upon opening or importing the file
# You may place double quote marks (i.e. " not ' or '') around column values that contain spaces or commas
# Field values must be in the original format and one of the accepted values for the column type. For example, the Duplex field may be either blank, an plus sign (+), a minus sign (-), or the word "split". The ToneMode field may be either blank, the words "Tone", "TSQL", "DTCS", or "Cross", and so on. If there is ever a question, use CHIRP to create a file with a given value and observe what it puts into the CSV file as a result.
h2. Getting The Data Back Into A Radio
CSV files are generic, radio-independent text files. This means that you cannot upload them directly into a radio. In order to get the information into your device, you must go through some sort of an _Import_ operation. There are two basic ways to do this, depending on what you are trying to accomplish:
h3. Method !#1: Importing the CSV file into a radio
This method should be used when you want to import the entire contents (or some large portion) of the CSV file into the destination radio. Follow these steps:
# Open a *.img* file of your radio, or download one from it using *Radio* > *Download From Radio*. Make sure that the tab at the top says something like "Yaesu FT-7800" or "Icom IC-880" to indicate that you're operating on a radio-specific driver.
# Go to *File* > *Import from file* and choose your CSV file.
# An import dialog box will appear, which lets you preview the memories that can and will be imported. Make your selections or corrections, if necessary, and then click *OK*.
# The memories stored in the CSV file should now be visible in your editor.
# make any modification needed for your radio here. The CSV file is generic and does not have all of the columns your radio may need. See below.
# If you have a clone-mode radio, upload the changes back to your device using *Radio* > *Upload To Radio*. If you are using a live-mode radio, wait until all of the changes finish synchronizing back to the device by watching the status bar in the lower right corner of the main window.
h3. Method !#2: Manually copying memories into a radio
This method should be used when you want selectively import a few memories from a CSV file into the destination radio. Follow these steps:
# Open your CSV file using *File* > *Open* and choosing your file.
# Open a *.img* file of your radio, or download one from it using *Radio* > *Download From Radio*. Make sure that the resulting tab at the top says something like "Yaesu FT-7800" or "Icom IC-880" to indicate that you're operating on a radio-specific driver.
# Select the tab containing your CSV file at the top, and select memories from the CSV file you want to copy over. You can select multiple rows by holding the _Shift_ or _Control_ keys while making your selections.
# After selecting one or more memories, copy them to the clipboard by going to *Edit* > *Copy*.
# Next, select the tab corresponding to your actual radio at the top
# Select a spot in the radio's memory to paste the new memories and then go to *Edit* > *Paste*.
# If you have a clone-mode radio, upload the changes back to your device using *Radio* > *Upload To Radio*. If you are using a live-mode radio, wait until all of the changes finish synchronizing back to the device by watching the status bar in the lower right corner of the main window.
h2. Handling missing columns
Since the CSV files are generic your radio may need information that is not present in the CSV file. The most frequent example of this is the missing "Power" column. If your radio's "power" defaults to "low" then you probably want to change the setting to "high" for all channels.
After you import the spreadsheet into the CHIRP window file for your radio, you will need to change setting settiong in the "power" column for all rows. Fortunately, CHIRP has a shortcut that lets you change one or more columns in all rows:
* Select relevant all rows:
** Click click on the first row
** Move move to the last affected row and shift-click
* Right-click right-click to get the convenience popup, and click on "properties" to bring up the properties menu
* Select select the property ("column") checkbox to change and select the new value for it from its dropdown dropdown. (e.g., select "power" and select "high"). "high")
* Click click OK.