Importing Data from file using catalog item, data is not populating correctly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
when we try to upload a excel using import set, it is taking previously uploaded data not the new excel. This import is done using catalog item to automatically update or create records in Table.
I have created a catalog item, once request is submitted with attachment. Using Catalog client script and Workflow i will populate Datasource SYS_ID and Transform map SYS_ID.Based on that Import set will be created and data will be updated in target table. Transform script is configured to updated if record is existing and will create if no record is matching.
Issue is, every time we upload a attachment it is taking same data in Import set table.(example: i have initially uploaded 100 lines of excel(100 records are created), now when i upload excel with 6 lines(instead of creating 6 records it is again importing 100 lines and updating the same rows))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
Is the attachment in Data source is deleted and update with the latest attachment?
Palani