The iPushPull WordPress plugin makes it easy to automate updates or display live updating data from your desktop Excel spreadsheets in your WordPress pages. You’ll need an iPushPull account to use the plugin – sign up for a free trial here!
Features
- Display the latest data from your desktop spreadsheets in your WordPress pages
- You don’t need to save the source spreadsheet to update the data
- Your content updates automatically – the reader does not need to refresh their browser to get the latest update
- You choose the range of cells that gets displayed
- You control the update frequency – every few seconds, every hour, every day
- Data can be public or password protected
Examples
Take a look at this page on the iPushPull blog to see the plugin in action.
What is iPushPull?
iPushPull lets you share live data between desktop Excel spreadsheets and publish it on the web. The iPushPull WordPress plugin lets you easily embed the spreadsheet data you’re sharing in your WordPress site. You’ll need an iPushPull account to use it – if you don’t have one yet, sign up now for free.
For more information please visit the iPushPull website and the iPushPull Help and Support Centre.
User Guide
When you sign up to iPushPull we create a Folder for you, containing live data Pages. You can then push data to these pages from desktop Excel spreadsheets, databases or any of the other applications we support.
iPushPull Embed Shortcode
This embeds the live data page you specify in your article (or other places WP shortcodes may be used such as widgets etc.).
The easiest way to build a shortcode is by using our simple Shortcode Generator. Run it by clicking the iPushPull icon on the WordPress toolbar after you’ve installed the plugin. Select your folder, page and any options and it builds your shortcode for you automatically!
Here’s details of all the options you can set.
[ipushpull_page parameters]
Parameters
- folder – required Name of iPushPull Folder
- page – required Name of iPushPull Page
- width – Width of embedded element (any css value)
- height – Height of embedded element (any css value)
- interval – How often the page should update (in seconds). If your content doesn’t update frequently, it’s good to set the interval to a higher value. This will be more efficient for your visitors’ browsers. You cannot set this interval lower than the minimum pull interval in your page’s settings.
Look & Feel Control
Customers with Business or Enterprise packages can control the look and feel of their iPushPull pages using the following parameters:
- btn_share – Remove the “Share” button
- btn_popup – Remove the “Popup” button
- btn_download – Remove the “Download” button (data pages only)
- update_frequency – Remove the indicator of update frequency (not recommended)
Notes on parameters:
- Width and height parameters can hold any value that follows css format – *px, *em, *vw, *%, auto, etc.
- Look & feel parameters can take any of the values: “no”, “hide”, “false” or 0
Example
[ipushpull_page folder="my_folder_name" page="my_page_name" height="300px" interval=30]
To try this out without signing up to iPushPull first, use the following demo page that we keep constantly updated:
[ipushpull_page folder="DemoExcelUsers" page="BlogSummary" height="325px"]
If you are a Business or Enterprise customer, you can control the look and feel of the iPushPull toolbar like this:
[ipushpull_page folder="DemoExcelUsers" page="BlogSummary" height="325px" btn_share="no" btn_download="no"]
Identifiers
If you want to reference your embedded iPushPull pages in your site code or css, the plugin generates unique identifiers for the html elements containing the embedded pages:
- id – ippEmbedPage_folder_page (e.g. ippEmbedPage_MyCompany_PriceList)
- name – ipp_page_folder_page (e.g. ipp_page_MyCompany_PriceList)
Where “folder” and “page” are the Folder and Page names you’ve specified.
Styling
The content of the embedded data replicates the styles you’ve specified in Excel (or whatever client application you’ve used to generate the data). You can change the style of the wrapping element itself. Every element containing an iPushPull page has the css class “ipushpull_page“.
Feedback and Suggestions
If you find this plugin useful, please rate it and leave a review. If you have any suggestions for improvements then please get in touch!
Download & install the zip archive
The plugin package installer can be downloaded from the WP2E project tab called “code”.
1 – Select the version to download if this option is available otherwise the “latest” version of the main plugin will be used.
2 – After downloading the zip archive install the plugin package installer in you local environment and activate the script from the plugin list.
3 – Under the section “Plugins” of the admin dashboard you should see a new “Dependencies & Licenses” link. Follow the instructions from this panel to finalize the installation of the missing dependencies.
-
- Give a name to your project
-
- Download the Installer Package
-
- Install & activate the plugin locally
-
- Install the suggested dependencies
Tips: Use the WP2E panel to add/suggest new dependencies to the local installation. Press F5 in the list of dependencies if the changes are not displayed right away.