TM Scripts to filter Articles from Asp.NET 3.5 library based on list of titles

1. final version.cs

var titlesData     = "https://gist.github.com/DinisCruz/8653339/raw/04bac08187051090c239bf20866dc20d95752d6d/gistfile1.txt"; 
 
var tmDatabase   = TM_Xml_Database.Current;
var articles     = tmDatabase.Cached_GuidanceItems.Values;
var articlePaths = tmDatabase.GuidanceItems_FileMappings;


var libraryName = ".NET 3.5";
var libraryId   = tmDatabase.tmLibrary(libraryName).Id;
var titles      = "titles".o2Cache<List<String>>(()=>titlesData.GET().split("\n"))
			  .unique();

var articlesMatches = from article in articles
		      where article.Metadata.Library_Id == libraryId
		      where titles.contains(article.Metadata.Title)
		      select article.Metadata;
                      
var mappings = "TITLE,GUID".line();
foreach(var metadata in articlesMatches)
	mappings += "\"{0}\",{1}".line().format(metadata.Title, metadata.Id);
        
return "<pre style='color:black'>{0}</pre>".format(mappings);

//using TeamMentor.CoreLib;
//O2Ref:TeamMentor.CoreLib.dll

1. find titles in library.cs

var titlesData     = "https://gist.github.com/DinisCruz/8653339/raw/ce19914729bc232fdbfae2348803abeceb0b4ec8/gistfile1.txt"; 
 
var tmDatabase   = TM_Xml_Database.Current;
var articles     = tmDatabase.Cached_GuidanceItems.Values;
var articlePaths = tmDatabase.GuidanceItems_FileMappings;


var libraryName = ".NET 3.5";
var libraryId   = tmDatabase.tmLibrary(libraryName).Id;

var articlesMatches = from article in articles
		      where article.Metadata.Library_Id == libraryId
		      select article;
                      
//return articlesMatches.first().Metadata;                      
return articlesMatches.size();

//using TeamMentor.CoreLib;
//O2Ref:TeamMentor.CoreLib.dll

2. create mappings text.cs

var titlesData     = "https://gist.github.com/DinisCruz/8653339/raw/04bac08187051090c239bf20866dc20d95752d6d/gistfile1.txt"; 
 
var tmDatabase   = TM_Xml_Database.Current;
var articles     = tmDatabase.Cached_GuidanceItems.Values;
var articlePaths = tmDatabase.GuidanceItems_FileMappings;


var libraryName = ".NET 3.5";
var libraryId   = tmDatabase.tmLibrary(libraryName).Id;
var titles      = "titles".o2Cache<List<String>>(()=>titlesData.GET().split("\n"))
			  .unique();

var articlesMatches = from article in articles
		      where article.Metadata.Library_Id == libraryId
		      where titles.contains(article.Metadata.Title)
		      select article.Metadata;
                      
var mappings = "TITLE,GUID";
foreach(var metadata in articlesMatches)
	mappings += "\"{0}\",{1}".format(metadata.Title, metadata.Id);
        
return mappings;

//using TeamMentor.CoreLib;
//O2Ref:TeamMentor.CoreLib.dll

2. find files that match title list.cs

var titlesData     = "https://gist.github.com/DinisCruz/8653339/raw/04bac08187051090c239bf20866dc20d95752d6d/gistfile1.txt"; 
 
var tmDatabase   = TM_Xml_Database.Current;
var articles     = tmDatabase.Cached_GuidanceItems.Values;
var articlePaths = tmDatabase.GuidanceItems_FileMappings;


var libraryName = ".NET 3.5";
var libraryId   = tmDatabase.tmLibrary(libraryName).Id;
var titles      = "titles".o2Cache<List<String>>(()=>titlesData.GET().split("\n"))
			  .unique();

var articlesMatches = from article in articles
		      where article.Metadata.Library_Id == libraryId
		      where titles.contains(article.Metadata.Title)
		      select article;
                      
//return articlesMatches.first().Metadata;                      
return articlesMatches.size();

//using TeamMentor.CoreLib;
//O2Ref:TeamMentor.CoreLib.dll