Accesso rapido:  

Forum: Addons

Topic: LocalJSON
 
Inviato Thu 26 Dec 24 @ 1:44 pm
Er...."Use you own JSON file" for what? How?
 
Some users knows how to generate a JSON file (webmasters, Python, ...) but doesn't know c++ and how to compile a dll file. So I thought it would help to make a OnlineSource plugin that reads a JSON file on the drive. It uses the same structure as in the VDJ SDK but in JSON format.
{PluginName}.json is in the same folder as the dll

https://www.virtualdj.com/wiki/Plugins_SDKv8_OnlineSource.html

https://www.virtualdj.com/wiki/Plugins_SDKv8_Example7.html

You need to edit "streamUrl" with the url of your mp3 file for example
 
For the ones who are not expert in JSON and you have many lines, an easy way is Python.
Please find some ideas:

import json
import pandas as pd

def test1_sort_json():
     strFilepath_In = "C:\\Users\\xxxx\\AppData\\Local\\VirtualDJ\\Plugins64\\OnlineSources\\yyyy.json"
     strFilepath_Out = "C:\\Users\\xxxx\\AppData\\Local\\VirtualDJ\\Plugins64\\OnlineSources\\yyyy_fixed.json"
     
     df = pd.read_json(strFilepath_In)

     df_sorted = df.sort_values(by='uniqueId', ascending=False)

     #df_sorted.drop_duplicates(subset=['uniqueId'],keep='first',inplace=True)

     df_sorted['uniqueId'] = df_sorted['uniqueId'].astype(str)

     json_str = df_sorted.to_json(strFilepath_Out, orient='records')


def test2_read_json():
    strFilepath = "C:\\Users\\xxxx\\AppData\\Local\\VirtualDJ\\Plugins64\\OnlineSources\\yyyy.json"

    fp = open(strFilepath, "r", encoding="utf8")
    
    data = json.load(fp)

    for i in data[0]:
        print(i)

    fp.close()
 
What is the description of this JSON plugin?
What's it supposed to do?
I plugged it in now how do, I access it?

So, this below is a JSON file code of my 50s videos that I use in my online database for 60's videos. How would the plugin work with this below or do I need to change the format of this below a little?

[
{"Artist":"Everly Brothers","Title":"All I Have To Do Is Dream [Intro Clean] 97","Bpm":"97.0","Year":"1958"},
{"Artist":"The Platters","Title":"Smoke Gets In Your Eyes [Clean] [Single] 58","Bpm":"57.3","Year":"1958"},
{"Artist":"Chuck Berry","Title":"Johnny B. Goode [Neon Rad Redrum] [Intro Clean] 86","Bpm":"86.0","Year":"1958"},
{"Artist":"Little Richard","Title":"Long Tall Sally [Redrum] [Clean] [Extended] 98","Bpm":"98.0","Year":"1956"},
{"Artist":"Bobby Helms","Title":"Jingle Bell Rock [Neon Rad Redrum] [Intro Clean] 119","Bpm":"119.0","Year":"1957"},
{"Artist":"Frank Sinatra","Title":"Jingle Bells [Single] [HD] [Clean] [Christmas] 88","Bpm":"87.3","Year":"1957"},
{"Artist":"Jackie Wilson","Title":"Reet Petite (The Sweetest Girl In Town) (Mixmash 70's)","Bpm":"85.4","Year":"1957"},
{"Artist":"Mitch Miller","Title":"The River Kwai Colonel Bogey March [Single] - Clean 115","Bpm":"115.0","Year":"1958"},
{"Artist":"Little Richard","Title":"Good Golly Miss Molly [Redrum] [Clean] [Extended] 166","Bpm":"166.0","Year":"1958"},
{"Artist":"Little Richard","Title":"Good Golly Miss Molly [Redrum] [Clean] [Extended] 166","Bpm":"166.0","Year":"1958"},
{"Artist":"Cliff Richard And The Young Ones Feat. Hank Marvin","Title":"Living Doll (Mixmash)","Bpm":"125.0","Year":"1959"},
{"Artist":"Brenda Lee","Title":"Rockin Around The Christmas Tree [Single] [HD] [Clean] [Christmas] 71","Bpm":"70.6","Year":"1958"},
{"Artist":"Pink","Title":"I Don't Believe You","Bpm":"93.0","Year":"1959"},
{"Artist":"Harry Belafonte","Title":"Matilda","Bpm":"99.6","Year":"1957"},
{"Artist":"Frank Sinatra","Title":"Talk To Me","Bpm":"92.1","Year":"1959"},
{"Artist":"Frank Sinatra","Title":"Angel Eyes","Bpm":"82.3","Year":"1958"},
{"Artist":"Frank Sinatra","Title":"High Hopes","Bpm":"138.8","Year":"1959"},
{"Artist":"Frank Sinatra","Title":"Day In, Day Out","Bpm":"96.3","Year":"1954"},
{"Artist":"Frank Sinatra","Title":"It Had To Be You","Bpm":"142.2","Year":"1957"},
{"Artist":"Bill Haley & His Comets","Title":"Rock Around The Clock [50s Redrum Video Edit] [DJ Dolls Video Edit]","Bpm":"88.5","Year":"1955"},
{"Artist":"Frank Sinatra","Title":"At Long Last Love","Bpm":"132.7","Year":"1957"},
{"Artist":"Harry Belafonte","Title":"Jamaica Farewell","Bpm":"124.9","Year":"1956"},
{"Artist":"Harry Belafonte","Title":"Island In The Sun","Bpm":"110.5","Year":"1957"},
{"Artist":"Frank Sinatra","Title":"Pennies From Heaven","Bpm":"111.2","Year":"1956"},
{"Artist":"Frank Sinatra","Title":"Hello, Young Lovers","Bpm":"83.2","Year":"1955"},
{"Artist":"Buddy Holly","Title":"Peggy Sue (Screenplay)","Bpm":"150.3","Year":"1957"},
{"Artist":"Frank Sinatra","Title":"I Get A Kick Out Of You","Bpm":"89.8","Year":"1954"},
{"Artist":"Harry Belafonte","Title":"Turn The World Around","Bpm":"128.5","Year":"1959"},
{"Artist":"Eddie Cochran","Title":"C'mon Everybody (Mixmash)","Bpm":"86.8","Year":"1959"},
{"Artist":"Elvis Presley","Title":"Hound Dog [Intro] - Clean","Bpm":"84.0","Year":"1953"},
{"Artist":"Elvis Presley","Title":"Don't Be Cruel (Screenplay)","Bpm":"84.3","Year":"1956"},
{"Artist":"The Coasters","Title":"Yakety Yak [Intro Clean] 125","Bpm":"125.0","Year":"1958"},
{"Artist":"Dean Martin","Title":"Bye Bye Blackbird (Screenplay)","Bpm":"148.1","Year":"1950"},
{"Artist":"Harry Belafonte","Title":"Day O (The Banana Boat Song)","Bpm":"151.2","Year":"1957"},
{"Artist":"Fats Domino","Title":"I'm Walkin' (Bacca ReDrum) (Clean)","Bpm":"112.0","Year":"1950"},
{"Artist":"Frank Sinatra","Title":"Last Night When We Were Young","Bpm":"160.2","Year":"1955"},
{"Artist":"Elvis Presley","Title":"Love Me Tender (Live) (Promo Only)","Bpm":"123.2","Year":"1956"},
{"Artist":"Elvis Presley","Title":"Heartbreak Hotel [Intro Clean] 96","Bpm":"96.0","Year":"1956"},
{"Artist":"The Platters","Title":"The Great Pretender [Intro] - Clean","Bpm":"78.0","Year":"1955"},
{"Artist":"Muddy Waters","Title":"Hoochie Coochie Man [Intro Clean] 72","Bpm":"72.0","Year":"1954"},
{"Artist":"Danny And The Juniors","Title":"At The Hop (Atom E Edit) (Clean)","Bpm":"91.7","Year":"1950"},
{"Artist":"Jerry Lee Lewis","Title":"Great Balls Of Fire (XMiX Edit Video)","Bpm":"79.5","Year":"1957"},
{"Artist":"Buddy Holly","Title":"That'll Be The Day [Clean] [Extended] 126","Bpm":"126.0","Year":"1958"},
{"Artist":"The Everly Brothers","Title":"Bye Bye Love [Clean] [Extended] 86","Bpm":"86.0","Year":"1957"}
]
 
It is part of the Online Source plugins. It means that it enables you to "read" songs available on Internet (via a URL).
In most cases, Online Source plugins are developped to be used with a songs provider like Deezer, TIDAL, SoundCloud, ...
https://www.virtualdj.com/wiki/Plugins_SDKv8_OnlineSource.html

But here, this plugin enables you to customize your own URLs via a JSON file at the same level as the DLL. It's name is "LocalJSON.json" and it gives you the structure of the expected file (by default it is just a template).
You can rename the dll but your JSON file has to have the same name

In your case, you need to edit your json file first by adding "uniqueId" and "streamUrl" fields first.
"UniqueId" has to be an unique identifier. It can be an incremental number but it has to be converted into a string
Then you also need to modify the bpm and year fields. It has to be a numeric value and not a string.


LocalJSON.json (template)
[
	{
		"artist" : "artist1",
		"bpm" : 0.0,
		"comment" : "",
		"coverUrl" : "https://url1a.jpg",
		"genre" : "",
		"isKaraoke" : false,
		"isVideo" : false,
		"key" : 0,
		"label" : "",
		"length" : 0.0,
		"remix " : "",
		"streamUrl" : "https://url1b.mp3",
		"title" : "title1",
		"uniqueId" : "1"
	},
	{
		"artist" : "artist2",
		"bpm" : 0.0,
		"comment" : "",
		"coverUrl" : "https://url2a.jpg",
		"genre" : "",
		"isKaraoke" : false,
		"isVideo" : false,
		"key" : 0,
		"label" : "",
		"length" : 0.0,
		"remix " : "",
		"streamUrl" : "https://url2b.mp3",
		"title" : "title2",
		"uniqueId" : "2"
	}
]
 
Thank you DJCEL for showing me where to find that and explaining how it works. I appreciate you doing that! I sort of understand it, but not completely. There's no need to explain it anymore. I will come back and read your messages again until I figure it out. It's just new to me now. I know once I read your description and follow your instructions, that I will catch on.
 
You are welcome.
I forgot to tell that the search in the plugin will work on the JSON file (based on artist and title fields).
To reload/refresh the json file, you need to click on the "local database" subfolder again after clicking on another folder in the browser.

If you have some new ideas or comments, do not hesitate to share.