on 01-08-2007 8:09 AM
What is the Procedure for loading Material master data from flat file to MDM Repository or Import Manager?
Hi Chiru,
In order to import flat files into MDM do the following. This solution is specific to MS Windows:
<b>I. Set up ODBC for *.txt or *.csv files</b>
1. Open Data Sources (ODBC) interface:
Start> Settings> Control Panel--> Administrative Tools -->Data Sources (ODBC).
2. Select System DSN Tab in Data Sources (ODBC) interface.
3. Click on [Add]. Select the Microsoft Text Driver. Click Finish.
4. Write a Data Source Name
5. Uncheck Use Current Directory to enable the [Select Directory ] button.
6. Click on [Select directory ] to determine the source directory.
7. Select the source file.
8. Click [OK] and return to the ODBC Text Setup screen.
9. Click [OK].
10. Return to the ODBC Data Source Administrator dialog and click [OK].
<b>II. Importing from Flat file</b>
1. Run MDM Import Manager.
2. Select ODBC from the Type drop-down field of the Connect To Source dialog.
3. Enter the DSN name from the Setup ODBC Connection dialog above.
4. Select the file name with extension (.csv or .txt) in the Tables panel of MDM Import Manager and the file content in the Records panel.
Hope this solved your problem.<b>Please mark helpful answers</b>
Regards,
Siddharth.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chiru,
For loading a flat file , after connecting to repository u have to select type as "odbc" and specify the DSN.I am assuming that you know how to create DSN and specify the correct folder containing ur source files.
Now select the required source file and destination table and perform the required field and value mapping. And then perform match record step and execute import.
Hope this will help you.Let me know the result.
Thanks,
<b>Shiv Prashant Dixit</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.