CUSTOM DMR Database

Post Reply
KA1CM
Posts: 97
Joined: Tue Nov 28, 2023 4:14 pm

CUSTOM DMR Database

Post by KA1CM » Tue Apr 16, 2024 1:30 am

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
rrr.png (86.75 KiB) Viewed 9016 times

GitHub Repository page

Excel file with source code, in case you wanna make your own version focusing on something that suite you.
Just click on the big-red-button "Download & Modify" and wait. After a while, you will get user.csv on your desktop.


Hope this to be useful.
73, KA1CM

Sample screenshots
US and Canada
USA.jpg
USA.jpg (113.36 KiB) Viewed 9187 times
Global
global.jpg
global.jpg (111.86 KiB) Viewed 9187 times
More screenshots from RT3S
Image
Last edited by KA1CM on Tue May 14, 2024 5:53 pm, edited 4 times in total.

KA1CM
Posts: 97
Joined: Tue Nov 28, 2023 4:14 pm

Re: CUSTOM DMR Database

Post by KA1CM » Fri Apr 19, 2024 9:02 pm

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.
Attachments
Screenshot 2024-04-19 165712.jpg
Screenshot 2024-04-19 165712.jpg (41.16 KiB) Viewed 9014 times

SA0BUX
Posts: 605
Joined: Tue Jul 05, 2022 8:50 am
Location: JO99ah, Stockholm, Sweden
Contact:

Re: CUSTOM DMR Database

Post by SA0BUX » Sat Apr 20, 2024 8:57 am

KA1CM wrote:
Fri Apr 19, 2024 9:02 pm
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
Capture.JPG (46.47 KiB) Viewed 8839 times
This is with Excel 2019 but I got the same error in 2013

KA1CM
Posts: 97
Joined: Tue Nov 28, 2023 4:14 pm

Re: CUSTOM DMR Database

Post by KA1CM » Sat Apr 20, 2024 1:05 pm

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
Posts: 97
Joined: Tue Nov 28, 2023 4:14 pm

Re: CUSTOM DMR Database

Post by KA1CM » Sat Apr 20, 2024 4:39 pm

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
Posts: 605
Joined: Tue Jul 05, 2022 8:50 am
Location: JO99ah, Stockholm, Sweden
Contact:

Re: CUSTOM DMR Database

Post by SA0BUX » Sun Apr 21, 2024 8:10 am

KA1CM wrote:
Sat Apr 20, 2024 4:39 pm
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
Posts: 97
Joined: Tue Nov 28, 2023 4:14 pm

Re: CUSTOM DMR Database

Post by KA1CM » Mon Apr 22, 2024 5:07 pm

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
Screenshot 2024-04-22 130233.jpg (92.99 KiB) Viewed 8618 times

KA1CM
Posts: 97
Joined: Tue Nov 28, 2023 4:14 pm

Re: CUSTOM DMR Database

Post by KA1CM » Tue May 14, 2024 2:01 pm

Re-Generated user.csv on 14 May 2024

What changed?

Post Reply