Project Ledger Budget Import - Error opening Excel file - Unhandled Exception

• Error received when attempting to Import budget package data file

• Munis (pabudimp)
  

  Error opening Excel file: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
     at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
     at System.Reflection.RuntimeModule.GetTypes()
     at System.Reflection.Assembly.GetTypes()
     at Tyler.ComponentModel.Composition.Hosting.CatalogStateInfo.RetrieveOrCreatePartDefinitions(String searchPath, String searchPattern, ICompositionElement definitionOrigin)
     at Tyler.ComponentModel.Composition.Hosting.CatalogStateInfo.Create(String searchPath, String searchPattern, ICompositionElement definitionOrigin)
     at Tyler.ComponentModel.Composition.Hosting.SharedStateDirectoryCatalog..ctor(String path, String searchPattern)
     at Tyler.ComponentModel.Composition.Hosting.MefComponentLocator..ctor(Boolean isThreadSafe)
     at Tyler.ComponentModel.Composition.Hosting.MefComponentLocator..ctor()
     --- End of inner exception stack trace ---
     at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
     at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
     at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
     at System.Activator.CreateInstance(Type type, Boolean nonPublic)
     at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
     at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
     at System.Activator.CreateInstance(Type type, Object[] args)
     at Tyler.ComponentModel.Composition.Hosting.ComponentLocatorManager..ctor(ComponentLocatorScopeOption scopeOption, Object[] args)
     at Tyler.Logging.LogServices.GetSharedLogger()
     at Tyler.Logging.LogServices.Error(Exception exception, String message)
     at Tyler.Munis.Office.OfficeManager.GetExcelReader(ImportSettings importSettings, Stream inputStream)
     at Tyler.IO.Conversions.MSExcelToXml.Tyler.IO.Conversions.IFileConverter.ConvertFile(FileConverterSettings settings, String& errMsg)
     at Tyler.IO.Conversions.TylerInteropFileConverter.Main(String[] inArgs)

• Project Budget Package Import

• Data File Format

• Microsoft Excel Workbook (.XLSX)

• Comma Delimited File (.CSV)

• Error Message - Hard Stop

Excel workbook.xlsx is required and site is attempting to use .csv comma delimited file that can be displayed in Excel but it is not truly Excel.

1. Open .CSV file

2. File

3. Save As

4. Select Excel Workbook as the Save as type field option from drop down box

5. Save

6. Attempt to repeat import process.

• Please ensure file is closed and not in use while attempting to import Excel workbook.xlsx file