Hi Folks,
I have been fooling around with the WWFF award references and managed to mangle them up pretty well. I downloaded the CSV file for the references, but I'm certain it isn't importing correctly. I think there are some secret incantations and manipulations that have to be done on the file first. Is that correct? Can they be done by mere mortals?
Thanks!
Dana, KA1WPM
WWFF CSV file from WWFF Website
Moderator: OE6CLD
WWFF CSV file from WWFF Website
-- Dana, KA1WPM
- G4POP
- Log4OM Alpha Team
- Posts: 10831
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: WWFF CSV file from WWFF Website
No mystic arts required, did you watch the YouTube tutorial here?
https://www.youtube.com/channel/UC6Ppcj ... yavI-azOug
https://www.youtube.com/channel/UC6Ppcj ... yavI-azOug
73 Terry G4POP
Re: WWFF CSV file from WWFF Website
No, I haven't. I will give it a look today. Thanks, Terry!
-- Dana, KA1WPM
Re: WWFF CSV file from WWFF Website
Terry,
I've looked at the video and uploaded a part of the CSV file I downloaded from the WWFF site. The fields do need to be manipulated a bit to be in the right order. I can see how trying to replace the prefixes with the DXCC IDs can be a daunting task. I only updated the Canadian parks.
So, I'm close, but I haven't done something right. Somehow the DXCC was set as 0 for all of the new parks I merged in. It had an adverse affect on all of the Canadian entities, but I don't fully understand how.
Is it important not to have any extra fields at the end of each line? I left some fields on each line, assuming that they would be skipped. Here are 3 lines including a header line.
Reference,Description,RefGroup,RefSubGroup,Note,Score,DXCC,validFrom,validTo,program,dxcc,state,county,continent,iota,iaruLocator,latitude,longitude,IUCNcat,validFrom,validTo,notes,lastMod,changeLog,reviewFlag,specialFlags,website,country,region
VEFF-0001,Alaksen National Wildlife Area,,,National Wildlife Area,,1,0000-00-00,0000-00-00,VEFF,VE,VE,VE,NA,-,-,49.10152,-123.17253,Cat V,0000-00-00,0000-00-00,National Wildlife Area,2017-09-20 by i5fln,"2017-09-20 by i5fln - Approved<br>2017-09-19 by OK2APY - Updated: Website, IUCN category, State, Lat/Lon, Locator, Region",0,,www.ec.gc.ca/ap-pa/default.asp?lang=En& ... ,Canada,BC
VEFF-0002,Aulavik National Park (Banks Island),,,National Park - IOTA NA-129,,1,0000-00-00,0000-00-00,VEFF,VE,VE,VE,NA,-,-,73.6021,-119.40411,Cat II,0000-00-00,0000-00-00,National Park - IOTA NA-129,2017-09-27 by VA3RJ - Updated,"2017-09-27 by VA3RJ - Updated: IUCN category<br>2017-09-20 by i5fln - Approved<br>2017-09-19 by OK2APY - Updated: Website<br>2017-09-19 by OK2APY - Updated: Website, State, IOTA, Lat/Lon, Locator, Region, Notes",0,,www.pc.gc.ca/en/pn-np/nt/aulavik,Canada,NT
It is close, just a matter of seeing what doesn't belong.
Thanks!
I've looked at the video and uploaded a part of the CSV file I downloaded from the WWFF site. The fields do need to be manipulated a bit to be in the right order. I can see how trying to replace the prefixes with the DXCC IDs can be a daunting task. I only updated the Canadian parks.
So, I'm close, but I haven't done something right. Somehow the DXCC was set as 0 for all of the new parks I merged in. It had an adverse affect on all of the Canadian entities, but I don't fully understand how.
Is it important not to have any extra fields at the end of each line? I left some fields on each line, assuming that they would be skipped. Here are 3 lines including a header line.
Reference,Description,RefGroup,RefSubGroup,Note,Score,DXCC,validFrom,validTo,program,dxcc,state,county,continent,iota,iaruLocator,latitude,longitude,IUCNcat,validFrom,validTo,notes,lastMod,changeLog,reviewFlag,specialFlags,website,country,region
VEFF-0001,Alaksen National Wildlife Area,,,National Wildlife Area,,1,0000-00-00,0000-00-00,VEFF,VE,VE,VE,NA,-,-,49.10152,-123.17253,Cat V,0000-00-00,0000-00-00,National Wildlife Area,2017-09-20 by i5fln,"2017-09-20 by i5fln - Approved<br>2017-09-19 by OK2APY - Updated: Website, IUCN category, State, Lat/Lon, Locator, Region",0,,www.ec.gc.ca/ap-pa/default.asp?lang=En& ... ,Canada,BC
VEFF-0002,Aulavik National Park (Banks Island),,,National Park - IOTA NA-129,,1,0000-00-00,0000-00-00,VEFF,VE,VE,VE,NA,-,-,73.6021,-119.40411,Cat II,0000-00-00,0000-00-00,National Park - IOTA NA-129,2017-09-27 by VA3RJ - Updated,"2017-09-27 by VA3RJ - Updated: IUCN category<br>2017-09-20 by i5fln - Approved<br>2017-09-19 by OK2APY - Updated: Website<br>2017-09-19 by OK2APY - Updated: Website, State, IOTA, Lat/Lon, Locator, Region, Notes",0,,www.pc.gc.ca/en/pn-np/nt/aulavik,Canada,NT
It is close, just a matter of seeing what doesn't belong.
Thanks!
-- Dana, KA1WPM
- G4POP
- Log4OM Alpha Team
- Posts: 10831
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: WWFF CSV file from WWFF Website
Why dont you delete the awards and download a fresh set?
73 Terry G4POP
Re: WWFF CSV file from WWFF Website
Actually, I did that just yesterday. It worked well, too. However, some 800 new parks have been added to the Canadian parks. I am trying to augment the list with these additions.
Now that I am sure I can delete the award and download it fresh, I can keep working on it until I get it right. (It gives me something to do when the bands are dead.)
73!
Now that I am sure I can delete the award and download it fresh, I can keep working on it until I get it right. (It gives me something to do when the bands are dead.)
73!
-- Dana, KA1WPM
Re: WWFF CSV file from WWFF Website
Dana, you seem to have a lot more columns than you need. It is for WWFF so you don't need IOTA details, they would go in the IOTA award file.
I have been adding new VK parks to my WWFF in Log4OM.
Here is the first 3 lines and header of a CSV I just added.
ActivationItem,ActivationItemDescription,ActivationItemGroup,ActivationItemSubGroup,ActivationItemNote,ActivationScore,DXCC,ValidFrom,ValidTo
VKFF-2897,Calverts Lagoon Conservation Area,VKFF,,,,150,,
VKFF-2898,Coles Bay Conservation Area,VKFF,,,,150,,
VKFF-2899,Cressy Beach Conservation Area,VKFF,,,,150,,
WE have tried before to add in dates but even Terry could not figure out what was wrong so I leave them out. If you look at a reference that is already in the WFF award in Log4OM you can see what fields are needed.
73
David
VK5PL, AG7SR
I have been adding new VK parks to my WWFF in Log4OM.
Here is the first 3 lines and header of a CSV I just added.
ActivationItem,ActivationItemDescription,ActivationItemGroup,ActivationItemSubGroup,ActivationItemNote,ActivationScore,DXCC,ValidFrom,ValidTo
VKFF-2897,Calverts Lagoon Conservation Area,VKFF,,,,150,,
VKFF-2898,Coles Bay Conservation Area,VKFF,,,,150,,
VKFF-2899,Cressy Beach Conservation Area,VKFF,,,,150,,
WE have tried before to add in dates but even Terry could not figure out what was wrong so I leave them out. If you look at a reference that is already in the WFF award in Log4OM you can see what fields are needed.
73
David
VK5PL, AG7SR
73
David
VK5PL
David
VK5PL