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 import file will not load, I've tried restarting myob redoing the export file but keep getting the same problem. any ideas? thanks 

  • 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

6 Replies

Sort By
Replies have been turned off for this discussion
  • gavin12345's avatar
    gavin12345
    Ultimate User
    3 years ago

    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