Forum Discussion

JMP_MT's avatar
JMP_MT
Cover User
4 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
    4 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

Replies have been turned off for this discussion
  • JMP_MT's avatar
    JMP_MT
    Cover User
    4 years ago

    thank you for your help, the issue has been resolved 

  • gavin12345's avatar
    gavin12345
    Ultimate User
    4 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

  • Maddie_G's avatar
    Maddie_G
    Former Staff
    4 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
    4 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

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

     

  • AWPGB's avatar
    AWPGB
    Cover User
    4 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

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.