The CreatorCon Call for Content is officially open! Get started here.

Importing Data from file using catalog item, data is not populating correctly.

SupriyaSase
Giga Explorer

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))

1 REPLY 1

palanikumar
Giga Sage
Giga Sage

Is the attachment in Data source is deleted and update with the latest attachment? 

Thank you,
Palani