Skip to main content
Solved

Importing data: unique reference ?


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.

 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

3 replies

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

Curious about this as well :)


Forum|alt.badge.img+17
  • Moderator
  • 761 replies
  • 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
  • 136 replies
  • 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.

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings