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.
@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?
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.
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.
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?
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.
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.
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?
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")
="SD-BACKUP,MEM CH,AR-DV10, 2305AT " & TEXT(TODAY(),"yyyy/mm/dd") & " " & TEXT(NOW(),"hh:mm:ss")
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.
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
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
