New CSV Memory Tool (Excel) for AR-DV10

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
I made a few changes. Please try this one. I think it will handle the "," regional setting (no other changes).
 

Attachments

  • AOR AR-DV10 CSV Formatter - Writer (V0.1).zip
    434.2 KB · Views: 20

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
Nope, see screenshot.

If you want to test it on your virtual Mac:
🍏 \ System Preferences... \ Language & Region \ Advanced...
At the General tab you can change the Number separators.

But no problem if you want me to test it.
 

Attachments

  • Screenshot 2023-09-13 at 14.31.12.png
    Screenshot 2023-09-13 at 14.31.12.png
    59.6 KB · Views: 4

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I took the easy way and changed the "Number separators" of my macOS. I don't think that's a problem for my other applications.
I will test writing to the radio later this week, maybe today.
I tested it. After writing the generated memch.csv and membk.csv to the radio I couldn't scroll through the memory channels by rotating the DIAL selector. By rotating it, sometimes the channel wasn't changed, and sometimes the channel changed from 3 to 7 for example.
Restoring my system.csv didn't help. A system reset didn't help. After a full reset the radio hang showing "Reset execute". After 10 minutes or more I switched off the radio. I tried a full reset again. After that a beep was heard stopping very shortly about every second, no matter what frequency I entered. 😱
I switched off the radio and switched it on again, and wrote the 2 generated CSV-files to the radio again. Same problems again.
I saw that there is an error 2015 in membk.ch. Not in memch.csv.
 
Last edited:

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
I still see the error 2015 in the memory bank file. The memory channel file looks OK. Just got back into town. I will look at it tomorrow.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I still see the error 2015 in the memory bank file. The memory channel file looks OK. Just got back into town. I will look at it tomorrow.
Oops. I thought you would be sleeping and changed my post after I saw the error 2015.
 

digiman1

Member
Joined
Aug 9, 2018
Messages
127
I ran into an issue when saving. it saves the Channels to a CSV ok but appears to fail on saving the banks with a Runtime Error '13' Type Mismatch?

1695215790496.png
 
Last edited:

digiman1

Member
Joined
Aug 9, 2018
Messages
127
See attached.. Thank you.
 

Attachments

  • AOR AR-DV CSV Formatter DIGIMAN1-ISSUE.zip
    460.3 KB · Views: 15

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
You reversed the entries in the frequency and memory tag columns in rows 252-275. It's failing because of the non-numeric entries in the frequency column (c). This first release doesn't have much error checking. The next release will have more. Reverse those and it should be OK.
 

digiman1

Member
Joined
Aug 9, 2018
Messages
127
You reversed the entries in the frequency and memory tag columns in rows 252-275. It's failing because of the non-numeric entries in the frequency column (c). This first release doesn't have much error checking. The next release will have more. Reverse those and it should be OK.
Right... That's embarrassing lol. I scrolled, scrolled and scrolled and that did not stand out to me haha. Thank you.
 

digiman1

Member
Joined
Aug 9, 2018
Messages
127
So, I was able to build up my Banks and Channels but when I load it to my DV10 it has loads of unused channels.
So, In bank 00 I have 5 channels for Tetra but the rest of bank 00 is blank channels. Hope that makes sense? Is that how it is meant to work as an early version or am I doing something wrong?
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
The radio has 40 banks of 50 channels each (00-39). The spreadsheet matches that. If you only enter 5 rows of data in bank 00 in channels 00-04, that's all that will be available in the radio. The tool does not compress or re-number the data - it loads it exactly as entered, by design. All the other rows will be blank. What are you expecting for the rows with no data?
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
Did you radio previously skip past the channels with no data until you loaded the data files created by the tool? If so, that's an easy fix. Currently, the tool writes all rows to the output file - even the blank ones. I can change it to write only the rows with data. I never loaded my radio with any tool other than this one, so the blank channels is what I've always seen.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
Please try the attached. I added an option when writing both the channels and banks files to write ALL rows or just the rows with data. Clicking "Yes" will work as it does currently. Clicking "No" will write only the rows with data. Please let me know if the radio scrolls as expected using the "No" option for both channel and bank files. If you select "No", i.e. write only channels/banks with data I think it will leave existing channels alone and only overwrite channels with data in the spreadsheet. Selecting "Yes" will overwrite ALL data.

Thanks for helping test this!
 

Attachments

  • AOR AR-DV10 CSV Formatter - Writer (V0.1).zip
    438.4 KB · Views: 14

digiman1

Member
Joined
Aug 9, 2018
Messages
127
Please try the attached. I added an option when writing both the channels and banks files to write ALL rows or just the rows with data. Clicking "Yes" will work as it does currently. Clicking "No" will write only the rows with data. Please let me know if the radio scrolls as expected using the "No" option for both channel and bank files. If you select "No", i.e. write only channels/banks with data I think it will leave existing channels alone and only overwrite channels with data in the spreadsheet. Selecting "Yes" will overwrite ALL data.

Thanks for helping test this!
Great, so that definitely fixed the Banks filled with blank channels on the DV10.

Came across another issue with banks.
You will see here I have named 2 Banks for Tetra and Marine:
1695227449276.png

I have created the following Channels for bank 00 Tetra:
1695227506420.png

And the following Channels for bank 01 Marine:
1695227574893.png

On My DV10, All the channels go into bank 00 Tetra, there is no Bank 01 in the radio.
I will post my filles in the next post as it wont allow me to upload anything else here.
 
Top