[chirp_users] importing CSV

[Tom Hayward]

Is there a question in here? Not sure exactly what you need.

If you haven't yet, you might want to read the Chrip CSV guide:
http://chirp.danplanet.com/projects/chirp/wiki/CSV_HowTo

If you're looking for a project, learning a programming language may help
you with all this data manipulation. Cross-referencing data sources is
something that would be pretty quick to automate with a programming
language.

Tom KD7LXL

On Sun, Apr 12, 2015 at 3:13 PM, Michael D Earls <mikeearls at earthlink.net>
wrote:

> 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
>
>
>
> _______________________________________________
> chirp_users mailing list
> chirp_users at intrepid.danplanet.com
> http://intrepid.danplanet.com/mailman/listinfo/chirp_users
> To unsubscribe, send an email to
> chirp_users-unsubscribe at intrepid.danplanet.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://intrepid.danplanet.com/pipermail/chirp_users/attachments/20150412/0fa7165a/attachment.html