header={
  "recipe_version": "1.177",
  "title": "Vimeo Review Notes To Nuendo Markers",
  "description": "Convert Vimeo review notes to a CSV for importing Nuendo markers",
  "tags": "default",
  "chef": "BeatRig",
  "dependencies": "",
  "instructions": "Add Vimeo Review Notes CSV",
  "type": "default",
  "os": "windows,macOS",
  "palette": "Clean Slate",
  "spice": "BQ==:G+Hy36kJcnQQYYavb/JV2Il6eCYr6h4hRJHCF9rRbhX5BcazL6cuTgUMdz0xA50VWA5PmmV0Q7aWkiUtNFtbk991l+t0e8IBXMReMIT1GNjnZZDv7n2YRAo0xcSQbY0ixjG6LLH4wGKnspKAoA/v69iLn6N2IH0XzIZwTGdHSo4=",
  "flavour": "VCxP8S3hbhM0isjZzUGCAjIjsxB9ZaMA3878Et0ivO2TgqKIXW0wgjFBj/O4VkRhaFW60jCBZm14u4waQ70Rdomr//nmddUx4kDd0MtSgsmXULy23lxgtrIgrKCjmGBldPeQrMVJP3BJN0bnsgEc8ZCrLK/ock3UjYCxS2E5RW0=",
  "time": 1734969450,
  "core_version": "0.7.2",
  "magnetron_version": "1.0.333",
  "functions": "main",
  "uuid": "e5d98c076289484aaf3b531470a99851"
};


// ============================================================================
// 
function main()
{
    // -----------------------------
    setMainMessage("running");
    setProgress(101);
 
    // -----------------------------
    // GET ALL FILES FROM THE APP
    var files = getFiles();
    for (i=0;i<files.length;i++)
    {
        // GET FILE CONTENTS
        var path = getPathInfo(files[i]['path']);
        var content = readFile(path.path);

        var out = "00:00:00:00,-- MOVIE START --\n";
        var outfile = path.folder+gvar.pss+path.basename+'-NUENDO.csv';

        // FOR EACH ROW
        var rows = content.split('\n');
        for (j=1;j<rows.length;j++)
        {
            // --------------------------------
            // FOR EACH CHARACTER
            // HIGHLY IN EFFICIENT WAY OF PARSING A CSV,
            // BUT CAN HANDLE WITH AND WITHOUT QUOTES AND COMMA'S WITHIN QUOTES
            var item = ["","","","","","",""];
            var item_id = 0;
            var quote = false;
            var row = rows[j];

            for (k=0;k<row.length;k++)
            {

                // CURRENT CHAR
                var char = row.charAt(k);

                // REMOVE QUOTES, AND TOGGLE TO REMEMBER ON/OFF STATE
                if(char == '"'){ quote = (quote === true ? false : true); }

                // BREAK ON COMMA
                else if(!quote && char == ","){ item_id++; }

                // OTHER CHARACTERS (also replace comma's within the value with a dash)
                else{ item[item_id] += (char == "," ? "-" : char); }

            }

            // --------------------------------
            // PARSE DATA
            // 0: Video Version
            // 1: # ID
            // 2: Timecode
            // 3: Author Name
            // 4: Note
            // 5: Reply
            // 6: Date Added
            // 7: Resolved
            // --------------------------------

            if(item[1] != "" && item[2] != "")
            {
                var time = item[2]+":00";
                var id = "VIM" + item[1].toString().padStart(3, '0');
                var description = id + ": " + (item[5] != "" && item[5] != "--" ? " >>>> "+item[5] : item[4] ) + " ("+ item[6] + ' - ' + item[3] + ")";
                out += '"' + time + '","' + description + '"\n';
            }
        }

        writeFile(outfile, out);
    }

    setMainMessage("done");
    setProgress(100);
}