UPOINT:: CGI Scripts:: @1 Table Publisher
.
Demo:

Login as Master Administrator: Login (features disabled)

Login as Sub User: Login (full features available)
   Try: password = upoint1 and password = upoint2

View HTML tables:
   - Table 4 Created by Master Administrator
   - Table 5 Created by Master Administrator

Try to import a Microsoft Excel data file:
   - This file is exported from Excel using tab-delimited text format. Try creating a new table by uploading the file Book2.txt (select Tab as delimiter).
   - Once the table is created, go to the Edit mode. You will see that some empty cells are initially missing. Once you have clicked "Save" and return to the Edit mode again, everything will look just fine. The script can most of the time recognize empty fields automatically.

Calling the tables:
   - tables are call using the format:

       http://yourdomain.com/cgi-bin/tablepublisher.cgi?table=X

where X is a number


General:

The is a completely revised and improved version of our popular 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 multiple tables and edit the tables directly from the browser.


Sources of Data:

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 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. Detailed procedure is available here.

  • If comma 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).

Supported Delimiters

  • Tab-delimited
  • Pipe-delimited
  • Semicolon-delimited
    * comma-delimiter is 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 ....
    - See configuration details here.

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.

Requirement:

  • Perl
  • No MySQL needed.
  • No SSI needed.

Purchase:

Price: USD44.95 + Life free upgrades & support

Select your preferred payment gateway
* 2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by UPDI Network Enterprise. * You may pay via PayPal with or without a PayPal account.
  We prefer PayPal (especially if you have a verified PayPal account).
  Join our affiliate program. Instant account approval. Start making $$$. Start with your own purchase.

Click here if you wish to make payment via other methods.
You might want to consider our Membership offer for full access to download ALL our current and future PHP & Perl scripts.


Search Categories (limited to this subject only):

content management system script, content management script, content management program, content management programme, content management solution, cms system, cms program, cms programme, cms solution, cms script, HTML table script, table conversion script, table creation script, table generation script, table manipulation script, plot data, convert Excel file to HTML table, convert Excel data to HTML table, convert Access file to HTML table, convert Access data to HTML table, MS-Access, MS-Excel, content management tool, perl script, cgi script