/// <summary>
/// Recursive writer of terms
/// </summary>
private static void WriteTerm(string termStoreName, string groupName, string termSetName, Term term, int level, bool splitLevels)
{
string id = GenUtil.CSVer(term.Id.ToString());
string name = GenUtil.CSVer(term.Name);
// get labels
//List<string> lstLabels = term.Labels.Where(x => x.Value != term.Name).Select(x => GenUtil.CSVer(x.Value)).ToList<string>();
//string labels = string.Join(",", lstLabels.ToArray<string>());
//if (term.Labels.Count <= 0)
// labels = "";
// get parent
Term termParent = term.Parent;
string termParentId = "null";
string termParentName = "null";
if (termParent != null)
{
termParentId = GenUtil.CSVer(termParent.Id.ToString());
termParentName = GenUtil.CSVer(termParent.Name);
}
if (splitLevels)
{
foreach (Microsoft.SharePoint.Taxonomy.Label lbl in term.Labels)
{
sbOutput.Append(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}" + Environment.NewLine,
termStoreName,
groupName,
GenUtil.MmdDenormalize(termSetName),
level.ToString(),
termParentId,
GenUtil.MmdDenormalize(termParentName),
id,
GenUtil.MmdDenormalize(GenUtil.CSVer(term.Name)),
GenUtil.MmdDenormalize(GenUtil.CSVer(lbl.Value)),
lbl.IsDefaultForLanguage.ToString()
));
}
}
else
{
// get labels, not including termname (default label)
//var lstLabels = term.Labels.Where(x => x.Value != term.Name).Select(x => GenUtil.CSVer(x.Value)).ToList<string>();
var lstLabels = term.Labels.Where(x => !x.IsDefaultForLanguage).Select(x => GenUtil.CSVer(x.Value)).ToList <string>();
string labels = string.Join(",", lstLabels.ToArray <string>());
if (term.Labels.Count <= 0)
{
labels = "";
}
sbOutput.Append(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8}" + Environment.NewLine,
termStoreName,
groupName,
GenUtil.MmdDenormalize(termSetName),
level.ToString(),
termParentId,
GenUtil.MmdDenormalize(termParentName),
id,
GenUtil.MmdDenormalize(name),
GenUtil.MmdDenormalize(labels)));
}
if (term.Terms.Count > 0)
{
level++;
foreach (Term childTerm in term.Terms)
{
WriteTerm(termStoreName, groupName, termSetName, childTerm, level, splitLevels);
}
}
}
/// <summary>
/// Currently ignores any selected terms or subterms to base export on.
/// </summary>
private static void ExportToCsv(
string fileName,
string siteUrl,
Guid?termStoreId,
Guid?groupId,
Guid?termSetId,
SortedList <int, Guid> slTerms,
bool splitLevels = false
)
{
sbOutput = new StringBuilder("");
if (splitLevels)
{
sbOutput.Append(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}" + Environment.NewLine,
GenUtil.CSVer("termStoreName"),
GenUtil.CSVer("groupName"),
GenUtil.CSVer("termSetName"),
GenUtil.CSVer("level"),
GenUtil.CSVer("parentId"),
GenUtil.CSVer("parentName"),
GenUtil.CSVer("termId"),
GenUtil.CSVer("termName"),
GenUtil.CSVer("termLabel"),
GenUtil.CSVer("isDefaultLabel")
));
}
else
{
sbOutput.Append(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8}" + Environment.NewLine,
GenUtil.CSVer("termStoreName"),
GenUtil.CSVer("groupName"),
GenUtil.CSVer("termSetName"),
GenUtil.CSVer("level"),
GenUtil.CSVer("parentId"),
GenUtil.CSVer("parentName"),
GenUtil.CSVer("termId"),
GenUtil.CSVer("termName"),
GenUtil.CSVer("termLabels")));
}
using (SPSite site = new SPSite(siteUrl))
{
TaxonomySession txsn = new TaxonomySession(site, true);
foreach (TermStore _curTermStore in txsn.TermStores)
{
if (termStoreId != null && _curTermStore.Id != termStoreId)
{
continue;
}
foreach (Group _curGroup in _curTermStore.Groups)
{
if (groupId != null && _curGroup.Id != groupId)
{
continue;
}
foreach (TermSet _curTermSet in _curGroup.TermSets)
{
if (termSetId != null && _curTermSet.Id != termSetId)
{
continue;
}
foreach (Term _curTerm in _curTermSet.Terms)
{
WriteTerm(_curTermStore.Name, _curGroup.Name, _curTermSet.Name, _curTerm, 1, splitLevels);
}
}
}
}
}
FileStream fs = new FileStream(fileName, FileMode.Create);
StreamWriter writer = new StreamWriter(fs);
writer.Write(sbOutput.ToString());
writer.Close();
fs.Close();
}
