Unable to import bulk ir codes

General
1

Hi community and welcome to 2024.

i´ve had the remote nearly a week, and I´m obviusly lacking some Excel-skills. Because I´ve yet to succed in uploadeing any IR bulk set… I followed this guide Unfolded Circle Remote Two Guide 2023-11.docx - Google Docs and I´m able to get past the “no go” uploading error but never the less it seems like no data is registerd.

image
image545×708 15.6 KB

This is the first line from Control tower IR database:

function, code1, hexcode1, code2, hexcode2

“3D”,“sendir,1:1,1,38000,1,69,341,170,21,21,21,21,21,64,21,21,21,21,21,21,21,21,21,21,21,64,21,64,21,21,21,64,21,64,21,64,21,64,21,64,21,21,21,21,21,64,21,64,21,64,21,21,21,64,21,64,21,64,21,64,21,21,21,21,21,21,21,64,21,21,21,21,21,1544,341,85,21,3665”,“0000 006D 0022 0002 0155 00AA 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0015 0015 0040 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0608 0155 0055 0015 0E51”,

And when saved and removing unwanted fields looks like this (I´ve tried both hexcode and pronto code):

image
image1413×255 12.9 KB

Can someone please point me in the right direction? (yes I have read every single post about this)

2

I think Control tower gives PRONTO codes.
I got this format:

“key”,“format”,“code”
“ARROW LEFT”,“PRONTO”,“0000 0073 0000 001E 0060 0020 0010 0010 0010 0010 0010 0020 0010 0020 0030 0020 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0020 0020 0020 0020 0010 0010 0020 0020 0010 0010 0010 0010 0010 0010 0020 0020 0010 0010 0010 0010 0010 0010 0020 0020 0020 0010 0010 0010 0010 0020 0020 0010 0010 09DD”
“VOLUME UP”,“PRONTO”,“0000 0073 0000 0020 0060 0020 0010 0010 0010 0010 0010 0020 0010 0020 0030 0020 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0020 0020 0020 0020 0010 0010 0020 0020 0010 0010 0010 0010 0010 0010 0020 0020 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0020 0020 0010 0010 0010 0010 0010 0010 0010 0010 0010 09CD”

So yours should look like:
“key”,“format”,“code”
“3D”,“PRONTO”,“0000 006D 0022 0002 0155 00AA 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0015 0015 0040 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0608 0155 0055 0015 0E51”

The PRONTO code starts with 0000.

3

Thank you for your reply.

Hm, if I copy all the data from the saved CSV-file from Excel in to notes there are no special signs like commas etc.? Just in the first row…

key, format, code,
3D pronto 0000 006D 0022 0002 0155 00AA 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0015 0015 0040 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0608 0155 0055 0015 0E51
3D ALTERNATE pronto 0000 006D 0022 0002 0155 00AA 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0040 0015 0040 0015 0040 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0015 0015 0040 0015 0040 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 0040 0015 0015 0015 0015 0015 05ED 0155 0055 0015 0E47

image
image1252×125 5.98 KB

image
image1705×141 4.32 KB

4

Copy the codes received in the e-mail from Control tower into notepad and then edit them. Don’t put them in Excel.

5

From the Excel you export the file as a CSV file which you then import in the Remote. Works like a charm.

6

I could not get that to work.

7

This is exactly what I´m doing, but it wont work.

8

Something is screwy with your CSV, I think from a combo of trying to do this in excel and a text editor. Your headers have quotes and commas in it, the text file appears to have tab delimits, something is just not quite right. If you set up custom delimiters in windows, that could be a culprit, but let’s assume it’s the easy stuff first

You can do this with Excel, just use ctrl + shift + v to paste without formatting.

Start with a blank sheet and add the following

The headers should be
key
code
format

The format column is optional, the default is assumed to be PRONTO. So you can either skip the format column OR put PRONTO in all the cells. For my example below, I will skip the format column.

You should then enter data like

key code
3D 0000 0070 0000 0032 0080 0040 0010 0010 0010 0030 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0030 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0030 0010 0030 0010 0010 0010 0030 0010 0030 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 0030 0010 0030 0010 0030 0010 0030 0010 0030 0010 0010 0010 0030 0010 0010 0010 0010 0010 0030 0010 0030 0010 0030 0010 0010 0010 0030 0010 0030 0010 0030 0010 0ACD

Make sure there are no spaces before the first octet or after the last. In other words, there is not a leading space on the first four zeros, and there is not a trailing space after 0ACD.

After you are done, make sure you are going File > Save As > and selecting the .csv option in the dropdown.

EDIT: screenshot from an Excel CSV and then opening it in notepad++

image
image2256×637 84.6 KB

9

See my PM.

1 Like
10

Solved.

Thanks to WinnieandBuzz. Stupid mistake from my side, I have tried to put a comma in this field but not a semicolon…

image
image533×686 35.4 KB

Maybe this will help somebody else.