Board Thread:Wiki Technical Discussion/@comment-4356266-20170205031227/@comment-4356266-20170225090429

I've added a new column, the SocialBlade grade, to the list. Currently it contains placeholder data, to be filled with proper data using the script - see below.

Secondly, I'm currently writing a new updater script for this new list format, motivated by how easier it is to read and write data to and from this new format. Currently the script can read from and write into this new format nicely. The part that calls YouTube's API and SB is in the works but I'm confident that it would work as planned.

The way YouTube's API work is that it can pull data from multiple Channel IDs (up to 50 per response) but only a single username. Therefore one of the things the script will do is replace usernames in the list with channel IDs so that future updates take considerably less calls to YT API.

In the future, I plan on also determining the status by looking at the publish dates of several most recent videos on the channel. That'd require separate calls, one per channel.

Regarding CSV, after a bit more thinking I conclude that the current format is better represented with JSON. The module and the WIP script associates the column positions to named properties internally, and there are several named properties like noAjax that is not mapped, and formatted in a way CSV doesn't support. Therefore it's easier to export and import to JSON rather than CSV. I'm pretty sure there are tools out there that let you edit JSON.

I envision this new format to be the next database thingy, where the Unterganger Infobox pulls data from it. I'm not yet sure what kind of data we can add to it. Please respond with what kind of data you think is tedious to manually update periodically. My candidate is the status.