Setting up a Push from your database to ipushpull

This article explains how to push data from your local databases into ipushpull so you can access it across all our client apps and share it with your colleagues and customers. These are the steps to take:

• Configure your data source

• Select the ipushpull page you want to push your data to

• Configure the SQL query that will extract the data from your database

• Apply styles and formatting to your data

• Save your configuration

 1. Set up the DataLoader and connect your database

See this article to find out how to install the DataLoader, login and configure your data sources. 

2. Configure a Push

The DataLoader lets you configure multiple pushes in a single saveable config. Here's how to set up your first push:

Open

a. Enter a name for this push in the Name field (this can be anything - it's for your own reference).

b. Choose the Folder and Page for the Page you want to push the data into using the dropdowns. In this case the folder is called Demo and the page is called DBDemo:

Open

c) Choose your data source from the dropdown and enter the SQL query you want to run (we suggest you paste the query in from the DB dev tool you are using). In this case we are using an MS SQL Server database:

d) Tick the Headers checkbox if you want to push the header row from your query results to your ipushpull page.

e) To select data from your db and push it once, click the Push button

f) To start the query to run periodically at a specified interval, enter your interval (in seconds) in the Interval field and click Start

A message indicating whether or not your push was successful will be displayed in the Push status field.

3. Example Query Config

Here's a sample configuration for pushing data into the page Demo/DBDemo 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:

4. Style and format your data

By default the DataLoader 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

 Now update your DataLoader 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:

5. Save your configuration

Once you're happy with your configuration, select File | Save so you can return to it later.

6. Configuration Reference