DBF Upload

[Former Member]

Hi all,

I need to upload a DBF (Fox Pro, DBase) file into an internal table within an ABAP program.

I have looked at the function module "GUI_UPLOAD", but I have 2 problems with it:

- I need it to work in background mode, on the application server

- It does not that the 'DBF' filetype option on our system.

Does anyone have an alternative?

[Former Member]

Hi stuart,

1. I need it to work in background mode, on the application server

Yes, it will not work.

(bcos it needs an active front-end)

So u will have to use OPEN DATASET, READ DATASET , CLOSE DATASET

commands for reading file from app server.

2.

It does not that the 'DBF' filetype option on our system

I think it would be quite difficult

for reading a BINARY DBF file

and making sense out of it.

*----

---

3. Your requirement can be stated in another way like this :

To upload .XLS file

from application server

in background mode

(This is pure .XLS file, not Tab delimited file)

4. While using OPEN DATASET,

we read the BINARY CONTENTS OF THE FILE,

which will not make any sense of the XLS format.

regards,

amit m.

[Former Member]

Stuart,

Can you use WS_UPLOAD(Desktop) or Use OPEN DATA SET (from Application Server)

[Former Member]

WS_UPLOAD, afaik is just an older version of GUI_UPLOAD.

OPEN DATASET only works with plain text files. I guess the only alternative is to have an intermediate step - convert the dbf to, say, cvs then import it into SAP using OPEN DATASET.

[Former Member]

Hi again,

1. Yes u are right.

2. Thats the only best possible and practical approach.

3. Convert the DBF file into text/csv file,

and then upload using OPEN DATASET.

regards,

amit m.

[Former Member]

Hello Stuart,

I have programmed a DBase file importer that extracts the file definition and moves each corresponding table field dynamically into a predefined internal table according to it's structure (inclusive data conversion for the most well-known fields: char, numeric, date)

If you're interested I could mail you the coding.

Best wishes,

Florin

[Former Member]

That would be great!

[Former Member]

you don't have an email adress maintained in your user's business card.

would you please provide one in your b-card or send one to me?

Best regards,

Florin

[Former Member]

You should be able to view my email address on my BC now.

Thanks again.

[Former Member]

Hi Stuart,

did you succeed ???

Can you please send me the code.

My email-adress is on my business card.

[Former Member]

Hi, Can you send the source to me too?.

[Former Member]

done. you're welcome.

[Former Member]

Hi Stuart,

did you succeed ???

Can you please send me the code.

[Former Member]

Hi Stuart,

did you succeed ???

Can you please send me the code.

[Former Member]

Hi Florin,

can u send me the code too?

Thank you.

LB