Auto Import Process Not Working Correctly.

[Former Member]

HI All,

I am Trying to set-up auto import process for SAP MDM 7.1. I have completed the following activity and still i am not able to get the process right, Can any one suggest where am i missing ?

1) I have Created the Remote System With Type Inbound

2) I have Created Port with Type Inbound and attached the Remote System and Import Map to this Port. Processing type is Automatic, Block on Structural Exceptions has value set to "NO" and in staus i have value as HAS DATA. Fomat selected in this port is Excel.

Repository is Up and Running, file is already present in MDM Inbound Folder of this particular Port.

I have manually changed the Username and Password in MDIS under this particular reposity as

Username = Praful

Password - Admin

Above Password is used for logging into repository and so it matches

MDS, MDIS and MDSS are up and running.

The type of file i am trying to import is excel.

Can any one telll me if i have missed any step and if not then what may be the reason that i am not able to start the auto import process.

Thanks for your help and support.

Points would be awarded.

Regards

Praful Kulkarni

[Former Member]

irrespective of the support for excel ...

the password is not encripted for username Praful ... make sure you change it in the way SAP recommends - so that you see it in the same way as for the above username in mds

also its best practice to block port on str exception

thanks

-Adrivit

[Former Member]

Hello Praful Kulkarni

If your user pass is correct and your user has permission for import data.

In automatic mode your mdis periodically check your inbound directory and if it is not empty start import process.

Time interval for checking you can set in mdis.ini

"Interval" varuable.

Regards

Kanstantsin Chernichenka

[former_member182007]

This message was moderated.

[Former Member]

Hi Deepak,

Please find attached copy of my mdis.ini file

[GLOBAL]

Version=5540

Server=WS8EER2

Interval=10

Verbose=0x0000

MapScanTopToBottom=False

-- Verbose OFF: 0x0000

-- Verbose ON: 0xFFFF

-- FI Verbose: 0x0001

-- XML Verbose: 0x0002

-- MAP Verbose: 0x0004

-- THRD Verbose: 0x0008

-- PARSER Verbose: 0x0010

-- STRUCTX Verbose: 0x0020

-- VALUEX Verbose: 0x0040

-- IMPORTX Verbose: 0x0080

-- CHUNK Verbose: 0x0100

-- VxR Verbose: 0x0200

String Resource Dir=C:\usr\sap\MDM\MDIS01\exe\LangStrings\

Log Dir=C:\usr\sap\MDM\MDIS01\log

Wily Instrumentation=False

Wily Instrumentation Level Threshold=10

SLD Registration=True

Tracing Level=3

LogViewer Format Logging=False

LogViewer Format Tracing=False

[Product_MasterWS8EER2\BI_MSSQL2K8MSQL_14_19_4_3]

Login=Admin

PasswordE=KA9FPAOJG0BK7

[Customer DetailsWS8EER2\BI_MSSQL2K8MSQL_16_19_4_3]

Login=Praful

PasswordE=Admin

Chunk Size=50000

No. Of Chunks Proccessed In Parallel=5

also the error i found in Error log is

2011-03-03T10:29:29.506 8772 23 Returning from a function on encountering error: 0xFFAA0200

2011-03-03T10:29:29.506 8772 14 CatMgrClientWorker_Login: Unspecified Exit Point

2011-03-03T10:29:29.506 8772 23 Going to on encountering error: 0xFFAA0200

2011-03-03T10:29:29.506 8772 25 "[MDS=WS8EER2 Repository=Customer Details]: CatMgrClientWorker.Connect() failed. RC: 0xffaa0200 Invalid logon credentials

"

I have admin rights on this repository.

thanks anb Regards

Praful.

[former_member218126]

Hi Praful,

PasswordE for user id-Praful is not encrypted which is reason of import failure.Change your password again and make sure it should be encrypted in MDIS ini file.

Secondly, This is excerpt from reference guide so i don't think MDIS would support excel source file.

"To import data from Access or Excel source files, you must

use Import Manager instead of MDIS, or else convert the files to XML

or text (delimited or fixed width) formats. "

Regards,

Vineet

[rajesh_chavan]

I doubt if MDM suppport auto import for excel. Please let me know the update. If yes then it is learning for me

Cheers,

Rc

[Former Member]

Hi Rajesh

Yes, MDM support auto import from excel.

Vassoler

[Former Member]

Hi Vassalor,

Can you please tell me how Auto Import Process works for Excel, is it same like others or is there any other way for this also pleae let me know if i am not following any process.

thanks in advance for your help and support.

Regards

Praful.

[Former Member]

Hi Praful

The Auto Import Process from Excel is very similar with other Auto Import Process of XML type.

Follow this steps:

1 - With your Excel file, create a new map in MDM Import Manager;

2 - Save the map;

3 - Open your MDM Console, select the correct repository, go to Admin area and select "Ports";

4 - Create a new port, with this characteristics:

Name: <Chose a name>

Code: <Chose a code. This code is used to create directory structure>

Type: Inbound

Remote System: <select the remote system when you create your map>

Map: <select your map>

Format: Excel

Processing Type: Automatic

5 - Put one file into Ready folder and check if process is ok

Regards

Vassoler.

[cweissheimer]

Your problem is that you have set your password manually in the mdis.ini file, in the passwordE parameter.

That parameter is reserved for storing the encrypted password set in the client application.

So delete the passwordE parameter line, and set your password correctly in MDM Console, restart the server, and the automatic import should work.

[Former Member]

Hi Experts,

I have followed everything mentioned above still it is not working can anyone of you please tell me if i have missed any small settings because of which i am unable to automate the import process ?

your help would be highly appriciated.

Thanks and Regards

Praful

[former_member208981]

Hi Praful,

SAP MDM 7.1 version onwards, Automatic import of Excel format is not supported.

Please refer Console reference guide, Page 250:

To import data from Access or Excel source files, you must use Import Manager instead of MDIS, or else convert the files to XML or text (delimited or fixed width) formats.

Thanks,

Priti

[rajesh_chavan]

Thanks for confirming Priti.