JP1 Remotes

[The Robman]

Now that I've seen the master file, I guess I'm still not clear on what you're trying to do. That file is divided into tabs where each tab is a specific Sony device code. Each function listed in the tabs has it's OBC listed along with the pronto hex, so what additional info would you be looking to get from DecodeIR?

For example, let's pick a function at random, let's pick the "0013" tab and the "Memory" function, which is labeled as "14". The pronto hex is listed as:

0000 0067 0000 000D 0060 0018 0018 0018 0030 0018 0030 0018 0030 0018 0018 0018 0018 0018 0018 0018 0030 0018 0018 0018 0030 0018 0030 0018 0018 03DE

Now, let's drop this into IRTool (which uses DecodeIR) and we can see that DecodeIR lists it as:

Sony12, device 13, OBC 14

Which is exactly what the spreadsheet said it was.

You also mentioned that you want to decode other signals, not just Sony. Would I be right in assuming that most of those other signals would be coming from Pronto CCF files rather than spreadsheets? If so, what you need to do is run the CCF file through a program called DecodeCCF (which also uses DecodeIR). That program will decode all the signals in the CCF and save them in a tab delimited file, which you can then open using Excel if you like.

Once you get the protocol info, how are you inputting that into the Sony programmable remotes?

NOTE: One footnote about the tab names in the spreadsheet, for the Sony20 signals it uses the old device code format, so here's a translation table that converts them into the current format:

1370 = 26.42
2138 = 26.66
2362 = 26.73
3162 = 26.98
3130 = 26.97
4279 = 23.133
_________________
Rob
www.hifi-remote.com
Please don't PM me with remote questions, post them in the forums so all the experts can help!

[Mr Mod]

I am looking at that spread sheet you mentioned, there is this term =decode on sheet work2 cell AC1. I cant see anything in the the sheets or in Excel telling me what this does or how to use it. This could help me out.

I have another spreadsheet that allows me to input a manufacturer, device, command etc and will output the codes into a format the Sony understands. So what i would like to do is try to automate it by opening a CCF or by placing a discrete from any manufacturer and getting the resultant code.

John Fine created a table of manufacturers locate here
http://www.hifi-remote.com/forums/dload.php?action=file&file_id=3553

This other spread sheet allows for the conversion and is located here
http://users.tpg.com.au/mr_mod/create%20Sony%20format.xls

I have spent a while thinking about what it is i am trying to do

So I guess in essence what I'm really trying to do is 2 separate task;
1. Automate the last spread sheet so that i can enter a pronto CCF or hex code
2: Update the original spreadsheet to include separate columns for the Sony format and the Sony CIS modules

[The Robman]

[The Robman]

[3FG]

I looked at this a little bit. It turns out that DecodeIR and ExchangeIR declare functions as _stdcall, so they should not need a wrapper dll, as Liz already wrote. By contrast jp12serial.dll does require a wrapper.

I did get the easy functions (Version, ProtocolSupportLevel, and EnumerateProtocols) to work in Excel, and I suppose that DecodeIR can be made to work, although as Liz says, there is some fiddling required to get the variable length integer arrays correctly passed.

I'm not sure that I see the need for calling DecodeIR from Excel.

[The Robman]

[Mr Mod]

[The Robman]