App-Office-Contacts

 view release on metacpan or  search on metacpan

Changelog.ini  view on Meta::CPAN

[V 1.08]
Date=2010-04-16T08:52:00
Comments= <<EOT
- Warning: The organizations and people tables have a new column: upper_name.
This is due to a defect in SQLite, which does not allow function calls
when defining an index. Hence the index on people(upper(name) ) has to be
now written as people(upper_name). You can easily write a little program
to use alter table, and then populate the new column.
The search code uses the new column.
- Change SQLite attribute from unicode to sqlite_unicode.
- Change the default database driver from Postgres to SQLite,
to make installation easier (by not requiring DBD::Pg).
If using another database server, you'll need to edit the 2 lines
in .htoffice.contacts.conf which refer to SQLite.
- Fix Makefile.PL to use App::* not CGI::*.
My apologies for this carelessness.
- Rework cookies and POST validation, to allow Contacts, Donations and
Import::vCards to run in parallel.
EOT

Changelog.ini  view on Meta::CPAN

- Rename data/email_addresses.txt => data/fake.email_addresses.txt.
- Rename data/email_people.txt => data/fake.email_people.txt.
- Rename data/people.txt => data/fake.people.txt.
- Rename data/phone_numbers.txt => data/fake.phone_numbers.txt.
- Rename data/phone_people.txt => data/fake.phone_people.txt.
- Rename data/organizations.txt => data/fake.organizations.txt.
- Add comments to .htoffice.contacts.conf, while simplifying the
discussion of the Javascript URL.
- Change the default URL of the FAQ.
- Use common::sense instead of strict and warnings.
- Add unicode to .htoffice.contacts.conf - used by SQLite - and add
corresponding code to BEGIN{} in App::Office::Contacts::Database,
in case anyone wants to use DBD::SQLite.
- Fix off-by-one error in report.js when indexing into
document.report_form.report_id.options[report - 1].text.
- Change some logging in Contacts.pm from info to debug.
EOT

[V 1.04]
Date=2010-02-21T12:54:14
Comments= <<EOT

Changes  view on Meta::CPAN

	- Comment out the processing which checks for CSRF, since I encountered
		a case where it did not work.

1.08  Fri Apr 16  8:52:00 2010
	- Warning: The organizations and people tables have a new column: upper_name.
		This is due to a defect in SQLite, which does not allow function calls
		when defining an index. Hence the index on people(upper(name) ) has to be
		now written as people(upper_name). You can easily write a little program
		to use alter table, and then populate the new column.
		The search code uses the new column.
	- Change SQLite attribute from unicode to sqlite_unicode.
	- Change the default database driver from Postgres to SQLite,
		to make installation easier (by not requiring DBD::Pg).
		If using another database server, you'll need to edit the 2 lines
		in .htoffice.contacts.conf which refer to SQLite.
	- Fix Makefile.PL to use App::* not CGI::*.
		My apologies for this carelessness.
	- Rework cookies and POST validation, to allow Contacts, Donations and
		Import::vCards to run in parallel.

1.07  Wed Apr  7  8:51:00 2010

Changes  view on Meta::CPAN

	- Rename data/email_addresses.txt => data/fake.email_addresses.txt.
	- Rename data/email_people.txt => data/fake.email_people.txt.
	- Rename data/people.txt => data/fake.people.txt.
	- Rename data/phone_numbers.txt => data/fake.phone_numbers.txt.
	- Rename data/phone_people.txt => data/fake.phone_people.txt.
	- Rename data/organizations.txt => data/fake.organizations.txt.
	- Add comments to .htoffice.contacts.conf, while simplifying the
		discussion of the Javascript URL.
	- Change the default URL of the FAQ.
	- Use common::sense instead of strict and warnings.
	- Add unicode to .htoffice.contacts.conf - used by SQLite - and add
		corresponding code to BEGIN{} in App::Office::Contacts::Database,
		in case anyone wants to use DBD::SQLite.
	- Fix off-by-one error in report.js when indexing into
		document.report_form.report_id.options[report - 1].text.
	- Change some logging in Contacts.pm from info to debug.

1.04  Sun Feb 21 12:54:14 2010
	- Remove text 'All rights reserved' (for Debian licensing).
	- Remove docs heads 'Required Modules' and 'Changes'.
	- Replace personal doc root with /var/www.

lib/App/Office/Contacts.pm  view on Meta::CPAN

See L</Creating and populating the database> for a discussion of scripts/populate.fake.people.pl.

Do a search for Brocard, the author of the original L<GraphViz>, and you will find LE<233>on Brocard.

Also, see lines 48 .. 52 in the config file for options to control the utf8 setting in the connect() attributes
as used by L<DBI>. These are the defaults:

	mysql_enable_utf8 = 1
	# pg_enable_utf8 == 0 for DBD::Pg V 3.0.0 in my code.
	pg_enable_utf8    = 0
	sqlite_unicode    = 1

These values are used in App::Office::Contacts::Util::Logger lines 44 .. 57.

=head2 Why not allow multiple Facebook and Twitter tags per org or person?

This is under consideration.

=head2 How can I update the spouses table?

You cannot. I have not yet decided how to provide an on-screen mechanism to update this table.

lib/App/Office/Contacts/Util/Logger.pm  view on Meta::CPAN

	my($config) = $self -> module_config;
	my($attr)   =
	{
		AutoCommit => defined($$config{AutoCommit}) ? $$config{AutoCommit} : 1,
		RaiseError => defined($$config{RaiseError}) ? $$config{RaiseError} : 1,
	};
	my(%driver) =
	(
		mysql_enable_utf8 => qr/dbi:MySQL/i,
		pg_enable_utf8    => qr/dbi:Pg/i,
		sqlite_unicode    => qr/dbi:SQLite/i,
	);

	for my $db (keys %driver)
	{
		if ($$config{dsn} =~ $driver{$db})
		{
			$$attr{$db} = defined($$config{$db}) ? $$config{$db} : 1;
		}
	}

share/.htapp.office.contacts.conf  view on Meta::CPAN

# My DocumentRoot: /dev/shm/html.

demo_page_css_url   = /assets/js/DataTables-1.9.4/media/css/demo_page.css
demo_table_css_url  = /assets/js/DataTables-1.9.4/media/css/demo_table.css
fancy_table_css_url = /assets/css/app/office/contacts/fancy.table.css
homepage_css_url    = /assets/css/app/office/contacts/homepage.css

# Database stuff
# --------------
# Note:
# o sqlite_unicode=1 is only for DBD::SQLite.
#   If not using SQLite, you can safely leave that line in here.
# o Session stuff (below) also refers to database stuff.
# o pg_bytea and pg_text are used by Data::Session.

AutoCommit      = 1
#dsn            = dbi:SQLite:dbname=/tmp/contacts.sqlite
#dsn            = dbi:mysql:database=contacts
dsn             = dbi:Pg:dbname=contacts
log_table_name  = log
pg_bytea        = 0
pg_text         = 1
RaiseError      = 1
username        = contact
password        = contact
max_note_length = 10000

mysql_enable_utf8 = 1
# pg_enable_utf8 == 0 for DBD::Pg V 3.0.0 in my code.
pg_enable_utf8    = 0
sqlite_unicode    = 1

# Identification stuff (for the About tab)
# ----------------------------------------

program_author  = Ron Savage
program_faq_url = /assets/templates/app/office/contacts/faq.html
program_name    = App::Office::Contacts
program_version = V 2.00

# Javascript stuff