Forum Discussion

JMP_MT's avatar
JMP_MT
Cover User
3 years ago
Solved

Import error: import file not loaded

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 ...
  • Maddie_G's avatar
    Maddie_G
    3 years ago

    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) .txt

    Then 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,

    Maddie
    MYOB Team

gavin12345's avatar
gavin12345
Ultimate User

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

JMP_MT's avatar
JMP_MT
Cover User
3 years ago

AccountRight Application Error Report
=====================================
Application Version: 2021.7.24.5180
Application File Version: 2021.7.24.5184
Incident Id: c9f2b1e9-d098-49c2-bc66-ae5c324124cb
Time: 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: length
at mscorlib!0x060004df!System.String.Substring(Int32 startIndex, Int32 length) +0x6f
at 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) +0xbf
at Huxley.ApplicationServices!0x06000523!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportData.GetNextRecord() +0x32
at Huxley.ApplicationServices!0x06000524!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportData.GetNextRecords() +0x6
at Huxley.ApplicationServices!0x060004d6!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportHelperService.GetFileHeaders(Stream stream, ImportExportFormat format, ImportExportFirstLine firstLine) +0xc
at Huxley.ApplicationServices!0x060004d5!MYOB.Huxley.ApplicationServices.ImportExport.Import.ImportHelperService.GetFileHeaders(String filename, ImportExportFormat format, ImportExportFirstLine firstLine) +0x9
at Huxley.UI.Controllers!0x060024ed!MYOB.Huxley.UI.Controllers.ImportExport.ImportExportController.GetImportFileHeaders() +0x4a
at Huxley.UI.Forms!0x06001764!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportEntityMapFields.RefreshContainer() +0x8e
at Huxley.UI.Forms!0x06002760!MYOB.Huxley.UI.Forms.BaseForms.BaseViewWizard.RefreshContainer() +0x261
at Huxley.UI.Forms!0x06001791!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportExportWizard.RefreshContainer() +0x0
at Huxley.UI.Forms!0x0600276a!MYOB.Huxley.UI.Forms.BaseForms.BaseViewWizard.tabWizard_SelectedPageChanged(Object sender, TabPageChangedEventArgs e) +0x8d
at 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) +0x19
at DevExpress.XtraEditors.v17.1!0x06002799!DevExpress.XtraTab.XtraTabControl.OnSelectedPageChanged(Object sender, ViewInfoTabPageChangedEventArgs e) +0xc8
at DevExpress.XtraEditors.v17.1!0x06004e4c!DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.OnSelectedPageChanged(IXtraTabPage prevPage) +0x20
at DevExpress.XtraEditors.v17.1!0x06004e47!DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.set_SelectedTabPage(IXtraTabPage value) +0x5e
at DevExpress.XtraEditors.v17.1!0x06004e45!DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.set_SelectedTabPageIndex(Int32 value) +0x2d
at DevExpress.XtraEditors.v17.1!0x060027fd!DevExpress.XtraTab.XtraTabControl.set_SelectedTabPageIndex(Int32 value) +0x0
at Huxley.UI.Forms!0x06002766!MYOB.Huxley.UI.Forms.BaseForms.BaseViewWizard.OnCustomRight1Clicked(ButtonClickedArgs args) +0x190
at Huxley.UI.Forms!0x06001794!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportExportWizard.OnCustomRight1Clicked(ButtonClickedArgs args) +0x58f
at Huxley.UI.Forms!0x060023f6!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.CallButtonClicked(Action`1 execute, ButtonClickedArgs args, String buttonText) +0x12
at Huxley.UI.Forms!0x06002372!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.btnCustom1_Click(Object sender, EventArgs e) +0x30
at System.Windows.Forms!0x06000e16!System.Windows.Forms.Control.OnClick(EventArgs e) +0x19
at DevExpress.XtraEditors.v17.1!0x06000d4f!DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e) +0x2e
at DevExpress.XtraEditors.v17.1!0x06000d48!DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e) +0x1d
at System.Windows.Forms!0x06000efd!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0x184
at System.Windows.Forms!0x06000f0d!System.Windows.Forms.Control.WndProc(Message& m) +0x62c
at DevExpress.Utils.v17.1!0x06002708!DevExpress.Utils.Controls.ControlBase.WndProc(Message& m) +0x2e
at DevExpress.XtraEditors.v17.1!0x06000256!DevExpress.XtraEditors.BaseControl.WndProc(Message& msg) +0x0
at System.Windows.Forms!0x0600571b!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0
at System.Windows.Forms!0x0600571e!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) +0x8e
at 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:1
MODULE: DevExpress.XtraEditors.v17.1 => DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1
MODULE: Huxley.ApplicationServices => Huxley.ApplicationServices, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:663455b3be59482980870b4270c0758a; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:23470bf464064a7a8fb00fa049b1bbf5; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2021.7.24.5180, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:de1928e734314460a5ab7b2fe0b5d51e; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:4f7b64af12624780a21b88bb3460cac5; A:2
MODULE: 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: length
at mscorlib!0x060004df!System.String.Substring(Int32 startIndex, Int32 length) +0x6f
at 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:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:4f7b64af12624780a21b88bb3460cac5; A:2

----------------------------------------

 

  • Maddie_G's avatar
    Maddie_G
    Former Staff
    3 years ago

    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) .txt

    Then 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,

    Maddie
    MYOB Team

    • JMP_MT's avatar
      JMP_MT
      Cover User
      3 years ago

      thank you for your help, the issue has been resolved 

      • Maddie_G's avatar
        Maddie_G
        Former Staff
        3 years ago

        That's great to hear JMP_MT thank you for letting me know!


  • AWPGB's avatar
    AWPGB
    Cover User
    3 years ago

    I am getting the same error - it Started last Thursday morning. Later in the day it worked but doesnt work again this morning