Script that can Extract timecode stamps from a table in a word document and create markers!

Here is a script I created for taking a FrameIO comments CSV and creating markers.

function openCsvAsText() {

    var startOfClip = getCurrentTimeCode() //get start timecode

    var path = sf.interaction.selectFile({
        prompt: 'Please Select File to Open',
    }).path;

    var contents = sf.file.readText({ path }).text;
    var arr = contents.trim() //gets rid of empty cells
    var arr = arr.split('\n'); //splits on lines


    for (var i = 1; i < arr.length; i++) {
        var data = arr[i].split(',');
        var frameIOTeam = data[0];
        var frameIOProject = data[1];
        var frameIOFile = data[2];
        var frameIOFileUrl = data[3];
        var frameIOVersion = data[4];
        var frameIOCommenter = data[5];
        var frameIOCommentID = data[6];
        var frameIOComment = data[7];
        var frameIOReply = data[8];
        var frameIOCommented = data[9];
        var frameIOComplete = data[10];
        var frameIOAnnotation = data[11];
        var frameIOFrame = data[12];
        var frameIODuration = data[13];
        var frameIOTimecode = data[14];
        var frameIOTimecodeIn = data[15];
        var frameIOTimecodeOut = data[16];
        var frameIOTCSource = data[17];
        var frameIOTCSourceIn = data[18];
        var frameIOTCSourceOut = data[19];
        var frameIOTimeIn = data[20];
        var frameIOTimeOut = data[21];
       // alert(frameIOComment);


        var clipTC = convertMStoSamples(startOfClip, frameIOTimeIn)
        goToTimeCode(clipTC)
        var commentText = data[2].replace(/"/g, '');
        //  addMarkerComment(commentText)

        var commenter = frameIOCommenter.replace(/"/g, '');
        var commentText = frameIOComment.replace(/"/g, '');
        var commentFieldText = ("Version:" + frameIOVersion + "  From:" + commenter);




        //  addMarkerBaseSpot(baseSpot);

        // sf.ui.proTools.waitForNoModals();

       //  if (isNaN(durationNum)) continue;
        //goToTimeCode(timeCodeSource);

        addMarkerIsci(commentText, commentFieldText);
        //alert(baseSpot);
        //addTimeCode(durationNum);

        //    alert(isci);
    }


}


function getCurrentTimeCode() {
    sf.ui.proTools.mainCounterSetValue({
        targetValue: "Samples",
    });
    var currentTC = sf.ui.proTools.selectionGet().mainCounter.trim();
    return currentTC

}

function goToTimeCode(timeCodeSource) {

    var timeCodeSource = timeCodeSource + ""
    sf.ui.proTools.selectionSet({
        selectionStart: timeCodeSource,
    });

}

function convertMStoSamples(startTime, timeFromSource) {
    var spc = 48048
    var a = timeFromSource.split(':');
    //alert(a.length + "")
    if (a.length > 2) {
        var seconds = (+a[0]) * 60 * 60 + (+a[1]) * 60 + (a[2]);
        //  alert (seconds)
    } else {
        var seconds = (+a[0]) * 60 + (a[1]);
        //alert (seconds)
    }
    var startTime2 = (Number(startTime))
    var tfs = ((Number(seconds)) * spc);
    var offsetTime = (startTime2 + tfs)
    // alert (startTime2+"")
    //  alert (tfs+"")
    //  alert(offsetTime+"")
    return offsetTime

}

function returnDisplay() {
    sf.ui.proTools.mainCounterSetValue({
        targetValue: "Timecode",
    });
}

function addMarkerIsci(commentText, commentFieldText) {

    sf.keyboard.press({
        keys: "numpad enter",
    });

    sf.keyboard.type({
        text: commentText,
    });

    sf.keyboard.press({
        keys: "tab, tab",
    });

    sf.keyboard.type({
        text: commentFieldText,
    });

    //sf.keyboard.press({
    //    keys: "cmd+v",
    //});


    sf.keyboard.press({
        keys: "numpad enter",
    });


}

function addMarkerComment(markerDescription) {

    sf.keyboard.press({
        keys: "numpad enter",
    });

    sf.keyboard.type({
        text: markerDescription,
    });


    sf.keyboard.press({
        keys: "numpad enter",
    });
}


//start of script

sf.ui.proTools.appActivateMainWindow();

const areYouReadyToStart = sf.interaction.displayDialog({
    prompt: 'The ProTools Playhead needs to be at FFOP for the reviewed version. Is it there now?',
    buttons: ['Yes', 'No'],
    defaultButton: 'Yes',
    cancelButton: 'No'

}).button

if (areYouReadyToStart === 'Yes') {
    log("Let's Go")
    openCsvAsText();
} else {
    alert("Move playhead to start of file and try again")
}


returnDisplay();

Excel is definitely better to work with. I’ll play with the idea in the morning (GMT-5) and see what I can come up with. What version of Pro Tools are you on?

Thanks for sending me something to work with. I'm not sure under what conditions this script is supposed to work with excel, but unfortunately it doesn't seem to interact with the time code written as a number value like so 01:01:19:21.

I may need way more than a starting place :D