• Effective immediately we will be deleting, without notice, any negative threads or posts that deal with the use of encryption and streaming of scanner audio.

    We've noticed a huge increase in rants and negative posts that revolve around agencies going to encryption due to the broadcasting of scanner audio on the internet. It's now worn out and continues to be the same recycled rants. These rants hijack the threads and derail the conversation. They no longer have a place anywhere on this forum other than in the designated threads in the Rants forum in the Tavern.

    If you violate these guidelines your post will be deleted without notice and an infraction will be issued. We are not against discussion of this issue. You just need to do it in the right place. For example:
    https://forums.radioreference.com/rants/224104-official-thread-live-audio-feeds-scanners-wait-encryption.html

Importing RadioReference CSV to Q7A via TK7?

Status
Not open for further replies.

kd4e

Member
Joined
Jun 19, 2006
Messages
13
Has anyone successfully imported RadioReference CSV data
files to an Icom IC-Q7A HT via the TK7 app?

We are getting a message saying there is an error in
the CSV data file.

The CSV files are of several counties here in central
Florida including Hernando, Pinellas, Pasco, Citrus,
Polk, Lake, and Orange.

Every one of them is flagged as containing errors.

Ideas, please?

--

Thanks! & 73, doc kd4e
http://bibleseven.com
 

kd4e

Member
Joined
Jun 19, 2006
Messages
13
kd4e said:
Has anyone successfully imported RadioReference CSV data
files to an Icom IC-Q7A HT via the TK7 app?

We are getting a message saying there is an error in
the CSV data file.

The CSV files are of several counties here in central
Florida including Hernando, Pinellas, Pasco, Citrus,
Polk, Lake, and Orange.

Every one of them is flagged as containing errors.

Ideas, please?

--

Thanks! & 73, doc kd4e
http://bibleseven.com
Perhaps I need to broaden the context, please?

Can someone please download the Pasco County Florida CSV files from RR and try to import them to a
Q7A?

I need to know if the files are defective or if the problem lies in the app.

Thanks! doc
 

seamusg

Member
Joined
Feb 10, 2004
Messages
2,181
Location
Grand Blanc, MI
CSV files from RR here have the following fields:
output freq
input freq
call sign
entity
description
channel number
pl tone
mode - AM FM Motorola EDACS, etc
type - BM R, etc
You can bring up the file in a spreadsheet and edit the fields to the order your app wants.
 

seamusg

Member
Joined
Feb 10, 2004
Messages
2,181
Location
Grand Blanc, MI
As a note I did run across one problem when I wrote an app to load the csv file to my BC796, the end of line character was just a LF insted of CRLF. Bring up the file in spreadsheet and saving it as csv fixed this.
 

kd4e

Member
Joined
Jun 19, 2006
Messages
13
seamusg said:
As a note I did run across one problem when I wrote an app to load the csv file to my BC796, the end of line character was just a LF insted of CRLF. Bring up the file in spreadsheet and saving it as csv fixed this.
Office Excel 2003 refuses to save as a CSV.

Which spreadsheet sis you use, please?

Thanks! doc
 

kd4e

Member
Joined
Jun 19, 2006
Messages
13
seamusg said:
Microsoft Works
We do not have MS Works.

I tried Gnumeric Spreadsheet Editor under Linux but when I look,
using Notepad on his WinXP box, the end of the line shows a
vertical rectangle on the original and the Gnumeric-saved files so I
take that to mean that no change was made?

> We are getting a message saying there is an error in
> the CSV data file.

The specific error is:

"Invalid Mode WPKC993"

The are commas prior to and following so it does not
seem to be the result of a missing comma delimiter.
 

Al42

Member
Joined
Apr 29, 2005
Messages
3,485
Location
Long Island, NY, USA
kd4e said:
Office Excel 2003 refuses to save as a CSV.
What problems are you having? My Excel handles csv files fine.

If you have a text editor that can read *nix files, just load the csv into it and save it under another name. Most Windows editors write CRLF as the EOL regardless of what it was coming in.
 
Status
Not open for further replies.
Top