MDM Import Manager Batch

[Former Member]

Hi everyone,

We are using the MDM Import Manager Batch to import data automatically. Can we write in our ImportBatch.ini the file name with * at the end : CREMDM.CREMDM04*.xml

because the file name comes with time stamp (CREMDM.CREMDM0420061129-103959-602.xml)

[Source]

Type=XML Schema

XML Schema=CREMDM04

File name= \...\... CREMDM.CREMDM04*.xml

DSN=

DBMS Server=

Database=

User=admin

In advance thanks,

Aklilu

[Former Member · Accepted solution]

Hi,

This is not possible. Even if you add the name with *, this will not work the way you are expecting it to work. Have you explored the possibility of using Import Server for this. In case of Import Server, irrespective of the file name, once the file is placed in the appropriate folder, import happens automatically.

Rajani

[Former Member · Accepted solution]

Hi Rajani,

Thank you for your very helpful answer, in our scenario CREMDM arrives always in the same folder from XI. The time stamp is the only way to distinguish among xml files. What do you advice?

Regards,

Aklilu

[Former Member · Accepted solution]

Hi,

Below are couple of thoughts from my side. However, there may be better alternatives...

Import Server Scenario:

How about using OS level commands to move this file to the appropriate folder suitable for Import Server.

Impart Manager Batch Scenario:

In your .ini file maintain a specifc name for file and whenever you recieve the file from XI, rename it as soon as you recieve using OS level commands before triggering Import Manager Batch commands.

Rajani

[Former Member · Accepted solution]

Thanks,

Aklilu

[michael_theis · Accepted solution]

Hi,

> Import Server Scenario:

> How about using OS level commands to move this file

> to the appropriate folder suitable for Import

> Server.

Instead of this you could change the XI configuration in a way that XI puts the file directly into the corresponding Port Folder. With a running Import Manager Server this scenario enable a fully automated data load into MDM - and it works fine in our local test landscape

Kind regards

Michael

[Former Member · Accepted solution]

Hi Michael,

Thanks for your answer. Actually We are trying to parameter the mdis.ini and until now it does not work. We put directlly the xml file in the folder ready with interval 1 sec. Concerning the folder it is possible to change it in XI but still the xml files names contain the time stamp.

Regards,

Aklilu

[michael_theis · Accepted solution]

Hi Aklilu,

the names of the XML files don't matter. MDIS tries to process everthing that is put into the ready folder. The ready folder is processed in a "first comes, first served" way. So there's no need to change the names. Is the time stamp in the file name really a problem? If yes, why?

> We are trying to parameter the mdis.ini and until now it does not work.

Could you specify this? In addition, I've got a few hints:

MDIS has to have the same build version as the MDM Server. In addition, MDIS has to be running (in Windows, you can check this in the Services Screen). Furthermore you should have a look at the Console's port definition (select your repository, go to Admin -> Ports in the menu tree). The port has to be configured correctly (XML Scheme, which map to be used, and so on). Very important: you have to set the port to automatic processing.

Here's a sample for the MDIS.ini:

[GLOBAL]
Version=5540
Server=WDFD00146633A
Interval=30
Automap Unmapped Value=True
Unmapped Value Handling=Add
Always Use Unmapped Value Handling=False
VXR_MAX=25000
Verbose=0xFFFF
-- 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
String Resource Dir=C:PROGRA~1SAPMDM~1.5IMPORT~2LangStrings
Log Dir=Logs
SLD Registration=False

[SP04_BUSINESS_PARTNERWDFD00143366AMSQL_21_13_4_3]
Login=Admin
Password=
Chunk Size=50000
No. Of Chunks Proccessed In Parallel=5

Using the Verbose parameter you can define which errors, issues, messages and so on should be written into the MDIS log. You can find the logs directly in the port's log folder and in the log folder of your MDIS installation directory. If MDIS is not working or the import fails, these files contain some helpful information.

Kind regards

Michael