[chirp_users] Not importing all data.
I created a CSV file from an export. Added all the frequencies I wanted and then tried importing it. This dis not work out well. I will attach the IMG and the CSV so you can compare the two. Maybe I have something entered or formatted wrong. This is happening with the current daily build as well as the last one. Thanks. Dan
Hi Dan,
I created a CSV file from an export. Added all the frequencies I wanted and then tried importing it. This dis not work out well. I will attach the IMG and the CSV so you can compare the two. Maybe I have something entered or formatted wrong.
Yep. Here is part of your file:
"Location";"Name";"Frequency";"Duplex";"Offset";"Tone";"rToneFreq";"cToneFreq";"DtcsCode";"DtcsPolarity";"Mode";"TStep";"Skip";"Bank";"Bank Index";"URCALL";"RPT1CALL";"RPT2CALL" 1;"Nat Simplex 2M";146.52;"(NONE)";0;"(NONE)";88.5;88.5;23;"NN";"FM";5;;;-1;;; 2;"Nat Simplex 70cm";446;"(NONE)";0;"(NONE)";88.5;88.5;23;"NN";"FM";5;;;-1;;; 3;"ORR N7PIR";440.45;"+";5;"Tone";103.5;103.5;23;"NN";"FM";5;;;-1;;; 4;"Portland K7RPT";147.04;"+";0.6;"(NONE)";100;100;33;"NN";"FM";5;;;-1;;;
First, it's not comma-separated, it's semicolon-separated. Second, the columns are quoted. Third, the "(NONE)" columns should be just blank.
Some people get confused into thinking that CSV is a strict format and that anything they save out of a spreadsheet as "CSV" will work, but that's not the case :)
Hope that helps...
I think I figured it out. I used to get an error message on import when there was a string that was wrong. Now it just skips the channels with wrong items. I fixed the problems in my CSV and it worked.
Thank you
On Fri, May 27, 2011 at 5:38 PM, Dan dan.my.studio@gmail.com wrote:
I created a CSV file from an export. Added all the frequencies I wanted and then tried importing it. This dis not work out well. I will attach the IMG and the CSV so you can compare the two. Maybe I have something entered or formatted wrong. This is happening with the current daily build as well as the last one. Thanks. Dan
I think I figured it out. I used to get an error message on import when there was a string that was wrong. Now it just skips the channels with wrong items.
Yes, I made that change for a reason, but I need to finish it off. Previously, it would fail on the first bad entry all the time. What I want to do is have it continue on, collecting the errors and present them all to you at the end. I need to get on that :)
I fixed the problems in my CSV and it worked.
Cool!
participants (2)
-
Dan -
Dan Smith