X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fpart_export%2Fnena2.pm;h=36f0293021c4e91af7b36acd0f920e3c4b2ab2a0;hb=f84f4970c03fa01779fc94cdc9dbada9f314b0cc;hp=50f4b1695845769515c4abe484c6bb160e817eb4;hpb=03e71483c54ec32d701d6726ec0f5b6b8aa48b02;p=freeside.git diff --git a/FS/FS/part_export/nena2.pm b/FS/FS/part_export/nena2.pm index 50f4b1695..36f029302 100644 --- a/FS/FS/part_export/nena2.pm +++ b/FS/FS/part_export/nena2.pm @@ -15,7 +15,7 @@ my %upload_targets; tie %options, 'Tie::IxHash', ( 'company_name' => { label => 'Company name for header record', - type => 'text' + type => 'text', }, 'company_id' => { label => 'NENA company ID', type => 'text', @@ -169,15 +169,6 @@ my %function_code = ( ); sub immediate { - local $@; - eval "use Geo::StreetAddress::US"; - if ($@) { - if ($@ =~ /^Can't locate/) { - return "Geo::StreetAddress::US must be installed to use the NENA2 export."; - } else { - die $@; - } - } # validate some things my ($self, $action, $svc) = @_; @@ -209,6 +200,15 @@ sub create_item { } sub data { + local $@; + eval "use Geo::StreetAddress::US"; + if ($@) { + if ($@ =~ /^Can't locate/) { + return "Geo::StreetAddress::US must be installed to use the NENA2 export."; + } else { + die $@; + } + } # generate the entire record here. reconciliation of multiple updates to # the same service can be done at process time. my $self = shift; @@ -224,46 +224,88 @@ sub data { my %hash = map { $_ => '' } @{ $item_format->names }; $hash{function_code} = $function_code{$action}; - + # Add default area code if phonenum is 7 digits - if ($self->option('area_code') =~ /^\d{3}/ && $svc->phonenum =~ /^\d{7}/ ){ - $svc->phonenum = $self->option('area_code'). $svc->phonenum + my $phonenum = $svc->phonenum; + if ($self->option('area_code') =~ /^\d{3}$/ && $phonenum =~ /^\d{7}$/ ){ + $phonenum = $self->option('area_code'). $svc->phonenum; } # phone number - - $svc->phonenum =~ /^(\d{3})(\d*)$/; + $phonenum =~ /^(\d{3})(\d*)$/; $hash{npa} = $1; $hash{calling_number} = $2; # street address + # some cleanup: + my $full_address = $cust_location->address1; + my $address2 = $cust_location->address2; + if (length($address2)) { + # correct 'Sp', 'Sp.', 'sp ', etc. to the word SPACE for convenience + $address2 =~ s/^sp\b\.? ?/SPACE /i; + # and join it to $full_address with a space, not a comma + $full_address .= ' ' . $address2; + } + my $location_hash = Geo::StreetAddress::US->parse_address( - uc( join(', ', $cust_location->address1, - $cust_location->address2, - $cust_location->city, - $cust_location->state, - $cust_location->zip + uc( join(', ', $full_address, + $cust_location->city, + $cust_location->state, + $cust_location->zip ) ) ); - $hash{house_number} = $location_hash->{number}; - $hash{house_number_suffix} = ''; # we don't support this, do we? - $hash{prefix_directional} = $location_hash->{prefix}; - $hash{street_name} = $location_hash->{street}; - $hash{street_suffix} = $location_hash->{type}; - $hash{post_directional} = $location_hash->{suffix}; - $hash{community_name} = $location_hash->{city}; - $hash{state} = $location_hash->{state}; - if ($location_hash->{sec_unit_type}) { - $hash{location} = $location_hash->{sec_unit_type} . ' ' . - $location_hash->{sec_unit_num}; + if ( !$location_hash and length($address2) ) { + # then parsing failed. Try again without the address2. + $location_hash = Geo::StreetAddress::US->parse_address( + uc( join(', ', + $cust_location->address1, + $cust_location->city, + $cust_location->state, + $cust_location->zip + ) ) + ); + # this should not produce an address with sec_unit_type, + # so 'location' will be set to address2 + } + if ( $location_hash ) { + # then store it + $hash{house_number} = $location_hash->{number}; + $hash{house_number_suffix} = ''; # we don't support this, do we? + $hash{prefix_directional} = $location_hash->{prefix}; + $hash{street_name} = $location_hash->{street}; + $hash{street_suffix} = $location_hash->{type}; + $hash{post_directional} = $location_hash->{suffix}; + $hash{community_name} = $location_hash->{city}; + $hash{state} = $location_hash->{state}; + if ($location_hash->{sec_unit_type}) { + $hash{location} = $location_hash->{sec_unit_type} . ' ' . + $location_hash->{sec_unit_num}; + } else { + $hash{location} = $address2; + } } else { - $hash{location} = $cust_location->address2; + # then it still wouldn't parse; happens when the address has no house + # number (which is allowed in NENA 2 format). so just put all the + # information we have into the record. (Parse::FixedLength will trim + # it to fit if necessary.) + $hash{street_name} = uc($cust_location->address1); + $hash{location} = uc($address2); + $hash{community_name} = uc($cust_location->city); + $hash{state} = uc($cust_location->state); } - $hash{location} = $location_hash->{address2}; # customer name and class $hash{customer_name} = $svc->phone_name_or_cust; $hash{class_of_service} = $svc->e911_class; + if (!$hash{class_of_service}) { + # then guess + my $cust_main = $svc->cust_main; + if ($cust_main->company) { + $hash{class_of_service} = '2'; + } else { + $hash{class_of_service} = '1'; + } + } $hash{type_of_service} = $svc->e911_type || '0'; $hash{exchange} = '';