Add-on to parse spreadsheet > follow links to youtube > play video through XBMC??

d3mncln3r · 2011-03-02 19:36

There is a google spreadsheet that organizes links to videos of live songs by a band I like. Each entry in the spreadsheet contains a link to a youtube video per song. Is there a way to set up XBMC to parse this info, and play the videos? Or at least follow the youtube links?

Does my question make sense?

darkscout · 2011-03-02 21:27

Easy, just add another column to the sheet that sends the video to XBMC, then click on that link.

d3mncln3r · 2011-03-03 02:59

ok first of all I don't really understand what you're talking about. Secondly, its not my spreadsheet, so I'm don't have permission to "add" anything to it. Although, if what you're trying to describe is in fact what I asked about, I could probably talk to the owner of the spreadsheet and explain my intentions and how it might be cool for anyone else who uses XBMC.... care to clarify? Thanks

schneidz · 2011-03-05 19:05

i made a bash script in my xbmc revo that pulls stuff from theonion.com:

Code:

xbmc@XBMCLive:~$ cat /etc/rc.local 

#!/bin/sh -e

#

# rc.local

#

# This script is executed at the end of each multiuser runlevel.

# Make sure that the script will "exit 0" on success or any other

# value on error.

#

# In order to enable or disable this script just change the execution

# bits.

#

# By default this script does nothing.

echo USB0 | tee /proc/acpi/wakeup &

/home/xbmc/bin/masquerade.ksh &

# /home/xbmc/bin/random-vid.ksh &

/home/xbmc/bin/onion.ksh &

exit 0

xbmc@XBMCLive:~$ cat /home/xbmc/bin/onion.ksh

#!/bin/bash

cd /home/xbmc/win/stuff/clips/onion

wget http://www.theonion.com/feeds/onn/

i=1

for mp4 in `grep enclosure index.html | awk -F "http" '{print $3}' | awk -F "mp4" '{print "http" $1 "mp4" }'`

do

 last=`basename $mp4`

 if [ "`ls *$last`" ]

 then

  mv *$last `/home/xbmc/bin/zero-pad-2.x $i`-$last 

  else

   wget $mp4

   mv $last `/home/xbmc/bin/zero-pad-2.x $i`-$last

 fi

 i=`expr $i + 1`

done

rm index.html

i would save the spreadsheet as a text file and parse it thru bash, sed, awk, grep, cut, ...

can you provide us with a few sample rows ?

d3mncln3r Junior Member Posts: 10 Joined: Mar 2011 Reputation: 0	2011-03-02 19:36 Post: #1 There is a google spreadsheet that organizes links to videos of live songs by a band I like. Each entry in the spreadsheet contains a link to a youtube video per song. Is there a way to set up XBMC to parse this info, and play the videos? Or at least follow the youtube links? Does my question make sense?
	find quote

darkscout Posting Freak Posts: 2,148 Joined: Jul 2008 Reputation: 12	2011-03-02 21:27 Post: #2 Easy, just add another column to the sheet that sends the video to XBMC, then click on that link. Code: GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%'; IF you have a mysql problem, find one of the 4 dozen threads already open.
	find quote