TpqcPhp1003.Sqlhtm.com.

Tamil

TpqcPhp1003

TpqcPhp1003 is a point-and-click, realtime sqlplus script library generator / reporting interface that creates a new html library from your reporting or tuning scripts. When a connect string and source directory of tuning scripts are provided, it generates a html library with realtime display of the script and data.

Needs Xp-sp2+ / Apache 2.2.15 / Php5.2.14 / 10g client on your client-pc.

Features

1.TpqcPhp1003 generates a new html library from your sqlplus scripts. Click on the leftside link to get an always-updated realtime report on the right side.

2.TpqcPhp1003 makes a new copy of your current scripts so they are intact.

3.TpqcPhp1003 can generate a library of any directory with sqlplus tuning scripts on your pc.

4.TpqcPhp1003 can create formatted output for both scripts with simple select statements and scripts with sqlplus formatting commands.

5.TpqcPhp1003 formats your queries so there is really no need for your formatting statements, but existing column format statements work fine.

6.Currently TpqcPhp1003 can make reports from plsql scripts but cannot format them properly.

7.Tpqc generates the library in HTA format but it can be renamed to html to be viewed by most browsers.

8.If TpqcPhp1003 is unable to produce a report, please make sure that

a) the scripts do not use UNAVAILABLE features like support for plsql and user input with &.

b) the scripts do not use unsupported views on the version of the database used.

c) the scripts end with a / or ;.

For your safety: Backup your source directory. Enter correct connect string. Verify current connection on the title bar of the TpqcPhp1003 script library window before running scripts.

Requirements

Xp-sp2,sp3 / Apache 2.2.15 / Php5.2.14 / 10g client.

Install Instructions

1.Download TpqcPhp1003.zip and extract to a folder.

2.If your httpd.conf file is at C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf, run TpqcPhp1003.ProgFiles.Install.bat.

If your httpd.conf file is at C:\xampp\apache\conf\httpd.conf [xampp], run TpqcPhp1003.Xampp.Install.bat.

[You can find excellent download & install instructions for Xampp 1.7.3 from Apache Friends at http://www.apachefriends.org/en/xampp-windows.html.]

[If you have the httpd.conf file at other install locations, please modify the install and uninstall batch files accordingly.]

These installers create directories, copy files and configure the Apache Web Server automatically. They start TpqcPhp1003 at the end of the install from the default location: C:\Sqlhtm\Tpqc\Php.

Run Intructions [These long-winded instructions may wear you out. If you can drive the installation procedure clicking your way through, that's great. These instructions are for people like me:)]

1.At the end of the install, the installer starts TpqcPhp1003 and the "Get Connect string & source directory page" appears.

In the second part [at bottom] of the page, first enter the connect string, press the "Save to File" button, then select the source script directory by pressing the "Press to Browse" button and press the "Generate Library Now" button.

You can also manually copy/paste the source directory in the text box under the "Press to Browse" button, press the "Save to File" button and press "Generate Library Now" button. The installer finishes the install.

2.Start TpqcPhp1003 with C:\Sqlhtm\Tpqc\Php\TpqcPhp1003.exe or Start Menu-All Programs-Sqlhtm-TpqcPhp-TpqcPhp1003.

Now you can use the saved connect string and source directory from the top of the "Get connect string & source directory" page and press "Generate Library Now" button. You can also use the second part of the page at bottom to enter a new connect string, then select the source script directory by pressing the "Press to Browse" button and press the "Generate Library Now" button.

You can also manually copy/paste the source directory in the text box under the "Press to Browse" button, press the "Save to File" button and press "Generate Library Now" button.

3.On the "Confirm" page, choose "Okay" afer verifying the connect string and source directory.

Depending on how many files you have in the source directory, you may have to wait for a few seconds before the "Confirm" page appears.

4.On the left of the TpqcPhp1003 main window, press the "Script" button to verify your script and then "Script name-data" button to view the output on the right.

Uninstall Intructions

-For Apache installations with httpd.conf file at C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf run TpqcPhp1003.ProgFiles.Uninstall.bat.

-For XAMPP-Apache installations with httpd.conf file at C:\xampp\apache\conf\httpd.conf run TpqcPhp1003.Xampp.Uninstall.bat.

from where you unzipped the zip file.

The uninstallers cannot delete install directory if files are opened by browsers or hta windows or sqlplus.

[If you want to customize TpqcPhp1003, please contact sqlhtm@sqlhtm.com or neutratek@neutratek.com for customization options.]

Debugging Tips

-Timing & size of outputs: TPQC uses the PHP default of 60 second response limit and under ~10MB output size.

-Apache installation: Check the C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf file for a valid TPQC entry, or if it is an xampp install, check xampp-install-dir\apache\conf\httpd.conf [eg. C:\xampp\apache\conf]

The TpqcPhp1003.httpd.conf file installs this code at install time and removes it at the uninstall in the httpd.conf file.

# TPQC.PHP.START - Create An Alias for the Tpqc script dir
<IfModule alias_module>
   Alias /Tsd "C:/Sqlhtm/Tpqc/Php/Tsd/"
</IfModule>
<Directory "C:/Sqlhtm/Tpqc/Php/Tsd">
   Order allow,deny
   Allow from all
</Directory>
# TPQC.PHP.END

-Check the file used to store the connection string[C:\Sqlhtm\Tpqc\Php\Tpcstr.txt] and the file used to store Source directory[C:\Sqlhtm\Tpqc\Php\Tpsdir.txt] and make sure that there are no leading or trailing whitespaces.

-connect string example:

1. system/manager@xe

2. sys/change_on_install@xe as sysdba

Free Licence

TpqcPhp1003 is free for your personal/non-commercial use. Do not copy, distribute or sell this tool or parts of it without crediting the author, Jerome Christopher [Neutratek-Sqlhtm.com].

If you find this useful to you, consider a gift. Thanks.

Disclaimer

By using this tool you agree that backing up your source scripts, entering correct connect string and source directory during use of this tool are your responsibility and that Neutratek-sqlhtm.com is not responsible for any unwanted results arising from the use of this tool.

Thanks

Apache ApacheFriends.org F2ko Filezilla Google GreenGeeks Hostmonster Html-form-guide Iview Internet.com Java2s.com Msdn Oracle Oracle-base Optimumx Php Pspad Sothink Sqldeveloper Stackoverflow Ssr Tektips Unixutils visualbasicscript.com Yahoo