Joomla CSV plugin, module, extension, component. Shows CSV file in your Joomla content.
Renders table by data from CSV file. Allows create table with customizable columns containing data from CSV file. This plugin is also a part of ARI Smart Content: DataTable Pack
Features:
- Customizable columns
- Could be wrapped by other table plugins, for example Flex Grid or Table Sorter to adjust table look and functionality
Example1:
| Name | Value | Date | Time | 1 | 2 | 3 | 4 | 5 |
|---|
| First | 391.49 | 10/2/2008 | 4:00pm | 0.00 | N/A | N/A | N/A | 150 | | Second | 500.00 | 10/1/2008 | 4:00pm | 0.00 | N/A | N/A | N/A | 11543 | | Third | 145.00 | 10/5/2008 | 5:00pm | 7.00 | N/A | N/A | N/A | 5143 | | 4 | 45.00 | 11/5/2007 | 3:00pm | 5.00 | N/A | N/A | N/A | 6443 | | 3 | 15.00 | 5/5/2007 | 1:00pm | 9.00 | N/A | N/A | N/A | 6443 |
Usage1:
{aricsvtable file="data.csv"}
{aricsvtablecolumns}
{aricsvtablecolumn id="ID" alias="ID" width="20%" className="idg"}
{aricsvtablecolumn id="NAME" alias="UserName" headerClassName="head"}
{/aricsvtablecolumns}
{aricsvtablecolumnspan row="-1,0,2,4" startIndex="0" endIndex="3"}
{/aricsvtable}
Example2: ARI CSV Table wrapped by ARI JData Table to add sorting and filtering support:
| Number1 | Number2 | Number3 |
|---|
| 390.49 | 555 | 23 | | 110 | 100 | 14 | | 110.5 | 20 | 120 | | 110 | 50 | 50 | | 34 | 78.55 | 121 | | 35 | 79.55 | 121 | | 36 | 75.55 | 121 | | 200 | 200 | 141 | | 110.5 | 200 | 20 | | 110 | 250 | 520 | | 34 | 78.55 | 123 | | 34 | 79.55 | 122 | | 34 | 75.55 | 124 | | 392.49 | 555 | 24 | | 391.49 | 555 | 75 |
Usage2:
{arijdatatable}
{aricsvtable file="data.csv"}
{aricsvtablecolumns}
{aricsvtablecolumn id="ID" alias="ID" width="20%" className="idg"}
{aricsvtablecolumn id="NAME" alias="UserName" headerClassName="head"}
{aricsvtablecolumn alias="Virtual Column" headerClassName="head" virtual="true" pos="1"}
{coltemplate}{$NAME} - {$ID}{/coltemplate}
{/aricsvtablecolumn}
{/aricsvtablecolumns}
{/aricsvtable}
{/arijdatatable}
aricsvtable parameters:
- file - CSV file(Required). Values: path to CSV file
- heading - Use first line/entry as field names. Values: true,false
- sortBy - Sorting field
- sortDir - Sorting direction.Values: asc, desc
- sortType - Sorting type. Values: SORT_REGULAR,SORT_NUMERIC,SORT_STRING
- autoDetect - Auto-detect delimiter. Values: true, false
- delimiter - Data delimiter
- enclosure - Data enclosure
- offset - Number of rows to ignore from beginning of data. Values: number
- limit - Limits the number of returned rows to specified amount. Values: number
- header - Display header or not. Values: true, false
- footer - Display footer or not. Values: true, false
- cellPadding - Cell padding. Values: number
- cellSpacing - Cell spacing. Values: number
- width - Table width. Values: px or percentage
- className - CSS class name to be applied to the table
- inputEncoding - Indicate input encoding. Values: input encoding
- advancedStyling - If this parameter is enabled, HTML table will contain additional CSS classes for each column and row. Values: true, false
aricsvtablecolumn parameters:
- id - Column name
- className - CSS class name to be applied to content cells (td)
- headerClassName - CSS class name to be applied to header (th)
- width - Width. Values: px, percentage
- alias - Columns name to be displayed on UI. Values: string
- headCellTag - HTML tag. Values: th,td
- cellTag - HTML tag. Values: th,td
- virtual - Indicate that this column is virtual. Values: true, false
- hidden - Indicate that this column will be hidden. Values: true, false
- pos - Column order. Values: integer
aricsvtablecolumnspan parameters:
- row - Row index(es). Values: zero-based row index (for header and footer use -1);
- startIndex - Start column index. Values: zero-based column index;
- endIndex - End column index. Values: zero-based column index;
|