Jump to content
  • 0
Sign in to follow this  
Shiro

Make trigger react during import records

Question

Is there someway I can design a trigger so when I Import a records to my table, it will only import those records which have an actual value. When I try to update some records on my table via import, it overwrites everything even though some of the records imported are blank. I made a trigger that shall only update records which are not null via condition statement but it seems not working. 

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hello again @Shiro

 

That will surely wont work...

The last time I check, trigger doesn't activates when you use import for updating or inserting data. 

I can suggest this workaround though.

instead of directly updating your table from import, import your records to a dummy copy of your main table first then use Task to update the main table from records imported to dummy table. by then you can now use a condition statement to not include those records with blank values

 

Hope it helps

quack
 

Share this post


Link to post
Share on other sites
  • 0

Just to back up @NiceDuck's statement, here it is on the Caspio HowTo article referring to triggered actions:

'Triggered Actions currently will not run from import of data through either manual import or DataHub tasks.'

Duck's workaround is your best bet. You need to first do something to the imported data to be able to manipulate it. Putting it into a dummy table and THEN filtering it is the way to go.

Share this post


Link to post
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...
Sign in to follow this  

×
×
  • Create New...