[Xastir] RAC Database

[Jeff Brower]

Hi Tom and group,

Unfortunately I don't know perl Tom. I did check out the database format and it looks like Industry Canada added additional/auxiliary club information to the call signs data.  The new format is as below. I think if the script could read up to and including character 209 of the string then things should work with xastir's look up. Is there an easy parsing to clean up this new format?

TIA to any perl coders for their input.

Jeff VA7TZ

    Each record is in the following format:

      FIELD                        STARTING COLUMN   LENGTH
        ~~~~~                        ~~~~~~~~~~~~~~~   ~~~~~~
      Callsign                               1            6
      Given Names                            8           35
      Surname                               44           35
      Street Address                        80           70
      City                                 151           35
      Province                             187            2
      Postal/ZIP Code                      190           10
      BASIC Qualification (A)              201            1
      5WPM Qualification (B)               203            1
      12WPM Qualification (C)              205            1
      ADVANCED Qualification (D)           207            1
      Basic with Honours (E)               209            1 <--- End here?
      Club Name (field 1)                  211           70
      Club Name (field 2)                  282           70
      Club Address                         353           70
      Club City                            424           35
      Club Province                        460            2
      Club Postal/ZIP Code                 463            7

On 2012-May-18, at 06:28 , ve7did wrote:

> Hi Jeff:  Yes, that is what I am getting as well.  Perhaps someone else (Curt) has some ideas..
> 
> Propagation Knows No Boundaries
> 73 de Tom,  ve7did
> 
> 
> 
> Jeff Brower wrote:
>> Hi Tom.
>> 
>> Yes, I see the same thing. That's why I made the comment :
>> 
>> "It does display but the parsing is nt(sic) longer correct for the new IC/RAC txt format."
>> 
>> I see RAC Database Lookup
>> Name
>> address
>> City, BC
>> Zip
>> License level 
>> Then an indented r a empty line the it is followed by some one else's address that is badly parsed. 
>> Is that what you are seeing?
>> 
>> I'm not sure if it is caused by a Windows LF compared to a Linux newline or what is happening. The old RAC db parsed cleanly.
>> 
>> Jeff
>> 
>> 
>> 
>> On 2012-May-17, at 23:53 , ve7did wrote:
>> 
>>  
>>> Hi Jeff:
>>> Just having a second look at the Station Info and there is a strange address for each user.
>>> 
>>> Do you see the same?
>>> 
>>> Propagation Knows No Boundaries
>>> 73 de Tom,  ve7did
>>> 
>>> 
>>> 
>>>    
>> 
>> Hi Tom,
>> 
>> I had problems too. 
>> Try changing the url to (worked earlier this week):
>> 
>> http://apc-cap.ic.gc.ca/datafiles/amateur.zip
>> 
>> And make sure to change the script from file2 = amateur.rpt to file2 =amateur.txt
>> 
>> It does display but the parsing is nt longer correct for the new IC/RAC txt format.
>> 
>> I hope this helps.
>> 
>> 73, Jeff VE7THZ/VA7TZ/NK0L
>> 
>> 
>> On 2012-May-17, at 20:48 , ve7did wrote:
>> 
>> > Anyone having difficulties updating the RAC database?  The fcc updates ok.
>> > Perhaps the url has changed?
>> > > Updated with latest cvs.
>> > ################################
>> > > root at ve7did:/usr/local/share/xastir/scripts# perl get-fcc-rac.pl
>> > Name "main::prefix" used only once: possible typo at get-fcc-rac.pl line 31.
>> > *********************************
>> > *** Fetching the RAC database ***
>> > *********************************
>> > --2012-05-17 13:24:03--  http://205.236.99.41/%7Eindicatif/download/amateur.zip
>> > Connecting to 205.236.99.41:80... connected.
>> > HTTP request sent, awaiting response... 403 Forbidden
>> > 2012-05-17 13:24:03 ERROR 403: Forbidden.
>> > > > -- > Propagation Knows No Boundaries
>> > 73 de Tom,  ve7did
>> >