[Ledger-smb-devel] Change setup.pl initial connection from 'template1' to 'postgres' database?
Hi all, When we decommissioned the use of 'createdb' as a dependency for setup.pl, we have replaced it by a direct connection to the 'template1' database. However, some (most?) installs turn out to explicitly block connections (over IP interfaces??) to that database. Should we replace the connection to template1 with a connection to the 'postgres' database? According to the documentation *that*'s the default database to be used by utilities, users, etc. Any reason not to do it in 1.3.17? Bye, Erik. -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Address formatting functionality
What about putting this template fragment in the country table? Best Wishes, Chris Travers -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Address formatting functionality
Drupal 7 has been addressing :-P these issues with an addressfield module ( http://drupal.org/project/addressfield ), which aims to incorporate the flexibility of xNAL - http://xml.coverpages.org/xnal.html . The challenge for xNAL is to provide the ability to handle the following: - About 36+ customer name formats - Addresses of 241+ Countries - About 130+ Address Formats - Represented in 5,000+ languages (dialects) - Should be application independent, ie., capable of being used for a variety of applications ranging from simple user profiling to name and address parsing, matching, validation and postal services - Should be Platform independent - Should be open, and - Should be vendor neutral. Might as well incorporate the discovery done by others! I haven't looked into how Addressfield stores its data -- it does have to deal with similar location issues for tax jurisdiction as LSMB, and Drupal obviously uses a relational database instead of an XML object database, so I'd say it's worth seeing how they modeled this problem... Cheers, John On 05/06/2012 08:04 PM, Chris Travers wrote: What about putting this template fragment in the country table? Best Wishes, Chris Travers -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel !DSPAM:4fa73bf0314442135420002! -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Address formatting functionality
On Sun, May 6, 2012 at 8:30 PM, John Locke m...@freelock.com wrote: Drupal 7 has been addressing :-P these issues with an addressfield module ( http://drupal.org/project/addressfield ), which aims to incorporate the flexibility of xNAL - http://xml.coverpages.org/xnal.html . Interesting idea. I am all for incorporating work of others into LedgerSMB. However, I am not sure how this would be done since I doubt our invoices, check printing, etc. will ever move off TT/LaTeX. it seems to me we'd have to find out what they are doing regarding address formats and convert these into TT snippets to be used. Best Wishes, Chris Travers -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
