Developers

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
37mediagroup
Roku Guru

Exporting from Excel

Does anyone export their json file from Excel or Google Sheets?  I wrote my original site by hand coding, but I kept a file of the videos just for a "database" (a very basic one at least).  Adding to it, and thinking there's gotta be a way to successfully perform it. I've found how to export sheets to json, but I can't seem to figure out how to keep child/parent columns for something like the content & videos in the below example

"content": {
            "dateAdded": "2015-08-13T14:14:54.431Z",
            "captions": [],
            "duration": 63,
            "adBreaks": ["00:00:00", "00:01:03"],
            "videos": [{
                "url": "http://roku.cpl.delvenetworks.com/media/59021fabe3b645968e382ac726cd6c7b/5686748268874a57a4ba3debda1619dd/75ad4598ef4a4e5c950e26d80464abb4/ep-126-seg-3_contv_v1-mo.mp4",
                "quality": "HD",
                "videoType": "MP4"
            }]
        }
    },


*** Nevermind everyone, it's beyond the scope of support here.  If I do get it I'll post back.
Tags (1)
0 Kudos
2 REPLIES 2
37mediagroup
Roku Guru

Re: Exporting from Excel

FWIW this method is what I followed to export to json. Just couldn't figure out child statements (Although I'm thinking with careful find/replace maybe I could insert them):

https://www.youtube.com/watch?v=HnFwl-8aTmQ[youtube:10da26n0]HnFwl-8aTmQ[/youtube:10da26n0]
Tags (1)
0 Kudos
mitchstein
Roku Guru

Re: Exporting from Excel

I wrote a script that gets everything from an access database in classic asp.. lol.. yeah I'm old...
http://www.TVByDemand.com
Tags (1)
0 Kudos
Community is Being Upgraded!

We’re upgrading Roku Community to bring you a faster, more mobile-friendly experience. You may notice limited functionality or read-only access during this time. Read more here.

Planned Downtime:
Community will be unavailable for up to 24–48 hours during the upgrade window during the week of May 19th and you may notice reduced functionality. In the meantime, for additional assistance, visit our Support Site.

We're sorry for this disruption — we’re excited to share what’s next!