Roku Direct Publisher

[mitchstein]

I have a published channel and all was good, then needed to just make a small change to a single video entry in the json and rebpublish.
now it tells me that it imported 50 videos and 201 have release date errors... Yet when I go into the chnnel it shos only the first video in the index not even the other 49 tht supposedly were injested.
I know this is not possibly the case, since the json file published a couple years ago no problem and all I did was change the url to the very first video in the json file..

The json file also passes JSONLint with no problem..

Here's an excerpt (since the entire json file is huge) with the actual paths changed...

If anyone can help I will be much obliged....

{"providerName":"TVByDemand Productions",
"lastUpdated":"2019-03-06T9:32:54+00:00",
"language":"en",
"movies":[{
"id":"1",
"title":"24/7 Full Streaming",
"content":{
"dateAdded":"2015-11-11T22:21:37+00:00",
"videos":[
{
"url":"http://www.tvbydemand.com......../mixedmedia1.m3u8",
"quality": "SD",
"videoType":"HLS"
}
],
"duration":2408
},
"genres":[
"sports",
"special",
"news"
],
"tags":[
"24/7 streaming",
"misc",
"comedy",
"music",
"documentaries",
"DIY",
"live tv"
],
"thumbnail":"http://www.tvbydemand.com/images/streaming-tv-logo1%20copy.jpg",
"releaseDate":"2015-03-06",
"shortDescription":"Channel 1 Streaming TV MISC.",
"longDescription":"A little bit of everything from Documentaries, how tos/DIY, Pro Wrestling, Hockey Live Music and much much more always fresh and new"
},
{"id":"1324",
"title":"Duke Becomes a Father. S1E30",
"content":{
"dateAdded":"2019-03-06T9:32:54+00:00",
"videos":[
{
"url":"http://www.tvbydemand.com/me.......30/finished.ism/manifest",
"quality":"SD",
"videoType":"SMOOTH"}],
"duration":1800},
"genres":[
"comedy"
],
"tags":[
"comedy",
"vintage tv",
"Beverly HillBillys"
],
"thumbnail":"http://www.tvbydemand.com/images/beverlyhillbilys.jpg",
"releaseDate":"2019-03-06T9:32:54+00:00",
"shortDescription":"Duke Becomes a Father. S1E30",
"longDescription":"Duke Becomes a Father.Mlle. Denise comes back for the birth of her dog's puppies, and to see Jed. They do some courtin' and sparkin' Mrs. Drysdale isn't nearly so happy when she finds the puppies share more in common with Duke the bloodhound than Claude the poodle.     S1E30..LD.."
},
{"id":"1325",
"title":"The Clampetts Entertain. S1E31",
"content":{
"dateAdded":"2019-03-06T9:32:54+00:00",
"videos":[
{
"url":"http://www.tvbydemand.com.............nished.ism/manifest",
"quality":"SD",
"videoType":"SMOOTH"}],
"duration":1800},
"genres":[
"comedy"
],
"tags":[
"comedy",
"vintage tv",
"Beverly HillBillys"
],
"thumbnail":"http://www.tvbydemand.com/images/beverlyhillbilys.jpg",
"releaseDate":"2019-03-06T9:32:54+00:00",
"shortDescription":"The Clampetts Entertain. S1E31",
"longDescription":"The Clampetts Entertain.Jed arranges a party to get Grannie out of her doldrums and invites the Drysdale. But when Mr. Drysdale's boss comes and wants to meet them for dinner, he wonders if he's going to be sent to an Alaskan bank when his boss finds out he's been lying about Jed and his family being sophisticated.     S1E31..LD.."
},

[37mediagroup]

Your bottom two 'Release Dates' have a different time format. Release date is only YYYY-MM-DD, you put a full code date/time stamp that belongs in "Last Updated" field.

[mitchstein]

Ok, that must be it... I'll try it out on monday, thanx a million, I was going nuts looking at it over and over again..

[Baradanikto]

I know I'm late to the party, but, this is the sort of error my software can pick up easily.

[mitchstein]

Remember I tried the software but ran into memory problems, with over 5000 videos scripts just can't handle it all. I create my json files from sql using classic asp on a 2012r2 server, once I get the json lingo correct it just automats the process..

Working on putting all the videos into one channel, that'll be over 25K total videos, since I run entire tv series like bonanza, bev hill billies, ozzy & harriet etc etc plu all the pro wrestling and independant films I have rights to..

[Baradanikto]

FYI...Next release (2.0) will have support for importing SQLite databases.

[mitchstein]

It shouldn't be too hard to make it link to acces, mysql, sql server then. Just different connect statements, miimal sql statements.... I use to develop for a company that did copier service support software and the most powerfull part of the software was being able to create our own custom sql connect and query statements..