Re: [chirp_users] CSV Partial Load
I just trimmed off all the punctuation spaces and made names 8 characters or less. Same problem, it imports and shows channels 0-34 fine but stops at 34 with errors:
Line 35: [rtone] could not convert string to float:
Line 36: [rtone] could not convert string to float:
Line 37: [rtone] could not convert string to float:
Line 38: [rtone] could not convert string to float: ...
to the end of the list just after channel 70cm Cal:
31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,,
Something is happening here between 33 and 34.
I think that you have a problem with the NAMES of the channels. NAMES should not have a space as this break the rules of CSV files. Try replacing the spaces with “_” and that might work a lot better.
Just my $0.02, Jean-Paul N1JPL
On Jul 3, 2018, at 2:50 PM, imatglamis imatglamis@gmail.com wrote:
I just trimmed off all the punctuation spaces and made names 8 characters or less. Same problem, it imports and shows channels 0-34 fine but stops at 34 with errors:
Line 35: [rtone] could not convert string to float:
Line 36: [rtone] could not convert string to float:
Line 37: [rtone] could not convert string to float:
Line 38: [rtone] could not convert string to float: ...
to the end of the list just after channel 70cm Cal:
31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,,
Something is happening here between 33 and 34. _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Jean-Paul Louis at louijp@yahoo.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
Actually, spaces are allowed in CSVs (in general just about everything other than a COMMA is fine since it's the comma that separates the fields). And, we see that line 33 is loading (which also has a space).
What I am seeing, however, is a lot more empty fields in line 34 than in the previous lines. In particular, the warning from Chirp is for the 'rtone' column that it can't convert the string to a float. In line 33 this appears to have a value of 88.5 while it's empty on line 34. I suggest looking at the values for the tone columns to see why these are blank (and/or why Chirp is expecting a value there).
I also see from the history of this email chain that you're using Excel to edit the CSV. Excel is notorious for munging CSV files. You may want to use a text editor of some kind instead of Excel to make sure that the fields aren't getting messed up when the file is saved.
On 7/3/2018 2:02 PM, Jean-Paul Louis via chirp_users wrote:
I think that you have a problem with the NAMES of the channels. NAMES should not have a space as this break the rules of CSV files. Try replacing the spaces with “_” and that might work a lot better.
Just my $0.02, Jean-Paul N1JPL
On Jul 3, 2018, at 2:50 PM, imatglamis imatglamis@gmail.com wrote:
I just trimmed off all the punctuation spaces and made names 8 characters or less. Same problem, it imports and shows channels 0-34 fine but stops at 34 with errors:
Line 35: [rtone] could not convert string to float:
Line 36: [rtone] could not convert string to float:
Line 37: [rtone] could not convert string to float:
Line 38: [rtone] could not convert string to float: ...
to the end of the list just after channel 70cm Cal:
31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,,
Something is happening here between 33 and 34. _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Jean-Paul Louis at louijp@yahoo.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Aubrey Turner at aubrey.c.turner@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
He needs values for all these fields in your csv file: rToneFreq, cToneFreq, DtcsCode, DtcsPolarity, Mode, TStep
rToneFreq & cToneFreq need to be proper ctcss tones. 67.0 will do
DtcsCode needs to be valid too. First valid code is 023
DtcsPolarity needs to be one of [‘NN', 'NR', 'RN', 'RR']
Mode needs to be AM or FM at least
TStep (tuning step) needs to be numeric! Zero will do
So this:
35,BECKER1/AGAVE,153.62,,0,,,,,,FM,,,,,,,
Needs to become this at a minimum:
35,BECKER1/AGAVE,153.62,,0,,67.0,67.0,023,NN,FM,12.5,,,,,,
There is no problem with the / in the name, but remember if you see a conversion error like ’String to Float’ for any field, that indicates that you must supply at least a numeric value, not an empty field.
I hope this helps
Ken
On 3 Jul 2018, at 20:14, Aubrey Turner aubrey.c.turner@gmail.com wrote:
Actually, spaces are allowed in CSVs (in general just about everything other than a COMMA is fine since it's the comma that separates the fields). And, we see that line 33 is loading (which also has a space).
What I am seeing, however, is a lot more empty fields in line 34 than in the previous lines. In particular, the warning from Chirp is for the 'rtone' column that it can't convert the string to a float. In line 33 this appears to have a value of 88.5 while it's empty on line 34. I suggest looking at the values for the tone columns to see why these are blank (and/or why Chirp is expecting a value there).
I also see from the history of this email chain that you're using Excel to edit the CSV. Excel is notorious for munging CSV files. You may want to use a text editor of some kind instead of Excel to make sure that the fields aren't getting messed up when the file is saved.
On 7/3/2018 2:02 PM, Jean-Paul Louis via chirp_users wrote:
I think that you have a problem with the NAMES of the channels. NAMES should not have a space as this break the rules of CSV files. Try replacing the spaces with “_” and that might work a lot better.
Just my $0.02, Jean-Paul N1JPL
On Jul 3, 2018, at 2:50 PM, imatglamis imatglamis@gmail.com wrote:
I just trimmed off all the punctuation spaces and made names 8 characters or less. Same problem, it imports and shows channels 0-34 fine but stops at 34 with errors:
Line 35: [rtone] could not convert string to float:
Line 36: [rtone] could not convert string to float:
Line 37: [rtone] could not convert string to float:
Line 38: [rtone] could not convert string to float: ...
to the end of the list just after channel 70cm Cal:
31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,,
Something is happening here between 33 and 34. _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Jean-Paul Louis at louijp@yahoo.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Aubrey Turner at aubrey.c.turner@gmail.com mailto:aubrey.c.turner@gmail.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com mailto:chirp_users-unsubscribe@intrepid.danplanet.com
chirp_users mailing list chirp_users@intrepid.danplanet.com mailto:chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Bitfarmer at ei7dkb@logicatrium.com mailto:ei7dkb@logicatrium.com To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com mailto:chirp_users-unsubscribe@intrepid.danplanet.com
Well one thing is starting at 34 you removed the default values for Tone, ToneSql, DTCS Code, DTCS Rx Code and DTCS Pol. They should be there even if they are not used. The Tone Mode value determines if they are used or not. And it looks like it is missing from all the memory rows.
Jim
31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,,
Program memory 31 using the CHIRP UI and then export it to a CSV file. That is what the others need to look like.
Jim
Your frequency doesn't conform to an acceptable frequency step?
On 03 July 2018 at 14:50 imatglamis imatglamis@gmail.com wrote:
I just trimmed off all the punctuation spaces and made names 8 characters or less. Same problem, it imports and shows channels 0-34 fine but stops at 34 with errors: Line 35: [rtone] could not convert string to float: Line 36: [rtone] could not convert string to float: Line 37: [rtone] could not convert string to float: Line 38: [rtone] could not convert string to float: ... to the end of the list just after channel 70cm Cal: 31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,, Something is happening here between 33 and 34. _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Nigel Gunn, W8IFF at nigel@ngunn.net To unsubscribe, send an email to chirp_users-unsubscribe@intrepid.danplanet.com
Nigel A. Gunn, 1865 El Camino Drive, Xenia, OH 45385-1115, USA. tel +1 937 825 5032 Amateur Radio G8IFF W8IFF (was KC8NHF 9H3GN), e-mail nigel@ngunn.net www http://www.ngunn.net Member of ARRL, QRPARCI #11644, SOC #548, Flying Pigs QRP Club International #385, Dayton ARA #2128, AMSAT-NA LM-1691, GCARES, EAA382.
Columns G, H, I, J, and L require data be in the CSV file. Of these columns some will produce a Chirp error but if you continue Chirp will kindly fill in dummy data. And some of the columns require data, that if not there will stop the import. I just don't have time to research and tell you which. But simply put, put data in all fields.
This will work: 88.5 88.5 23 NN FM 5 and so will this: 67 67 23 NN FM 5 Your rTone on channel 57, line 58 is wrong too.
Dennis M. Wage (W9BOQ)
245 Corum Hill Road Castalian Springs, TN 37031 (615) 310-4242 Cell (615) 562-5128 Home http://hammondb3organ.net http://overdubs.net
On Tue, Jul 3, 2018 at 6:08 PM, Nigel A. Gunn G8IFF/W8IFF nigel@ngunn.net wrote:
Your frequency doesn't conform to an acceptable frequency step?
On 03 July 2018 at 14:50 imatglamis imatglamis@gmail.com wrote:
I just trimmed off all the punctuation spaces and made names 8 characters or less. Same problem, it imports and shows channels 0-34 fine but stops at 34 with errors:
Line 35: [rtone] could not convert string to float:
Line 36: [rtone] could not convert string to float:
Line 37: [rtone] could not convert string to float:
Line 38: [rtone] could not convert string to float: ...
to the end of the list just after channel 70cm Cal:
31,WX9,161.775,,0,,88.5,88.5,23,NN,FM,5,,,,,, 32,WX10,163.275,,0,,88.5,88.5,23,NN,FM,5,,,,,, 33,70cm Cal,446,,0,,88.5,88.5,23,NN,FM,5,,,,,, 34,BAJA PIT,154.98,,0,,,,,,FM,,,,,,, 35,BECKER1,153.62,,0,,,,,,FM,,,,,,, 36,BECKER2,153.245,,0,,,,,,FM,,,,,,,
Something is happening here between 33 and 34. _______________________________________________ chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Nigel Gunn, W8IFF at nigel@ngunn.net To unsubscribe, send an email to chirp_users-unsubscribe@ intrepid.danplanet.com
Nigel A. Gunn, 1865 El Camino Drive, Xenia, OH 45385-1115, USA. tel +1 937 825 5032 Amateur Radio G8IFF W8IFF (was KC8NHF 9H3GN), e-mail nigel@ngunn.net www http://www.ngunn.net Member of ARRL, QRPARCI #11644, SOC #548, Flying Pigs QRP Club International #385, Dayton ARA #2128, AMSAT-NA LM-1691, GCARES, EAA382.
chirp_users mailing list chirp_users@intrepid.danplanet.com http://intrepid.danplanet.com/mailman/listinfo/chirp_users This message was sent to Dennis Wage at dwage@dwage.com To unsubscribe, send an email to chirp_users-unsubscribe@ intrepid.danplanet.com
participants (7)
-
Aubrey Turner -
Dennis Wage -
imatglamis -
Jean-Paul Louis -
Jim Unroe -
Ken FitzGerald-Smith -
Nigel A. Gunn G8IFF/W8IFF