This article explains how to push data live from your local databases into ipushpull so you can access it across all the applications we integrate with and share it with your colleagues and customers.
1. Set up and configure the loader for your database
See this article to find out how to install and configure the DB Loader
2. Create a Query
The next step is to create your query and choose the ipushpull page the data where you want the data to be displayed. Here's the configuration settings for each query:
- Name: an optional field where you can enter your own name for this query
- Folder: the ipushpull folder containing the page you want to push the data to
- Page: the ipushpull page you want to push the data to
- Format Folder & Page: a template page where styles and formats will be copied from - see step 3 below
- Database Name: the name of the database to run the query against. This is not required for MS Access
- Database Query: the actual SQL query that you want to run against your database.
- Interval: how frequently the query should be run in seconds
- Push button: run the query once and push the data to your page
- Start button: start periodically pushing the data to ipushpull, according to the interval you set
- Web button: launch the ipushpull website and display the page
- Push Status: a status message showing whether the push was successful or not
For example, here's a configuration for pushing data into a page called DBDemo in the Demo folder every 30 seconds:
Once you're happy with your configuration, press the Start button to start pushing. Your data will appear in ipushpull and update each time the query is run:
3. Style and format your data
By default the DBLoader pushes data without any formatting and styling. You can style your data by specifying a format page. The colours, styles, column widths etc. will be copied from the format page and applied to your data.
The easiest way to create a format page is to set the formats up in Excel then paste them into ipushpull. Here's an example of a formatted range in Excel - dark blue header, with alternate shades of blue for the content rows. The first column is right justified, and is narrower than the others.
Once you're happy with this, paste it into your formats page in ipushpull - called DBDemoFormat in this example:
Now update your DBLoader config to specify this Format Page (you will have to pause updates while you do this):
Restart and you will see that your data page is now formatted the way you specified:
4. Save your configuration
When you've taken the time to set things up the way you want, make sure you save your configuration by selecting File | Save so you can return to it later.