Skip to Content

Error while importing excel sheet in Import manager

Hi All,

I am trying to import an excel file through Import Manager but after mapping and all done once i click on import button one pop-up window comes as "Error in opening file" and could not proceed there after.

This is happening in few PC's and other systems are working fine without error. Can anyone please let me know anything to be changed in settings?.

Thanks in advance

Regards,

Channa R

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 18, 2013 at 10:24 AM

    Hi Vamsi,

    Please compare excel options in both PC's. I think you need to make changes to excel file before importing it.

    Excel options-->Trust center->Trust center settings->Macro settings

    Please let us know more on what you find. We shall strive our best to overcome this.

    Regards,

    Ali

    Add comment
    10|10000 characters needed characters exceeded

    • Ravi Verma Channamallikarjunaiah R

      HiĀ  Channa,

      You can try the following -

      1.Save and close the excel once you have done the changes as mentioned above.

      2.Copy the content to another file and try to reconnect.

      3.Decrease the data volume and re try.

      Please reply with findings.

      Thanks,

      Ravi

  • avatar image
    Former Member
    Jul 19, 2013 at 10:56 AM

    Hello,

    Check the file name of the successful one and the error one.

    Also check the volume of data.

    Make sure the file is not open, while importing

    Thanks & regards,

    Abhishek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2013 at 08:54 AM

    Hi,

    Please refer the SAP Note 1736750 : "Ensure that the User running the Import Manager has Write permissions on the Import Manager folder or create a "Logs" folder within this folder and ensure write access to it"

    As per the note, when you import the file through Import Manager, the system writes the log under the Log folder of Import Manager in the respective system.

    Kindly get the write access for the folder C:/Program Files/SAP MDM 7.1/Import Manager and try again

    Regards,

    Antony

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 23, 2013 at 11:52 AM

    Hi Channa,

    Check the following

    1. Excel version is compatible with MDM Import Mrg version.

    2. compare the excel versions and also the extension of both the files that are successful and failed.

    update with your observations.

    regards,

    mohan

    Add comment
    10|10000 characters needed characters exceeded