Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id EA191200B29 for ; Thu, 30 Jun 2016 12:23:40 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id E8A72160A52; Thu, 30 Jun 2016 10:23:40 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 16DA2160A51 for ; Thu, 30 Jun 2016 12:23:39 +0200 (CEST) Received: (qmail 64644 invoked by uid 500); 30 Jun 2016 10:23:39 -0000 Mailing-List: contact dev-help@fineract.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@fineract.incubator.apache.org Delivered-To: mailing list dev@fineract.incubator.apache.org Received: (qmail 64632 invoked by uid 99); 30 Jun 2016 10:23:38 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Jun 2016 10:23:38 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5DB9A187C88 for ; Thu, 30 Jun 2016 10:23:38 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.198 X-Spam-Level: * X-Spam-Status: No, score=1.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.in Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id q-NU4KkjrsSl for ; Thu, 30 Jun 2016 10:23:34 +0000 (UTC) Received: from nm41-vm8.bullet.mail.gq1.yahoo.com (nm41-vm8.bullet.mail.gq1.yahoo.com [67.195.87.95]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id F0F9A60CE5 for ; Thu, 30 Jun 2016 10:23:32 +0000 (UTC) Received: from [127.0.0.1] by nm41.bullet.mail.gq1.yahoo.com with NNFMP; 30 Jun 2016 10:23:25 -0000 Received: from [98.137.12.189] by nm41.bullet.mail.gq1.yahoo.com with NNFMP; 30 Jun 2016 10:20:23 -0000 Received: from [106.10.166.60] by tm10.bullet.mail.gq1.yahoo.com with NNFMP; 30 Jun 2016 10:20:23 -0000 Received: from [106.10.151.187] by tm17.bullet.mail.sg3.yahoo.com with NNFMP; 30 Jun 2016 10:20:23 -0000 Received: from [127.0.0.1] by omp1013.mail.sg3.yahoo.com with NNFMP; 30 Jun 2016 10:20:23 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 46805.87147.bm@omp1013.mail.sg3.yahoo.com X-YMail-OSG: FLlzGKcVM1kjQQzYqhdaLzeaAZu_Udi_lqp4qgJ0uW4z8FJU7r7yPE98inYTymL OX0PVdSmvGcTsSOdkfzPzbhWhdR0BiaGPn0hjvFB0XLqjamRKhJqBmYtd9PHSCoYndFrtWVmVfcv cNqO5zR.L8fIRRtB.lBXCBL043OWl32VH9kVTgKRKp0aTDcFYsKEQuyDufsf0n._jBC7SeEhtgrx GN7mEAd9i1SjZ.Okz63Qn1IKQcsmW5DuyxCzriY.sWWirRpmJju5g7MWn5KBcFd5er3pir7n_uIi awC4FWb995VzLHO9Ae_UYHou6kdpzv5_l6_CuR9VXootdLgbS6JsbGrnTVyd_PLFJdS03oTkRA_k EHgAkAe8e8KBqgXFsg9P6XlVh6zYp19RnB3TsLRfYYJfOPGa8jrgHny9NVHQvJ0i9CtO4D72hl1e oLueVFjwAP2r1HASV4fcDkswKRc.aV4zfI7keOSoINPxPQqWg_CSG6uQD7oad7hkZKRyxYi7raiR wQHA1YoCXjjk- Received: from jws10921.mail.sg3.yahoo.com by sendmailws107.mail.sg3.yahoo.com; Thu, 30 Jun 2016 10:20:22 +0000; 1467282022.601 Date: Thu, 30 Jun 2016 10:20:09 +0000 (UTC) From: Reply-To: To: "dev@fineract.incubator.apache.org" Cc: Nayan Ambali , Dayna Harp , Mifos Software Development , =?UTF-8?Q?Markus_Gei=C3=9F?= , Ed Cable , Nazeer Shaik Message-ID: <1579040934.19179.1467282009936.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: <885106974.2890046.1467203862137.JavaMail.yahoo.ref@mail.yahoo.com> <885106974.2890046.1467203862137.JavaMail.yahoo@mail.yahoo.com> <30B433A1-9724-4978-A278-9320CFF29329@theupscale.in> Subject: Re: [IMPORTANT] Query regarding standard address table MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19178_195304003.1467282009930" archived-at: Thu, 30 Jun 2016 10:23:41 -0000 ------=_Part_19178_195304003.1467282009930 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I could not convince myself with your third point.Let me explain by taking = a simple use case of slum dwellers in Mumbai.In Mumbai there is one governm= ent scheme named as 'SRA' wherein slum dwellers are given houses in buildin= g in exchange of their slums.In between this exchange, there is a time slot= of 4-5 years wherein slum dwellers have address proof of their slums( whic= h is not in existence now) and are currently living in temporary accommodat= ion( whose address proof) they don't have.Only in such cases it makes sense= to store two addresses( permanent and current). In rest of the cases, we w= ould rather go with permanent address, instead of storing two same address.= So is there still a need of storing a boolean value.Let me know your view o= n this. Regards,Nikhil From: Saransh Sharma To: dev@fineract.incubator.apache.org=20 Cc: Nayan Ambali ; NIKHIL PAWAR ; Dayna Harp ; Mifos Software Development ; Markus Gei=C3=9F ; Ed Cable <= edcable@mifos.org>; Nazeer Shaik Sent: Thursday, 30 June 2016 3:29 PM Subject: Re: [IMPORTANT] Query regarding standard address table =20 See, the flow is generic while adding addresses for the customer the basic flow should be, 1 Address Type as suggested by Srinivasan but it should not duplicate the same address type we should be able to add more, addressType as per the requirements once the addressType is created it should not create the same addressType again 2 State Type we can load it from CodeValues 3. There are some cases when the customer have same address for case like Permanent and Residential a boolean for sameAddressType should be introduced or isBoth kind of boolean should be introduced and once the addresses are same it should not create new address type with the following one, On Thu, Jun 30, 2016 at 3:20 PM Nikhil Pawar wrote: > Latitude and longitude are also the attributes along with other fields of > the address table. > > Regards, > Nikhil > > On Thu, Jun 30, 2016 at 3:15 PM, Saransh Sharma > wrote: > > > What about geo mapping ? which enables the latitude and longitude from > > google maps or some other service > > > > On Thu, Jun 30, 2016 at 2:41 PM Nikhil Pawar wrote= : > > > > > Hello All, > > > > > > Please find the attached schema diagram of the proposed Address and > > > related configuration tables. > > > A quick description of the diagram: > > > Address table: > > > The fields of the address table would be configurable. The user can > > select > > > the field via field configuration table. > > > Rest of the fields are self explanatory. > > > > > > > > > On Thu, Jun 30, 2016 at 1:48 PM, Ankit Sharma > > wrote: > > > > > >> Hi team, > > >> We have already made addresses - official, residential and permanent > as > > a > > >> standard feature of CB. > > >> Looking forward on this. > > >> > > >> Ankit Sharma > > >> Upscale > > >> > > >> > On 30-Jun-2016, at 1:42 PM, Ashok > > >> wrote: > > >> > > > >> > +1 > > >> > > > >> > It makes sense to have a standard address with minimal fields to > > >> support CB > > >> > or any other integrations and can be extended/configurable by > > >> organization. > > >> > > > >> > Thanks and Regards, > > >> > Ashok > > >> > > > >> > On Wed, Jun 29, 2016 at 6:19 PM, Nayan Ambali < > nayan.ambali@gmail.com > > > > > >> > wrote: > > >> > > > >> >> Dayna, Markus, > > >> >> > > >> >> I feel, adding standard address to customer solves other problems > > too, > > >> >> example address can be made mandatory before activating client, > > >> address can > > >> >> be capture along with customer creation, Geo location based servi= ce > > on > > >> >> Android can built. > > >> >> > > >> >> i vote for adding client address as standard(out of box) feature. > > >> >> > > >> >> Thanks > > >> >> Nayan Ambali > > >> >> > > >> >> > > >> >> > > >> >> Thanks and Regards, > > >> >> Nayan Ambali > > >> >> +91 9591996042 > > >> >> skype: nayangambali > > >> >> > > >> >>> On Wed, Jun 29, 2016 at 6:07 PM, wrote: > > >> >>> > > >> >>> Hello Devs, > > >> >>> > > >> >>> While designing the credit bureau module, I came across few desi= gn > > >> >>> questions and I wanted community's opinion on that. > > >> >>> When you make a credit check query, the credit bureau expects yo= u > to > > >> send > > >> >>> the address along with few other identifiers. > > >> >>> > > >> >>> In order to fetch the address fields in a more hassle free and > less > > >> error > > >> >>> prone way, I was thinking if we can standardize the address as > core > > >> table. > > >> >>> By standardizing this address table, we may remove the need for > > >> defining > > >> >>> custom data table for storing addresses. > > >> >>> > > >> >>> Let me know your thoughts on this proposal of mine. > > >> >>> > > >> >>> Regards, > > >> >>> Nikhil > > >> >> > > >> > > > > > > > > > ------=_Part_19178_195304003.1467282009930--