[chirp_users] importing CSV

Michael D Earls mikeearls at earthlink.net
Sun Apr 12 15:13:02 PDT 2015


Since I was only working with my radio and the img file was a result of
reading from that radio, I started out by naming the columns as they appear
in the image file.

Needless to say, all of the effort I put into entering that data was wasted,
as CHIRP could not read it.

So then I did the image file export to CSV and was surprised to see
different column headings, different column order, and even new columns that
aren't explained anywhere (URCALL, RPT1CALL, RPT2CALL).

Once more, I moved my data into this format but in all of the
copying/pasting, I managed to get some lines misaligned, so now I don't
trust it.

However, the import would have apparently been successful except for the
following errors:

Line 2: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 3: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 4: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 5: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 6: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 7: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 8: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 9: [duplex] `(None)' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 10: [tmode] `(None)' is not in valid list: ['', 'Tone', 'TSQL', 'DTCS',
'DTCS-R', 'TSQL-R', 'Cross']
 
Line 11: [tmode] `(None)' is not in valid list: ['', 'Tone', 'TSQL', 'DTCS',
'DTCS-R', 'TSQL-R', 'Cross']
 
Line 30: [rtone] could not convert string to float: 
 
Line 38: [rtone] could not convert string to float: 
 
Line 46: [rtone] could not convert string to float: 
 
Line 53: [rtone] could not convert string to float: 
 
Line 56: [rtone] could not convert string to float: 
 
Line 57: [rtone] could not convert string to float: 
 
Line 75: [rtone] could not convert string to float: 
 
Line 108: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 109: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 110: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 111: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 112: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 113: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 114: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 115: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 116: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 117: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 118: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 119: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 120: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 121: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 122: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 123: [duplex] `Split' is not in valid list: ['', '+', '-', 'split',
'off']
 
Line 124: [dtcs_polarity] `' is not in valid list: ['NN', 'NR', 'RN', 'RR']
 
Line 125: [dtcs_polarity] `' is not in valid list: ['NN', 'NR', 'RN', 'RR']
 
Line 126: [dtcs_polarity] `' is not in valid list: ['NN', 'NR', 'RN', 'RR']
 
Line 127: [dtcs_polarity] `' is not in valid list: ['NN', 'NR', 'RN', 'RR']
 
Line 128: [dtcs_polarity] `' is not in valid list: ['NN', 'NR', 'RN', 'RR']
 
Line 129: [dtcs_polarity] `' is not in valid list: ['NN', 'NR', 'RN', 'RR']
 
Line 130: [rtone] could not convert string to float: 
 
Line 131: [rtone] could not convert string to float: 
 
Line 132: [rtone] could not convert string to float: 
 
Line 133: [rtone] could not convert string to float: 
 
Line 134: [rtone] could not convert string to float: 
 
Line 135: [rtone] could not convert string to float: 
 
Line 136: [rtone] could not convert string to float: 
 
Line 137: [rtone] could not convert string to float: 
 
Line 138: [rtone] could not convert string to float: 
 
Line 139: [rtone] could not convert string to float: 
 
Line 140: [rtone] could not convert string to float: 
 
Line 141: [rtone] could not convert string to float: 
 
Line 142: [rtone] could not convert string to float: 
 
Line 143: [rtone] could not convert string to float: 
 
Line 144: [rtone] could not convert string to float:


BTW, the CHIRP example here:

http://www.miklor.com/COM/UV_CHIRP_Examples.php

Shows a Simplex channel with (None) under Duplex. Following that example
resulted in the first 8 errors.

I can go back to my worksheet and manually enter 128 channels in a fraction
of the time I wasted trying to import a CSV.




FREQ
NAME
TONE
MODE
CTCSS
TONE
TONESQL
DTCS
CODE
DTCS
RX CODE
DTCS
POLARITY
CROSS
MODE
DUPLEX
OFFSET
MODE
POWER
SKIP





Location
Name
Frequency
Duplex
Offset
Tone
rToneFreq
cToneFreq
DtcsCode
DtcsPolarity
Mode
TStep
Skip
Comment
URCALL
RPT1CALL
RPT2CALL

It seems it should have been possible to be consistent with the column
headings.

Admittedly, I'm very frustrated after fighting this for two days when it
shouldn't have taken more than a couple of hours.

I still need to master importing from a CSV, but it will have to be after my
blood pressure lowers.

I know I could have imported from RepeaterBook. I actually began by
compiling a speadsheet of over 300 repeaters from surrounding counties using
RepeaterBook.

Then, I spent hours using RFProjector to verify every one. Having just
culled the inactive repeaters from the RepeaterBook info, I had no desire to
reintroduce them.
 
Mike Earls
AF5MS
TSRA Life Member
NRA Benefactor Member
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://intrepid.danplanet.com/pipermail/chirp_users/attachments/20150412/2ccf59d3/attachment-0002.html 


More information about the chirp_users mailing list