Caspio Team Contributes to Haiti Earthquake Victims

Posted by Caspio on February 4, 2010 under Commentary, News | Comments (0)

The magnitude of human suffering resulting from the Haiti earthquake is beyond what words can describe, and the stories and images of those affected have touched the hearts of everyone around the world.

Red Cross helping Haiti earthquake victims

Last month, Caspio and its employees joined resources to make a donation to the American Red Cross. It may be a small contribution in the grand scheme of things, but it allows us to be a part of the global movement where people from all over the globe are sending assistance.

Caspio has an especially close connection with Haiti as our CEO, Frank Zamani, visited several schools there in October of last year as part of a Mona Foundation delegation. See pictures of that trip.

Caspio CEO, Frank Zamani at a school in Haiti

There is still a long way to go before Haitians can return to a more normal life, and the Caspio team plans to continue to stay involved, finding other ways to contribute to the rebuilding of the nation and the recovery of the citizens.

Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • Twitter
  • Yahoo! Bookmarks

Texas Tribune Builds Data Library Apps Using Caspio

Posted by Caspio on January 7, 2010 under Customer Spotlights | Comments (1)

The recent launch of Texas Tribune’s Data Library is a great example of how media and government clients are utilizing Caspio Bridge to publish databases and share engaging web applications that increase website traffic and community interaction.

Texas Tribune is a non-profit news organization located in Austin, Texas, devoted to state government and public policy. They aim to promote civic engagement through original, explanatory journalism and public events.

The data library contains over a dozen database applications, all intended to give readers more information about the state’s government and its elected officials. Database applications built using Caspio include Lowest Performing Schools, Partisan Rankings by District, Texas Campaign Expenditures, and Government Employee Salaries containing records of over 250,000 public employees.

Texas Tribune Web Database Apps

Texas Tribune also plans to utilize Caspio’s advanced deployment capabilities to give visitors the option of easily downloading data or embedding the apps on their own websites. 

Request a demo, hosted by a product expert, to see other customer examples.

If you would like to share your own Caspio-powered application and be featured in our blog, please leave a comment below!

Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • Twitter
  • Yahoo! Bookmarks

Creating One-to-Many Relational DataPages

Posted by Frank Zamani on December 14, 2009 under Commentary | Comments (1)

The tutorial below shows how you can build an app with a parent-child table relationship. In this example, the user can search for Customers and then drill down to a details page where customer details and a list of their contact history are shown. There is also a web form on the page that automatically associates new call log submissions to the displayed customer.

View more presentations from Online Database.
Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • Twitter
  • Yahoo! Bookmarks

Create Location-Based Applications with Caspio

Posted by Frank Zamani on December 7, 2009 under Tips & Tricks | Comments (2)

Caspio Bridge provides you with a number of capabilities and services to create location-based applications. These include:

  • Search by Distance
  • Map Integration
  • Automatic Geocoding

With the Search by Distance feature, your search forms can be used to find records based on proximity to a location. For example, your search form could take an address and find all hospitals within 10 miles of that particular address. Creating such search forms is easily accomplished through the Search and Report wizard, provided that the Search by Distance feature is enabled in your account.

When you request Search by Distance, a geocoded database of all U.S. ZIP codes will also be uploaded into your account to utilize as you wish in your location-based applications. 

location-based-apps

We also have a step-by-step map mashup tutorial and live instructor-led training sessions for integrating your address-centric databases and applications with Google or Yahoo! maps. Using Caspio’s map integration, your search results and record details can easily be plotted on a map.

Additionally, Caspio has the capability to geocode large sets of data either as a batch or in real time. When activated, our geocoding service automatically adds latitude and longitude to your address-centric tables.

To request Distance Search or geocoding services, please contact Caspio Support or your account manager.

Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • Twitter
  • Yahoo! Bookmarks

How to Track User IP Addresses and Site URLs in Web Forms

Posted by Caspio on November 11, 2009 under Tips & Tricks | Comments (2)

Tracking where your data and users are coming from has many benefits and can be easily implemented using the AutoValues feature in Caspio Bridge 6.5.

See How It Works:


 

Why Track User IP Addresses?

As mentioned in the video, capturing user IP addresses in the database is useful for tracking multiple submissions, preventing malicious activities, and auditing data or users. 

Documenting the user IP addresses with each submission can pinpoint double entries when multiple submissions are made by the same user. This might be especially important if the app is for online sweepstakes, surveys, or polls.

In addition to Caspio’s built-in security features such as web user authentication and SSL protection, tracking user IP addresses can provide an extra level of awareness, allowing you to trace where all entries originated from. You can even take it a step further and deter malicious users from accessing your app by displaying a warning message explaining that their IP address is being tracked.

Auditing data or users by user IP is another convenient way to add extra functionality to your applications. For example, have you ever wondered if your competitors are accessing your information? If you know their IP range, you can easily identify them if they ever try to register through your apps.

Why Track Site URLs?

If your application is deployed on multiple websites, tracking the site URL will allow you to pinpoint exactly from which site the information was submitted. This would be highly useful if you are using affiliate or cost per action marketing. Knowing which affiliate generated the lead helps you track the success of that affiliate and award payments accordingly.

By tracking the URL, you can also capture parameters that are being passed from a page that links to the location of the hosted application. This can be helpful to track parameters from widely-distributed online advertisements or links.

Have a question about the AutoValues feature? Contact our support team at http://caspio.com/support.

Leave a comment below and share how IP address and site URL tracking has helped you improve your web forms.

Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • Twitter
  • Yahoo! Bookmarks