Exporting a list of Work Items

On the importing side, you might want to look at a blog post from last year, Adding Veracity Work Items via todo.txt and the script linked from there; it's more elaborate and specific than you'd want, but the core ideas are there.

A simple export script based on that follows, which you would run either as:

vscript listitems.js reponame

to list all items in the current milestone (if any is set), or

vscript listitems.js reponame milestone

to list all items from a specific milestone.

The output is tab-delimited to avoid having to escape commas.

// For entertainment purposes only. No warranty expressed or implied. Please, no wagering.

if ((arguments.length < 1) || (arguments.length > 2))
    showUsage();

var reponame = arguments[0];
var repo = null;
var milestone = null;

try
{
    repo = sg.open_repo(reponame);
}
catch (e)
{
    showUsage("Unable to open repo " + reponame + ": " + e.message);
}

if (arguments.length == 2)
    milestone = lookupMilestone(repo, arguments[1]);
else
    milestone = getCurrentMilestone(repo);

listTasks(repo, milestone);

repo.close();

quit(0);

function listTasks(repo, milestone)
{
    var users = {};

    var db = new zingdb(repo, sg.dagnum.USERS);
    var recs = db.query('user', ['*']);

    for ( var i = 0; i < recs.length; ++i )
        users[ recs[i].recid ] = recs[i].name;

    var useridToName = function(rec, field) {
        if (rec[field])
            rec[field] = users[ rec[field] ] || rec[field];
    };

    db = new zingdb(repo, sg.dagnum.WORK_ITEMS);

    recs = db.query('item', ['*'], "milestone == '" + milestone + "'");

    var fields = ['id', 'title', 'description', 'assignee', 'reporter', 'verifier', 'status', 'priority'];

    print( fields.join("\t") );

    for ( i = 0; i < recs.length; ++i )
    {
        var rec = recs[i];
        useridToName(rec, 'assignee');
        useridToName(rec, 'reporter');
        useridToName(rec, 'verifier');

        var vals = [];

        for ( var j = 0; j < fields.length; ++j )
        {
            var val = rec[ fields[j] ] || "";

            // keep everything on one line
            val = val.replace("\t", " ");
            val = val.replace(/^[ \t\r\n]+/, '');
            val = val.replace(/[ \t\r\n]+$/, '');
            val = val.replace(/\r?\n/g, "\\n");

            vals.push(val);
        }

        print( vals.join("\t") );
    }
}

// do we have a current milestone configured?
function getCurrentMilestone(repo)
{
    var cfg = new Configuration(repo);
    var cs = cfg.get('current_sprint');

    if (cs && cs.value)
        return(cs.value);

    showUsage("No milestone specified and no current milestone set");
}

function lookupMilestone(repo, milestone)
{
    var db = new zingdb(repo, sg.dagnum.WORK_ITEMS);
    var recs = db.query('sprint', ['recid'], "name == '" + milestone + "'");

    if ((! recs) || (recs.length == 0))
        showUsage("No milestone found matching '" + milestone + "'");

    return( recs[0].recid );
}

function showUsage(msg)
{
    if (repo)
        repo.close();

    if (msg)
    {
        msg = msg.replace(/[\r\n].+/, '') + "\n";   // trim stack trace
        print(msg);
    }

    print("usage: vscript listitems.js reponame [milestone]");

    quit(1);
}