0

buttons not working with this csv

peteg

April 10, 2008 00:49

None

Follow

I just started to work with HD600 and have made a simple csv file with a menu and 4 buttons which trigger 4 media files. Menu picture appears but buttons don't work (though they work normaly with BS demo).

That's how csv file looks in Excell:

IMAGEMODE 2
VIDEOMODE pal

EVENTS button:1 button:2 button:3 button:4
STATE menu.bmp pic01.bmp pic02.bmp kd.mpg mk.mpg

Upon saving as .cvs, the file opened in Notepad like this:

IMAGEMODE;2;;;;
VIDEOMODE;pal;;;;

EVENTS;;button:1;button:2;button:3;button:4
STATE;menu.bmp;pic01.bmp;pic02.bmp;kd.mpg;mk.mpg

I edited the file replacing semicolons with commas:

IMAGEMODE,2,,,,
VIDEOMODE,pal,,,,

EVENTS,,button:1,button:2,button:3,button:4
STATE,menu.bmp,pic01.bmp,pic02.bmp,kd.mpg,mk.mpg

What's wrong with the csv file?

thanks

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  RokuLyndon April 10, 2008 02:06

  
  
  Peter,
  
  
  
  Excel most likely has the semicolon set as the default delimeter character. I've been told this is the case for international versions of excel.
  
  
  
  Your CSV file must have a STATE row for each file that will be played. In this csv file, you are playing 5 different files. You only have one STATE row listed. I emailed a jpeg showing what this looks like in excel.
  
  
  
  So, opening the modified csv file in a text editor would give you the text below. In this csv, the buttons only work if the main menu is being displayed. This is because the only entries under he button events are on the menu.bmp row. No changes are necessary if this is the intent.
  
  
  
  
  
  IMAGEMODE,2,,,,
  
  VIDEOMODE,pal,,,,
  
  
  
  EVENTS,,button:1,button:2,button:3,button:4
  
  STATE,menu.bmp,pic01.bmp,pic02.bmp,kd.mpg,mk.mpg
  
  STATE,pic01.bmp,,,,
  
  STATE,pic02.bmp,,,,
  
  STATE,kd.mpg,,,,
  
  STATE,mk.mpg ,,,,
  
• 0
  
  peteg April 10, 2008 02:17

  
  
  Thanks Lyndon,
  
  That was really fast.  I found it inbetween - forgot to add states for each item.
  
  Sorry, just started to work with Roku today.
  
  
  
  I'm working with international version of Excell. But that's no problem, I just drag the exported file back in Excell and with Ctrl + F replace every semicolon with a comma. Then I copy it back to Notepad.
  
  
  
  thanks again,
  
  Peter
  
• 0
  
  RokuLyndon April 10, 2008 03:35

  
  
  Good to hear.
  
  
  
  Let me know if you have any questions. You can also use google's free spreadsheet program.
  
  
  
  I've also been looking at stand alone csv editors that display the file like a spreadsheet. There's a program called killinkcsv from White Peak software that works really well. I just downloaded the free trial today. Unlike some of the free editors that are cumbersome, using this program was almost effortless.
  
  
  
  Just another possibility if you get tired fo copying and replacing.