wbor-spinitron-user-import

A script we use at WBOR 91.1 FM to automate field entry in the "add users" dialogue for a Spinitron station. Populates field using a .csv with the credentials of DJs you want to onboard (see data.csv for an example).

Requirements

• A JavaScript runtime environment. Node.js will be used for this example (brew install node).
• A modern web browser, e.g. Firefox (brew install --cask firefox).

(brew commands are executed using Homebrew)

Usage

• Clone this repository to your machine and navigate to its location via command line.

• Add the .csv containing your data to the same folder as csv-array.js.

  • The first line of the file (the header) should be email, name, djName. Each line after should be a DJ entry (such as john@doe.com, John Doe, DJ John). The last line of the file should be left empty.

• Run node csv-array.js and copy its output. csv-array.js assumes your file is named data.csv. If it isn't, you have the option to pass the script an argument with the name of the .csv you'd like to use (for example, node csv-array.js dj_info.csv).

• Open spinitron-autofill.js in a text editor/IDE of your choice, e.g. VSCode.

• Replace {YOUR DATA HERE} with the output you copied when running csv-array.js

• In spinitron-autofill.js select all text and copy.

• Open Spinitron's "add users" dialogue after logging in as an admin.

• Open your browser's console. In Firefox on macOS, this is done by entering CMD + OPTION + K.

• Paste the spinitron-autofill.js script you copied (ensuring it includes your data[] array) and press enter.

• Submit! The script doesn't fill in the existing fields (the first 10 - so they will remain empty) but rather creates new ones for each entry at the bottom of the page, effectively allowing it to bypass Spinitron's limit of 10 at a time.

• If you encounter an issue wherein a DJ has an existing DJ profile, you may either decide to create an additional profile (not recommended) or to remove them from the dataset.