KM Bug? Or incompatibility with Excel 2000?

[nosnoop]

I am also experiencing problem with KM 9.09 with Excel 2000 for the
8820 I bought from Rob. I am using this file (Sharp TV):

https://www.hifi-remote.com/forums/dload ... le_id=4255

When loaded, everything looks OK. But once I changed the remote to
"URC-8820 / 10820 / 6820", the KeyMoves codes are all messed up.

This is what the original KeyMoves code look like:

KeyMoves
2F F4 64 45 74 A3«dot: …to the left of zero»¦2A F4 64 45 74
AD«discrete on» ¦2B F4 64 45 74 2D«discrete off» ¦9F F4 64 45 7C
77«channel up»¦95 F4 64
45 7C 53«input 1 select: Component/Composite (OBC=050)» ¦96 F4 64 45
7C 93«input 2 select: Svideo/Composite (OBC=051)» ¦97 F4 64 45 7C
13«input 3 sel
etc: Component (OBC=052)»
etc

And this is what I get when changed to URC-8820 (and nothing else
changed):

KeyMoves
9F F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,"","
"&INDEX(NumConv,1+Functions!$T2,D2H))«channel up»¦95 F0 21 04 45
TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,"","
"&INDEX(NumConv,1+Functions!$T2,D2H))«input 1 select: C
omponent/Composite (OBC=050)» ¦96 F0 21 04 45
TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,"","
"&INDEX(NumConv,1+Functions!$T2,D2H))«input 2 select: Svideo/Composite
(OBC=051)» ¦97 F0 21 04 45
TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))
>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 3 select:
Component (OBC=052)» ¦99 F0 21 04 45
TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,"","
"&INDEX(NumConv,1+Functions!$T2,D2H))«input 4 select: HDMI (OBC=211)»
¦9A F0 21 04 45 TRIM(
Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,"","
"&INDEX(NumConv,1+Functions!$T2,D2H))«input 5 select: HDMI» ¦9B F0 21
04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,"","
"&INDEX(NumConv,1+Functions!$T2,D2H))«input 6 select: HDMI» ¦9C
etc.

A bug in KM? Or incompatibility with Excel 2000?
I tried other device upgrade files and I get the same problem when
changing remote.

TIA!

[Mark Pierson]

A bug in KM?

It appears to be since I'm getting the same problem in Excel 2003. Mike will need to look into it...

[mr_d_p_gumby]

A bug in KM?

It appears to be since I'm getting the same problem in Excel 2003. Mike will need to look into it...

Yes, there is a bug in the keymove code. (It's not related to which Excel version you are using.) I've already fixed it in the upcoming v9.10, which I plan on releasing as soon as I finish up a few more details.

[nosnoop]

Yes, there is a bug in the keymove code. (It's not related to which Excel version you are using.) I've already fixed it in the upcoming v9.10, which I plan on releasing as soon as I finish up a few more details.

Thanks, Mike!

[iUSB]

Not sure if this related, I tried this file,
https://www.hifi-remote.com/forums/dload ... le_id=3746

and switch to 8910, it appears the key move code is not correct?

KeyMoves
30 F3 26 3C 4
End
Based on key map,
@sleep audio 064 078 4E
the hex command should be 4E, but it map to $4?

Also, it I add function to @phantom1 (for exampe), the keymoves code doesnt change. I am using rev9.09 as well.

Sorry if this is not a correct reading as I am very new to this whold JP1 thing. Thanks.

[mr_d_p_gumby]

I'm afraid I cannot duplicate the problem you describe.

Not sure if this related, I tried this file,
https://www.hifi-remote.com/forums/dload ... le_id=3746
and switch to 8910, it appears the key move code is not correct?
KeyMoves
30 F3 26 3C 4
End
Based on key map,
@sleep audio 064 078 4E
the hex command should be 4E, but it map to $4?

Using my copy of KM v9.09, if I open that upgrade file and change to URC-8910, here is what I get:

Code: Select all

Upgrade Code 0 = 26 3C (DVD/1596) Philips DVP5960 DVD Player (KM v9.09)
 58 12 1E DE BE FD 80 04 C7 2C 2C 5A 5B 31 D1 58
 59 5A 5B 5C 7E 0F 4B 82 83 F7 3B 1D 20 21      
KeyMoves
 30 F3 26 3C 4E«audio»                          
End

Also, it I add function to @phantom1 (for exampe), the keymoves code doesnt change. I am using rev9.09 as well.

If I assign the usb function to the phantom1 button, I get this:

Code: Select all

Upgrade Code 0 = 26 3C (DVD/1596) Philips DVP5960 DVD Player (KM v9.09)
 58 12 1E DE BE FD 80 04 C7 2C 2C 5A 5B 31 D1 58
 59 5A 5B 5C 7E 0F 4B 82 83 F7 3B 1D 20 21      
KeyMoves
 30 F3 26 3C 4E«audio»  ¦3D F3 26 3C 7E«usb»    
End

[iUSB]

Hmm... so I tried this on my other computer,
Now I got

KeyMoves
30 F3 26 3C 4E«audio»
End

Time to debug what's wrong on the other computer

Thank so much, Mike!

[The Robman]

I just tried it myself using KM 9.09 on a WinXP box and got the same results. The "before" upgrade looks like this...

Code: Select all

Upgrade Code 0 = 64 45 (Cable/1093) Sharp Aquos LC-52D92U (KM v9.09)
 9C 00 FE FE FE F5 7C AF 7C 7F 7C BF 7C 3F 7C DF
 7C 5F 7C 9F 7C 1F 7C EF 7C 6F 7C D7 7C 57 7C 17
 7C 77 7C B7 7C 97 7C 27 7C 0B 7C 10 7C 37 7C FB
 7C 15 7C E5 7C 50 7C 90 7C D0 7C 30 7C B2 7C D2
 7C 72 7C 32 74 0E 7C FA 7C A7 7C 2F 7C 8B 7C 5D
 7C 35                                          
KeyMoves
 2F F4 64 45 74 A3«dot: …to the left of zero»¦2A F4 64 45 74 AD«discrete on»  ¦2B F4 64 45 74 2D«discrete off» ¦9F F4 64 45 7C 77«channel up»¦95 F4 64
 45 7C 53«input 1 select: Component/Composite (OBC=050)» ¦96 F4 64 45 7C 93«input 2 select: Svideo/Composite (OBC=051)» ¦97 F4 64 45 7C 13«input 3 sel
etc: Component (OBC=052)»  ¦99 F4 64 45 7C 4C«input 4 select: HDMI (OBC=211)» ¦9A F4 64 45 74 CD«input 5 select: HDMI»  ¦9B F4 64 45 74 F5«input 6 sel
etc: HDMI»  ¦9C F4 64 45 74 56«input 7 select: DVI»¦88 F4 64 45 7C AD«close caption»¦8E F4 64 45 7C E0«av mode»¦90 F4 64 45 7C FD«service mode»       
End

And the "after" upgrade looks like this...

Code: Select all

Upgrade Code 0 = 04 45 (Cable/1093) Sharp Aquos LC-52D92U (KM v9.09)
 9C 71 7E FC FE 9A C1 7C D7 7C 57 7C 17 7C 77 7C
 B7 7C 97 7C 0B 7C 15 7C E5 7C 50 7C 90 7C 10 7C
 D0 7C 27 7C 30 7C FB 7C B2 7C FA 7C 72 7C 32 7C
 D2 74 0E 7C 2F 7C 35 74 A3 7C A7 7C 5D 7C 8B   
KeyMoves
 9F F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«channel up»¦95 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 1 select: C
omponent/Composite (OBC=050)» ¦96 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 2 select: Svideo/Composite (OBC=051)» ¦97 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))
>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 3 select: Component (OBC=052)»  ¦99 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 4 select: HDMI (OBC=211)» ¦9A F0 21 04 45 TRIM(
Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 5 select: HDMI»  ¦9B F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 6 select: HDMI»  ¦9C
 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«input 7 select: DVI»¦88 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«close capti
on»¦8E F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«av mode»¦90 F0 21 04 45 TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))«service mode»    
End

[mr_d_p_gumby]

And the "after" upgrade looks like this...

That is the bug we were referring to earlier in the thread. You'll get that on any remote using the JP1.x-style keymoves. (Excel managed to put quotes around the GetFuncKeyMoveStyle2 formula when I wasn't looking. )

[The Robman]

I just found that one myself and was about to tell you to replace it with...
=TRIM(Functions!$G2)&IF(LEN(TRIM(Functions!$G2))>2,""," "&INDEX(NumConv,1+Functions!$T2,D2H))

but never mind!

[iUSB]

Hmm... so I tried this on my other computer,
Now I got

KeyMoves
30 F3 26 3C 4E«audio»
End

Time to debug what's wrong on the other computer

Thank so much, Mike!

The one computer with problem is using EXCEL 2002 SP3 (winxp), the one without the probelm is 2003 SP2, maybe that's why?

Another data point,
After I load the data, I got,
Upgrade Code 0 = 26 3C (DVD/1596) Philips DVP5960 DVD Player (KM v9.09)
58 12 1E DE BE FD 80 04 C7 2C 2C 5A 5B 31 D1 58
59 5A 5B 5C 7E 0F 4B 82 83 F7 3B 1D 20 21
KeyMoves
30 F3 26 3C 4
End
If I click "Disable Embedded Notes", the code change to,
Upgrade Code 0 = 26 3C (DVD/1596)
58 12 1E DE BE FD 80 04 C7 2C 2C 5A 5B 31 D1 58
59 5A 5B 5C 7E 0F 4B 82 83 F7 3B 1D 20 21
KeyMoves
30 F3 26 3C 4E
End
Looks like a correct one... also new keymove (eg assign to @phantom1
will show up with "disable embedded notes" check).

[nosnoop]

Hi, is there a beta version of 9.10 I can try; or is there an earlier version without this bug (and with 8820 remote) that I can use? The one in the archive section is too old.

I am kind of stuck without the device upgrade. This Sharp TV's discrete code does not work with simple KeyMoves.

Thanks!

[Capn Trips]

The only previous version I have is 9.08a, and it behaves the same way, BUT...
you are not "stuck" in any way. You just have to build your keymoves in IR.exe.

Copy and paste the device upgrade as usual, then just delete the bogus keymoves from that "Keymove/Macro" pane on the Device Upgrade addition pop-up window before clicking on OK. Your device upgrade will be added to IR, and you can then create your keymoves in IR's Keymoves tab.

That's how it always used to be done.

[nosnoop]

You just have to build your keymoves in IR.exe.
Copy and paste the device upgrade as usual, then just delete the bogus keymoves from that "Keymove/Macro" pane on the Device Upgrade addition pop-up window before clicking on OK. Your device upgrade will be added to IR, and you can then create your keymoves in IR's Keymoves tab.

I see what you mean, but I think I need some help.
I did what you suggested, and I now see a list of Key map under devices.

How do I program discrete inputs and discrete on/off?
Those were supposed to be assigned by KM using Keymoves to shift keys. Or do I have to reassign them to normal buttons? But I would be running out of buttons for normal function.

The original file has discrete on/off assigned to phantom 6 & 7 which the 8820 does not have. So I have to reassign that. And I can't use any Phantom keys as they are part of Keymoves as well (if I understand the @ sign correctly).

One workaround I can think of is to have two device upgrade, one with normal key functions, another one just to map the discrete inputs and discrete power on/off. Or is there another more elegant solutions?

[Capn Trips]

Your KM file lists all of your functions on the functions worksheet, correct? So even if they are not assigned to a button on the Buttons worksheet, you know what the EFC, OBC and Hex Code are for each function.

e.g. For Discrete ON, EFC=43368, Hex=74 AD

You do NOT have to have a particular function assigned to a "real" button to create a keymove for that function in IR.

After uploading just the device upgrade (without keymoves) to IR as described above, go to IR's General tab and assign the upgrade to a Device key.

e.g. Assign TV=SAT/CBL 1093 (assuming your upgrade is a SAT/CBL device type and 1093 setup code)

Then in IR's Keymoves tab, click on ADD.

In the pop-up window, select the Device and Key to which you want the function (Discrete ON) assigned.
e.g. TV: Phantom 1

Then, moving down, select the Device and Setup code (upgrade code) FROM which you want to generate the keymoved function - PRESUMABLY the TV device in that window will have your upgrade code displayed there already.

e.g. click on TV and SAT/CBL 1093 should populate the device type and setup code windows below.

Then moving down again, select EFC (or Hex command), and type in the 5-digit EFC (or Hex Command) corresponding to the command you want assigned to the button you selected at the top of the window (in this example, TV:Phantom1)

e.g. EFC=43368 (or Hex=74 AD)

Add notes to taste.

Click "OK"

Voila! Discrete ON is assigned to Phantom 1 in your TV mode.

Repeat as desired.