Skip to Content
0
Former Member
Jan 16, 2008 at 04:15 PM

Problem in the BDC program to upload the data from a flat file.

35 Views

Hi,

I am required to write a BDC program to upload the data from a flat file. The conditions are as mentioned below:-

1) Selection Screen will be prompted to user and user needs to provide:- File Path on presentation server (with F4 help for this obligatory parameter) and File Separator e.g. @,#,$,%,... etc(fields in the file will be separated by using this special character) or fields may be separated by tab(tab delimited).

2) Finally after the data is uploaded, following messages need to be displayed:-

a) Total Number of records successfully uploaded.

b) Session Name

c) Number of Sessions created.

Problem is when each record is fetched from flat file, the record needs to be split into individual fields separated by delimiter or in case tab separated, then proceeding in usual manner.

It would be great if you provide me either the logic, pseudocode, or sample code for this BDC program.

Thanks,