How to preform the auto extraction of the Excel file in Import Manager

[Former Member]

Hi Experts,

I was performing an automatic import using the Import Manager.

In the port, i defined the map name, file type and the automatic execution. But the import manager could not perform the mapping correctly after i putted the Excel file into the ready folder. And the error message in the exception log was "MS Excel is not supported on x64 platform." But when I imported the file in import manager manually, nothing wrong was happend duing this processing.

How could I perform a correctly mapping in the Import Manager.

[former_member189669 · Accepted solution]

Hi Wendrin,

This is a limitation . The MDIS on 64-bit Windows cannot import from Excel . However manual imports are supported (as this doesnt need MDIS).

XML is the best suited format for automating imports in MDM. Suggest you switch over to xml and setup auto import.

Regards,

Vinay M.S

[Former Member]

Hi,

64 bit doesn't support the excel import just try converting it into eithier .txt or xml to import the same from MDIS. Manual import of excel is supported.

Thanks

[Former Member]

Hello Wendrin Duan

You got that message because Import manager used your local pc landscape for import xls.files,

but import server worked at another landscape (AIX or Linux not Windows)

You can change your source files format to xml or txt ( it is work anywhere)

Regards

Kanstantsin