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 Data 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
- Formats: toggle controlling whether the data will be pushed formatted or unformatted
- Format Folder & Page: the template page where styles and formats will be copied from - see step 3 below
- Data Source: the name of the data source you want to run the query against
- Data Query: the actual SQL query that you want to run against your database
- Headers: toggle controlling whether or not to push the data headers/column names to your ipp page
- 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 a folder called Demo 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 Data Loader 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 Data Loader 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.