SQL2XLS
8 months agofil-signature/01-01.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/01-01.sql

8 months agofil-signature/02-02.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/02-02.sql

8 months agofil-signature/03-03.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/03-03.sql

8 months agofil-signature/04-04.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/04-04.sql

8 months agofil-signature/05-05.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/05-05.sql

8 months agofil-signature/99-BA.sql
Marijana Glavica [Fri, 14 Nov 2008 07:20:27 +0000 (08:20 +0100)]
fil-signature/99-BA.sql

8 months agofil-signature/sr.sh
Marijana Glavica [Fri, 14 Nov 2008 07:20:23 +0000 (08:20 +0100)]
fil-signature/sr.sh

8 months agoang-signature/sr.sh
Marijana Glavica [Fri, 14 Nov 2008 07:12:39 +0000 (08:12 +0100)]
ang-signature/sr.sh

8 months agosoc-signature/00-00.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/00-00.sql

8 months agosoc-signature/01-01.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/01-01.sql

8 months agosoc-signature/02-02.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/02-02.sql

8 months agosoc-signature/03-03.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/03-03.sql

8 months agosoc-signature/04-04.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/04-04.sql

8 months agosoc-signature/05-05.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/05-05.sql

8 months agosoc-signature/06-06.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/06-06.sql

8 months agosoc-signature/07-07.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/07-07.sql

8 months agosoc-signature/08-08.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/08-08.sql

8 months agosoc-signature/09-09.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/09-09.sql

8 months agosoc-signature/10-10.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/10-10.sql

8 months agosoc-signature/11-11.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/11-11.sql

8 months agosoc-signature/12-12.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/12-12.sql

8 months agosoc-signature/13-13.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/13-13.sql

8 months agosoc-signature/14-14.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/14-14.sql

8 months agosoc-signature/15-15.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/15-15.sql

8 months agosoc-signature/16-16.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/16-16.sql

8 months agosoc-signature/17-17.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/17-17.sql

8 months agosoc-signature/18-18.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/18-18.sql

8 months agosoc-signature/19-19.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/19-19.sql

8 months agosoc-signature/20-20.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/20-20.sql

8 months agosoc-signature/21-21.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/21-21.sql

8 months agosoc-signature/22-22.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/22-22.sql

8 months agosoc-signature/23-23.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/23-23.sql

8 months agosoc-signature/24-24.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/24-24.sql

8 months agosoc-signature/25-25.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/25-25.sql

8 months agosoc-signature/26-26.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/26-26.sql

8 months agosoc-signature/27-27.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/27-27.sql

8 months agosoc-signature/28-28.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/28-28.sql

8 months agosoc-signature/29-29.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/29-29.sql

8 months agosoc-signature/30-30.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/30-30.sql

8 months agosoc-signature/99-BD.sql
Marijana Glavica [Fri, 14 Nov 2008 07:07:36 +0000 (08:07 +0100)]
soc-signature/99-BD.sql

8 months agotal-signature-duple/00-duple-signature.sql
Marijana Glavica [Fri, 14 Nov 2008 07:03:48 +0000 (08:03 +0100)]
tal-signature-duple/00-duple-signature.sql

8 months agotal-signature/00-00.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/00-00.sql

8 months agotal-signature/01-01.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/01-01.sql

8 months agotal-signature/02-02.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/02-02.sql

8 months agotal-signature/03-03.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/03-03.sql

8 months agotal-signature/04-04.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/04-04.sql

8 months agotal-signature/05-05.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/05-05.sql

8 months agotal-signature/06-06.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/06-06.sql

8 months agotal-signature/07-07.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/07-07.sql

8 months agotal-signature/08-08.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/08-08.sql

8 months agotal-signature/09-09.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/09-09.sql

8 months agotal-signature/10-10.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/10-10.sql

8 months agotal-signature/11-11.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/11-11.sql

8 months agotal-signature/12-12.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/12-12.sql

8 months agotal-signature/13-13.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/13-13.sql

8 months agotal-signature/14-14.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/14-14.sql

8 months agotal-signature/15-15.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/15-15.sql

8 months agotal-signature/16-16.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/16-16.sql

8 months agotal-signature/17-17.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/17-17.sql

8 months agotal-signature/18-18.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/18-18.sql

8 months agotal-signature/19-19.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/19-19.sql

8 months agotal-signature/20-20.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/20-20.sql

8 months agotal-signature/21-21.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/21-21.sql

8 months agotal-signature/99-FD.sql
Marijana Glavica [Fri, 14 Nov 2008 07:00:05 +0000 (08:00 +0100)]
tal-signature/99-FD.sql

8 months agotal-signature/sr.sh
Marijana Glavica [Fri, 14 Nov 2008 07:00:02 +0000 (08:00 +0100)]
tal-signature/sr.sh

8 months agopov-signature-duple/00-duple-signature.sql
Marijana Glavica [Mon, 10 Nov 2008 13:54:39 +0000 (14:54 +0100)]
pov-signature-duple/00-duple-signature.sql

8 months agoger-signature/07-07.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:31 +0000 (13:13 +0100)]
ger-signature/07-07.sql

8 months agoger-signature/06-06.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:23 +0000 (13:13 +0100)]
ger-signature/06-06.sql

8 months agoger-signature/05-05.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:16 +0000 (13:13 +0100)]
ger-signature/05-05.sql

8 months agoger-signature/04-04.sql
Marijana Glavica [Mon, 10 Nov 2008 12:13:10 +0000 (13:13 +0100)]
ger-signature/04-04.sql

8 months agoger-signature/02-02.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:54 +0000 (13:12 +0100)]
ger-signature/02-02.sql

8 months agoger-signature/03-03.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:45 +0000 (13:12 +0100)]
ger-signature/03-03.sql

8 months agoger-signature/01-01.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:27 +0000 (13:12 +0100)]
ger-signature/01-01.sql

8 months agoger-signature/00-00.sql
Marijana Glavica [Mon, 10 Nov 2008 12:12:07 +0000 (13:12 +0100)]
ger-signature/00-00.sql

8 months agoger-signature/99-FB.sql
Marijana Glavica [Mon, 10 Nov 2008 12:02:59 +0000 (13:02 +0100)]
ger-signature/99-FB.sql

8 months agoger-signature/sr.sh
Marijana Glavica [Mon, 10 Nov 2008 12:02:55 +0000 (13:02 +0100)]
ger-signature/sr.sh

8 months agosrc-signature-duple/00-duple-signature.sql
Marijana Glavica [Fri, 7 Nov 2008 13:32:05 +0000 (14:32 +0100)]
src-signature-duple/00-duple-signature.sql

8 months agoizn-signature-duple/00-duple-signature.sql
Marijana Glavica [Wed, 5 Nov 2008 15:09:54 +0000 (16:09 +0100)]
izn-signature-duple/00-duple-signature.sql

11 years agoescape data which looks like formula master
Dobrica Pavlinusic [Thu, 27 Dec 2012 12:57:01 +0000 (12:57 +0000)]
escape data which looks like formula

git-svn-id: svn://svn.rot13.org/SQL2XLS@28 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

13 years agoinitial port to Excel::Writer::XLSX
Dobrica Pavlinusic [Tue, 28 Dec 2010 13:56:16 +0000 (13:56 +0000)]
initial port to Excel::Writer::XLSX

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

git-svn-id: svn://svn.rot13.org/SQL2XLS@27 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

13 years agobegin porting to Excel::Writer::XLSX
Dobrica Pavlinusic [Tue, 28 Dec 2010 13:35:57 +0000 (13:35 +0000)]
begin porting to Excel::Writer::XLSX

git-svn-id: svn://svn.rot13.org/SQL2XLS@26 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agore-introduce $sth->rows > 0 check which PostgreSQL needs
Dobrica Pavlinusic [Thu, 12 Feb 2009 10:56:03 +0000 (10:56 +0000)]
re-introduce $sth->rows > 0 check which PostgreSQL needs
to detect queries which doesn't return results
(like create temporary table)

git-svn-id: svn://svn.rot13.org/SQL2XLS@25 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agomore output when running without debug
Dobrica Pavlinusic [Thu, 6 Nov 2008 10:53:59 +0000 (10:53 +0000)]
more output when running without debug

git-svn-id: svn://svn.rot13.org/SQL2XLS@24 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agosupport $db_encoding for Pg and mysql DBI drivers
Dobrica Pavlinusic [Thu, 6 Nov 2008 10:49:02 +0000 (10:49 +0000)]
support $db_encoding for Pg and mysql DBI drivers

git-svn-id: svn://svn.rot13.org/SQL2XLS@23 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agouse "set names '$db_encoding'" to for MySQL to get
Dobrica Pavlinusic [Thu, 6 Nov 2008 10:37:17 +0000 (10:37 +0000)]
use "set names '$db_encoding'" to for MySQL to get
correct character encoding in generated Excel

git-svn-id: svn://svn.rot13.org/SQL2XLS@22 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agosupport multiple SQL queries in one file, for example
Dobrica Pavlinusic [Mon, 3 Nov 2008 23:19:40 +0000 (23:19 +0000)]
support multiple SQL queries in one file, for example
to use create temporary time to speedup reporting

git-svn-id: svn://svn.rot13.org/SQL2XLS@21 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agostrip \d+[-_] from beginning of SQL file before creating sheet name
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:31:47 +0000 (22:31 +0000)]
strip \d+[-_] from beginning of SQL file before creating sheet name

git-svn-id: svn://svn.rot13.org/SQL2XLS@20 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agouse heuristics to guess date time fields if we don't
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:29:05 +0000 (22:29 +0000)]
use heuristics to guess date time fields if we don't
have correct type from database (as from MySQL, sigh!)

git-svn-id: svn://svn.rot13.org/SQL2XLS@19 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agosplit require_config into own sub, so we now read global
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:26:57 +0000 (22:26 +0000)]
split require_config into own sub, so we now read global
and local config (within directory)

git-svn-id: svn://svn.rot13.org/SQL2XLS@18 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoremove dependency on CGI
Dobrica Pavlinusic [Mon, 3 Nov 2008 22:24:11 +0000 (22:24 +0000)]
remove dependency on CGI

git-svn-id: svn://svn.rot13.org/SQL2XLS@17 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoundef $db_encoding to disable decode of encoding
Dobrica Pavlinusic [Mon, 3 Nov 2008 21:53:30 +0000 (21:53 +0000)]
undef $db_encoding to disable decode of encoding

git-svn-id: svn://svn.rot13.org/SQL2XLS@16 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agountaint config_path
Dobrica Pavlinusic [Mon, 3 Nov 2008 21:39:44 +0000 (21:39 +0000)]
untaint config_path

git-svn-id: svn://svn.rot13.org/SQL2XLS@15 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoadded configuration example and improved pod a bit
Dobrica Pavlinusic [Mon, 3 Nov 2008 20:42:55 +0000 (20:42 +0000)]
added configuration example and improved pod a bit

git-svn-id: svn://svn.rot13.org/SQL2XLS@14 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoimplement sub-reports which are simply directories and SQL queries,
Dobrica Pavlinusic [Mon, 3 Nov 2008 20:32:44 +0000 (20:32 +0000)]
implement sub-reports which are simply directories and SQL queries,
each generating single XLS file

git-svn-id: svn://svn.rot13.org/SQL2XLS@13 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agosuggest ScriptAlias to get nice URLs
Dobrica Pavlinusic [Mon, 3 Nov 2008 20:15:09 +0000 (20:15 +0000)]
suggest ScriptAlias to get nice URLs

git-svn-id: svn://svn.rot13.org/SQL2XLS@12 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoimplement 31 char limit for sheet name with warning
Dobrica Pavlinusic [Mon, 3 Nov 2008 19:30:12 +0000 (19:30 +0000)]
implement 31 char limit for sheet name with warning

git-svn-id: svn://svn.rot13.org/SQL2XLS@11 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoread config.pl file if it exists
Dobrica Pavlinusic [Mon, 3 Nov 2008 19:19:39 +0000 (19:19 +0000)]
read config.pl file if it exists

git-svn-id: svn://svn.rot13.org/SQL2XLS@10 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agoadded Makefile.PL to check dependencies
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:55:36 +0000 (18:55 +0000)]
added Makefile.PL to check dependencies
since we don't require building of anything

git-svn-id: svn://svn.rot13.org/SQL2XLS@9 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agostrip spaces around comments
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:51:49 +0000 (18:51 +0000)]
strip spaces around comments

git-svn-id: svn://svn.rot13.org/SQL2XLS@8 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b

15 years agofix warning
Dobrica Pavlinusic [Mon, 3 Nov 2008 18:50:02 +0000 (18:50 +0000)]
fix warning

git-svn-id: svn://svn.rot13.org/SQL2XLS@7 2e857b76-582b-47e5-ad5c-b3ba0f0ee29b