Skip to Content
author's profile photo Former Member
Former Member

Data Format

What is the most efficient format for source data when using Import Manager? What decides the format efficiency of the data to be imported?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Dec 03, 2007 at 06:44 AM

    Heii Krutarth,

    The efficient formats for massive upload are Microsoft Excel and Access, with no differences in performance. As Excel has limitations related to maximum number of records a single spreadsheet can hold, Access is the recommended option.

    And you find more with this.

    <xml.coverpages.org/sapXML9809.html >

    <www.sapnetweavermagazine.com/archive/Volume_03_(2007)/Issue_02_(Spring)/v3i2a12.cfm?session=>

    Deepak

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 10:05 AM

    Hi Krutarth,

    In addition to Simonas answer i would like to add that if you are using remote systems then you cant use excel because excel is a read only file in MDM and it doesnt allows you to do any modificications like clonning the field.

    In SP05 in remote systems you can use xml format only for manual processing and not for automatic processing. For that you have to give xml schmea as your file type.

    Regards

    Dilmit Chadha

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2007 at 07:03 AM

    Krutarth,

    You may foind this useful.

    As Per the requirment You have to Chosse the source Data with respect to it's

    flexibility.

    Deepak

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 07:12 AM

    Hi Krutarth,

    The use of the right data format basically depends on the sytem you are trying to integrate.

    MDM supports different formats such as excel,access,xml,flat,delimilted text etc.

    Now depending on the format the remote sytem is sending data to MDM or wishes to receive data from MDM we will hve to send data in the required format.

    Regards

    Simona

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.