import manager getting closed while importing

[Former Member]

when i am trying to import the excel sheet thru import manager,the import manager is getting closed in the step while it is getting "prepared for importing the records."

Can someone tell me why it is so.

[Former Member · Accepted solution]

Hi Shifali

some check points to be followed:

1. After connecting to the excel file see in the source preview for blank rows and columns. If existing delete all such empty rows and connect to the file again.

2. If data is in multiple sheets are you using for field for joining the sheets? please ensure that there is atleast 1 field used for joining the sheets.

3. How big is the excel file? Try to import the records in chunks that is split the excel file to contain only say 10k records and connect to smaller files and see if import manager is working fine.

best regards

Ravi

[former_member616070]

HI Shifali,

Try the options mentioned by the members and if the problem still persists, try restarting the MDM Import Server(MDIS).

Thanks,

SA

[Former Member]

You can also try importing from some other machine with good configuration. This can also happen due to lack of RAM space on your machine.