How can we help?
You can use XML data binding if you want to display data in your content. Data can be altered any time through an XML sheet so you won’t have to edit your content each time data changes.
You can connect an XML and use its data by following this guide:
You can use your own XML file or a simple Google Spreadsheet to create an XML connection.
This is an example of a XML Spreadsheet.
First, your document has to be published through these steps:
File->Publish On Web-> Select: Entire Document and Web Page -> click Publish
Get back to the spreadsheet editor interface
and copy the ID from the URL. (Text highlighted with red)
Then replace the “Your_ID_Comes_Here” text with your ID in this URL:
You will use this URL in the next steps.
On the Administrator page, under the Datasources menu, add a new datasource.
Note that only users with SuperAdmin role can access this menu!
Give your datasource a name, which will be displayed in the Data Picker.
Select the client who will use the datasource in its contents.
Add the XML file’s URL or the URL that we created in the first step.
Save your datasource.
You can use data binding on widgets where there is an option for a Data Picker.
The following Widgets contain a data binding option:
Dynamic charts can only be used with data binding.
For this example I chose the Table Dynamic chart widget.
In the Data Picker, select your datasource from the dropdown.
After the selection, the column names will be displayed under the Select Columns tab.
Choose the columns you want to make Visible on your content.
The columns can be dragged up and down. This will allow you to set the order the columns will be shown.
You can set the columns’ width (in pixels), text and background color, the label (the column’s name), alignment, and the type of data, which can be Text or Image.
These formatting settings are found under the Column Level Settings. For images your must click the drop down and select image if you want your images to be displayed. By default this will be set to text.
If you want to use another page other than the first one, you will need to use this method:
When you create your spreadsheet, the Main Sheet will always be the default sheet created by the software .
If you are using sheet numbers to identify your sheets in the URL, the numbers will follow the order of the sheet pages in your spreadsheet.
Making a content using a Google Spreadsheet/XLM Connection: