Several Maps

[Former Member]

I am using Import Server for a Batch input, I have several files and several maps.

Is there to a way to control the import into MDM , first the main table map needs to be executed and then the rest of the maps needs to be executed.

[Former Member · Accepted solution]

Hi ,

The best bet for you is to use the Import Manager Batch.

To run the Import Manager Batch , you don't neet the Import Server.

Command Syntax.

ImportManagerBatch /INI <configfile> /CLIENTSYSTEM <clientsystem> /MAP <mapname> /LANGUAGE <language>

.

.

.

.

.

You put all the command in the .bat file in what ever order you want and execute the .bat file.

To schedule timely import, use the OS scheduling task feature to schedule the .bat file to execute periodically.

Hope this helps.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Thank you Subbu,

However, I would like to use the Import Server because of the Ports concept.

[Former Member · Accepted solution]

Hi,

As you might be knowing each port is associated with one map.

As you said you have multiple maps. You need to create multiple ports to execute the imports.

When you have multiple maps and you want to execute them in a particular order using Ports concept. I have not seen an option/configuration in the Import server configuration file to specify the map order.

Even I have the same situation, and I am using Import Manager Batch.

I think even in your case you want to have the control over the map order. To my knowledge I don't think we have an option to control the map order in Import Server.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

If I created multiple ports for multiple maps, where do I specify them in the .ini file .

As far as I know I see in the .ini there is a map option and a port option where you enter the logical port(2045) and not the port you create for inbound and outbound unlike Import Server.

If its ImportServer it would automatically pull from the Ready folder.

[Former Member · Accepted solution]

Hi Bob,

What I am saying is when you have multiple maps, which needs to be executed using ports concept. You will not have control over the map order.

I had the same problem like you, that is why I am using the Import Manager Batch.

Hope I answered your question. Let me know if it is not clear.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Subbu,

I totally understand what you are trying to explain .

So that means if I use Import Batch then we don't have to create several inbound ports and have maps associated with them at all. Rather mention the maps in the order we require in the batch file which is executed.

Correct me if I am wrong.

[Former Member · Accepted solution]

Hi,

You are absolutely right!!!!!!!.

I am trying to figure out with the import server with the following scenarios.

I have multiple ports and each of the ready folders I will put the source file and see.

I will update the answer soon.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Subbu,

Just a curious question how will MDM understand where to look for maps , because in the Batch file I just enter the map name and not even the location where the maps resides.

[Former Member · Accepted solution]

Hi,

We use the Import Manager to develop the MAP and save it with some name. That MAP information is specific to

Client system you defined in the Repository

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Subbu,

I have the client and map name saved for the repository,

I have a batch file created containing

ImportManagerBatch /INI <ini> /CLIENTSYSTEM <Clientcode>

/MAP <MAPname> /LANGUAGE "English[US]"

And in the .ini file specified the TYPE, Filename,Repository,Port and the Server name.

Please advise if I have missed any step , because its not working.

Thanks & Regards

Bob.

[Former Member · Accepted solution]

Hi,

Did you fill out all the necessary inputs in the configuration file.

And one more thins, give the Client System name not the CODE.

Apart from the above I don't see any thing which you are missing

Let me know this time if it does not work.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Hi Bob,

Just an example for the configuration file.

[Source]
Type=Excel
File name=<Absolute path of the file name>
DSN=
DBMS Server=<DBMS Server Name/IP>
Database=
User=<username who has DBA rights>
Password=<password>
//possible values are: True or False
Read-only=False

[Destination]
Repository=<Repository Name>
Server=<MDM Server Name>
Port=<Port No for the Repository>
User=admin
Password=<Password>
Agency=<Client System Name>
Map=<Map Name>
Language=English [US]

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Subbu,

I have entered all the required details in the .ini file, still getting 'Cannot connect to server' error.

Tried giving the Server name as well as the IP address,getting an error message "Cannot Connect to Server' Connection failed " in the log .

[Former Member · Accepted solution]

Hi,

Could you paste the .ini file content here.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Subbu- I have pasted the ini file

[Source]

Type=EXCEL

File name=C:\Material.xls

DSN=

DBMS Server=

Database=

User=

Password=

//possible values are: True or False

Read-only=

[Destination]

Repository=MATERIAL_1

Server=10.12.22.221

Port=2400

User=admin

Password=

Agency=

Map=

Language=

[Batch Import Default Option]

//possible values are: Yes or No

Automap Batch Unmapped Value=Yes

//possible values are: Add or Ignore

Batch Unmapped Value Handling=Add

//possible values are: Yes or No

Always Use Batch Unmapped Value Handling=No

[Former Member · Accepted solution]

Bob,

Everything looks OK.... Can you also paste the exact commands that you are using for the Import Manager Batch??

Regards,

rajani Kumar

[Former Member · Accepted solution]

Hi BOB

You can try using silmilar command and probably it will work. It worked for me.

commands:

command line syntax

c:\...\import Manager Batch>ImportManagerBatch /INI ImportBatch.ini /CLIENTSYSTEM MDM /MAP Test_nalco /LANGUAGE "English [US]

Thanks

manik

[Former Member · Accepted solution]

Hi,

I am trying to use the same commands, dont understand why its not able to establish connection to server.

Does this ImportManagerBatch work across Platform,

like if you are trying to connect the MDM server on Unix box.

Regards,

Bob.

[Former Member · Accepted solution]

Hi Bob,

Could you please cross check the following parameters.

1. Source file location.

2. Port No.

3. Repository Name.

4. Repository Password.

5. Finally try pinging the MDM Server from the client systems command prompt.

Could you please paste the contents of the log file, which you can find under the Import Manager Batch insttalation directory.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Subbu,

I have ensured all those are right.

The Log says

2940 - Command line parsed

2940 - OLE and socket initialized

2940 - Login to 'TEST_SERVER:2400 : Login Error: no such user' Failed.

2940 - Import Manager Batch End.

Here 2400 is the port number of the repository

[Former Member · Accepted solution]

Bob,

Looks like the log clrearly says that the problem is with user name. Please make sure you are entering the user name properly including the case sensitivity.

Regards,

Rajani

[Former Member · Accepted solution]

Hi Bob,

Username and Password are case sensitive in the latest version of MDM SP3.

Probably username in the Repostory might be defined as

"Admin" and in your configuration file u mentioned it as "admin".

Try giving the case sensitive information and see.

Hope this helps.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Thanks you guys,

I gave everything within quotes(") and now having a different error "Cannot connect to server: '"TEST_SERVER"' failed

I did ping and there is connectivity to the server.

Am I missing something.

[Former Member · Accepted solution]

If the server name is not given within the quotes in the ini file then getting a different error message

'Login Error:Winsock error on connect' failed.

Inspite of repository happily running and loaded I get this error. Wierd !!

[Former Member · Accepted solution]

Hi Bob,

Try giving the IP address and the case sensitive login information.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

Thanks you all,

The commands I have given are pretty much the same you have suggested. There might be some connectivity issue from our side, I can check that.

Nevertheless, If we use ImportServer we donot have to specify the directory from which the data has to be picked up as of the Port Concept.

In ImportBatch how do we tell the ini file to a get all the input files from a directory ?? Because against FileName you just specify the name of the file.

[Former Member · Accepted solution]

Hi Bob,

I don't think there is an option in Import Manager Batch Scenario, where in you specify a directory and look for files in that directory.

As of now you have to give the absolute path of the exact source file name.

Thanks and Regards

Subbu

[Former Member · Accepted solution]

If say for eg, one would have many source files in a directory and would like to import all in a batch process, then we cannot specify the entire path of all the files in ini file right.

Correct me if my understanding is wrong.

Do we have to write some another embedded script for this.

[Former Member · Accepted solution]

Bob,

In this case, try to create multiple "ini" files and trigger the Import Manager Batch multiple times. Please note that even with Import Manager you can not input more than one file per map(except for the case where file type in Import Manager is "XML Schema").

In the case you mentioned, obviously you need to create multiple maps for each file (except for the case where file type in Import Manager is "XML Schema")and hence multiple "ini" files is the right approach.

Create a batch file with multiple Import Manager Batch triggering commands (one per file & map) if you want to trigger all the Import Manager commands in a sequence.

Regards,

Rajani Kumar

[Former Member · Accepted solution]

Hi Bob,

Scenario 1:

Let say if you have multiple source files and multiple maps (One to one relation, I mean each map is associated with one source file), then you can have that many .ini files and in the ImportManagerBatch command with option /INI you can specify the config file name and in each config file you will be specifying the source filename path.

Scenario 2:

If you have multiple source files and you are using single map to load the data.

[This scenario can occur, where you get source data from all your source systems in a specific XML format]

You can have one ini file in which

Source type as XML Schema and filename(s) seperated by comma.

[This is what i am guessing, but I have not tried this scenario with multiple source files in ImportManagerBatch.]

Because In ImportManager once you select XML Schema file as source file type, we can select multiple source file and it combines all the source files and populate the source hierarchy in the Import Manager.

I am not sure whether we can do with the other source file types or not ?.

Thanks and Regards

Subbu