topic Re: DBF Upload in Application Development and Automation Discussions

DBF Upload

Former Member — Mon, 12 Jun 2006 08:28:03 GMT

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?

Re: DBF Upload

Former Member — Mon, 12 Jun 2006 08:30:49 GMT

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.

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.

Re: DBF Upload

Former Member — Mon, 12 Jun 2006 08:40:30 GMT

Stuart,

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

Re: DBF Upload

Former Member — Mon, 12 Jun 2006 08:54:57 GMT

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.

Re: DBF Upload

Former Member — Mon, 12 Jun 2006 09:40:59 GMT

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.

Re: DBF Upload

Former Member — Fri, 14 Jul 2006 12:34:06 GMT

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

Re: DBF Upload

Former Member — Fri, 14 Jul 2006 12:38:39 GMT

That would be great!

Re: DBF Upload

Former Member — Fri, 14 Jul 2006 14:51:35 GMT

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

Re: DBF Upload

Former Member — Mon, 17 Jul 2006 07:18:29 GMT

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

Thanks again.

Re: DBF Upload

Former Member — Wed, 23 Aug 2006 07:16:43 GMT

Hi Stuart,

did you succeed ???

Can you please send me the code.

My email-adress is on my business card.

Re: DBF Upload

Former Member — Wed, 08 Nov 2006 21:55:56 GMT

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

Re: DBF Upload

Former Member — Wed, 08 Nov 2006 22:05:07 GMT

done. you're welcome.

Re: DBF Upload

Former Member — Wed, 08 Nov 2006 22:06:01 GMT

Hi Stuart,

did you succeed ???

Can you please send me the code.

Re: DBF Upload

Former Member — Wed, 21 Mar 2007 13:53:19 GMT

Hi Stuart,

did you succeed ???

Can you please send me the code.

Re: DBF Upload

Former Member — Wed, 27 Oct 2010 10:01:08 GMT

Hi Florin,

can u send me the code too?

Thank you.