/[SQL2XLS]/sql2xls.cgi
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Log of /sql2xls.cgi

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (annotate)
Sticky Revision:

Revision 14 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:42:55 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 5330 byte(s)
Diff to previous 13
added configuration example and improved pod a bit

Revision 13 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:32:44 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 4836 byte(s)
Diff to previous 12
implement sub-reports which are simply directories and SQL queries,
each generating single XLS file

Revision 12 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:15:09 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 4332 byte(s)
Diff to previous 11
suggest ScriptAlias to get nice URLs


Revision 11 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 19:30:12 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 4019 byte(s)
Diff to previous 10
implement 31 char limit for sheet name with warning


Revision 10 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 19:19:39 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 3913 byte(s)
Diff to previous 8
read config.pl file if it exists


Revision 8 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:51:49 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 3792 byte(s)
Diff to previous 7
strip spaces around comments

Revision 7 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:50:02 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 3743 byte(s)
Diff to previous 6
fix warning

Revision 6 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:44:42 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 3738 byte(s)
Diff to previous 5
disconnect from database before next connect, support unknown types

Revision 5 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 18:31:58 2008 UTC (15 years, 4 months ago) by dpavlin
File length: 3683 byte(s)
Diff to previous 4
cleanup mode in preparation for first release

- move pod documentation to top
- check GATEWAY_INTERFACE to detect cgi, so it works as
  simple command-line xls dumper again
- disabled AutoCommit so we can't corrupt data by invoking reports

Revision 4 - (view) (annotate) - [select for diffs]
Modified Mon Mar 24 23:02:15 2008 UTC (16 years ago) by dpavlin
File length: 3457 byte(s)
Diff to previous 3
- support for \c database just like psql does
  (you can pipe sql into psql and it will work!)
- better support for multi-line SQL queries


Revision 3 - (view) (annotate) - [select for diffs]
Modified Mon Mar 24 16:35:29 2008 UTC (16 years ago) by dpavlin
File length: 3195 byte(s)
Diff to previous 2
convert SQL date into excel dates (with format dd.mm.yyyy)


Revision 2 - (view) (annotate) - [select for diffs]
Modified Mon Mar 24 15:57:14 2008 UTC (16 years ago) by dpavlin
File length: 2745 byte(s)
Diff to previous 1
fix encoding of characters in generated sheet


Revision 1 - (view) (annotate) - [select for diffs]
Added Mon Mar 24 14:05:54 2008 UTC (16 years ago) by dpavlin
File length: 2663 byte(s)
begin work on web reports which return SQL queries
as XLS table (readable in Gnumeric also :-)


This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.26