Jump to content
  • 0

Import Update Logic


SteveT

Question

Does the import 'update' option also have the capability to delete and add items as part of the import?  Let's say the 'inventory' destination table has 10 items. We import a file of 8 records and we want the logic to be:

  • 6 import items match 6 table items match so no update to table takes place (number of records in the table is still 10)  
  • 1 new item imported, so add that item to the table  (number of records in the table is now 11)  
  • 1 imported item matches a table item but has a single data change,  so update that item in the table (number of records in the table is still 11)
  • the kicker - if 3 items in the current table are not included in the import file, is there a way to auto-delete them from the table upon import?   (This would take the number of items in the table to 8) 

New to caspio, trying to understand the update logic

 

Thanks!!!!!!!!!!

 

Edited by SteveT
Added Subject
Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi @SteveT,

For the Update Action on Import, what it does to update the table provided that they have a Unique Field.

If there are new records in the file you're importing, you should use the Append actions. If you're updating and adding new records, you'll be using two actions: Append and Update. 
https://howto.caspio.com/tables-and-views/importing-data/
 

However, these actions do not have the ability to delete the records that are not in the imported table, REPLACE can. 
If you replace the table, it only means that you are overwriting the table. 

Hope this helps. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...