You are here:
< Back

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)

https://docs.google.com/spreadsheets/d/

1BVqnifu16QgYuaOPBUcTeCD0ZvJoPT-YvBuvc1Kez8Y

/edit#gid=0

Then replace the “Your_ID_Comes_Here” text with your ID in this URL:

https://spreadsheets.google.com/feeds/list/

Your_ID_Comes_Here

/od6/public/values

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 Datapicker.

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 elements where there is an option for Datapicker.

The following Elements contain a data binding option:

Dynamic charts can only be used with data binding.

Meter, List, Pie, Bar, Column, Line, Area, Pyramid, Gauge.  For this example, I chose the List Dynamic chart element. In the data picker, select your datasource.

After the selection, the column names will be displayed.
Choose the columns you want to display on your content.

You can even 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.

The columns can be dragged up and down.
This way you can set the order the columns will be shown.

If you want to use another pages 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.

Watch a walkthrough about the feature:

Comments are closed.