topic Re: Bdc data upload in Application Development and Automation Discussions

Bdc data upload

Former Member — Tue, 10 Jul 2007 11:13:18 GMT

Hai all,

I want the claridfication abt this, ie for example, If the flatfile contains ten fields and their corresponding 10 records. In this the out 10 records, 5 of them have values for 8 fields and for the rest of the fields it have null values and the remaining five records have values for all the fields.

My problem is while uploading data through BDC for the records with values only for eight fields the system has taken the value from the adjacent field and make the value as wrong.

For the records with value for 10 fields it is uploading correctly.

Please help to clear this.

Thanks in advance,

S.Jenibalet.

Re: Bdc data upload

Simha_ — Tue, 10 Jul 2007 11:19:39 GMT

Hi,

The row that contains 8 fields...should be given a space i.e tab..

Then BDC will take it as the null value...

If not , then the wrong values will be uploaded..

Cheers,

Simha.

Re: Bdc data upload

Former Member — Tue, 10 Jul 2007 11:22:39 GMT

Thanks for ur response Eventhough I have seperate the field values by tab it is showing the same error

Re: Bdc data upload

Former Member — Tue, 10 Jul 2007 11:31:57 GMT

First put the data in an EXCEL file with all the fields

Leave space for the fields where there is no data

and save this EXCEL file as TAB delimited TEXT file

and upload it to internal table using GUI_UPLOAD

now process the BDC , it will update correctly

Check the data in the int table whether the data for the fields (no data is there) have been correctly uploaded or not.

<b>Reward points for useful Answers</b>

Regards

Anji