Please help- Advanced function codes for Panny SC-HT15

[gfb107]

ElizabethD,

RM has no limit on the number of functions allowed. The protocol determines that maximum number of unique commands.

Protocols that use 1 byte hex commands have a maximum of 256 values.
Protocols that use 2 byte hex commands have a macimum of 65536.

Panasonic Combo is a 2 byte protocol. 8 bits are used for the sub-device and 8 bits are used for the OBC.

[johnsfine]

Is that the question Elizabeth was really asking? Or was she really asking how many lines you can use in RM's functions tab UI before some part of the UI processing will break?

I assume the answer to that is "more than you're going to have patience to try, but maybe less than 65536."

[The Robman]

Wouldn't it have been easier to use RM?

I can only use RM at home as it's not copmpatible with the machine I use during the day, so it wasn't even an option. But even if it was, one of the main things that I like about using KM is that, being a spreadsheet, it allows you to cut & paste large chunks of data at a time, whereas RM forces you to type in the data one cell at a time.

I don't see how I could easily have created those lists of EFC5 codes, ready to post in a thread, using RM (unless I'm missing something).

[johnsfine]

Copy/paste of large chunks in RM isn't as obvious as it is (to an experienced Excel user) in KM. But I have managed to move bulk lists of functions in and out of RM via copy/paste.

With either KM or RM, I can't get decent results copying a large chunk of info directly to a post in the forum. I always copy from KM or RM to a text file in Visual Studio then repair the formatting, then copy/paste to a post.

[The Robman]

Copy/paste of large chunks in RM isn't as obvious as it is (to an experienced Excel user) in KM. But I have managed to move bulk lists of functions in and out of RM via copy/paste.

Care to elaborate?

With either KM or RM, I can't get decent results copying a large chunk of info directly to a post in the forum. I always copy from KM or RM to a text file in Visual Studio then repair the formatting, then copy/paste to a post.

You're probably talking about the tabs between cells not displaying correctly. Here's how I handle it, let's say that the EFC5 was in cell B2 and the function name was in cell A2, in cell C2 I would type the following formula: =B2&" "&A2, this will put the EFC5 code in the beginning of the line, then a space, then the function name. I would then repeat this down the entire column before cut & pasting the results into the post.

If we were talking about OBCs or EFC3s where leading zeroes might be dropped causing the data to not line up correctly, I might use the following formula instead: =text(B2,"000")&" "&A2

[gfb107]

I can only use RM at home as it's not copmpatible with the machine I use during the day, so it wasn't even an option.

I saw the post time of 10:02pm and assumed you were home at the time.

But even if it was, one of the main things that I like about using KM is that, being a spreadsheet, it allows you to cut & paste large chunks of data at a time, whereas RM forces you to type in the data one cell at a time.

I don't see how I could easily have created those lists of EFC5 codes, ready to post in a thread, using RM (unless I'm missing something).

To create that list using RM, here's what I would have done:

1. Load the upgrade
2. Change the remote to one that uses EFC5
3. Go to the Functions sheet.
4. Reorder the columns to make EFC5 come immediately before Name (by dragging the column header of EFC5 to the left).
5. Drag-select the cells I want to copy
6. Right-click and select Copy
7. Paste into a post

Here's how it looks (starting with Panasonic SC-HT500rm DVD.rmdu):

Code: Select all

11426	0
11314	1
11442	2
11378	3
11506	4
11282	5
11410	6
11346	7
11474	8
11298	9
60734	vol up
60862	vol down
60790	mute
11368	channel up
11432	channel down
11398	power
60695	dolby
03897	menu
44854	surround
03862	up arrow
03990	down arrow
04054	left arrow
03926	right arrow
03929	select
03865	return
04048	display
04056	repeat
03881	position memory
03946	play
60903	pause
03962	rewind
04090	fast fwd
03898	stop
45045	centre focus
45023	csm
11475	-/--
60903	channel select - test
44539	sfc
60817	sub-woofer
04086	audio
04071	play mode mix2
04079	top menu navigator
03991	fm mode setup
11475	display dimmer
03899	cancel
60675	tv
60739	vcr
60447	tuner
60927	dvd/cd

Block pasting in RM works also, assuming tab-separated column data.
Just reorder to columns to match the source data, then select the top-left cell you want to paste into, and paste.
Note that this is a destructive paste, in that it will overlay the values in subsequent rows and/or columns (if pasting multiple rows and/or columns). If it runs out of rows for pasting, it'll add as many as needed. In the early days of RM (back when we called it KMJ), before RM could import KM upgrades, this was how we transferred data from KM to RM.

[The Robman]

I saw the post time of 10:02pm and assumed you were home at the time.

For the 2nd list I was at home, but the original list was posted at 2:09pm.

To create that list using RM, here's what I would have done: 1. Load the upgrade.

I wasn't basing my list on an upgrade, I was basing it on the master list spreadsheet as I didn't want to limit the functions to just those that works for a specific device, I wanted to include all available functions for the model type.

Given that I was starting with a spreadsheet, would you still have done it using RM?

[gfb107]

Given that I was starting with a spreadsheet, would you still have done it using RM?

Not if I knew how to use Excel as well as you do.
But I probably would have used RM. I would have blocked copied-n-pasted from the spreasheet into RM after reordering the columns to match what was in the spreadsheet.

I just tried it, and copied the three columns of sub dev, obc, and name all in one operation, and it worked as expected. I even figured out how to hide the EFC5 column in Excel, since I would have started with the spreasheet that didn't have that column.

[ElizabethD]

Or was she really asking how many lines you can use in RM's functions tab UI before some part of the UI processing will break?

Correct. I did not contemplate the need for 65k rows.

I just ran quick statistics for current state of Panasonic main device 160 (as of 9-15, no HT15 there):
13 possible subdevices, 321 unique Subdevice-OBC combinations.


Edited:
I goofed, forgot to filter out devices 144 and 176, and no time to rerun now.

[ElizabethD]

Never mind where I did or did not mess up. Excel says is 321 for device 160

Here is the whole Audio and HT list in case someone needs a quick list for this conversion. It's in Diagnosis.
https://www.hifi-remote.com/forums/dload ... le_id=2245

File includes some old devices 9, 12, 18 as well as incomplete 144, 176. The filter is set for just 160.
It needs to go through Rob's calculator or, if fits through RM.
If not then sections can fit into KM or RM.

[ElizabethD]

Quick busy work so experts don't have to waste time on it.
If this passes sanity check, then EFC5 for 144,176,160 devices are updated in the file I posted earlier.

Code: Select all

Dev    Sub OBC Functions                 Hex    EFC5

144     0   61 VCR: power/SYSTEM: power  FF 43  60806
160     0   61 power                     FF 43  60806
160     4   61 power                     DF 43  60550
160    10   61 power                     AF 43  28550
160    18   61 power                     B7 43  44934
160    28   61 power                     C7 43  11398
176     0   61 DVD: Power                FF 43  60806