toggle quoted messageShow quoted text
Check again step-by-step....
1. Open JCC.csv with NotePad. I see like this.
2. Open secondary admin database maintenance table.
Tools/database maintenance/Secondary admin database maintenance.
I see like this.
3. Right click on any QSO in Logbook page window. Click "Edit
admin subdivision info"
Select Japan for country. Select JCC for award. I see like this.
If you open JCC.csv with Excel then you may see like this. No
So If you open JCC.csv with Excel and save it then no leading
ZERO in saved JCC.csv.
If you import this saved JCC.CSV then you may miss leading ZERO in
On 2020/10/14 15:55, John Muzyka via
I have tracked the JCC/JCG
award in L32 for years and have worked well over 1K JCC/JCG a
few months ago after working a couple oj JA's with new JCC
numbers which my L32 did not recognise I decided to upload the
latest JCC/JCG.CSV file.
It went on no problem but
after checking my total number of JCC/JCG my worked number was
down to below 200?? and when I tried putting in some JCC/JCG
numbers say 0101 L32 gave me a message saying that it did not
I didn't bother with it much
then but now I am starting to work JA's and the error message
kept on coming up again, so a few weeks I tried to get down to
the bottom of this problem, first of all I tried to see if I
had a copy of the original JCC/JCG file which had worked for
lots of years, no unfortunately I did not keep the original
(note to oneself, rename a file before deleting it!!) so
because it was a new file I looked at the JCC.SCV that I had
download from Aki san JA1NLX and what I found was that the
EXCEL file showed the numbers of the prefectures without the
leading 0 (zero) in both the first part of the number and the
second part of the number so instead of 0101 it looked like it
was 11 Also when I worked a station which was already in my
log with a JCC number in the full fout figure format if there
was a 0 (zero) in the number when I tried to enter it again it
would not recognize the number even if I edited the number by
right clicking on the call in the log and choosing Edit Admin
I spoke to a radio friend of
mine who knows a lot more about PC programmes than me and he
said that EXCEL files will sometimes depending on their format
with automatically take out the 0 (zero) and that I should
report this back to the writer of the programme file. So hence
this message before messing around with the file myself. Has
anyone else had this problem or is it something with my PC?
I have attached a few screen
shots and a copy of the .CSV file