private async Task CreateNavListAsync()
{
await Task.Run(() =>
{
foreach (Worksheet ws in workbook.Sheets)
{
if (!ws.Name.Equals("NAV"))
{
continue;
}
sheetFunctions = new ExcelHelperFunctions(ws);
TotalRecords = sheetFunctions.RowCount;
// reading starts with second row as first row contains headlines
for (int row = 1; row < sheetFunctions.RowCount; row++)
{
ExcelNav nav = GetNavRow(row);
if (nav != null)
{
navList.Add(nav);
}
else
{
}
}
}
});
}
static void Main(string[] args)
{
// Get input variables
Console.Write("Enter Zendesk Support API base (e.g. https://xyz.zendesk.com): ");
string userApiBase = Console.ReadLine();
Console.Write("Enter email address of a Zendesk admin or agent: ");
string emailAddress = Console.ReadLine();
Console.Write("Enter Zendesk API token: ");
string apiToken = Console.ReadLine();
Console.Write("Enter output Excel file name: ");
string excelFileName = Console.ReadLine();
Console.Write("Enter output Excel file sheet name: ");
string sheetName = Console.ReadLine();
var apiCredentials = Convert.ToBase64String(Encoding.Default.GetBytes($"{emailAddress}/token:{apiToken}"));
IOrderedEnumerable <IGrouping <string, ZdUser> > duplicatedUsersGrouped = null;
IEnumerable <ZdUser> zdUsers = null;
var stopwatch = Stopwatch.StartNew();
try
{
// Get all users
zdUsers = ZdFunctions.Users.GetAllUsers(userApiBase, apiCredentials);
// Get duplicate users, grouped by name
duplicatedUsersGrouped = zdUsers.GroupBy(x => x.Name)
.Where(g => g.Count() > 1)
.OrderBy(g => g.Key);
// Create output Excel file and write duplicated users if any
if (duplicatedUsersGrouped.Any())
{
Console.WriteLine("Creating Excel file");
ExcelHelperFunctions.CreateExcelFile(excelFileName, sheetName);
Console.WriteLine("Writing duplicate users to Excel file");
ExcelHelperFunctions.OutputDuplicatedUsersToExcel(excelFileName, sheetName, duplicatedUsersGrouped, zdUsers);
}
}
catch (Exception ex)
{
Console.WriteLine($"Exception occurred, message: {ex.Message}, stackTrace: {ex.StackTrace}");
}
stopwatch.Stop();
TimeSpan ts = stopwatch.Elapsed;
Console.WriteLine("");
Console.WriteLine($"Total # user records: {zdUsers.Count()}, # duplicated users: {duplicatedUsersGrouped.Count()}");
Console.WriteLine($"Program duration time: {ts.Hours} hours, {ts.Minutes} minutes, {ts.Seconds} seconds, {ts.Milliseconds} milliseconds");
Console.ReadLine();
}
private Task ReadCommitmentsAsync()
{
CanAddMissingItems = false;
foreach (Worksheet ws in workbook.Sheets)
{
if (!ws.Name.Equals("Commitment"))
{
continue;
}
sheetFunctions = new ExcelHelperFunctions(ws);
for (int row = 1; row < sheetFunctions.RowCount; row++)
{
GetCommitmentRow(row);
}
}
return(Task.CompletedTask);
}
