ItemRequiresSkillLevel generator

Valkream GoogleSheet to Detalhes.ItemRequiresSkillLevel.yml How to

build your database with your team & export it to Detalhes.ItemRequiresSkillLevel.yml

Author: Bhor@ValkreamTeam
Contact: Valkream Discord (https://discord.com/invite/KeeFpDgQ)
License: GNU (feel free to do whatever you want with this code)

Fork this googlesheet : Wiki Valkream V2 & edit it for your needs. Declare your new ggolesheet URL in ItemRequiresSkillLevelFiles/config.js:

        // GOOGLE SHEET URL (for console links), feel free to copy the Valkream one, or make yours by yourself
        let T2Y_GOOGLE_SHEET_URL = 'https://docs.google.com/spreadsheets/d/1LW1sWIsoBmMpp7P9dLTemWN146wruXwWgHiAbBit-UI/edit?gid=0#gid=0';

Open your googlesheet & download it as .tsv file, with File -> Download -> Values separated by tabulations (.tsv)
show screenshot

Save this file & use [browse file] to load it into the page.

a [Config] button is available to change every requiered field names (default one are thoses for our valkream googlesheet), maybe you want yours.
your new config will be store as a cookie, browser side
you may also edit config.js for your own needs.

You will be able to use [Convert] button, to get & verify your data at yaml format
A [Download] button will be available to save your Detalhes.ItemRequiresSkillLevel.cfg file

You will have in the bottom frame, the convertion script output, with provided links to every googleSheet cells that aren't compiled.

version 0.6.2

todo:

add diff-compare with original requireskill.yml & new compiled one

0.6.3

added blockEquipExceptions in config.js to handle prefabs list that require BlockEquip: false (lvl/skill//attrib requierement to craft but not to use)

0.6.2

added google sheet's url to config (to prefix Console Output links to cells sheet)
corrected some ItemRequiresSkillLevel's vars
scopped every new root vars & new functions names

0.6.1

added Test button in config modal & live tests for every fields

added config modal to both steps & auto page mode
splitted modals vars & functions to modals.js

0.5.2

changed config.js constants to be more friendly with config form
removed T2Y_TSV_HEADER_LINES from config.js constants (compiled by script for now)
corrected data header
finalized standalone config form
synchronized config with localStorage
added base64 images for config help

0.5.1

added localStorage as cookie functionality
forked config.js to localStorage
added every test & alerts for standalone mode requirements
added config form modal

Enhanced T2Y_convert2yml() function to handle with duplicated labels from the sheet's table header
Changed T2Y_COLUMN_NAMES_INC to T2Y_COLUMN_NAMES
(T2Y_COLUMN_NAMES_INC will be generated with T2Y_COLUMN_NAMES) for easier & form rdy config
added self injecting for config.js and example.html for tsc2yml use as a very basic polyfill for any webpage
added myConsole data as a modal for standalone mode

added PageMode : dev / prod
some js improvements
scopped every root vars & functions names
added <ItemRequiresSkillLevel /> HTML tag support
added tsv2yml.js standalone mode (use it from whatever page u want)
added how-to modal for standalone mode

added HTML5 doctype & every css/js tweaks for app-like feelings
added googlesheet direct links into the console
added yaml validator functionality
split css/js into files
split configuration into dedicated file

added native google sheet export support
added browse tsv file support
added convert file download

Proof Of Concept successful