Batch Process files from G-Drive to RX

Hi @Tim_Tregubopv,

This is a very in depth workflow, And I'm not sure if @Dustin_Harris is still working on it.

But if your just needing to monitor when new files are added to a folder you could use a run-forever script like the one below;

Note: you'll need to update the following two variables (or consts) at the top of the script;

• The folderPath (The path of the folder you want to monitor).
• The targetCommandId (This can be collected by selecting the Target Command in the "Command Name" list, ie the script you want to run when files are added to the folder, and then from the "Command" menu in SoundFlow select "Copy Command ID Local to Package" which will copy the command ID to the clipboard.),

---

This is the Run-Forever script.

// Path to the folder you want to watch
const folderPath = "~/Desktop/Folder Name";

// This is the command ID for the script you wish to run if a file is added to the folder.
const targetCommandId = 'package:ckyuvevvp0003pg108ocjlmoa';

// Collect file paths from folder on first run
let oldFilePaths = getFilePaths();

function getFilePaths() {
    return sf.file.directoryGetFiles({
        path: folderPath,
    }).paths;
}

function main() {
    try {
        //Get the file paths in the folder
        let newFilePaths = getFilePaths();

        //Compare the new files to the old files
        if (JSON.stringify(newFilePaths) !== JSON.stringify(oldFilePaths)) {

            //log("Folder content has changed");

            //Get the file paths of the added files 
            let addedFilePaths = newFilePaths.filter(item => !oldFilePaths.includes(item));

            //Check to see if there have been any files added to the folder
            if (addedFilePaths.length !== 0) {

                //log("Files have been added to the folder");

                // Run the target Command ID;
                sf.soundflow.runCommand({
                    commandId: targetCommandId,
                    props: { folderPath, addedFilePaths, } //Send the Folder Path and newly added File Paths to the target Command.
                });
            }

            //Update the old file paths
            oldFilePaths = newFilePaths;
        }
    } catch (err) {
    }
}

/**
 * @param {object} settings
 * @param {string} settings.name
 * @param {function} settings.action
 * @param {number} settings.interval
 * @param {number} settings.timeout
 */
function runForever({ name, action, interval, timeout }) {
    var now = (new Date).valueOf();
    if (now - globalState[name] < timeout) throw 0; //Exit if we were invoked again inside the timeout

    globalState[name] = now;
    sf.engine.runInBackground(function () {
        try {
            while (true) {
                sf.engine.checkForCancellation();
                globalState[name] = (new Date).valueOf();

                action();

                sf.wait({ intervalMs: interval, executionMode: 'Background' });
            }
        } finally {
            globalState[name] = null;
        }
    });
}

runForever({
    name: "folderUpdateMonitorService",
    action: main,
    interval: 500,
    timeout: 5000
});

---

This would in turn run the targetCommandId (ie the Target Command) whenever the run-forever script detects one or more files have been added to the folder;

Note: Run-forever scripts can only be run once. To cancel the script either restart SoundFlow or use "Control+Shift+ESC" to terminate all running SoundFlow Commands.

So the target command (a separate script, see below) could then receive the folder path and the file paths from the Run-forever script.

This is the Target Command script

const { folderPath, addedFilePaths } = event.props;

let folderName = folderPath.split('/').slice(-1)[0];

alert(`The following files have been added to the ${folderName};\n\n${addedFilePaths.join('\n')}`);

I've not extensively tested it but I hope that helps.
Rock on

Yeah, it can either be that, or if the narrators use distinct naming conventions for their uploads, that can be used too…