- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2017 11:30 PM
Hi all,
I was having 1083 records with me in excel,i want to update the data in alm_hardware table and don't wanted to create any new records.From the script
if(action=='insert')
ignore=true;
i updated some records (like asset tag,acquistion method)and some are ignored.
Now i want the details of those ignored records(like asset tag)may i know how to fetch these details.However from the i symbol i can see the details but i am unable to export those ignored records.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2017 11:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2017 11:43 PM
Hi Pooja,
You can go to the Import Set Row (sys_import_set_row) table, from the Navigation Menu, and filter the required Ignored imported data.
Here, you have a column, Target record, which would point out that an update on this record was ignored.
You can also export this data by right clicking on the header of the list layout and select Export > Excel, etc.
Let me know if this is what you were looking for.
PS: Mark this answer as Correct if it solved your query or hit Like/Helpful depending upon the usefulness of the response.
Regards
Supriya Bisht

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2017 11:45 PM