/[SQL2XLS]/sql2xlsx.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 /sql2xlsx.cgi

Parent Directory Parent Directory | Revision Log Revision Log


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

Revision 27 - (view) (annotate) - [select for diffs]
Modified Tue Dec 28 13:56:16 2010 UTC (13 years, 3 months ago) by dpavlin
File length: 6361 byte(s)
Diff to previous 26
initial port to Excel::Writer::XLSX

Which doesn't seem to work as-is yet!


Revision 26 - (view) (annotate) - [selected]
Modified Tue Dec 28 13:35:57 2010 UTC (13 years, 3 months ago) by dpavlin
File length: 6302 byte(s)
Copied from: sql2xls.cgi revision 25
Diff to previous 25
begin porting to Excel::Writer::XLSX


Revision 25 - (view) (annotate) - [select for diffs]
Modified Thu Feb 12 10:56:03 2009 UTC (15 years, 1 month ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6302 byte(s)
Diff to previous 24 , to selected 26
re-introduce $sth->rows > 0 check which PostgreSQL needs
to detect queries which doesn't return results
(like create temporary table)

Revision 24 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:53:59 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6278 byte(s)
Diff to previous 23 , to selected 26
more output when running without debug

Revision 23 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:49:02 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6308 byte(s)
Diff to previous 22 , to selected 26
support $db_encoding for Pg and mysql DBI drivers

Revision 22 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:37:17 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6116 byte(s)
Diff to previous 21 , to selected 26
use "set names '$db_encoding'" to for MySQL to get
correct character encoding in generated Excel

Revision 21 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 23:19:40 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6025 byte(s)
Diff to previous 20 , to selected 26
support multiple SQL queries in one file, for example
to use create temporary time to speedup reporting


Revision 20 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 22:31:47 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5673 byte(s)
Diff to previous 19 , to selected 26
strip \d+[-_] from beginning of SQL file before creating sheet name

Revision 19 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 22:29:05 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5670 byte(s)
Diff to previous 18 , to selected 26
use heuristics to guess date time fields if we don't
have correct type from database (as from MySQL, sigh!)


Revision 18 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 22:26:57 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5454 byte(s)
Diff to previous 16 , to selected 26
split require_config into own sub, so we now read global
and local config (within directory)

Revision 16 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 21:53:30 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5394 byte(s)
Diff to previous 15 , to selected 26
undef $db_encoding to disable decode of encoding


Revision 15 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 21:39:44 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5359 byte(s)
Diff to previous 14 , to selected 26
untaint config_path


Revision 14 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:42:55 2008 UTC (15 years, 4 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5330 byte(s)
Diff to previous 13 , to selected 26
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
Original Path: sql2xls.cgi
File length: 4836 byte(s)
Diff to previous 12 , to selected 26
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
Original Path: sql2xls.cgi
File length: 4332 byte(s)
Diff to previous 11 , to selected 26
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
Original Path: sql2xls.cgi
File length: 4019 byte(s)
Diff to previous 10 , to selected 26
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
Original Path: sql2xls.cgi
File length: 3913 byte(s)
Diff to previous 8 , to selected 26
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
Original Path: sql2xls.cgi
File length: 3792 byte(s)
Diff to previous 7 , to selected 26
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
Original Path: sql2xls.cgi
File length: 3743 byte(s)
Diff to previous 6 , to selected 26
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
Original Path: sql2xls.cgi
File length: 3738 byte(s)
Diff to previous 5 , to selected 26
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
Original Path: sql2xls.cgi
File length: 3683 byte(s)
Diff to previous 4 , to selected 26
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
Original Path: sql2xls.cgi
File length: 3457 byte(s)
Diff to previous 3 , to selected 26
- 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
Original Path: sql2xls.cgi
File length: 3195 byte(s)
Diff to previous 2 , to selected 26
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
Original Path: sql2xls.cgi
File length: 2745 byte(s)
Diff to previous 1 , to selected 26
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
Original Path: sql2xls.cgi
File length: 2663 byte(s)
Diff to selected 26
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