0

problem with csv

Terry

April 08, 2008 04:29

None

Follow

Please help me figure this out:

I can run your csv demo, buttons and all, and it works fine. However, if I do ANYTHING to the file, even just saving it as is, I get no video output at all. I have tried Open Office, and Microsoft Works, with same result. Can't find my Excel software- on an old PC.

I have written my file, attached here. It does the same thing. I have played each video sucessfully, by renaming to autoplay.mpg. I think my problem is in the csv file.

I have firmware ver 1.1.28, and downloaded bas file from your site.

"VIDEOMODE","1024x768x60p",,,,
,,,,,
"EVENTS",,"button:2","button:3","button:4","videoend"
"STATE","attract.mpg","up.mpg",,,"attract.mpg"
"STATE","up.mpg",,"won.mpg","lost.mpg",
"STATE","won.mpg",,,,"attract.mpg"
"STATE","lost.mpg",,,,"attract.mpg"


Thanks,

<!-- s:( --><img src="{SMILIES_PATH}/icon_sad.gif" alt=":(" title="Sad" /><!-- s:( -->

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  RokuLyndon April 08, 2008 04:39

  
  
  Terry,
  
  
  
  Can you send me a copy of the csv file after you save it? It sounds like the program you are saving the file with isn't writing the end of line or end of file characters properly.
  
  
  
  I've seen this happen on some macintosh applications.
  
  
  
  <!-- e --><a href="mailto:lallydice@rokulabs.com">lallydice@rokulabs.com</a><!-- e -->.
  
• 0
  
  RokuLyndon April 08, 2008 04:59

  
  
  This is what your csv looks like when I open it using ms notepad:
  
  
  
  "VIDEOMODE","1024x768x60p",,,,
  
  ,,,,,
  
  "EVENTS",,"button:2","button:3","button:4","videoend"
  
  "STATE","attract.mpg","up.mpg",,,"attract.mpg"
  
  "STATE","up.mpg",,"won.mpg","lost.mpg",
  
  "STATE","won.mpg",,,,"attract.mpg"
  
  "STATE","lost.mpg",,,,"attract.mpg"
  
  
  
  You'll notice it has extra quotation marks that shouldn't be present. Maybe, there's a setting in the application we can use to elimitate the quotes. There's also that extra row of commas. Here's the same file after I saved it using excel:
  
  
  
  VIDEOMODE,1024x768x60p,,,,
  
  
  
  EVENTS,,button:2,button:3,button:4,videoend
  
  STATE,attract.mpg,up.mpg,,,attract.mpg
  
  STATE,up.mpg,,won.mpg,lost.mpg,
  
  STATE,won.mpg,,,,attract.mpg
  
  STATE,lost.mpg,,,,attract.mpg
  
  
  
  If you have a google account, log into google, and go to "docs". You can upload your csv file to google docs, and then choose File - Export ->CSV. Google's spreadsheet creates a csv file without the quotes or the extra line of commas. It will open a new web browser window with the contents of the csv file. Just copy and paste the contents of the browser window into a text file, minus an leading spaces or lines at the top of the document. Then, name the text file, autoplay.csv.
  
• 0
  
  jorg November 20, 2008 00:03

  
  
  And don't forget to use a linefeed (enter) at the end of the last STATE.
  
  
  
  Caused me some headache  <!-- s:x --><img src="{SMILIES_PATH}/icon_mad.gif" alt=":x" title="Mad" /><!-- s:x --> before I found why my state-machine did not work correctly.