javascript – Web-Based Music Royalty Measurement Tool

Working on a passion project so I am willing to invest the time & research, just need some starting advice/tips.

Currently just started and have only…

  • AWS Light Sail Sever
  • WordPress + bitnami

Looking to create a web-based music recording royalty model & graphing tool that breaks down different royalty earning measurements for artists based on their data and generates graphs. The data will be retrieved from the artist’s TuneCore & DistroKid account. Averages, Change in Earnings based on catalog size, etc. (Not worried about the math part so much right now since I have these calculations done already).

The big hurdle that is keeping me in the way is figuring out a way to grab this information from the outside websites & accounts. This is needed so that my web app can then generate graphs and models off of their data. I am not looking to store their account information and data, other than the streaming data needed to generate the graphs and charts. Streaming reports can be downloaded from TuneCore (.CSV file) & DistroKid (.TSV file)

The streaming reports are typically stored in the “bank”.

My belief is that DistroKid & TuneCore are pulling their numbers & stats from the .CSV & .TSV files stored on their end.

A website called Royalty Exchange offers something quite similar, however, they’re collecting from different royalty agencies and don’t deliver the data I am looking for. They’re collecting data from artists’ publishing agencies.

Royalty Exchange has a blog post that shows their early model of the “Royalty Calculator” and how they used the user’s inputted username and password for their BMI (publisher) account to access their data and reports. Blog post link with video demonstration.

My thoughts/questions were

  1. Is Royalty Exchange is using JavaScript & AJAX in order to collect the inputted Publishing Account Username and Password. Maybe that, once RoyaltyExchange’s app got access to the account it downloaded and store the .CSV / .TSV information to the registered artist’s account on the Royalty Exchange. Bringing the data from BMI (Publisher) to the Royalty Exchange’s server.
  2. While not storing the artist’s username and password, RoyaltyExchange stores the catalog & streaming information in their servers in order to draw the graphs and measurements for the artist. Wouldn’t this be the case if they’re able to show that information in the artists’ dashboard without them needing to sign into their Publishing account again?
  3. Maybe instead of downloading & storing the.TSV and .CSV files – Royalty Exchange’s app is just scanning for the specific artist’s stats on the site and transferring it some other way?
  4. Like mentioned in the beginning, I am aware of how intense or complex this may sound especially for my obvious lack of experience, but it’s a passion project of mine that I’d really like to work on. I feel like this community though will help point me in the right direction with what I need to brush up on & learn.

Image Links For Reference:

Appreciate it, anything will help!

adobe camera raw – ACR: Quick Color Preview While Using “B&W Mixer” tool for Black and White Photo?

In Adobe Camera Raw, when using a monochrome color profile, we get the B&W Mixer tool:
Photo of B&W Mixer tool in Adobe Camera Raw

When using this tool, I wish I could quickly enter a keyboard shortcut and see a quick color preview of the image.

Is there a quick and easy way to see a color preview of an image with a monochrome color profile in Adobe Camera Raw, without just changing the color profile?

Research

Lightroom B&W Mix: how to see where the original colors are? – this post is about seeing where certain colors are in Lightroom, which is similar, but not the same as my question. I’m interested in seeing the entire image in color briefly, not seeing a mask of a selected color.

magento2 – Magento 2 – Data Migration Tool, unknown column store_id in customer_entity_varchar after data migration

I am trying to migrate a CE 1.9.4.5 site to CE 2.4.0 and have installed the data migration tool.
I managed to migrate both Settings and data successfully.
My orders, products, settings etc .. where successfully migrated
But when i try to perform reindex after successful migration, following error occurs

Catalog Search index process unknown error:
SQLSTATE(42S22): Column not found: 1054 Unknown column 't.store_id' in 'field list', query was: SELECT `u`.* FROM ( (SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_varchar` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('111', '479', '113', '114', '118', '563', '533', '514', '927', '982')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_int` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('119', '940', '941', '937', '117', '120')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_text` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('112', '115', '116', '121', '122', '123', '926', '530')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `catalog_category_entity_varchar` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('965')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_datetime` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('565', '566')) AND (`store_id` IN ('2', 0)))UNION ALL(SELECT `t`.`value`, `t`.`attribute_id`, `t`.`store_id` FROM `customer_entity_decimal` AS `t` WHERE (entity_id = '3') AND (attribute_id IN ('942')) AND (`store_id` IN ('2', 0))) ) AS `u` ORDER BY `store_id` ASC

The same sql error is shown when i take the category menu in backend admin panel.

Note. I checked in my old magento 1.9.4.5 site, there also store_id column is not present in customer_entity_varchar table, but everything is working perfectly there.
Tried migrating data again in a freshly installed magento 2, but no luck.

Thanks in advance for your help.

sql server – How to tell if SQL is autogenerated by some tool

I am looking into some stored procedures and the code is more or less non-readable e.g. there are 15 main joins in one statement and the level of nesting of the subqueries is e.g. 7 in order to simply define one of the tables used in the joins… If one counts the joins in the subqueries then there are many more joins… Hope it makes sense…

I do not think a human has written these SPs and I think they have generated the code and copy-pasted it in the SP template… Does this sound right?

What are these tools called? So I am trying to refactor these and I was first annoyed and thought what idiot writes code like this but now like I said I think it is autogenerated… By autogenerated I mean a drag and drop interface.

Is my inference correct based on the description above? If you could comment of performance that would be great. My understanding is that these tools are performance killers…

Is there a way to disable / disallow someone from using View Creator using Diagram Tool in SQL Server?

We have a lot of DB and BI analysts who regularly create views. Some folks create these views using SSMS’ view creator which allows someone to drag and drop tables. This creates a lot of problems when we need to review or modify their code as the diagram tool in SSMS messes up the indentations and formatting, making it impossible to review the code. Is there an option or permission that I can revoke/change that disallows everyone from using it?

enter image description here