Tech Tip: Automatically Import Data to Keep Your Caspio Applications Up-to-Date | Caspio
  • Platform
    • Product
      • Platform Overview
      • Features
      • Why Low Code
      • Case Studies
    • Industries
      • Healthcare
      • Education
      • Government
      • Financial Services
      • Energy and Utilities
      • Nonprofits
      • Media
      • Consulting
    • Get Started
      • Free Trial
      • Get a Custom Demo
      • Contact Sales
  • Resources
    • Resources
      • Resource Center
      • App Marketplace
      • Blog
    • Plan for Success
      • Free Training
      • Onboarding
      • Professional Services
      • Partner Directory
  • Pricing
    • Pricing
      • SMB Plans
      • Enterprise Plans
    • Special Programs
      • Nonprofit Discount
      • Qualifying Countries Discount
      • Caspio in the Classroom
  • search
  • Contact Sales
  • Support
    • Online Help
    • Community Forum
    • Contact Support
  • Log in
Get a Demo Try Free
Caspio logo Try Free
  • Platform

    The Caspio Low-Code Platform

    • menu-product-icon[1]
      Product
      • Platform Overview
      • Features
      • Why Low Code
      • Case Studies
    • industries-icon
      Industries
      • Healthcare
      • Education
      • Government
      • Financial Services
      • Energy and Utilities
      • Nonprofits
      • Media
      • Consulting
    • get-started-icon
      Get Started
      • Free Trial
      • Get a Custom Demo
      • Contact Sales
  • Resources

    All the Tools and Support You Need

    • menu-resources-icon[1]
      Resources
      • Resource Center
      • App Marketplace
      • Blog
    • menu-plan-for-success-icon[1]
      Plan for Success
      • Free Training
      • Onboarding
      • Professional Services
      • Partner Directory
  • Pricing

    Unlimited Users With Every Plan

    • menu pricing icon
      Pricing
      • SMB Plans
      • Enterprise Plans
    • menu special programs icon
      Special Programs
      • Nonprofit Discount
      • Qualifying Countries Discount
      • Caspio in the Classroom
  • search
  • Contact Sales
  • Support
    • Online Help
    • Community Forum
    • Contact Support
  • Log in
Get a Demo Try Free

Tech Tip: Automatically Import Data to Keep Your Caspio Applications Up-to-Date

January 7, 2015

  • Tech Tips
  • Customer Spotlight
  • News Articles
Try Free
  • Home
  • Blog
  • Current Article
9334
January 7, 2015
Tech Tip: Automatically Import Data to Keep Your Caspio Applications Up-to-Date

Tech-Tip-Caspio-Data-Import-ExportFor many Caspio users, importing and exporting data is a recurring task. You may not be aware that Caspio offers a number of features – some of them released within the last few months – to help you to streamline the entire import/export process.

In this blog, we would like to focus on two specific features which are each quite powerful in their own right, but truly shine when used together.

Import Update

In the Caspio Import Wizard, “Update” is a new addition to the existing import methods (Import as New, Append, Replace, and Update Design):

Caspio-Data-Import-Update
When you import a new data file and choose the Update option, the data in your file is compared against the existing data in your Caspio online database. If a matching record is found and the data in the file is different, the record will be automatically updated; and if there isn’t an existing matching record in the database, the data will be automatically added as a new record. All other records in the database are left untouched.

Using the Import Update feature, you can now easily import only the changed and new records to ensure your online application is up-to-date with any updates made outside of Caspio. Given that the alternative is to re-import the entire table every single time, this feature saves you a lot of energy, not to mention the data transfer if you are dealing with large tables.

DataHub

To put it simply, Caspio’s DataHub feature provides automated import/export. You can schedule data import and export tasks to run on-demand or at recurring frequencies:

Caspio-DataHub
DataHub can interact with a variety of cloud storage services and protocols including Amazon S3, Dropbox, Microsoft OneDrive, Box, Google Drive, FTP, SFTP, FTPS, HTTP, etc.

Typical Use Case

Here is a usage scenario that many Caspio customers can relate to:

A printing service is using a Caspio application to allow their customers to check the status of their print orders. A legacy internal system is used to handle the operation of all print orders. A daily task is created on the internal system to export all the records that have a new status. This file is saved on a local folder that is synched to Dropbox. Caspio DataHub is scheduled to take this file every 2 hours and import the data into the Caspio application using the Import Update feature. As a result, customers can view the latest status of their orders.

Import Update and DataHub are available depending on your pricing plan. Please contact your Account Manager for detailed information.

Feel free to request a project consultation to learn more, or sign up for a free trial if you are new to Caspio.

Caspio Free Trial Caspio Free Trial
Previous Post:
Tech Tip: How to Create Responsive Web Apps Using Caspio
Next Post:
Tech Tip: How to Capture Environment Data Using Caspio System Parameters

Recommended Articles

How to Build a Simple Project Management App to Boost Remote Work Productivity

How to Build a Simple Project Management App to Boost Remote Work Productivity

Custom CRM Tips: Improve Your Customer Relationships With These Best Practices

Custom CRM Tips: Improve Your Customer Relationships With These Best Practices

20 Online Business Dashboards You Can’t Live Without, And That You Can Build Right Now

20 Online Business Dashboards You Can’t Live Without, And That You Can Build Right Now

5 Apps You Can Deploy Right Now to Support Teleworking and Business Continuity

5 Apps You Can Deploy Right Now to Support Teleworking and Business Continuity

How to Overcome the Limitations of Excel for Data Management

How to Overcome the Limitations of Excel for Data Management

How COVID-19 Changed the Role of CIOs

How COVID-19 Changed the Role of CIOs

IT Helpdesk App: 5 Essential Features to Look For

IT Helpdesk App: 5 Essential Features to Look For

COVID-19 Response: 8 Low-Code Apps Your Government Agency Needs Right Now

COVID-19 Response: 8 Low-Code Apps Your Government Agency Needs Right Now

Midstream Oil & Gas Companies: Digitally Transforming For a Bright Future

Midstream Oil & Gas Companies: Digitally Transforming For a Bright Future

Subscribe for More Updates
  • PRODUCT

  • Platform Overview
  • Features
  • Why Low Code
  • Case Studies
  • App Marketplace
  • Pricing
  • Get a Custom Demo
  • Free Trial
  • SOLUTIONS

  • Healthcare
  • Education
  • Government
  • Financial Services
  • Energy and Utilities
  • Nonprofits
  • Media
  • Consulting
  • RESOURCES

  • Resource Center
  • Free Training
  • Online Help
  • Onboarding
  • Get Certified
  • Professional Services
  • Support Center
  • COMPANY

  • Our Story
  • Careers
  • Leadership
  • News
  • Blog
  • Partner Programs
  • Referral Program
  • Contact Us
  • TRENDING

  • Build Custom CRM
  • Create Web Dashboards
  • Best Online Database
  • Convert Excel to Web
  • Migrate MS Access Online
  • HIPAA Compliant Database
  • Create a Patient Portal
Caspio Logo

Caspio is the world’s leading cloud platform for building online database applications without coding.
Start a free trial today and experience the power of no-code.

  • AICPA SOC Logo

© 2023 Caspio, Inc. Sunnyvale, California. All rights reserved.

  • Privacy Statement
  • Terms of Use
  • Report Abuse
  • Sitemap
  • Feedback