on 10-08-2007 11:23 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The version of DTW that you are working on (2005.0.11) has a bug and I have also faced an issue with import of BP master with that version. I would advise upgrading to DTW version 2005.0.17 (available with SBO 2005A SP01 PL29) and that should take care of your issue.
Also, make sure that the values entered in Recordkey column of the template are 1, 2, 3.....1281.
Regards,
Gyanesh
When loading SalesOpportunities with DTW we get following error:
<Errorlist><Error>System Id=31478720,Line Number=1,Column Number=79,Description=The Namespace of element schema must be from the schema namespace</Error><Error>System id=314787820,Line Number=1,Colum Number=99, Description=The numspac
Who has a solution?
DTW version: 2005.0.17
API Version: 6.80.320
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I have replicated your problem and successfully got the error message. I try to delete cardcode in business partner template in the first - third record key and then import. The result is the error that is as same as you are currently facing.
I guess some cardcodes are not defined in the business partners template and seems unseen because is not in the 1st - 10th record keys, maybe in the 20th record keys or above. Try to check it.
Rgds,
Hello,
As far as I know, the record key can't contain A, B, C ...Z, but you must write 1, 2, 3, 4, ..until reach BP data total amount. So, replace the current record key if your record key begin from X000001, replace it to be 1, 2, 3...1281. If you have tried with that, I guess there is a problem in your cardcode there is possibility a record key but no cardcode and it made the error message will appears.
Rgds,
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.