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": "h0eGBUlZokaLfyh3uy6bFVL8TK3TUa4Gx7DbPC7wSYQW932ozUD7FH6SrmPUSPsDprWXBGuBCNmvtXw0bnc0umEfYfO629ZUzYbyzMUgA2sTSN7H4omLI0I9qSjNeN3dbflEq9ZgIOhj6jfuPAg4NQ5bS7OZnuVu23eOiqY2PVI=",
  "time": 1724022598,
  "core_version": "0.6.4",
  "magnetron_version": "1.0.317",
  "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 description = "VIM"+pad(item[1], 3) + ": " + (item[5] != "" && item[5] != "--" ? " >>>> "+item[5] : item[4] ) + " ("+ item[6] + ' - ' + item[3] + ")";
                out += '"' + time + '","' + description + '"\n';
                }




            //echo( objectToString(item) );
        }

    writeFile(outfile, out);
    // echo( out );
    // write file


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




// ============================================================================
// NUMBER PADDING
    function pad(num, size) {
        while (num.length < size) num = "0" + num;
        return num;
        }