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

DTW problem 2

Posted on Oct 08, 2007 at 10:23 AM 132 Views

Data Transfer Workbench - second problem:

After selecting my files (BusinessPartners and ContactEmployees) I arrive at step 3. Under tab [Map Rule] the columns ‘Source Fields’ and ‘Target Fields(B1)’ are equal. When I go to tab [Source Data] I see all data to import. But when I go to the tab [Target Data] I only see fields filled-in at BusinessPartners.txt (after waiting and unfolding). There are only two fields (MailAddress and MailCity). If I now go back to tab [Source Data] then the other data like ‘RecordKey’, ‘CardCode’, ‘Address’, ‘CardName’, ‘Cardtype’, etc. has disappeared!

When I go back to step 2 and select the files again the fields are there again. But as soon as I repeat the steps mentioned above the fields have disappeared again.

When I continue with step 4 and choose ‘Import New Object’ then I get following message in my logbook ‘Code undefined [OCRD.Cardcode]Application-defined or object-defined errorBusinessPartners’. The column [Key] is empty.

But DTW worked. I did put something in the database. However, the new files have a different ‘RecordKey’ and ‘CardCode’.

Does anyone have any idea what is happening?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Jimmy Michael
    Jimmy Michael
    Posted on Oct 08, 2007 at 11:28 AM
    0

    Hello,

    I suspect the cardcode can't be recorded caused by record key error or you have already imported the BP but not deleted it when trying to import again using the same template data. Just check : select * from OCRD and select * from CRD1 to see the data imported previously (if any).

    Rgds,

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2007 at 05:52 PM
    0

    Hello,

    Please give us the SBO Version and Patch level you are on.

    After you have selected the Business Partners and Contact Employee files what are you trying to do by going into the TARGET DATA tab.

    SBO automatically maps all the data if the column names from your Excel match SBO field name.

    Please try to Import Business Partners first and then import the Contact Persons along with just the CardCodes from the Business Partner file as an UPDATE.

    Thanks

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2007 at 05:00 AM
    0

    Hi,

    May I ask which version of DTW are you using? If you are using any version below 17, I'd advise you to upgrade to the latest version as the older versions have some issue or the other.

    Also, when you try to import the data, i am sure you have checked the values that have been entered in the template. So in that case, try continuing with all the steps of DTW without clicking on source data & target data tabs - I have faced a similar issue with DTW and after not touching these tabs the data has been imported successfully!! I know it is weird but that is how DTW is!!

    Regards,

    Gyanesh

    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.