topic Re: BDC session in Application Development and Automation Discussions

BDC session

Former Member — Fri, 29 Jun 2007 01:49:03 GMT

I have a problem relating BDC download.

First I have a file in .txt (with pipes in between the fields) format and wen I uploaded it in Call Transaction, the errors which i asked to download back is in .txt format with space (with space in between the field. Now wen iam trying to upload the error file using BDC session method to correct them foreground!!! in SM35, the records with correct fields are not loading in correct way as there is a change of positions in the FLAT FILE. Can anyone help me out for downloading the errors in the same format so that i can upload the errors in session and then work foreground for the filed values missing. If any code is required plzz help me in this regard. Thanks heaps

Re: BDC session

Former Member — Fri, 29 Jun 2007 01:53:51 GMT

Hi Mukunda,

Why can't you change your file separator for download from SPACE to PIPE.

Regards,

Atish

Re: BDC session

Former Member — Fri, 29 Jun 2007 04:50:43 GMT

Hi Mukunda,

The problem you are getting is obviously because of pipes you are using as separator when uploading and space during downloading.

1. This problem can be solved by using the same separator while uploading and downloading both.

2. Just program it in a way that you dont depend upon the separator as such.

I mean.

a) declare an internal table with just one field text(255) and upload it without separator.

b) Now loop at this table translate pipe into space.

c) split each record into filds at space

d) Now update the record as usual.

This way it works for every thing.

Hope this answers your curiosity.

Award points if useful or get back.

Aleem.

Re: BDC session

Former Member — Fri, 29 Jun 2007 14:19:47 GMT

how can we download it with pipes... please send me if there is any code for it thanks heaps

Re: BDC session

Former Member — Fri, 29 Jun 2007 14:20:52 GMT

can you send me some example like a small code where i can upload and download in the same format either in space or pipes. Thanks heaps