/[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 (8 years, 1 month 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) - [select for diffs]
Modified Tue Dec 28 13:35:57 2010 UTC (8 years, 1 month 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 (10 years ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6302 byte(s)
Diff to previous 24
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6278 byte(s)
Diff to previous 23
more output when running without debug

Revision 23 - (view) (annotate) - [select for diffs]
Modified Thu Nov 6 10:49:02 2008 UTC (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6308 byte(s)
Diff to previous 22
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6116 byte(s)
Diff to previous 21
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 6025 byte(s)
Diff to previous 20
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5673 byte(s)
Diff to previous 19
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5670 byte(s)
Diff to previous 18
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5454 byte(s)
Diff to previous 16
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
File length: 5394 byte(s)
Diff to previous 15
undef $db_encoding to disable decode of encoding


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


Revision 14 - (view) (annotate) - [select for diffs]
Modified Mon Nov 3 20:42:55 2008 UTC (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 3 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 10 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 10 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 10 months ago) by dpavlin
Original Path: sql2xls.cgi
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 (10 years, 10 months ago) by dpavlin
Original Path: sql2xls.cgi
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