This article explains how to push data from your local databases into ipushpull so you can access it across all our application integrations and share it with your colleagues and customers. These are the steps you need 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 and configure the loader for your database
See this article to find out how to install the DataLoader, login and configure your data sources.
2. Configure a Push
The DBLoader lets you configure multiple pushes in a single saveable config. Here's how to set up your first push:
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:
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 - called DBDemoFormat in this example:
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.
- 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 or not you want to apply styles and formats to your data
- Format Folder & Page: the template page where styles and formats will be copied from
- 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 (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