Keyboard Shortcuts
Likes
- D-Rats
- Messages
Search
Re: Need a database please
erwestgard
¿ªÔÆÌåÓý? Yes that is what we use at the Medtronic Twin Cities Marathon to track runners in any of a dozen aid stations, medical tents and busses in real time.? We are handed a spreadsheet of starter information by our events for loading.? ?In a disaster, we would need to support ad-hoc person entry.? We years ago developed trivnetdb, a Linux database replacement for ARES-DATA on PostgreSQL.? Trivnetdb allows TCP/IP users and AX.25 Packet users to access mail, live status messages and databases that can be built on the fly for shelter operations, etc. ?A new version/rewrite under test has a web front end and messaging/query platform and are working on a dashboard for aid station /hospital capacity etc.? It works for us over mesh and DD mode.? We like an API for access to chip timing systems and could be used to upload information to other systems.? ? A basic database would be a nice back end for D-RATS.? If you could use the keypad on the radio or a cheap tablet individual hams could do queries or updates.? One update is to query a runner bib number and indicate ¡°got on a SAG bus¡± or ¡°entered an aid station¡± via a button.? Any system has to scale massively and support real time updates.? ??? From: [email protected] [mailto:[email protected]] On Behalf Of John WB4QDX
Sent: Tuesday, September 29, 2020 6:02 PM To: [email protected] Subject: Re: [d-rats] Need a database please ? We have been thinking about developing a way to take data transmitted from D-RATS forms into a database.? Since D-RATS transmits only the data from forms, an app could populate a database or a spreadsheet for further analysis or filtering.? The key is to make it versatile enough to handle data from a variety of forms and not develop it based on one particular application. ? Several years ago, a similar application was developed using packet to support medical information from the Peachtree Road Race in Atlanta with 50,000+ runners.? When someone visited (or brought) to one of several medical tents, their info was entered and included their location and if they were transported to a hospital.? When someone inquired on a runner¡¯s status, the query would provide their location and status. ? Developing something similar with D-RATS as the transport would be great.? The application could allow you to define the fields because you would already know the order and format from a form.? Once the data was captured, typical database functions could be used for query or reporting.? How do you capture the data from the radio as data entry? ? D-RATS would offer a great front end for data entry with the custom form capability.? We are looking for ideas or other programs that may be adaptable for this purpose.? Thoughts and input is appreciated. ? John WB4QDX ? From: [email protected] <[email protected]> On Behalf Of Patrick Connor via groups.io ? The forms included in D-RATS can be edited to suit your needs. New forms can also created for specific situations. If you wish to print the received message on paper, an associated XSL style sheet must must be created to format the data for printing. ? Patrick (N3TSZ) ? ? ? ? If anyone is digging into D-rats we need a database.? We are very well supplied with messaging and file transfer apps.? Radiograms scream "it is still 1917" to me.? Medical command center, missing persons and family reunification use cases need a database.? Leadership will ask about trends, shelter capacity, supply levels.? And where is a given person.? Dashboards are all the rage.? ?Simple fields are key.? Adding new entries on the fly is key.? Scale is key.? "Better data better decisions" etc.?? First name Last name? Phone number and or email Age and or DOB Gender? Location/status (no PII/HIPAA details please)? ? The American Red Cross is rolling out a large database project - cloud based- called RC Care.? After the big Microsoft Office cloud outage yesterday I realized I missed a memo on why we must all use the cloud in natural disasters.? ?We built a fleet of eight mesh tower trailers and are adding a local virtualized compute capability.? The idea is you roll to a disaster, start collecting data, operate locally and then upload via an API if the cloud comes back up lol.?? ? ? Erik, NY9D? Medtronic Twin Cities Marathon? |
Re: Need a database please
Hey John, That sounds like a great way to collate and sort a large amount of data. A D-RATS front end would be an excellent way to input the data. Patrick (N3TSZ)
On Tuesday, September 29, 2020, 07:17:49 PM EDT, John WB4QDX <jdavis@...> wrote:
We have been thinking about developing a way to take data transmitted from D-RATS forms into a database.? Since D-RATS transmits only the data from forms, an app could populate a database or a spreadsheet for further analysis or filtering.? The key is to make it versatile enough to handle data from a variety of forms and not develop it based on one particular application. ? Several years ago, a similar application was developed using packet to support medical information from the Peachtree Road Race in Atlanta with 50,000+ runners.? When someone visited (or brought) to one of several medical tents, their info was entered and included their location and if they were transported to a hospital.? When someone inquired on a runner¡¯s status, the query would provide their location and status. ? Developing something similar with D-RATS as the transport would be great.? The application could allow you to define the fields because you would already know the order and format from a form.? Once the data was captured, typical database functions could be used for query or reporting.? How do you capture the data from the radio as data entry? ? D-RATS would offer a great front end for data entry with the custom form capability.? We are looking for ideas or other programs that may be adaptable for this purpose.? Thoughts and input is appreciated. ? John WB4QDX ? From: [email protected] <[email protected]> On Behalf Of
Patrick Connor via groups.io
Sent: Tuesday, September 29, 2020 6:22 PM To: [email protected] Subject: Re: [d-rats] Need a database please ? The forms included in D-RATS can be edited to suit your needs. New forms can also created for specific situations. If you wish to print the received message on paper, an associated XSL style sheet must must be created to format the data for printing. ? Patrick (N3TSZ) ? ? ? ? If anyone is digging into D-rats we need a database.? We are very well supplied with messaging and file transfer apps.? Radiograms scream "it is still 1917" to me.? Medical command center, missing persons and family reunification use cases need a database.? Leadership will ask about trends, shelter capacity, supply levels.? And where is a given person.? Dashboards are all the rage.? ?Simple fields are key.? Adding new entries on the fly is key.? Scale is key.? "Better data better decisions" etc.?? First name Last name? Phone number and or email Age and or DOB Gender? Location/status (no PII/HIPAA details please)? ? The American Red Cross is rolling out a large database project - cloud based- called RC Care.? After the big Microsoft Office cloud outage yesterday I realized I missed a memo on why we must all use the cloud in natural disasters.? ?We built a fleet of eight mesh tower trailers and are adding a local virtualized compute capability.? The idea is you roll to a disaster, start collecting data, operate locally and then upload via an API if the cloud comes back up lol.?? ?
? Erik, NY9D? Medtronic Twin Cities Marathon? |
Re: Need a database please
¿ªÔÆÌåÓýWe have been thinking about developing a way to take data transmitted from D-RATS forms into a database.? Since D-RATS transmits only the data from forms, an app could populate a database or a spreadsheet for further analysis or filtering.? The key is to make it versatile enough to handle data from a variety of forms and not develop it based on one particular application. ? Several years ago, a similar application was developed using packet to support medical information from the Peachtree Road Race in Atlanta with 50,000+ runners.? When someone visited (or brought) to one of several medical tents, their info was entered and included their location and if they were transported to a hospital.? When someone inquired on a runner¡¯s status, the query would provide their location and status. ? Developing something similar with D-RATS as the transport would be great.? The application could allow you to define the fields because you would already know the order and format from a form.? Once the data was captured, typical database functions could be used for query or reporting.? How do you capture the data from the radio as data entry? ? D-RATS would offer a great front end for data entry with the custom form capability.? We are looking for ideas or other programs that may be adaptable for this purpose.? Thoughts and input is appreciated. ? John WB4QDX ? From: [email protected] <[email protected]> On Behalf Of
Patrick Connor via groups.io
Sent: Tuesday, September 29, 2020 6:22 PM To: [email protected] Subject: Re: [d-rats] Need a database please ? The forms included in D-RATS can be edited to suit your needs. New forms can also created for specific situations. If you wish to print the received message on paper, an associated XSL style sheet must must be created to format the data for printing. ? Patrick (N3TSZ) ? ? ? ? If anyone is digging into D-rats we need a database.? We are very well supplied with messaging and file transfer apps.? Radiograms scream "it is still 1917" to me.? Medical command center, missing persons and family reunification use cases need a database.? Leadership will ask about trends, shelter capacity, supply levels.? And where is a given person.? Dashboards are all the rage.? ?Simple fields are key.? Adding new entries on the fly is key.? Scale is key.? "Better data better decisions" etc.?? First name Last name? Phone number and or email Age and or DOB Gender? Location/status (no PII/HIPAA details please)? ? The American Red Cross is rolling out a large database project - cloud based- called RC Care.? After the big Microsoft Office cloud outage yesterday I realized I missed a memo on why we must all use the cloud in natural disasters.? ?We built a fleet of eight mesh tower trailers and are adding a local virtualized compute capability.? The idea is you roll to a disaster, start collecting data, operate locally and then upload via an API if the cloud comes back up lol.?? ?
? Erik, NY9D? Medtronic Twin Cities Marathon? |
Re: Need a database please
The forms included in D-RATS can be edited to suit your needs. New forms can also created for specific situations. If you wish to print the received message on paper, an associated XSL style sheet must must be created to format the data for printing. Patrick (N3TSZ)
On Tuesday, September 29, 2020, 06:10:00 PM EDT, ny9d@... <ny9d@...> wrote:
If anyone is digging into D-rats we need a database.? We are very well supplied with messaging and file transfer apps.? Radiograms scream "it is still 1917" to me.? Medical command center, missing persons and family reunification use cases need a database.? Leadership will ask about trends, shelter capacity, supply levels.? And where is a given person.? Dashboards are all the rage.? ?Simple fields are key.? Adding new entries on the fly is key.? Scale is key.? "Better data better decisions" etc.??
First name
Last name?
Phone number and or email
Age and or DOB
Gender?
Location/status (no PII/HIPAA details please)?
?
The American Red Cross is rolling out a large database project - cloud based- called RC Care.? After the big Microsoft Office cloud outage yesterday I realized I missed a memo on why we must all use the cloud in natural disasters.? ?We built a fleet of eight mesh tower trailers and are adding a local virtualized compute capability.? The idea is you roll to a disaster, start collecting data, operate locally and then upload via an API if the cloud comes back up lol.??
?
https://www.youtube.com/playlist?list=PLpPGplrS0T3rs0Cexr7buwRaa0lOLdhRT
?
Erik, NY9D?
Medtronic Twin Cities Marathon?
|
Need a database please
If anyone is digging into D-rats we need a database.? We are very well supplied with messaging and file transfer apps.? Radiograms scream "it is still 1917" to me.? Medical command center, missing persons and family reunification use cases need a database.? Leadership will ask about trends, shelter capacity, supply levels.? And where is a given person.? Dashboards are all the rage.? ?Simple fields are key.? Adding new entries on the fly is key.? Scale is key.? "Better data better decisions" etc.??
First name
Last name?
Phone number and or email
Age and or DOB
Gender?
Location/status (no PII/HIPAA details please)?
?
The American Red Cross is rolling out a large database project - cloud based- called RC Care.? After the big Microsoft Office cloud outage yesterday I realized I missed a memo on why we must all use the cloud in natural disasters.? ?We built a fleet of eight mesh tower trailers and are adding a local virtualized compute capability.? The idea is you roll to a disaster, start collecting data, operate locally and then upload via an API if the cloud comes back up lol.??
?
https://www.youtube.com/playlist?list=PLpPGplrS0T3rs0Cexr7buwRaa0lOLdhRT
?
Erik, NY9D?
Medtronic Twin Cities Marathon? |
Re: Starting up d-rats development
Maurizio Andreotti <maurizioandreottilc@... wrote:
AboutThe ISP does not drop the entire internet connection, it only drops the idle TCP/IP sessions. The only way to keep that from happening is to use a tcpip keep-alive in the affected application. Easy to implement, except that you want to make sure that it never makes it on the air. So a ratflector needs to discard it, instead of relaying an empty packet. As I do not currently have documentation of the protocol used for a ratflector, I do not know if it has some way to discarding empty packets already. This keepalive also should not be needed as D-rats contains code to throw an exception when the connection has been disconnected and then reconnect it. On my Windows systems, the exception is not being thrown, and D-rats goes into an tight CPU bound loop retrying doing a read() from the disconnected sockets. Also, even though d-rats should reconnected if the connection is disconnected, there is a possibility that with out a keepalive in the protocol, some message fragments may be lost. I may need to try various Windows Python implementations to see if the problem is unique to the one that I am currently using for d-rats. Regards, -John WB8TYW |
Re: Starting up d-rats development
Larry Whited
¿ªÔÆÌåÓýWA4YIH Ed Woodrick has written a keep-alive tool for this very problem. ?We used that during our Covid status monitoring nets back in March. It works great. This is not a unique problem.
Larry, AB4NX
Get for iOS
From: [email protected] <[email protected]> on behalf of Maurizio Andreotti <maurizioandreottilc@...>
Sent: Monday, September 28, 2020 4:13:45 AM To: [email protected] <[email protected]> Subject: Re: [d-rats] Starting up d-rats development ?
About
"My ISP will drop connections that do not have any activity for some period of minutes, so this is pretty must guaranteed to occur for me" Wouldn¡¯t be enough to setup a ping to some internet host to keep the connection alive? -----Original Message----- From: [email protected] <[email protected]> On Behalf Of John E. Malmberg Sent: domenica 27 settembre 2020 15:48 To: [email protected] Subject: [d-rats] Starting up d-rats development I have finally got a setup to start testing and debugging d-rats. Is it possible for me to get write access to the WIKI at The github user is "wb8tyw" I am using Visual Studio code for the editing. So far I have installed "markdownlint" from David Anson "Markdown Preview Github Styling" by Matt Bierner. The first thing that I noticed after starting to get set up is that the does not pass markdown lint. Getting it to pass will remove many or all of the horizontal bars in the text.?? Would a PR to make it pass markdown lint be accepted? Aside from just getting an isolated development environment working, there is a Windows Bug that I need to find out more information on. On Windows (Both versions I have tested) D-rats, if the connection drops, D-rats goes into a continuous read loop. My ISP will drop connections that do not have any activity for some period of minutes, so this is pretty must guaranteed to occur for me when connected to a ratflector.?? The only workaround I have found is to setup a QST to spam the ratflector. In my analysis of the d-rats code, it is looking like something is broken in the python that I am using, in that it is not raising the exception when the connection is broken. I notice that we also do not have documentation of the following: 1. The protocol between d-rats and the radio. 2. The protocol between d-rats and a ratflector. I do not know if the protocol between d-rats and a ratflector can be setup with a TCP/IP keepalive that would not be transmitted over the air. I should be able to be testing soon on: Anti-X Linux current version based on Debian Buster.? (primary) Ubuntu Linux 20.04 Raspberry Pi Linux current version based on Debian Buster. Windows 7 64 bit. Windows 8.1 64 bit. Windows 10 32 bit. In the future I should be able to add VMs for other Linux distributions and a single Windows 10 64 bit VM. I would also like to try experimenting with SikuliX to do automated testing of d-rats. Regards, -John |
Re: Starting up d-rats development
About
toggle quoted message
Show quoted text
"My ISP will drop connections that do not have any activity for some period of minutes, so this is pretty must guaranteed to occur for me" Wouldn¡¯t be enough to setup a ping to some internet host to keep the connection alive? -----Original Message-----
From: [email protected] <[email protected]> On Behalf Of John E. Malmberg Sent: domenica 27 settembre 2020 15:48 To: [email protected] Subject: [d-rats] Starting up d-rats development I have finally got a setup to start testing and debugging d-rats. Is it possible for me to get write access to the WIKI at The github user is "wb8tyw" I am using Visual Studio code for the editing. So far I have installed "markdownlint" from David Anson "Markdown Preview Github Styling" by Matt Bierner. The first thing that I noticed after starting to get set up is that the does not pass markdown lint. Getting it to pass will remove many or all of the horizontal bars in the text. Would a PR to make it pass markdown lint be accepted? Aside from just getting an isolated development environment working, there is a Windows Bug that I need to find out more information on. On Windows (Both versions I have tested) D-rats, if the connection drops, D-rats goes into a continuous read loop. My ISP will drop connections that do not have any activity for some period of minutes, so this is pretty must guaranteed to occur for me when connected to a ratflector. The only workaround I have found is to setup a QST to spam the ratflector. In my analysis of the d-rats code, it is looking like something is broken in the python that I am using, in that it is not raising the exception when the connection is broken. I notice that we also do not have documentation of the following: 1. The protocol between d-rats and the radio. 2. The protocol between d-rats and a ratflector. I do not know if the protocol between d-rats and a ratflector can be setup with a TCP/IP keepalive that would not be transmitted over the air. I should be able to be testing soon on: Anti-X Linux current version based on Debian Buster. (primary) Ubuntu Linux 20.04 Raspberry Pi Linux current version based on Debian Buster. Windows 7 64 bit. Windows 8.1 64 bit. Windows 10 32 bit. In the future I should be able to add VMs for other Linux distributions and a single Windows 10 64 bit VM. I would also like to try experimenting with SikuliX to do automated testing of d-rats. Regards, -John |
Re: Starting up d-rats development
Hi John, I have just invited "wb8tyw" as contributor for the github
toggle quoted message
Show quoted text
Have a nice day, maurizio -----Original Message-----
From: [email protected] <[email protected]> On Behalf Of John E. Malmberg Sent: domenica 27 settembre 2020 15:48 To: [email protected] Subject: [d-rats] Starting up d-rats development I have finally got a setup to start testing and debugging d-rats. Is it possible for me to get write access to the WIKI at The github user is "wb8tyw" I am using Visual Studio code for the editing. So far I have installed "markdownlint" from David Anson "Markdown Preview Github Styling" by Matt Bierner. The first thing that I noticed after starting to get set up is that the does not pass markdown lint. Getting it to pass will remove many or all of the horizontal bars in the text. Would a PR to make it pass markdown lint be accepted? Aside from just getting an isolated development environment working, there is a Windows Bug that I need to find out more information on. On Windows (Both versions I have tested) D-rats, if the connection drops, D-rats goes into a continuous read loop. My ISP will drop connections that do not have any activity for some period of minutes, so this is pretty must guaranteed to occur for me when connected to a ratflector. The only workaround I have found is to setup a QST to spam the ratflector. In my analysis of the d-rats code, it is looking like something is broken in the python that I am using, in that it is not raising the exception when the connection is broken. I notice that we also do not have documentation of the following: 1. The protocol between d-rats and the radio. 2. The protocol between d-rats and a ratflector. I do not know if the protocol between d-rats and a ratflector can be setup with a TCP/IP keepalive that would not be transmitted over the air. I should be able to be testing soon on: Anti-X Linux current version based on Debian Buster. (primary) Ubuntu Linux 20.04 Raspberry Pi Linux current version based on Debian Buster. Windows 7 64 bit. Windows 8.1 64 bit. Windows 10 32 bit. In the future I should be able to add VMs for other Linux distributions and a single Windows 10 64 bit VM. I would also like to try experimenting with SikuliX to do automated testing of d-rats. Regards, -John |
Re: Starting up d-rats development
Strong work!
toggle quoted message
Show quoted text
On Sep 27, 2020, at 8:48 AM, John E. Malmberg <wb8tyw@...> wrote: |
Starting up d-rats development
I have finally got a setup to start testing and debugging d-rats.
Is it possible for me to get write access to the WIKI at The github user is "wb8tyw" I am using Visual Studio code for the editing. So far I have installed "markdownlint" from David Anson "Markdown Preview Github Styling" by Matt Bierner. The first thing that I noticed after starting to get set up is that the does not pass markdown lint. Getting it to pass will remove many or all of the horizontal bars in the text. Would a PR to make it pass markdown lint be accepted? Aside from just getting an isolated development environment working, there is a Windows Bug that I need to find out more information on. On Windows (Both versions I have tested) D-rats, if the connection drops, D-rats goes into a continuous read loop. My ISP will drop connections that do not have any activity for some period of minutes, so this is pretty must guaranteed to occur for me when connected to a ratflector. The only workaround I have found is to setup a QST to spam the ratflector. In my analysis of the d-rats code, it is looking like something is broken in the python that I am using, in that it is not raising the exception when the connection is broken. I notice that we also do not have documentation of the following: 1. The protocol between d-rats and the radio. 2. The protocol between d-rats and a ratflector. I do not know if the protocol between d-rats and a ratflector can be setup with a TCP/IP keepalive that would not be transmitted over the air. I should be able to be testing soon on: Anti-X Linux current version based on Debian Buster. (primary) Ubuntu Linux 20.04 Raspberry Pi Linux current version based on Debian Buster. Windows 7 64 bit. Windows 8.1 64 bit. Windows 10 32 bit. In the future I should be able to add VMs for other Linux distributions and a single Windows 10 64 bit VM. I would also like to try experimenting with SikuliX to do automated testing of d-rats. Regards, -John |
Re: RF-only D-RATS
¿ªÔÆÌåÓýDon't forget that D-Rats works over AX.25 packet networks too. --David KI6ZHD On 09/18/2020 07:30 PM, Rafael Diniz
wrote:
You just need a D-Star enabled radio. I have a IC-7100. Indeed, through the D-Star data channel you can transfer anything you want. Rafael On 9/18/20 9:25 PM, Patrick Connor via groups.io wrote:D-RATS started out as an RF only application for D-STAR radios. The network connection was added later. So yes, D-RATS can do all that stuff on RF only. Patrick (N3TSZ) On Friday, September 18, 2020, 08:22:58 PM EDT, KP3FT via groups.io <kp3ft@...> wrote: Hi all, Just found out about D-RATS.? I was wondering what it can, and can't, do with RF-only; no internet.? Will it do message store-and-forward, file-transfer, chat, and ICS forms if all radios are D-STAR?? And multiple connects?? Thanks, 73 |
Re: RF-only D-RATS
You just need a D-Star enabled radio. I have a IC-7100. Indeed, through
toggle quoted message
Show quoted text
the D-Star data channel you can transfer anything you want. Rafael On 9/18/20 9:25 PM, Patrick Connor via groups.io wrote:
D-RATS started out as an RF only application for D-STAR radios. The |
Re: RF-only D-RATS
D-RATS started out as an RF only application for D-STAR radios. The network connection was added later. So yes, D-RATS can do all that stuff on RF only. Patrick (N3TSZ)
On Friday, September 18, 2020, 08:22:58 PM EDT, KP3FT via groups.io <kp3ft@...> wrote:
Hi all, Just found out about D-RATS.? I was wondering what it can, and can't, do with RF-only; no internet.? Will it do message store-and-forward, file-transfer, chat, and ICS forms if all radios are D-STAR?? And multiple connects?? Thanks, 73 |
Re: Trying to access a ratflector from my radio
If you do make a sked, and it is on voice reflector BE PREPARED for all the helpful hams telling you "You have NO AUDIO on your transmission". LOL They will SEE the data flow (Call, name, whatever message you have), but not hear the audio. If you can pick a one-off reflector, like a D, the sked will be better. OR NOT, maybe come back to the 'helpful' hams and let them know what you are doing and they will explore too. 73 On Tue, Sep 15, 2020 at 6:23 AM ko4fzj <bodell@...> wrote:
-- jim fisher Jedijf AJ3DI "Do, or do not. There is no 'try.'" ? --? Jedi Master Yoda |
Re: Trying to access a ratflector from my radio
ko4fzj
Patrick, |
Re: Trying to access a ratflector from my radio
It is unlikely you will make a D-RATS contact on a D-STAR reflector unless you make a sked first. Most D-RATS activity takes place on the internet or on local frequencies. I believe there is a bridge between the GA ARES Ratflector and a repeater in Atlanta. I think it sits on REF030A most of the time. K3PDR in Philadelphia has a Ratflector with D-STAR and analog radios connected to it exclusively for local D-RATS traffic. One way to test the connection to your 5100 is listen to a mobile or portable radio that is transmitting a GPS stream. You should be able to see the data being decoded in the Events Log tab. If that works, then you probably have everything else set correctly. Patrick (N3TSZ)
On Monday, September 14, 2020, 05:53:33 AM EDT, ko4fzj <bodell@...> wrote:
I watched your video, and we are in agreement that it is too late to figure out how this stuff works if you wait until you need it. I have been connecting my laptop to my id-5100, and using my pi-star to connect to the reflectors that say "data" or "d-rats" in the descriptions. I then do a "ping all stations" and have never seen another station. I am quite confident all is configured correctly, as it works thru the internet, and I can see my radio key up when d-rats makes a call. Please let me know what I am doing wrong, and if my (infrequent) actions are impacting other users or resources. -KO4FZJ |