b98c0523-6503-49a7-bdf3-1b0c0e1561b3 Journal Set CSV Import This plugin adds a menu option to the Journal Sets form to "Import From CSV". Imported journal will have it's type set to "Pending". The CSV columns will be:

Date, AccountNo, Debit, Credit, BASCode, Reference, Remark

Column headers will be included. A sample CSV file is attached to the documents tab of this plugin. BAS Codes are numeric - refer to the attached "BAS Codes.txt" document. true false 0 Jiwa Financials 7.2.1.0 using Microsoft.VisualBasic; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using JiwaFinancials.Jiwa; using System.Windows.Forms; using System.Data.SqlClient; using System.Drawing; using ServiceStack; using ServiceStack.DataAnnotations; using ServiceStack.Model; #region "FormPlugin" public class FormPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void SetupBeforeHandlers(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { var journalSetsForm = (JiwaFinancials.Jiwa.JiwaJournalSetsUI.MainForm)JiwaForm; // Add the tool to the toolbar Infragistics.Win.UltraWinToolbars.RibbonGroup group; Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool; buttonTool = new Infragistics.Win.UltraWinToolbars.ButtonTool("ID_RecordImportFromCSV"); buttonTool.SharedProps.Caption = "Import From CSV"; journalSetsForm.UltraToolbarsManager1.Tools.Add(buttonTool); group = journalSetsForm.UltraToolbarsManager1.Ribbon.Tabs["Main"].Groups["Actions"]; group.Tools.AddTool("ID_RecordImportFromCSV"); journalSetsForm.UltraToolbarsManager1.Ribbon.Tabs["Main"].Groups["Actions"].Tools["ID_RecordImportFromCSV"].InstanceProps.PreferredSizeOnRibbon = Infragistics.Win.UltraWinToolbars.RibbonToolSize.Normal; journalSetsForm.UltraToolbarsManager1.Toolbars["Toolbar"].Tools.InsertTool(journalSetsForm.UltraToolbarsManager1.Toolbars["Toolbar"].Tools["ID_RecordNew"].Index + 1, "ID_RecordImportFromCSV"); journalSetsForm.UltraToolbarsManager1.ToolClick += journalSetsForm_UltraToolbarsManager1_ToolClick; } public void journalSetsForm_UltraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { if(e.Tool.Key == "ID_RecordImportFromCSV") { string fullFileName = GetCSVFileName(); if(fullFileName != null && fullFileName.Trim().Length > 0) { //Create a new journal set JiwaFinancials.Jiwa.JiwaJournalSetsUI.MainForm journalSetsForm = (JiwaFinancials.Jiwa.JiwaJournalSetsUI.MainForm)((Infragistics.Win.UltraWinToolbars.UltraToolbarsManager)sender).DockWithinContainer; journalSetsForm.NewRecord(); journalSetsForm.JournalSet.SetType = JiwaFinancials.Jiwa.JiwaJournalSets.JournalSet.SetTypes.Pending; //Get the CSV data List<ImportLine> lines = System.IO.File.ReadAllText(fullFileName).FromCsv<List<ImportLine>>(); JiwaFinancials.Jiwa.JiwaJournalSets.Line journalSetLine = null; foreach(ImportLine line in lines) { SetLineDefaults(line); journalSetLine = journalSetsForm.Manager.CollectionItemFactory.CreateCollectionItem<JiwaFinancials.Jiwa.JiwaJournalSets.Line>(); journalSetLine.TransPostDateTime = line.Date; journalSetLine.GLAccount.ReadRecordFromAccountNo(line.AccountNo); journalSetLine.DebitAmount = line.Debit; journalSetLine.CreditAmount = line.Credit; journalSetLine.BASCode = (JiwaFinancials.Jiwa.JiwaJournalSets.Line.BASCodes)line.BASCode; journalSetLine.Reference = line.Reference; journalSetLine.Remark = line.Remark; journalSetsForm.JournalSet.Lines.Add(journalSetLine); } MessageBox.Show(string.Format("{0} imported.", fullFileName), "Journal Set CSV Import", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); } } } public string GetCSVFileName() { //Show open CSV dialog string FileFilter = "CSV Files (*.csv)|*.csv|All Files (*.*)|*.*"; System.Windows.Forms.OpenFileDialog DialogOpen = new System.Windows.Forms.OpenFileDialog(); DialogOpen.Title = "Journal Set Import"; DialogOpen.Filter = FileFilter; DialogOpen.FileName = ""; if (DialogOpen.ShowDialog() == System.Windows.Forms.DialogResult.OK && DialogOpen.FileName.Trim().Length > 0) return DialogOpen.FileName; else return ""; } public void SetLineDefaults(ImportLine Line) { //Set defaults if(Line.Date == null) Line.Date = DateTime.Now; if(Line.AccountNo == null) Line.AccountNo = ""; if(Line.Debit == null) Line.Debit = 0; if(Line.Credit == null) Line.Credit = 0; if(Line.BASCode == null) Line.BASCode = 0; if(Line.Reference == null) Line.Reference = ""; if(Line.Remark == null) Line.Remark = ""; } } #endregion #region "BusinessLogicPlugin" public class BusinessLogicPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogicPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic JiwaBusinessLogic, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "ApplicationManagerPlugin" public class ApplicationManagerPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "CustomFieldPlugin" public class CustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #region "LineCustomFieldPlugin" public class LineCustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #region "SystemSettingPlugin" public class SystemSettingPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } } #endregion #region "ScheduledExecutionPlugin" public class ScheduledExecutionPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin { public void Execute(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule Schedule) { lock (JiwaFinancials.Jiwa.JiwaApplication.Manager.CriticalSectionFlag) { // place processing code in here } } public void OnServiceStart(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void OnServiceStopping(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "POCO" public class ImportLine { public enum BASCodes { No_Code = 0, Sales_G1 = 1, Exports_G2 = 2, Sales_GST_Free_G3 = 3, Input_Tax_Sales_G4 = 4, Not_Used_G5 = 5, Not_Used_G6 = 6, Sales_Adjustments_G7 = 7, Not_Used_G8 = 8, Not_Used_G9 = 9, Capital_Purchases_G10 = 10, Purchases_G11 = 11, Not_Used_G12 = 12, Purchases_For_Sales_G13 = 13, Purchases_GST_Free_G14 = 14, Purchases_Private_G15 = 15, Not_Used_G16 = 16, Not_Used_G17 = 17, Purchase_Adjustments_G18 = 18, Not_Used_G19 = 19, Not_Used_G20 = 20, Salaries_Paid_W1 = 21, Salary_Deductions_W2 = 22, Investment_Deductions_W3 = 23, No_ABN_W4 = 24, Wine_Equalisation_Payable_1C = 25, Wine_Equalisation_Refundable_1D = 26, Luxury_Car_Payable_1E = 27, Luxury_Car_Refundable_1F = 28, WST_Credit_1G = 29, Pay_As_You_Go_4 = 30 } public DateTime Date {get; set;} public string AccountNo {get; set;} public decimal Debit {get; set;} public decimal Credit {get; set;} public BASCodes BASCode {get; set;} public string Reference {get; set;} public string Remark {get; set;} public ImportLine() { Date = DateTime.Now; AccountNo = ""; Debit = 0; Credit = 0; BASCode = 0; Remark = ""; Reference = ""; } } #endregion Report CSharp 6c739fe8-96f4-4a21-8860-e4652dd64713 Journal Sets JiwaFinancials.Jiwa.JiwaJournalSetsUI.MainForm e84a96b0-cc32-44c9-883b-26cfa032effe JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaApplication.dll 3411efd5-1992-4b35-9281-1157ceffbb02 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll d5207dfe-ccd6-4196-9d44-c9dfb58c7edb System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll e75b0e0a-4496-45de-abee-5396365cfe09 Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll 11e95bcd-daa7-4943-a4df-9091a9da809e System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll 0770ae6b-6695-4220-94c5-3108b54e5124 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaODBC.dll 7297cf5c-e22c-4dd4-a703-eda643776814 System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll 1e878437-73f7-44a6-be1c-9bc50dc4af0f System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll f5d44776-e99b-4f70-a821-a4cde59d97e5 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll e950d6e9-0566-43f8-b34b-bbe683d71a87 System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll 66d99929-93fd-4a30-86c6-236c214d74d6 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaServiceModel.dll 2760b7c6-96ea-4f5b-9bf4-ad21ddf34adb Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.Misc.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.Misc.v13.1.dll 58f32cfc-4b09-4b9b-bed2-bc1074e04831 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinEditors.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinEditors.v13.1.dll 9a12afc5-a86a-4aca-8f10-7db385b91f44 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.v13.1.dll feb5c3e1-ea40-4ce9-84d4-4cfe89544600 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll D:\VSTSSnaps\7.02.01.00 SR3\Microsoft.SqlServer.Smo.dll 9368e6bd-e48d-4e09-ba41-156f4e180f8f Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll D:\VSTSSnaps\7.02.01.00 SR3\Microsoft.SqlServer.ConnectionInfo.dll 0d826c00-c0e7-4510-979f-cd27da52e3e1 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinExplorerBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll c9232074-2eea-4b4e-adcb-ba60713d00ec Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTree.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTree.v13.1.dll e7d99fa3-8b19-4f75-897c-e7fc2efa509f FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win.Spread\8.35.20151.0__327c3516b1b18457\FarPoint.Win.Spread.dll 0392f59b-bc53-4129-a106-63fe327f8170 Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTabControl.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTabControl.v13.1.dll 29a97267-9ed4-4f48-896f-675287a37327 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Shared.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Shared.v13.1.dll 32bdc7a7-f682-4422-acb1-4fe9c3e826dd Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinToolbars.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinToolbars.v13.1.dll e67e3905-da94-4ce7-bc43-c4ab7d42dae0 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinStatusBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 5cfe416f-544e-4924-a4f7-6ba728b4365d Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinSchedule.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinSchedule.v13.1.dll 1eaf7c58-d010-434c-be83-ae2c312ac622 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinListView.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinListView.v13.1.dll f051b97f-84d0-4f51-926b-4aec582f20c2 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll D:\VSTSSnaps\7.02.01.00 SR3\ServiceStack.dll 84480249-a297-4a46-9812-15275113043c EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll D:\VSTSSnaps\7.02.01.00 SR3\EntityFramework.dll d4910bee-88f4-4977-86be-aeb61cfa47d6 System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll 8e096286-efe1-4f11-8723-4e9d9ed61e1b ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll cca9841d-c6be-417f-bf03-3486b6089f7f ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll D:\VSTSSnaps\7.02.01.00 SR3\ZetaHtmlEditControl.dll daf7e028-749f-45d9-b6e9-355c03ef23e4 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll b468c1d8-6bb9-4ce1-a2d5-749af885a28c JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaEncryption.dll fda72e68-c19e-4e73-8b2b-98604eca8fb0 System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll e8b6584c-c104-434a-ad3d-9a7ddfcbe25d Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinGrid.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinGrid.v13.1.dll 98f53639-8c35-4256-83c8-9007a2c69734 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll D:\VSTSSnaps\7.02.01.00 SR3\Microsoft.SqlServer.Dac.dll 71678576-9162-458d-a911-6fe9aac1f285 CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll 4dbe2634-cd45-4084-9301-c8a5a9283cab CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Shared.dll eb906872-2cf9-49bc-be4a-c94221add965 CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ClientDoc.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ClientDoc\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ClientDoc.dll 74781469-387e-49f1-a872-480f1676f61f CrystalDecisions.ReportAppServer.Controllers, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.Controllers.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.Controllers\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.dll b192454e-8af3-4aa7-9bed-351201fc93ee Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.AppStylistSupport.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.AppStylistSupport.v13.1.dll d6cb8bee-e9d6-4694-833e-fe6968a2a3aa JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaLib.dll 7b1ebb0c-67dd-4ddb-b0d7-75b2619d4d33 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll D:\VSTSSnaps\7.02.01.00 SR3\Microsoft.ApplicationInsights.dll ccdd6cce-4dbb-4b66-a66b-126062963897 CrystalDecisions.Windows.Forms, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll 15e597e9-a785-4876-b534-ad4317ed22c0 EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll D:\VSTSSnaps\7.02.01.00 SR3\EntityFramework.SqlServer.dll 204b9e40-7644-4271-9837-8733e3b68a9f ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll D:\VSTSSnaps\7.02.01.00 SR3\ServiceStack.Text.dll d42a861b-4ec5-4c19-bbce-a05762455d6c ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll 0811a6ef-ae4b-484e-8a8a-0db7b3c9bc61 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win\8.35.20151.0__327c3516b1b18457\FarPoint.Win.dll 5b463e57-dc6c-4aef-b4f2-cad348a3a386 CrystalDecisions.ReportAppServer.ReportDefModel, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ReportDefModel.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ReportDefModel\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll b4640ee8-e539-407f-9d49-b08e80e9d63d ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll D:\VSTSSnaps\7.02.01.00 SR3\ServiceStack.Interfaces.dll 9e884b1f-5667-4ad5-bce6-8f0598f5852d ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll D:\VSTSSnaps\7.02.01.00 SR3\ServiceStack.Server.dll 49a3df07-b839-430a-a5b9-ce2ad2fc0a27 ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll D:\VSTSSnaps\7.02.01.00 SR3\ServiceStack.OrmLite.dll afb101a7-be87-4375-a306-762f9df4b3e2 JiwaJournalSetsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaJournalSetsUI.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaJournalSetsUI.dll f3096a9a-20c7-40af-9a1c-dce9c52da438 JiwaJournalSets, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaJournalSets.dll D:\VSTSSnaps\7.02.01.00 SR3\JiwaJournalSets.dll 8f2a16e9-73bb-4217-bf56-63b9e1fc1026 BB6E534C-73E3-4706-851D-80FA3661375C 1 Default Plugin Document Type true Sample.csv Sample CSV File 2020-04-21T09:18:01.907 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin