I'm setting up a file & imported the card files from the previous file no problem. now trying to import the supplier files and get the 'somethings gone wrong' message - I believe this is because the import file will not load, I've tried restarting myob redoing the export file but keep getting the same problem. any ideas? thanks
Hi @JMP_MT @AWPGB,I have seen this issue with another customer who was importing a .csv file. Firstly, could you please clear your AccountRight cache which you can find the steps from our post here.
Then if you can try importing again, if you still get the same error can you try importing the file as a .txt (tab-delimited) instead, please. You can do this by opening the file in Excel then going to the File Menu and into Save As, from there click on Browse and change the Save As type to Text (Tab Delimited) .txtThen can you try importing the file again into AccountRight as that should no longer produce the error you are getting. Just make sure you change the Import Format in Step Three to Tab instead of Commas:Cheers,MaddieMYOB Team
AccountRight Application Error Report=====================================Application Version: 2021.7.24.5180Application File Version: 2021.7.24.5184Incident Id: c9f2b1e9-d098-49c2-bc66-ae5c324124cbTime: Friday, 10 December 2021 9:44:34 AM
Code:Unknown (0)
Message:(Unknown):
Stack Trace----------------------------------------1 : MYOB.Huxley.API.HuxleyApplicationException----------------------------------------MYOB.Huxley.API.HuxleyApplicationException: (Unknown): ---> System.ArgumentOutOfRangeException: Length cannot be less than zero.Parameter name: lengthat mscorlib!0x060004df!System.String.Substring(Int32 startIndex, Int32 length) +0x6fat Huxley.ApplicationServices!0x06000362!MYOB.Huxley.ApplicationServices.ImportExport.CSVFormatProvider.DecodeLine(String line) +0x45--- End of inner exception stack trace ---at Huxley.ApplicationServices!0x06000362!MYOB.Huxley.ApplicationServices.ImportExport.CSVFormatProvider.DecodeLine(String line) +0xbfat Huxley.ApplicationServices!0x06000523!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportData.GetNextRecord() +0x32at Huxley.ApplicationServices!0x06000524!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportData.GetNextRecords() +0x6at Huxley.ApplicationServices!0x060004d6!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportHelperService.GetFileHeaders(Stream stream, ImportExportFormat format, ImportExportFirstLine firstLine) +0xcat Huxley.ApplicationServices!0x060004d5!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportHelperService.GetFileHeaders(String filename, ImportExportFormat format, ImportExportFirstLine firstLine) +0x9at Huxley.UI.Controllers!0x060024ed!MYOB.Huxley.UI.Controllers.ImportExport.ImportExportController.GetImportFileHeaders() +0x4aat Huxley.UI.Forms!0x06001764!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportEntityMapFields.RefreshContainer() +0x8eat Huxley.UI.Forms!0x06002760!MYOB.Huxley.UI.Forms.BaseForms.BaseViewWizard.RefreshContainer() +0x261at Huxley.UI.Forms!0x06001791!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportExportWizard.RefreshContainer() +0x0at Huxley.UI.Forms!0x0600276a!MYOB.Huxley.UI.Forms.BaseForms.BaseViewWizard.tabWizard_SelectedPageChanged(Object sender, TabPageChangedEventArgs e) +0x8dat DevExpress.XtraEditors.v17.1!0x06008726!DevExpress.XtraTab.TabPageChangedEventHandler.Invoke(Object sender, TabPageChangedEventArgs e)at DevExpress.XtraEditors.v17.1!0x06002791!DevExpress.XtraTab.XtraTabControl.RaiseSelectedPageChanged(TabPageChangedEventArgs e) +0x19at DevExpress.XtraEditors.v17.1!0x06002799!DevExpress.XtraTab.XtraTabControl.OnSelectedPageChanged(Object sender, ViewInfoTabPageChangedEventArgs e) +0xc8at DevExpress.XtraEditors.v17.1!0x06004e4c!DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.OnSelectedPageChanged(IXtraTabPage prevPage) +0x20at DevExpress.XtraEditors.v17.1!0x06004e47!DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.set_SelectedTabPage(IXtraTabPage value) +0x5eat DevExpress.XtraEditors.v17.1!0x06004e45!DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.set_SelectedTabPageIndex(Int32 value) +0x2dat DevExpress.XtraEditors.v17.1!0x060027fd!DevExpress.XtraTab.XtraTabControl.set_SelectedTabPageIndex(Int32 value) +0x0at Huxley.UI.Forms!0x06002766!MYOB.Huxley.UI.Forms.BaseForms.BaseViewWizard.OnCustomRight1Clicked(ButtonClickedArgs args) +0x190at Huxley.UI.Forms!0x06001794!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportExportWizard.OnCustomRight1Clicked(ButtonClickedArgs args) +0x58fat Huxley.UI.Forms!0x060023f6!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.CallButtonClicked(Action`1 execute, ButtonClickedArgs args, String buttonText) +0x12at Huxley.UI.Forms!0x06002372!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.btnCustom1_Click(Object sender, EventArgs e) +0x30at System.Windows.Forms!0x06000e16!System.Windows.Forms.Control.OnClick(EventArgs e) +0x19at DevExpress.XtraEditors.v17.1!0x06000d4f!DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e) +0x2eat DevExpress.XtraEditors.v17.1!0x06000d48!DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e) +0x1dat System.Windows.Forms!0x06000efd!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0x184at System.Windows.Forms!0x06000f0d!System.Windows.Forms.Control.WndProc(Message& m) +0x62cat DevExpress.Utils.v17.1!0x06002708!DevExpress.Utils.Controls.ControlBase.WndProc(Message& m) +0x2eat DevExpress.XtraEditors.v17.1!0x06000256!DevExpress.XtraEditors.BaseControl.WndProc(Message& msg) +0x0at System.Windows.Forms!0x0600571b!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0at System.Windows.Forms!0x0600571e!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) +0x8eat System.Windows.Forms!0x06002deb!System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) +0x25==========MODULE: DevExpress.Utils.v17.1 => DevExpress.Utils.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:b8c34c059b804930811d5f6d50999b6c; A:1MODULE: DevExpress.XtraEditors.v17.1 => DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1MODULE: Huxley.ApplicationServices => Huxley.ApplicationServices, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:663455b3be59482980870b4270c0758a; A:1MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:23470bf464064a7a8fb00fa049b1bbf5; A:1MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:de1928e734314460a5ab7b2fe0b5d51e; A:1MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:4f7b64af12624780a21b88bb3460cac5; A:2MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:c643f8c6b47f4807860bf3c099806bf8; A:1
----------------------------------------
2 : System.ArgumentOutOfRangeException----------------------------------------System.ArgumentOutOfRangeException: Length cannot be less than zero.Parameter name: lengthat mscorlib!0x060004df!System.String.Substring(Int32 startIndex, Int32 length) +0x6fat Huxley.ApplicationServices!0x06000362!MYOB.Huxley.ApplicationServices.ImportExport.CSVFormatProvider.DecodeLine(String line) +0x45==========MODULE: Huxley.ApplicationServices => Huxley.ApplicationServices, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:663455b3be59482980870b4270c0758a; A:1MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:4f7b64af12624780a21b88bb3460cac5; A:2
Hi @JMP_MT
Click the 'View Error Details' link and copy and paste contents into the post or attach as a link. Ensure the import file isn't open in notepad or excel, etc.
Regards
Gavin
Self-help & Learning
Level up your skills and find answers across all MYOB products
Help Guides
MYOB Academy