New CSV Memory Tool (Excel) for AR-DV10

Status
Not open for further replies.

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
Hi. The issue with the original version is because you're using a Mac. Try the version I posted on Aug 29 in a msg to fafax. He said that version worked on his Mac.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
Hi. The issue with the original version is because you're using a Mac. Try the version I posted on Aug 29 in a msg to fafax. He said that version worked on his Mac.
I used the version of Aug 29. I can write the two .xlsx-files on my Mac with Excel and your spreadsheet. But I can't read the two generated .xlsx-files on my Mac with Excel. OpenOffice on my Mac shows error 2015 at the first line in the .xlsx-files.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
@BobHGL , I'm a bit confused about your comment that you can write the 2 XLSX files, but not open them. The output of the tool is 2 CSV files, not XLSX files. Also, once you create them, you don't open them in Excel, you load them on an SD card to put in the radio and load in the radio. The generated CSV files are in a multi-line per channel format required by the radio. Can you clarify, and give me the steps you are doing when you get the error?
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
1) I unzip the latest AOR AR-DV10 CSV Formatter - Writer (V0.1).zip, of Aug 29
2) I open AOR AR-DV10 CSV Formatter - Writer (V0.1).xlsm on my Mac with Excel
3) I click on Enable Macros
4) At cell 3B i change 2205A to 2305AT
5) I don't change any data. I just want to see whether I can generatie files with your data
6) I click at Write CSV
7) I see a popup with titel "Save", and "Save As: memch.xlsx, and File Format: Excel Workbook (.xlsx)"
8) I change the File Format to CSV UTF-8 (Comma-delimited) (.csv)
I forgot to do this te previous time. That's why two .xlsx files were generated.
9) I open memch.csv with TextEdit.app, to see what has been generated.
The top lines of what I see are:
Error 2015
MC0,05,08
MC1,00,00,0152.88500,012.50,000.00,+00,+00000,0600,2000,00000,0,2,0,0x0000
MC2,0,0,0,0,1,0,0,000,2,00,00,00,1,0,0,0,0,00,"SMW "
MC3,00,0,0,0x000,0,0,00,0,0
MC1,00,01,0154.60000,012.50,000.00,+00,+00000,0600,2000,00000,0,2,0,0x0000
MC2,0,0,0,0,1,0,0,000,2,00,00,00,1,0,0,0,0,00,"MURS-5 "
MC3,00,0,0,0x000,0,0,00,0,0
10) I open membk.csv with TextEdit.app, to see what has been generated.
The top lines of what I see are:
Error 2015
MB0,05
MB1,00,50,1,0,00,"Railroads "
MB1,01,50,1,0,00,"TestBank2 "
MB1,02,50,1,0,00," "

Note the "Error 2015" at the top of both files.
Should there be anything before MC0,05,08 in memch.csv, and MB0,05 in membk.csv? Or can I remove the line with "Error 2015" with an editor?
I also tried all the other File Formats to generate .CSV-files. Then "Error 2015" was still at the top of both generated files.Screenshot 2023-09-08 at 15.55.00.png
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
Ok, this is very helpful, thanks. I'm not at home now, but I'll look at it this afternoon. I think I know whats causing that. It does have to do with error handling on the Mac Vs windows. Easy to fix, I think. Did you change anything else besides the firmware version?
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
Thanks. I only changed the firmware version.

4) At cell 3B i change 2205A to 2305AT
5) I don't change any data. I just want to see whether I can generatie files with your data
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
This is an example of what should be the first line of each of those files: SD-BACKUP,MEM CH,AR-DV10,2205A 2023/09/09 09:37:24. Here is the formula that creates that string: ="SD-BACKUP,MEM CH,AR-DV10," & Instructions!B3& " " & TEXT(TODAY(),"yyyy/mm/dd") & " " & TEXT(NOW(),"hh:mm:ss"). Somehow, that formula is failing, creating the error 2015, which ends up as the first row instead of the correct string. I've done a little research, but can't figure out why Excel on the Mac is failing on that formula (I know nothing about Excel on Mac). Cell B3 on the hidden Instructions tab is the firmware cell that you're changing from 2205A to 2305AT. Simply changing that shouldn't make the formula fail, which tells me it's another part of the formula (or not the formula at all), such as the TEXT() formatting, the NOW() and/or TODAY() functions, or the formatting string. However, I don't know which part is failing (or multiple parts) because I don't have access to Excel on Mac to test it. Are you knowledgeable about Excel on Mac? If so, can you try the following formula in a new spreadsheet to see what it does: ="SD-BACKUP,MEM CH,AR-DV10, 2305AT " & TEXT(TODAY(),"yyyy/mm/dd") & " " & TEXT(NOW(),"hh:mm:ss"). This formula is the what is in my sheet, except using a constant (2305AT) instead of the cell reference. That might at least tell me if it's the cell reference or another part of the formula failing. I developed this on Windows and without access to Excel on Mac, it's nearly impossible for me to figure out what's going on. I don't know if it's the error handling or the formula failing, which is why I'd like you to just try the formula in a blank spreadsheet. Error 2015 can mean a lot of things. If this works for fafax in Excel on his Mac, but not on yours, it could be an Excel version difference problem. So, if you're willing to try it, that will help me in the debugging process. I'll get it figured out eventually. Thanks.
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I'm not knowledgeable about Excel on Mac, but Google is my friend. I'm very busy at this moment, so it can take a few days before I can debug this.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
Ok, thanks. In the meantime, I can run mac on in a virtual machine and will see if I can get excel and try to debug it on my own as well.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
I got a VM loaded with Excel today and tested the same thing you did. It worked fine for me - no error messages, no process errors and it created the files correctly. I was using Excel 365 on Mac OS Monterey. Perhaps this is a version related issue. What version Mac OS and Excel are you running?
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
I use
Microsoft Excel for Mac
Version 16.76
on
macOS Monterey
Version 12.6.8
 

Attachments

  • Screenshot 2023-09-11 at 17.12.29.png
    Screenshot 2023-09-11 at 17.12.29.png
    81.4 KB · Views: 2

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
According to the sites I read this should work: =TEXT(NOW(),"hh:mm)"
But:
 

Attachments

  • Screenshot 2023-09-11 at 18.19.27.png
    Screenshot 2023-09-11 at 18.19.27.png
    253.1 KB · Views: 6

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
The close quote is in the wrong place. It should be before the ). Please try the whole formula (just copy/paste):

="SD-BACKUP,MEM CH,AR-DV10, 2305AT " & TEXT(TODAY(),"yyyy/mm/dd") & " " & TEXT(NOW(),"hh:mm:ss")
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
The close quote is in the wrong place. It should be before the ).
Oops, that was a typo in my post, but it was correct in the cell. as you can see.
I tried the whole formula. The result was the same error message. Because of that I tried only a part of the formula, to find which part of the formula is causing the error.
I guess it is caused by regional settings. I'm experimenting with that.
 

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
OK, try this version. I replaced the TEXT function with string functions that should not be affected by regional settings.
 

Attachments

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

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
="SD-BACKUP,MEM CH,AR-DV10, 2305AT " & TEXT(TODAY();"jjjj/mm/dd") & " " & TEXT(NOW();"uu:mm:ss")

note the two semicolons instead of colosn
jjjj = jaar, in Dutch
uu = uur, in Dutch
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
OK, try this version. I replaced the TEXT function with string functions that should not be affected by regional settings.
Yesss!!!
SD-BACKUP,MEM CH,AR-DV10,2205A 2023/09/11 20:11:26
MC0,05,08
MC1,00,00,0152.88500,012.50,000.00,+00,+00000,0600,2000,00000,0,2,0,0x0000
 

BobHGL

Member
Joined
Aug 26, 2023
Messages
35
My macOS is in English, Excel is in English, but my region is Netherlands.
Great that you found how to make it independent of the region. Now it will work in other countries too.
 

Attachments

  • Screenshot 2023-09-11 at 20.23.50.png
    Screenshot 2023-09-11 at 20.23.50.png
    323.2 KB · Views: 3

dsalomon

Member
Premium Subscriber
Joined
May 6, 2003
Messages
218
Location
Brooks, GA
My macOS is in English, Excel is in English, but my region is Netherlands.
Great that you found how to make it independent of the region. Now it will work in other countries too.
That looks correct. Glad it worked. I don't think there is anything else in there that is language or region specific/dependent, but if you find another issue please let me know. Now that I have Excel working in Mac, I can test under Windows and Mac before the next version.

Please let me know if it works OK with your data.

Best - David
 
Status
Not open for further replies.
Top