Difference between revisions of "Manual:Extension/BlueSpiceExportTables"

[unchecked revision][unchecked revision]
(Perform ExportTables)
(Tag: 2017 source edit)

What is ExportTablesBlueSpiceExportTables?[edit | edit source]

ExportTables supplements tables with the option to save them with one click into other formats, eg. MS Excel, to export.

How does ExportTables work?

BlueSpiceExportTables allows exporting tables on wikipages and grids with tabular data.

Using BlueSpiceExportTables[edit | edit source]

If the Extension ExportTables is installed, you can assign tables the additional property "Exportable". This allows you to open the table in read-only mode with a mouse click in other formats.

Where to find ExportTables?

Any regular table that is insert on a page can be exported. Before table export is possible, table must be configured to support exporting.

In VisualEditor[edit | edit source]In the WYSIWYG editor

While editing a page in VisualEditor, click on the page and select "Properties". In the dialog that is opened, turn on option "Exportable".

In Wikitext[edit | edit source]

In Edit mode, click on a table and expand the Formats button in the WYSIWYG editor.

exptab1.jpg

The entry "Table" opens another menu in which you select the last entry "Exportable". The selected points are orange indicated.

exptab2.jpg
exptab3.jpg

After saving, the table has the additional property that you can export it to other formats (right click on the table).

exptab4.jpg
In the wiki code

Table can be set to be exportable in wiki text as well. Add classes "bs-exportable" and "exportable" to the table's "class" argument.

                
{| class="wikitable bs-exportable exportable"
|+...


            

After saving the page, all users viewing the page can export the table by right-clicking on the table and selecting desired format.

Formats[edit | edit source]

You can also quickly and easily export a table in the wiki code. Add the bs-exportable attribute to the table tag:

exptab5.jpg

To remove the function from a table, you must go to the wiki code and delete the "bs-exportable" attribute from the start of the tableFormats that are offered for exporting a page are:

  • CSV - Comma separated values
  • XLS - Microsoft Office Excel 2003
  • XLSX - Microsoft Office Excel

Exporting data from grids[edit | edit source]

In addition to exporting the tables on pages, most of BlueSpice managers and other extensions that display tabluar data also offer exporting of data. Exporting such data is done over "Export table" menu in right top corner of the managers like BlueSpiceNamespaceManager.

You can also export tables from any Manager (Book Manager, Assignment management, Category manager, Group manager, Namespace manager, Permission manager, User manager).

bookmnger1.jpg
permnger1.jpg

See also[edit | edit source]

Our reference page.


Attachments

Discussions