Re: [VoiceOps] 911 Database Stuff

[Andrew Haninger via VoiceOps]

I did something like this in Excel long ago. Not VBA, but regular Excel
formulas with conditional formatting to help sort out one set of records
from another. It wasn't pretty, but it worked for what we needed and it was
better than nothing.

Andy



On Thu, Nov 10, 2022, 16:57 Mike Hammett via VoiceOps 
wrote:

> Does anyone have a better way of generating the NENA SOI files than
> Notepad if you're waiting on your billing system to make reports that
> generate the correct files automatically?
>
>
>
> -
> Mike Hammett
> Intelligent Computing Solutions
> http://www.ics-il.com
>
>
>
> Midwest Internet Exchange
> http://www.midwest-ix.com
>
>
>
> --
> *From: *"Mike Hammett via VoiceOps" 
> *To: *voiceops@voiceops.org
> *Sent: *Tuesday, October 18, 2022 5:21:39 PM
> *Subject: *[VoiceOps] 911 Database Stuff
>
> Going through a migration from E911 to NG911, I've been peering into what
> and how we do 911, both old and new.
>
> A) Not all services have a web UI for you to make changes. Intrado does,
> but the new one does not. Only way is to upload SOI files. I guess we gotta
> figure out how to do that.
> B) We have more entries than we have TNs.
> C) People are bad at documentation.
>
> I'm assuming we should be deleting records for customers that disconnected
> service. I'm not sure we've done that, based on the records that I see.
> For customers that port away, I'm assuming we're supposed to be unlocking
> the TN for the new provider to take over the record.
> If I unlock it, but the new provider never migrates away, what do I do
> with it?
> What happens if a provider inserts a duplicate record?
>
>
>
> -
> Mike Hammett
> Intelligent Computing Solutions
> http://www.ics-il.com
>
>
>
> Midwest Internet Exchange
> http://www.midwest-ix.com
>
>
>
>
> ___
> VoiceOps mailing list
> VoiceOps@voiceops.org
> https://puck.nether.net/mailman/listinfo/voiceops
>
> ___
> VoiceOps mailing list
> VoiceOps@voiceops.org
> https://puck.nether.net/mailman/listinfo/voiceops
>
___
VoiceOps mailing list
VoiceOps@voiceops.org
https://puck.nether.net/mailman/listinfo/voiceops

Re: [VoiceOps] Automatic 911 location updates

[Andrew Haninger]

(This time to the group. Sorry for the dupe, Carlos.)

On Tue, Oct 23, 2018, 19:22 Carlos Alvarez  wrote:

> Is anyone doing this yet?  The ability to detect the location of a phone
> and automatically update the 911 address?  Yes, I realize it's a difficult
> if not impossible thing, yet thought I'd ask since a customer asked me.
>

The Skype for Business system does this where I work. It uses the location
of the nearest AP or the location recorded for the jack you're using if
you're wired. If neither are available, the SfB application asks the user
to enter their location.

The analog phones we're switching from only update when an order is
processed, but then customers generally have to put in a request for us to
do a MAC order. The local PSAP will report to us if they get a 911 call
with incorrect name or location info.

It's not fool proof and there is plenty of room for errors, but it's not
too bad, either.

Andt

>
___
VoiceOps mailing list
VoiceOps@voiceops.org
https://puck.nether.net/mailman/listinfo/voiceops