Forum6849: CSV to Table Widget plug-in

Title: CSV to Table Widget plug-in

This plug-in provides a widget which reads a CSV file and display it as a table.

Download

Click the link below to download com.traction.widget.csvtotable-NN.zip file. (NN means the version number.)

Install

Upload the zip file in Server Settings > Plugins page.

After uploading, you will see the I18N error. But don't worry. This error means "you need to restart TeamPage server to load the I18N resources (language files)."

Click [Restart TeamPage] in Server Settings > General > Manage Server page. If your TeamPage server is hosted in Traction's cloud environment, you will need to restart your server twice to load the I18N resources correctly.

After restarting, you will see that the plugin's name show up correctly.

Usage

In this introduction, I'm going to show you how to generate a table from an attached CSV file. You don't have to attach a CSV file -- you can specify a URL of a CSV file somewhere in a shared folder etc.

1. Attach a CSV file and get its ID. The ID is a number displayed before the file icon. In this case, the ID is "3".

2. Click the "Insert/Edit Widget" icon and select "CSV to Table".

3. Fill-in and/or select the options.

CSV Attachment ID or URL
Specify the ID or the URL of the CSV file. If the ID is "3", you should fill-in or just "3".
Headers
If empty, the widget assumes that the first line of the CSV file contains the header names. If you want to specify the additional headers which are not defined in the CSV file, you can specify them in this text box by separating each name with the comma characters.
TABLE Class
You can specify the following pre-defined class names and any other your class names.
- bordered ... surrounds the cells with borders.
- stripped ... grays the background of the "odd" lines.
- fullwidth ... sets the 100% width to the table.

4. Press OK button, confirm that the widget is inserted, and submit the article.

5. You will see that the CSV file is displayed as a table.

6. Click the header line to order. In the picture below, I clicked the "Qty" header to make it ordered by the Qty.

Attachments:

image01.png
image03.png
image04.png
image05.png
image06.png
image07.png
installed.png

Article: Forum6849 (permalink)
Categories: :Doc:plug-in
Date: July 18, 2017; 4:47:23 AM Eastern Daylight Time

Author Name: Takashi Okutsu
Author ID: takashi