Skip to main content
Answer

Importing data: unique reference ?

  • August 14, 2024
  • 3 replies
  • 127 views

Hugo Nienhuis
Superhero
Forum|alt.badge.img+12

We import an Excel-file using the standard importing feature within Universal. Before importing the data (or right after) I would like to delete the records that were already present in the table.

I am looking to use the default logic to do so, however, I am unable to distinquish the previously imported records (except for a time-based solution which is not a preferable option to me). I need a unique condition / trigger before the import starts to delete all existing records, or I would need to be able to distinguish the newly imported records from the old records.

 

Is there a way to do this using the default logic?

 

 

Best answer by Hugo Nienhuis

Our backup plan is to create a task and use the indicium API to process the import. The staging table is a nice idea. 

I would have expected a variable to identify a specific import though. I will create an idea for this.

 

 

This topic has been closed for replies.

3 replies

rbiram
Hero
Forum|alt.badge.img+4
  • Hero
  • August 19, 2024

Curious about this as well :)


Forum|alt.badge.img+17
  • Moderator
  • August 30, 2024

Not sure you could or should accomplish this by using the default.

Why not create a task have the task handle the import, that way you could do a merge strategy or a delete and insert.  
Or alternatively if you really want the excel import functionality, you could use a staging table and compare the data from import table with actual table either by using a process flow or have a system flow that checks if there is something in the staging table and updates the records in the actual table.  


Hugo Nienhuis
Superhero
Forum|alt.badge.img+12
  • Author
  • Superhero
  • Answer
  • September 2, 2024

Our backup plan is to create a task and use the indicium API to process the import. The staging table is a nice idea. 

I would have expected a variable to identify a specific import though. I will create an idea for this.