Jump to content
  • 0
Sign in to follow this  
geoffdude

Via Scheduled Task Import - Possible To Append New Data Only?

Question

Is there a way to have  only new data append to existing caspio data table during a scheduled import from a managed Excel file off Google Drive?

Right now I keep getting duplicate records for each import.

To be clear, we don't want to delete/overwrite the excel file and data that lives on Google Drive .. we want to add data/rows to it.. then have only those new rows of data imported into the mirrored Caspio table via scheduled task import.

I'd also like to not do a full rewrite/upload of the data file that's on Caspio too.

 

Thx

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi @geoffdude,

Yes it is possible, you just have to set the 'Action' to your table to 'Append'  (http://prntscr.com/m4kum8 ) so that it will adds the new data to your existing table. Any fields that don’t exist in the current table design will be added.  And your excel file in your Google Drive will not be affected in this Import process, for more details about this kindly check the link below

https://howto.caspio.com/tables-and-views/importing-data/

I hope this helps

Regards,

TsiBiRu

Share this post


Link to post
Share on other sites
  • 0

Thx - But not sure that's what I'm looking for.

Note: this is for a scheduled task. Not a manual import.

If I have an Exel file on Google Drive that I do not want to overwrite, just update for ongoing changes, how do I keep all previous data from importing into my Caspio table? I only want the new data that's just been added to the GD Excel file to append to the Caspio table.

So, if the GD excel table has an existing 100 rows, and I add 15 new rows of data, my GD excel file now has 115 rows.  But .. my Caspio table for the import already has the previous 100 rows from a past import. If the new import happens tonight I'll get all 115 rows of data from my GD excel file uploaded into my caspio table, giving me 215 rows of data, 100 of which are now duplicates, because I just added/appended the 115 current GD excel file's rows of data to the existing Caspio data table... which I don't want to do.

I need to have just the new 15 rows of data from the GD excel sheet append on the Caspio table not the full 115 rows of data.

Basically trying to sync/link up the two tables of data.

Share this post


Link to post
Share on other sites
  • 0

Hi @geoffdude ,

You can use "Update" action which will update the data of an existing table with the imported data and add new records which do not exist in your Caspio Table.

The import will add to your Caspio table only 15 records and update 100 of existing records if you made any changes in them. 

You should have a correspondent unique field in Caspio Table and Excel spreadsheet in order to perform this type of import "Action". 

Also, currently Caspio Datahub cannot import data from google spreadsheet and you need to have an Excel copy of your spreadsheet in Google drive account to perform the Datahub import as far as I know. 

Hope this helps.

Regards,

vitalikssssss

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×