CUSTOM DMR Database

[KA1CM]

Hi all,
I really love our firmware, very special thanks to Roger and Daniel for all the fantastic work.

I'm giving back to the community, a custom DMR ID database.

This database will try to display First_Name and Last_Name on the first line. If they are too long, it will display only First_Name.

For the City, State, and Country. it will try to display them on the second line. To be able to make this possible, I use "." to group them together.

copy and paste this link to Download from URL box and click "Download from..."

rrr.png (86.75 KiB) Viewed 604 times

Hope this to be useful.
73, KA1CM

Sample screenshots
US and Canada

USA.jpg (113.36 KiB) Viewed 775 times

Global

global.jpg (111.86 KiB) Viewed 775 times

More screenshots from RT3S

[KA1CM]

Excel file with source code, in case you wanna make your own version focusing on something that suite you.

DMRID.xlsm

Just click on the big-red-button "Download & Modify" and wait. After a while, you will get user.csv on your desktop.

[SA0BUX]

Excel file with source code, in case you wanna make your own version focusing on something that suite you.

DMRID.xlsm

Just click on the big-red-button "Download & Modify" and wait. After a while, you will get user.csv on your desktop.

I got a "Run Time Error '1104': Application-defined or object-defined error"

Capture.JPG (46.47 KiB) Viewed 427 times

This is with Excel 2019 but I got the same error in 2013

[KA1CM]

I'm using office 365. I believe the "FormulaVersion:=xlReplaceFormula2" is the problem with older Excel. I've tried remove it from the code and it work fine on my 365, so I will update the source on GitHub for backward compatibility.

I'm in the middle of config GitHub to display my code (using hook). In the meantime you can try remove "FormulaVersion:=xlReplaceFormula2" and run the code again.

By the way there are two "FormulaVersion:=xlReplaceFormula2" in the code.

[KA1CM]

the Excel file has been updated on Github. Please let me know if it work?

I still can't get GitHub to work, just manually replace the file. Very annoying.

[SA0BUX]

the Excel file has been updated on Github. Please let me know if it work?

I still can't get GitHub to work, just manually replace the file. Very annoying.

Yes, it works fine now !

[KA1CM]

Finally I have made it work!!!

I don't quite understand Microsoft. Why is it so hard to make their products work together. Excel, Github, and OneDrive are all their products, and I have to spent the whole weekend to make them work together.

Screenshot 2024-04-22 130233.jpg (92.99 KiB) Viewed 206 times