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
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 ----- Original Message ----- From: "Mike Hammett via VoiceOps" <voiceops at voiceops.org> To: voiceops at 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 at voiceops.org https://puck.nether.net/mailman/listinfo/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 <voiceops at voiceops.org> 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" <voiceops at voiceops.org> *To: *voiceops at 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 at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
_______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
I'm working to build an Excel document to help generate the appropriate lines for a NENA SOI file. Where can I find when I would use what setting in the "Type of Service" field? Almost anywhere I go just lists the types out. "Non-published" makes sense. If it's a non-published number, then don't display the caller info to dispatch, if state regulations dictate so. To shift liability in keeping that straight, just always file that correctly, regardless of what the rules of the state are at the time. Some Googling has me believing that "Foreign Exchange" is when my switch isn't in the rate center that the caller is. Is that correct and if so, what difference does that make? What's a "911 serving area"? LNP? Is that supposed to be if they have been ported or not? What if they ported, but also fit under one of the other categories? Interim Ported Number? That one seems self-explanatory, but again, what if they also fit one of the other categories? ----- Mike Hammett Intelligent Computing Solutions http://www.ics-il.com Midwest Internet Exchange http://www.midwest-ix.com ----- Original Message ----- From: "Andrew Haninger" <ahaning at gmail.com> To: "Mike Hammett" <voiceops at ics-il.net> Cc: voiceops at voiceops.org Sent: Thursday, November 10, 2022 5:34:30 PM Subject: Re: [VoiceOps] 911 Database Stuff 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 < voiceops at voiceops.org > 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" < voiceops at voiceops.org > To: voiceops at 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 at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops _______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops
participants (2)
-
ahaning＠gmail.com -
voiceops＠ics-il.net