I don't have replication steps. Just this comment from Alastair on the LeanKitKanBan board we were using:

GiveCRM title
Email field
Password field
Sign in button

Reproduction Steps

1. Navigate to Member Dashboard (/Member)
2. Click "Import Excel Spreadsheet"

Expected

You end up at the Excel Importer

Actual

You get an ActivationException

Error activating IExcelImportService
No matching bindings are available, and the type is not self-bindable.
Activation path:
  2) Injection of dependency IExcelImportService into parameter excelImporter of constructor of type ExcelImportController
  1) Request for ExcelImportController

Suggestions:
  1) Ensure that you have defined a binding for IExcelImportService.
  2) If the binding was defined in a module, ensure that the module has been loaded into the kernel.
  3) Ensure you have not accidentally created more than one kernel.
  4) If you are using constructor arguments, ensure that the parameter name matches the constructors parameter name.
  5) If you are using automatic module loading, ensure the search path and filters are correct.

Reproduction steps

1. Visit the Excel Importer, by going to /ExcelImport.
2. Do not select a file for upload.
3. Click the Upload button

Expected

1. An error message is displayed indicating that you did not select a file for upload.

Actual

1. The Import page is re-displayed with no error message.

I don't have replication steps, unfortunately. Just this comment from Alastair on the LeanKitKanBan board we were using:

Common membership across charities
Persistent login cookie
Authorization (which charities you can access) is separate

This should be split into specific tasks when we come to it, as I know there are already a couple of guys looking into Auth/Authz.

Ok for now I am going to hook up my teamcity server to GiveCRM repo and build it from there - i will also make a test site on my server and push deploys to there

i will work along the assumption of check in causes deployment for now

that way you can all monitor the progress - if anyone has any objections say ay!

Paul

This can happen in two ways:

1. clicking on a campaign in GiveCRM that has a date search criteria
2. generating random data using the data generation tool (when it tries to find the members that match the criteria for a campaign run)

The error is "Conversion failed when converting date and/or time from character string", with a stack trace of (from case 1):

[SqlException (0x80131904): Conversion failed when converting date and/or time from character string.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2084770
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5084476
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.HasMoreRows() +211
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +217
System.Data.SqlClient.SqlDataReader.Read() +9
Simple.Data.Ado.DataReaderEnumerator.MoveNext() +28
System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +87
System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +87
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +327
System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
GiveCRM.Web.Controllers.CampaignController.Show(Int32 id) in E:\Develop\github\adrianbanks\GiveCRM\src\GiveCRM.Web\Controllers\CampaignController.cs:102
lambda_method(Closure , ControllerBase , Object[] ) +101
System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +208
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
System.Web.Mvc.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() +55
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +263
System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +191
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +343
System.Web.Mvc.Controller.ExecuteCore() +116
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +97
System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +37
System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
System.Web.Mvc.<>c__DisplayClasse.<EndProcessRequest>b__d() +50
System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f) +7
System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +22
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +60
System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8964029
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184

I don't have replication steps. This comment is from Kim on the LeanKitKanBan board we were using.

I suspect this refers to several specific things, such as:

• Validation of input values for donations (i.e. must be >= 0)
• Validation of empty fields

It may be suitable to create separate cases if there are many places where this is an issue.

This may no longer be necessary since the introduction to the CRM and admin site of Twitter bootstrap?

There is some sensitive information in the repository (a list of everyone's name, Twitter handles and email addresses).

It is not considered best practice to check in NuGet packages to the repository.

The repository should be cleaned up a bit to remove these extra items.

This needs some serious separation of concerns - in it's current state there is a hard dependency on MembershipRole provider. We need to put this into the Member service IMO as this is just not testable

Guys the db project doesnt build unless you have visual studio installed

Please can someone check the following file into a /src/tools folder and reference the file in the dataaccess project from this tools folder rather than program files folder

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets

Thanks

Paul

This came from the "Member add Facets" card on LeanKitKanban created by Kim.

This issue is from the card created by Alastair on the LeanKitKanBan board we were using:

IE6 (7?) probably shouldn't be supported.

When the user clicks to view an existing campaign that has been committed or closed, they should not be able to change details of the campaign.

This comment is from Alastair on the LeanKitKanBan board we were using:

Activate a charity's site when the activation link is visited.
Configure subdomain using our default generated "short name"
Charity ID: pass to Core UI for setting up DB connection, etc. Take from activation URL?

This issue is from the card created by Alastair on the LeanKitKanBan board we were using.

The current data generator can only generate members and campaigns, with the campaigns being committed and having no members.

The data generator needs updating so that it can create:

• uncommitted campaigns

• committed campaigns

• closed campaigns

  (all of which should have search criteria, and hence members)

This issue is from the card created by Alastair on the LeanKitKanBan board we were using:

IE6 (7?) probably shouldn't be supported.

Steps to replicate

1. Arrange test data to have Campaign with >1000 members included.
2. Commit Campaign.
3. Click "Download Mailing List".
4. Choose download location for xls file.
5. Open xls file in Excel 2003 (or, I suspect, earlier versions).

Expected Result

Spreadsheet opens with no formatting (except bold applied to header row) and no messages.

Actual Result

Spreadsheet opens, but Excel displays a warning message:

Too many different cell formats

Also, the background colour of all the cells is set to white. I think this is a side-effect of Excel being upset, rather than anythin in the GiveCRM code. If we fix the formatting problem, I believe the cell background formatting will disappear. Clicking okay displays data and a second messagebox:

"Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please check your formatting carefully."

Additional Notes

Although this isn't a problem with newer versions of Excel, I suspect the kind of charities we're targeting with GiveCRM might well have this issue, so it's not something to ignore. I believe this is because the Excel export tool we're using is applying formatting to each cell individually, rather than to an Excel Range of cells.

From the build log:

[05:08:00][Step 2/4]
    Unhandled exception in remote appdomain: System.NullReferenceException: Object reference not set to an instance of an object.
       at GiveCRM.ImportExport.ExcelXlsImporter.Dispose(Boolean disposing) in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 117
       at GiveCRM.ImportExport.ExcelXlsImporter.Finalize() in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 104
[05:08:00][Step 2/4] 2012-04-08 05:08:00,488 [2328] ERROR JetBrains.TeamCity.NUnitLauncher.ErrorLoggerImpl - Unhandled exception in remote appdomain: System.NullReferenceException: Object reference not set to an instance of an object.
[05:08:00][Step 2/4]    at GiveCRM.ImportExport.ExcelXlsImporter.Dispose(Boolean disposing) in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 117
[05:08:00][Step 2/4]    at GiveCRM.ImportExport.ExcelXlsImporter.Finalize() in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 104
[05:08:00][Step 2/4] 2012-04-08 05:08:00,533 [2328] WARN  JetBrains.Container.Log4netDefaultLoggerInitializer - Unhandled exception in current domain: System.NullReferenceException: Object reference not set to an instance of an object.
[05:08:00][Step 2/4]    at GiveCRM.ImportExport.ExcelXlsImporter.Dispose(Boolean disposing) in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 117
[05:08:00][Step 2/4]    at GiveCRM.ImportExport.ExcelXlsImporter.Finalize() in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 104,    at GiveCRM.ImportExport.ExcelXlsImporter.Dispose(Boolean disposing) in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 117
[05:08:00][Step 2/4]    at GiveCRM.ImportExport.ExcelXlsImporter.Finalize() in c:\BuildAgent\work\d6628f96903cef80\src\GiveCRM.ImportExport\GiveCRM.ImportExport\ExcelXlsImporter.cs:line 104, (null)

This issue is from the card created by Alastair on the LeanKitKanBan board we were using:

Connection String
Blank database
Apply GiveCRM schema
Apply base data

This issue is from the card created by Kim on the LeanKitKanBan board we were using. I suspect this is already part-done (there's a "Setup" menu on the menu bar that has "facets" listed) but it may not be complete.

This comment is from Alastair on the LeanKitKanBan board we were using:

Currently the search functionality can only display a maximum of 25 results. This is not very useful. Paging the search results would provide a better UX.

The GiveCRM.Web project has a two files referenced in .csproj which are not part of the repo. Can whoever knows about them please add / delete them as required.

Views/Shared/_LogOnPartial.cshtml
Views/Setup/AddFacetOption.cshtml

Thanks,
Chris

Hey guys

there is a large dependency on the DataAccess layer throughout the campaign controller. This is caused by a new instance of the DataAccess layer being called in a lot of methods in this way:

Campaigns db = new Campaigns();
Campaign savedCampaign = db.Insert(campaign);
return savedCampaign.Id;

We really need to get this moved out of the Controller

I think this would be a big milestone for Separation of Concerns

Paul

Reproduction steps

1. Go the Excel Importer by visiting /ExcelImport
2. Click the Download Excel Template link

Expected

1. The Excel Template file downloads to disk successfully.

Actual

1. An error is thrown and the template does not download.

Notes

This was broken when the Excel Importer was moved to the main application. The Excel Template is still in the GiveCRM.Admin repository, and is being embedded into the GiveCRM.Admin.Web assembly. It should be moved to the GiveCRM.Web assembly.

Create new IIS website [or virtual machine, Azure instance, etc.]

There's some discussion about this not being strictly necessary, if we can tell (via host headers or through the URL) the CRM which database to connect to. This would be preferable, because then requests can be shared across a horizontally-scaled cluster, rather than siloing each charity to their own CRM instance.

Steps to replicate

1. Open CRM site
2. Click "Donations" on menu bar

Expected result

The donations page to appear.

Action result

An exception is thrown in Views/Donation/Index.cshtml (see below).

Exception detail

System.Web.HttpException was unhandled by user code
Message=Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'.
Source=System.Web
ErrorCode=-2147467259
WebEventCode=0
StackTrace:
at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)
at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
at System.Web.HttpServerUtilityWrapper.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
at System.Web.Mvc.Html.ChildActionExtensions.ActionHelper(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues, TextWriter textWriter)
at System.Web.Mvc.Html.ChildActionExtensions.RenderAction(HtmlHelper htmlHelper, String actionName, String controllerName)
at ASP._Page_Views_Donation_Index_cshtml.Execute() in c:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Donation\Index.cshtml:line 25
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
at System.Web.WebPages.StartPage.RunPage()
at System.Web.WebPages.StartPage.ExecutePageHierarchy()
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
at System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance)
at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer)
at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1c.b__19()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func`1 continuation)
InnerException: System.Web.HttpCompileException
Message=c:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml(35): error CS1026: ) expected
Source=System.Web
ErrorCode=-2147467259
WebEventCode=0
SourceCode=#pragma checksum "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "4722FD71B23E0A111F69AC5F99792055"
//------------------------------------------------------------------------------
//
// This code was generated by a tool.
// Runtime Version:4.0.30319.239
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
//
//------------------------------------------------------------------------------

namespace ASP {
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Helpers;
using System.Web.Security;
using System.Web.UI;
using System.Web.WebPages;
using System.Web.Mvc;
using System.Web.Mvc.Ajax;
using System.Web.Mvc.Html;
using System.Web.Routing;

#line 2 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"
using GiveCRM.Web.Models.Members;

#line default
#line hidden

#line 3 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"
using PagedList.Mvc;

#line default
#line hidden

public class _Page_Views_Member_MembersList_cshtml : System.Web.Mvc.WebViewPage {

line hidden

   public _Page_Views_Member_MembersList_cshtml() {
   }

   protected ASP.global_asax ApplicationInstance {
       get {
           return ((ASP.global_asax)(Context.ApplicationInstance));
       }
   }

   public override void Execute() {





       #line 4 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"

Layout = null;

       #line default
       #line hidden

WriteLiteral("\r\n<script src="");

       #line 8 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"
   Write(Url.Content("~/Scripts/ViewScripts/MemberList.js"));


       #line default
       #line hidden

WriteLiteral("" type="text/javascript"></script>\r\n<script type="text/javascript">\r\n\r\n $(func" +
"tion () {\r\n MemberList.Initialise()\r\n });\r\n\r\n</script>\r\n\r\n");

       #line 17 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"

if (Model != null && Model.Count > 0)
{

       #line default
       #line hidden

WriteLiteral("

\r\n\r\n \r\n \r\n \r\n <t" +
"h> \r\n \r\n \r\n \r\n \r\n \r\n\r\n");

       #line 31 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"
foreach (var member in Model)

{

       #line default
       #line hidden

WriteLiteral("

\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n");

       #line 42 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"

}

       #line default
       #line hidden

WriteLiteral(@"

\r\n \r\n

		Reference	Name	Ad" + "dress	Email
"); #line 34 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(Html.ActionLink("Edit", "Edit", new { id = member.Id })); #line default #line hidden WriteLiteral("	"); #line 35 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(Html.ActionLink("Delete", "Delete", new { id = member.Id } new { title = "ref_" + member.Reference })); #line default #line hidden WriteLiteral("	"); #line 36 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(Html.ActionLink("Log Donation", "Donate", new { id = member.Id })); #line default #line hidden WriteLiteral("	"); #line 37 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.Reference); #line default #line hidden WriteLiteral("	"); #line 38 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.Salutation); #line default #line hidden WriteLiteral(" "); #line 38 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.FirstName); #line default #line hidden WriteLiteral(" "); #line 38 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.LastName); #line default #line hidden WriteLiteral("	"); #line 39 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.AddressLine1); #line default #line hidden WriteLiteral(" "); #line 39 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.AddressLine2); #line default #line hidden WriteLiteral(" "); #line 39 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.City); #line default #line hidden WriteLiteral(" "); #line 39 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.PostalCode); #line default #line hidden WriteLiteral("	"); #line 40 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(member.EmailAddress); #line default #line hidden WriteLiteral("
<style type=""text/css""> .PagedList-pager ul li { display: inline; margin: 0 5px; } .PagedList-currentPage { font-weight: bold; } .PagedList-currentPage a { color: Black; } </style> "); #line 56 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml" Write(Html.PagedListPager(Model, Model.PagingFunction, PagedListRenderOptions.OnlyShowFivePagesAtATime)); #line default #line hidden WriteLiteral("\r\n

\r\n");

       #line 60 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"

}
else
{

       #line default
       #line hidden

WriteLiteral("

Your search returned no results.

\r\n");

       #line 64 "C:\Code\GiveCampUK2011\GiveCRM_nbarnwell\src\GiveCRM.Web\Views\Member\MembersList.cshtml"

}

       #line default
       #line hidden

WriteLiteral("\r\n\r\n");

   }

}
}

  StackTrace:
       at System.Web.Compilation.AssemblyBuilder.Compile()
       at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
       at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
       at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
       at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
       at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
       at System.Web.Mvc.BuildManagerWrapper.System.Web.Mvc.IBuildManager.FileExists(String virtualPath)
       at System.Web.Mvc.BuildManagerViewEngine.FileExists(ControllerContext controllerContext, String virtualPath)
       at System.Web.Mvc.VirtualPathProviderViewEngine.GetPathFromGeneralName(ControllerContext controllerContext, List`1 locations, String name, String controllerName, String areaName, String cacheKey, String[]& searchedLocations)
       at System.Web.Mvc.VirtualPathProviderViewEngine.GetPath(ControllerContext controllerContext, String[] locations, String[] areaLocations, String locationsPropertyName, String name, String controllerName, String cacheKeyPrefix, Boolean useCache, String[]& searchedLocations)
       at System.Web.Mvc.VirtualPathProviderViewEngine.FindView(ControllerContext controllerContext, String viewName, String masterName, Boolean useCache)
       at System.Web.Mvc.ViewEngineCollection.<>c__DisplayClassc.<FindView>b__b(IViewEngine e)
       at System.Web.Mvc.ViewEngineCollection.Find(Func`2 lookup, Boolean trackSearchedPaths)
       at System.Web.Mvc.ViewEngineCollection.FindView(ControllerContext controllerContext, String viewName, String masterName)
       at System.Web.Mvc.ViewResult.FindView(ControllerContext context)
       at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1c.<InvokeActionResultWithFilters>b__19()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func`1 continuation)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1c.<>c__DisplayClass1e.<InvokeActionResultWithFilters>b__1b()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult)
       at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
       at System.Web.Mvc.Controller.ExecuteCore()
       at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
       at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)
       at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
       at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d()
       at System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f)
       at System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action)
       at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
       at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
       at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerAsyncWrapper.<>c__DisplayClassa.<EndProcessRequest>b__9()
       at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.<>c__DisplayClass4.<Wrap>b__3()
       at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1 func)
       at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap(Action action)
       at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerAsyncWrapper.EndProcessRequest(IAsyncResult result)
       at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
  InnerException:

The underlying library will handle Excel 2007+ (.xlsx) files without a problem, but the ExcelImportService has a hard-coded expectation that the file is in Excel 97-2003 (.xls) format.

There is also a hard-coded expectation that the data to import is in the first worksheet in the file.

This issue is from the card created by Alastair on the LeanKitKanBan board we were using.

Which charities can I access? Keep this separate from Authentication for maximum flexibility