topic CSV.file upload in Application Development and Automation Discussions

CSV.file upload

Former Member — Thu, 29 Nov 2012 07:22:29 GMT

Actually I am using GUI_upload but as i know this is for fronted loading.I want to create one ABAP upload program to read Csv.file and then store the data in custom table . The ABAP program will be scheduled as batch program to run periodically to upload the csv.file and store the data in our custom table.

the path can be saved as program variant

Moderator message: very frequently discussed, please search for information before posting.

Message was edited by: Thomas Zloch

Re: CSV.file upload

Former Member — Thu, 29 Nov 2012 07:47:28 GMT

Hi,

Ok, what is the question? Upload in background processing works only via dataset statement. I'm not sure whether csv format is suitable for that. Check it out!

Regards

Robert

Re: CSV.file upload

Former Member — Thu, 29 Nov 2012 08:37:29 GMT

Hi,

I have to write a pgm to upload a csv file and then store data from csv to our custom table.

This ABAP program will be scheduled as batch program to run periodically to upload the csv.file and store the data in our custom table.

Re: CSV.file upload

Former Member — Thu, 29 Nov 2012 08:38:33 GMT

Thanks robert for your response!!

Rgards,

Prashant

Re: CSV.file upload

SujeetMishra — Thu, 29 Nov 2012 09:03:53 GMT

Prashant,

It means you have to perform two task in program.

1. upload the *.CSV :

OPEN DATASET lv_filename

FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc = 0.

* Write file records into file on application server

LOOP AT gt_datatab INTO gs_datatab.

TRANSFER gs_datatab TO lv_filename.

ENDLOOP.

CLOSE DATASET lv_filename.

and 2. update the Ztable.:

create one internal table with all the fields which you have to update in ztable.

transfer the value into work area and then update the table.

Regards,

Sujeet