Each table created in the EasyTable component can be configured to show/hide fields in either the list or detail views. The table editor lets you treat fields as either text, URL's, names of images or links to records detail views.

In our previous article introducing the EasyTable component we included an annotate screenshot of the table editing screen (shown to the left). This article will explain in more detail each of the annotated points in the EasyTable Editor.

After downloading the EasyTable component and installing it the first thing you will want to do is import a CSV/TAB file (you can get sample files here). TAB files are only supported in EasyTable Pro. After the install EasyTable will appear in the Components menu, depending on the version installed you will see either the free or Pro versions icon in the menu.

EasyTable Manager

Selecting EasyTable or EasyTable Pro from the Component menu will take you straight to the EasyTable Manager screen. 

The EasyTable Manager should be familiar to you as it's modelled after the all of the standard content manager interfaces in Joomla, such as the Article, Section, Category, etc Managers. From this screen you can create a New table, Edit/Delete existing ones or change their Published state using the standard Joomla buttons found in right-hand side of the the EasyTable toolbar (as show below). You also set some global defaults for your tables using the Parameters button.

Let's create a new table, the first thing to do is click on the New button.

Creating A New Table

When creating a new table in EasyTable you are presented with a blank editor that only displays the "Details" and "Statistics" sections.  At this point all you need to provide is a name for the table and a data file is a CSV/TAB format. You don't need an alias as EasyTable will create a suitable one from the tables name.

You can follow along or look at the screenshot above if you want to skip through the key points.

1. Step 1 is to provide a user friendly name, something that the end user browsing the website can understand.
2. A description of the data contained in the table, this is used in both a Tables list and under the Table heading in the table view.
3. At this stage the Published state is "No" and can't be changed until you've uploaded the first set of data.
4. Choose a suitable CSV/TAB file to import - if you don't have one try one of our sample files.
5. Click the "Upload file" button and if everything works your Editor screen will now have a "Field Configuration" section as shown in the "Annotated" screen shot above.

Field Configuration

During the initial import EasyTable process the CSV file and creates field labels for each column it finds in the file.  The fields are label based on the column headings in the file as shown in this screenshot .

Of course it can only use the headings if the file has them and if you've told EasyTable to treat the first row as headings. If the file has no headings EasyTable will create generic labels (Column1, Column2, etc... ) and alias for each field/column. After importing the file you will want to set the Position of each field.

Positions

The Position value determins the order in which fields are presented in both the List and Detail Views.The first thing you may notice is that the fields are not in the same order they appear in your CSV file. This happens because EasyTables displays the fields ordered by their Position and then within that by Label.

You can determine the order they are in the file from their ID number which is created in the same order as the original position in the CSV file. ID numbers constantly increment for each field and are unique within your Joomla installation. Your first table will have fields with ID's from 1 to N, where N is the number of fields in the file. Subsequent tables will have field ID's starting at N+1 and continue to increment.

Once you set the Position value for each field and clicked the Apply button the fields will be redisplayed in the new order, as shown in this screenshot .

Ticks & Crosses ( or List & Detail View and Detail Links )

Once you have your fields in the right order, you will want to decide which columns you want to appear in the tables list view. More often than not the number of columns in any given table is more than it is practical to display sensibly in a list view, however a detail view, which shows only a single row can easy accomodate many fields/columns of data.

Clicking on the standard Joomla red Cross will toggle it to a green Tick, so any column/field you want to appear in the list view simply click on its red Cross to toggle it to a green Tick in the "List View" column. The same applies for columns/fields you want to appear in the detail view.

How do users get from the list view to a records detail view? I hear you ask.  Simple really, just choose a suitable field or two that appear in the list field and Tick its "Detail Link" column.

• In the List View column a green Tick means that the table column will appear in the main or List View of the table. a red Cross means it will not be displayed.
• In the Detail View column a green Tick means that the table column will appear in the Detail View of a row, a red Cross means it will not be displayed in the Detail View.
• In the List View column a green Tick means that the table column will appear in the main view of the table.

• EasyTable Editor Explained (Part 1)
• EasyTable Editor (Part 2) - Alias & Type & CSS
• EasyTable Editor (Part 3) - Linked Table Settings
• EasyTable Editor (Part 4) - Preferences