Wayne Posted July 23, 2011 Share Posted July 23, 2011 Does anyone know of a way to DDE or any other method to get the title of the song that is playing to an excel cell?? Link to comment Share on other sites More sharing options...
ItsMeBobO Posted July 23, 2011 Share Posted July 23, 2011 There are a lot of things which can be done to log. I love this kind of stuff and will try to help. But at the moment I dont know of anyway to cause excel to notice the change and pull it in.Maybe if you tell me the total project. Is excel being used to pass the data somewhere else? Or you want to use excel as a repository for what played? Link to comment Share on other sites More sharing options...
Wayne Posted July 23, 2011 Author Share Posted July 23, 2011 I have some digital signage software that i will be using. it will have a countdown till Christmas web info but i wanted to also have a page to show what song is playing and i can link data to and from excel into the signage software. I could also pull it form rss and or outlook but i don't think they would be useful..I can also trigger events on the LCD i am using form the data that is in excel (videos or other playlist items). it will work great if i can get the data into excel.. Link to comment Share on other sites More sharing options...
ItsMeBobO Posted July 23, 2011 Share Posted July 23, 2011 That sounds pretty cool! I want to see that sign!Excel may be the least friendly option though.For ALL of your options you will be starting with a DOS command line since that is all LOR does.Usually you will ECHO the playing song into a text file.If your software periodically looks for a new RSS file.... You can simply echo into that skipping excel.Is this sign software publicly available? I will look at the documentation for you. Link to comment Share on other sites More sharing options...
Wayne Posted July 24, 2011 Author Share Posted July 24, 2011 The software is called Moxie you can find it at www.omnivex.comit is not free by any stretch but we are a CSV of theirs so i have a demo copy they let me use for customer demos and I borrow it during the month of DecemberI can pull RSS feeds easily thanks for the I can do all the same things with that guess i better learn how to do the DOS Link to comment Share on other sites More sharing options...
ItsMeBobO Posted July 24, 2011 Share Posted July 24, 2011 Here are some links to old threads on this topic.Have fun with your project. And let us see the picture when its ready.http://forums.lightorama.com/view_topic.php?id=22193&forum_id=72&jump_to=201736#p201736http://forums.lightorama.com/view_topic.php?id=19627&forum_id=25&jump_to=182362#p182362http://www.lavernelllights.info/telephone/ Link to comment Share on other sites More sharing options...
Wayne Posted July 25, 2011 Author Share Posted July 25, 2011 I will defiantly post pictures when they it is ready and maybe some intermediate pic's as wellI had a basic version running last year Just had a Christmas countdown and a couple other things but I did not use any triggersI am not that good with .bat filesI can get the song title form LOR to the .bat file and with very basic code get it to a .xml file but the file only has the song title in it. I cant seam to get all the headers my linking software needs to read so I can pull it into my signage software..I am sure it is simple but I don't know what it is.. Link to comment Share on other sites More sharing options...
Wayne Posted July 25, 2011 Author Share Posted July 25, 2011 OKthanks for your help pointing me in the right direction. I did get it working and now the fun part begins..I used this for the windows shell command[... Removed by LOR. Image did not post ...] Link to comment Share on other sites More sharing options...
Wayne Posted July 25, 2011 Author Share Posted July 25, 2011 Sorry about the last postapparently it did not work wellI just wanted to paste my code in but apparently the form did not like it.. Link to comment Share on other sites More sharing options...
Recommended Posts