topic Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event in Application Development and Automation Discussions

Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Former Member — Tue, 08 May 2007 14:33:34 GMT

I guys, I have a problem validating data when I import from a file. What I'm doing is a kind of utility to load a table from a text file, via the ALV grid. I succeed in loading that file into my editable ALV grid (using OO), but loaded data doesn't goes thru the CHANGED_DATA process... Thanks for helping me.

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Former Member — Tue, 08 May 2007 14:51:22 GMT

The button with which you are uploading the data should be there in the application tool bar in order to trigger the event DATA_CHANGED.

This event trigger when PAI trigger. So make sure that your upload button is there in the application tool bar.

Thanks,

Raj

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Former Member — Tue, 08 May 2007 15:10:33 GMT

Yes, there is a button (not a standard but mine) that I use to import the file data into the grid Internal table. This button triggers a subroutine that parse the file, load the grid internal table, and call a REFRESH_TABLE_DISPLAY method of the grid.

But no data is added to the "change log" of the grid (parameters of the DATA_CHANGED event).

Thanks

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Former Member — Tue, 08 May 2007 15:28:02 GMT

You can get the UCOMM value in E_UCOMM of the event. AN dbased on that, compare the old ITAB and New ITAB values.

May be this has some extra process , but i think helpful.

Pass the Data to a temp. internal table. and compare with this table when ever there is a upload process triggers.

- Raj

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Former Member — Tue, 08 May 2007 15:43:19 GMT

But I want the grid to validate the data integrity (check table), and DATA_CHANGED Event subroutine to validate the rest (key duplication). I don't need to compare with a temp table, I just want to have the imported data added to the ER_DATA_CHANGED->MT_MOD_CELLS, ER_DATA_CHANGED->MT_DELETED_ROWS and

ER_DATA_CHANGED->MT_INSERTED_ROWS tables of the CL_ALV_CHANGED_DATA_PROTOCOL object like when you change data manually.

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Sagar47 — Fri, 22 Dec 2023 06:31:16 GMT

Do you have any solutions now? I'm encountering the same issue.

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

javier_alonso63 — Thu, 04 Jan 2024 13:12:45 GMT

As far as I know, data_changed event of ALV Grid is only triggered when the ALV is editable and the user moves between cells or enters values.

If you edit the table content via code, the event is not triggered.

Re: Editable ALV Grid - Validate Imported Data from file via DATA_CHANGED Event

Sandra_Rossi — Thu, 04 Jan 2024 13:27:41 GMT

That's incorrect that "this event triggers when PAI trigger", it may trigger even without PAI, e.g. while the user moves out of an editable cell or press Enter. It depends how the code is done.