topic Re: Exporting data from excel to database in Application Development and Automation Discussions

Exporting data from excel to database

Former Member — Wed, 24 Jul 2019 11:06:22 GMT

I want to export data from excel sheet into a database and display it in an ALV with an additional field which will show the status whether every entry is saved successfully or not.

Here, I have a field 'Id' which is a primary key. When I am copying data from excel into an internal table consisting of the same id then the values from excel are getting overwritten into the internal table.

Can somebody tell me how can I print a message in this 'Status' field to show if data is successfully saved or not without getting it overwritten into the database?

Re: Exporting data from excel to database

loyd_enochs3 — Wed, 24 Jul 2019 12:59:21 GMT

Data in the ALV will not be written to the database without explicit update logic. Changes made to the internal table that is used to display the ALV list will not change the database unless you write the procedure to update the database (Call Transaction, BAPI, IDoc, BusObject, etc).

"Viewer" is the key word in the name "ABAP List Viewer".

Re: Exporting data from excel to database

Sandra_Rossi — Wed, 24 Jul 2019 15:27:55 GMT

You are talking about memory and database operations, altogether mixed-up, that don't make sense to me. Can you elaborate? (and "separate the concerns" if possible)

Re: Exporting data from excel to database

Former Member — Thu, 25 Jul 2019 08:00:20 GMT

How can I validate duplicate records while exporting data from excel to the database and display a field in ALV which shows a status whether data is saved or not in the database?

Re: Exporting data from excel to database

Sandra_Rossi — Thu, 25 Jul 2019 08:27:18 GMT

"Elaborate" doesn't mean "give an abstract"... 🙂

Sorry, I really don't understand your question. Or your question is about a so-complex topic that nobody knows the answer.

Re: Exporting data from excel to database

SachinArtani — Thu, 25 Jul 2019 11:33:52 GMT

You can use one of those FM to take data from excel file into an internal table -

1. ALSM_EXCEL_TO_INTERNAL_TABLE

2. TEXT_CONVERT_XLS_TO_SAP

Then insert the data of internal table to database table by sorting the internal table, deleting adjacent records as per your condition using below syntax -

SORT itab BY <field1> <field2> <field3>.DELETE ADJANCEMENT DUPLICATES from itab COMPARING <field1> <field2> <field3>.

Now using simple insert syntax, enter data to database table and on success, popup a Message (Type 'I' showing that the records has been updated in db successfully) and show the ALV using that internal table.

Re: Exporting data from excel to database

rudramani — Fri, 26 Jul 2019 05:25:01 GMT

Can you check this article: https://gocoding.org/abap-excel-upload/
Here, the uploading excel is explained. What apart from the content mentioned here you want to know?

Re: Exporting data from excel to database

Former Member — Fri, 26 Jul 2019 06:11:36 GMT

here I am trying to display contents of excel sheet in an ALV with an additional field 'Status' which will show duplicate entries are not saved and unique ones are saved. My actual problem is validating duplicate entries.

Ps: thank you for everyone's help I am able to export data from excel to z table. Now I just want to validate it.

Re: Exporting data from excel to database

SachinArtani — Sat, 27 Jul 2019 10:45:04 GMT

Before showing your internal table data, you can sort the internal table and delete duplicate entries as I mentioned in below answer. Please check.