CSV file structure for Award manager

Update and distribution of news relating to awards

Moderator: OE6CLD

Post Reply
User avatar
ON4LEY
Novice Class
Posts: 16
Joined: 08 Jul 2020, 18:06
Location: JO10pr - DOTTIGNIES - HT-

CSV file structure for Award manager

Post by ON4LEY » 14 Nov 2020, 17:02

Hello everyone,

I am interested in the Ukrainian District Award( URDA).
So I tried to find a CSV file but I couldn't find anything.
However, I found a list in Pdf format which I converted into CSV.

I have a problem because even if the loading of the CSV file is done without any problem, when I want to encode a reference, a lot of references are missing (e.g.: The SH district has several references but the system only offers one or two).

So I certainly have a problem of nomenclature/structure in the CSV file.

If any of you have any leads or can tell me what the correct structure of a CSV file should be to create an award.

I have attached the file I created .

73 - Fred ON4LEY-OP1Z
Attachments
Oblast-Ukraine2.csv
(29.35 KiB) Downloaded 33 times

OE6CLD
Log4OM Alpha Team
Posts: 165
Joined: 04 Jun 2013, 08:54
Location: Munich
Contact:

Re: CSV file structure for Award manager

Post by OE6CLD » 14 Nov 2020, 17:59

Hi Fred,

I have moved your post under v2 Award Support.

I checked the attached CSV file, and found some problems. Can you please provide the link to the original PDF file you mentioned? I want to check if it would be easier to use the PDF or your Excel file to proceed. I will then create this award and will provide some details how I did it afterwards (for the next one you want to build).

73
Claus
Claus, OE6CLD/DJ0DX/EI7JZ

User avatar
ON4LEY
Novice Class
Posts: 16
Joined: 08 Jul 2020, 18:06
Location: JO10pr - DOTTIGNIES - HT-

Re: CSV file structure for Award manager

Post by ON4LEY » 14 Nov 2020, 19:09

Good evening Claus,

Thank you for your reaction and for moving the post ( I think I did post it in the wrong place ;) ).

I also use Apple Mac and from this site, I have the possibility to make a PDF export.

http://www.uarl.com.ua/urda/files/listeng.htm

It is very kind of you to proceed with the tests and the creation of the award.

I am curious to get your feedback on the subject, especially as I would like to do it on my own (I have a lot of diplomas to create).

If I can do this, I can submit the CSV files for approval and share them with other users.

73 - Fred ON4LEY - OP1Z

OE6CLD
Log4OM Alpha Team
Posts: 165
Joined: 04 Jun 2013, 08:54
Location: Munich
Contact:

Re: CSV file structure for Award manager

Post by OE6CLD » 14 Nov 2020, 20:36

Hi Fred,

Thanks for your prompt reply. Please give me a few days to go through it, 761 entries mean a lot of work and I'm quite busy this weekend.

73
Claus
Claus, OE6CLD/DJ0DX/EI7JZ

OE6CLD
Log4OM Alpha Team
Posts: 165
Joined: 04 Jun 2013, 08:54
Location: Munich
Contact:

Re: CSV file structure for Award manager

Post by OE6CLD » 14 Nov 2020, 20:40

Hi Fred,

Just for my understanding

СH-01 18000 - 18499 Cherkasy, Prydniprovs'kyi district

"CH-01" is the reference number
"18000-18499" is the ZIP code
"Cherkasy, Prydniprovs'kyi district" is the description

73
Claus
Claus, OE6CLD/DJ0DX/EI7JZ

User avatar
ON4LEY
Novice Class
Posts: 16
Joined: 08 Jul 2020, 18:06
Location: JO10pr - DOTTIGNIES - HT-

Re: CSV file structure for Award manager

Post by ON4LEY » 14 Nov 2020, 21:41

Yes Claus,

This is quite the case for district structure.

There is no emergency,Hi !

Post Reply