Title: @1 Table Publisher: General
Brief introduction on features.
The is a completely revised and improved version of our popular @1 Active Table. It is much powerful in the sense that administrator (login using master password) and sub users (login using sub user passwords) can create tables and edit the cell contents of the tables directly from the browser.
Source of Tables:
Source 1: Import tab-delimited text files converted from Microsoft® Excel or Microsoft® Access (and upload using the browser).
Source 2: Create new tables from blank directly on the browser.
Source 3: Use existing text data files on the server. These files might be the ones being produced/used by other database CGI scripts.
Export tables to Microsoft's products:
Whether you are using "Tab", "Semicolon" or "Pipe" as delimited in the script, all the tables can be exported to Microsoft® Excel or Microsoft® Access.
Supported Delimiter:
• Tab-delimited
• Pipe-delimited
• Semicolon-delimited
* comma-delimited data files are currently NOT supported by this script.
Master Administrator and Sub Users:
Master administrator (login using master password) has full control. The actions highlighted in RED are NOT available to sub users (login using sub user password):
- Clear Database: Remove all tables from the database including all sub users' status.
- Add New User: Create a sub user (multiple sub users supported).
- Add New Table: Create a new table.
- Edit: Edit existing table.
- View: View existing table in HTML.
- Delete: Delete a table.
- Download: Copy and save the text into an external file.
Master administrator's power:
- Master administrator can view/edit/delete his own tables as well as all tables under the sub users.
- The master administrator can delete a sub user's status by deleting all that sub user's table.
Sub users' status:
- When login using a sub user password, the sub user can only view, edit or delete his own tables. He can also create new tables.
- When creating a new table, the sub user is not allowed to use "existing data file in server" as the table source for security reasons.
- If a user deleted all his tables, he still hold his sub user status (the password is still valid). He can re-create new tables later.
Layout:
• You may optionally have the result plotted in your own template.
• You may specify the followings:
- global text box size (for table cells)
- table width
- cellpadding & cellspacing
- border
- font type, size
- table and cell alignment
- background colors and so on ....
Columns and Rows:
• It doesn't matter how may rows and columns of data you have, the script will handle it automatically.
• If you are importing form Excel or Access, it is advisable that you place a dash ( - ) in the empty fields (to prevent out-of-alignment of rows and columns) although the script can most of the time recognize empty fields automatically.
HTML in Headers:
• You can use basic HTML codes in the cells. For example <b>, <font color=red>, <font color=green><u> .... Please note that the closing tags such as </b>, </font> and </u> are not necessary.
• Using the HTML codes, you can make the first row or first column your title fields.
Automatic Double-Quotation Marks Bracketing:
• If comma(s) is present in a cell, the data of that particular cell will be automatically bracketed with double-quotation marks ( " ) when the file is saved as tab-delimited text file.
• There is a variable in the script for you to toggle this feature on/off. By default it is set to "on". If you are working on existing data files produced/used by other database scripts, you might want to set the variable to "off". Detailed instruction is available when configuring this variable.
• Due to this same reason, all double-quotation marks ( " ) entered into the cells are automatically removed by the scripts (to prevent conflicts).
Calling the tables:
- tables are call using the format:
http://yourdomain.com/cgi-bin/tablepublisher.cgi?table=X
where X is a number
Powered by Document Publisher |
