OFBiz › OFBiz - User

Telecom Number

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 5 messages Options
Ron Wheeler
Reply | Threaded
Open this post in threaded view
♦
♦
|

Telecom Number

Ron Wheeler
The TelecomNumber entity seems to be missing a place for an extension.

<entity entity-name="TelecomNumber"
             package-name="org.ofbiz.party.contact"
             title="Telecommunications Number Entity">
       <field name="contactMechId" type="id-ne"></field>
       <field name="countryCode" type="very-short"></field>
       <field name="areaCode" type="very-short"></field>
       <field name="contactNumber" type="short-varchar"></field>
       <field name="askForName" type="name"></field> <!-- person or
department to ask for at this number -->
       <prim-key field="contactMechId"/>
       <relation type="one" fk-name="TEL_NUM_CMECH"
rel-entity-name="ContactMech">
         <key-map field-name="contactMechId"/>
       </relation>
       <index name="COUNTRY_CODE_IDX">
         <index-field name="countryCode"/>
       </index>
       <index name="AREA_CODE_IDX">
         <index-field name="areaCode"/>
       </index>
       <index name="CONTACT_NUMBER_IDX">
         <index-field name="contactNumber"/>
       </index>
     </entity>

--
Ron Wheeler
President
Artifact Software Inc
email: [hidden email]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

Pierre Smits
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Telecom Number

Pierre Smits
Ron,

Should you feel that this is an improvement the product could benefit form,
please register a JIRA issue.

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Thu, Jan 22, 2015 at 9:05 PM, Ron Wheeler <[hidden email]
> wrote:

> The TelecomNumber entity seems to be missing a place for an extension.
>
> <entity entity-name="TelecomNumber"
>             package-name="org.ofbiz.party.contact"
>             title="Telecommunications Number Entity">
>       <field name="contactMechId" type="id-ne"></field>
>       <field name="countryCode" type="very-short"></field>
>       <field name="areaCode" type="very-short"></field>
>       <field name="contactNumber" type="short-varchar"></field>
>       <field name="askForName" type="name"></field> <!-- person or
> department to ask for at this number -->
>       <prim-key field="contactMechId"/>
>       <relation type="one" fk-name="TEL_NUM_CMECH"
> rel-entity-name="ContactMech">
>         <key-map field-name="contactMechId"/>
>       </relation>
>       <index name="COUNTRY_CODE_IDX">
>         <index-field name="countryCode"/>
>       </index>
>       <index name="AREA_CODE_IDX">
>         <index-field name="areaCode"/>
>       </index>
>       <index name="CONTACT_NUMBER_IDX">
>         <index-field name="contactNumber"/>
>       </index>
>     </entity>
>
> --
> Ron Wheeler
> President
> Artifact Software Inc
> email: [hidden email]
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>
>
Ron Wheeler
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Telecom Number

Ron Wheeler
Thanks.
Just wanted to be sure that I was not missing anything.

Ron

On 22/01/2015 4:22 PM, Pierre Smits wrote:

> Ron,
>
> Should you feel that this is an improvement the product could benefit form,
> please register a JIRA issue.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Thu, Jan 22, 2015 at 9:05 PM, Ron Wheeler <[hidden email]
>> wrote:
>> The TelecomNumber entity seems to be missing a place for an extension.
>>
>> <entity entity-name="TelecomNumber"
>>              package-name="org.ofbiz.party.contact"
>>              title="Telecommunications Number Entity">
>>        <field name="contactMechId" type="id-ne"></field>
>>        <field name="countryCode" type="very-short"></field>
>>        <field name="areaCode" type="very-short"></field>
>>        <field name="contactNumber" type="short-varchar"></field>
>>        <field name="askForName" type="name"></field> <!-- person or
>> department to ask for at this number -->
>>        <prim-key field="contactMechId"/>
>>        <relation type="one" fk-name="TEL_NUM_CMECH"
>> rel-entity-name="ContactMech">
>>          <key-map field-name="contactMechId"/>
>>        </relation>
>>        <index name="COUNTRY_CODE_IDX">
>>          <index-field name="countryCode"/>
>>        </index>
>>        <index name="AREA_CODE_IDX">
>>          <index-field name="areaCode"/>
>>        </index>
>>        <index name="CONTACT_NUMBER_IDX">
>>          <index-field name="contactNumber"/>
>>        </index>
>>      </entity>
>>
>> --
>> Ron Wheeler
>> President
>> Artifact Software Inc
>> email: [hidden email]
>> skype: ronaldmwheeler
>> phone: 866-970-2435, ext 102
>>
>>


--
Ron Wheeler
President
Artifact Software Inc
email: [hidden email]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102

Ruth Hoffman-4
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Telecom Number

Ruth Hoffman-4
Hi Ron:
The extension should not be in the Telecom table because one phone
number can have many extensions. At least here in the states, that is
how it can work.

Take a look at the PartyContactMech Entity. This is where an extension
should go. One extension per party and not per Telecom number.

Best Regards,
Ruth Hoffman
http://www.aesolves.net


On 1/22/15 4:33 PM, Ron Wheeler wrote:

> Thanks.
> Just wanted to be sure that I was not missing anything.
>
> Ron
>
> On 22/01/2015 4:22 PM, Pierre Smits wrote:
>> Ron,
>>
>> Should you feel that this is an improvement the product could benefit
>> form,
>> please register a JIRA issue.
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, Jan 22, 2015 at 9:05 PM, Ron Wheeler
>> <[hidden email]
>>> wrote:
>>> The TelecomNumber entity seems to be missing a place for an extension.
>>>
>>> <entity entity-name="TelecomNumber"
>>>              package-name="org.ofbiz.party.contact"
>>>              title="Telecommunications Number Entity">
>>>        <field name="contactMechId" type="id-ne"></field>
>>>        <field name="countryCode" type="very-short"></field>
>>>        <field name="areaCode" type="very-short"></field>
>>>        <field name="contactNumber" type="short-varchar"></field>
>>>        <field name="askForName" type="name"></field> <!-- person or
>>> department to ask for at this number -->
>>>        <prim-key field="contactMechId"/>
>>>        <relation type="one" fk-name="TEL_NUM_CMECH"
>>> rel-entity-name="ContactMech">
>>>          <key-map field-name="contactMechId"/>
>>>        </relation>
>>>        <index name="COUNTRY_CODE_IDX">
>>>          <index-field name="countryCode"/>
>>>        </index>
>>>        <index name="AREA_CODE_IDX">
>>>          <index-field name="areaCode"/>
>>>        </index>
>>>        <index name="CONTACT_NUMBER_IDX">
>>>          <index-field name="contactNumber"/>
>>>        </index>
>>>      </entity>
>>>
>>> --
>>> Ron Wheeler
>>> President
>>> Artifact Software Inc
>>> email: [hidden email]
>>> skype: ronaldmwheeler
>>> phone: 866-970-2435, ext 102
>>>
>>>
>
>

Adrian Crum-3
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Telecom Number

Adrian Crum-3
Thank you Ruth! For the same reason, the "askForName" field does not
belong in that entity.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 1/22/2015 2:30 PM, Ruth Hoffman wrote:

> Hi Ron:
> The extension should not be in the Telecom table because one phone
> number can have many extensions. At least here in the states, that is
> how it can work.
>
> Take a look at the PartyContactMech Entity. This is where an extension
> should go. One extension per party and not per Telecom number.
>
> Best Regards,
> Ruth Hoffman
> http://www.aesolves.net
>
>
> On 1/22/15 4:33 PM, Ron Wheeler wrote:
>> Thanks.
>> Just wanted to be sure that I was not missing anything.
>>
>> Ron
>>
>> On 22/01/2015 4:22 PM, Pierre Smits wrote:
>>> Ron,
>>>
>>> Should you feel that this is an improvement the product could benefit
>>> form,
>>> please register a JIRA issue.
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>> Services & Solutions for Cloud-
>>> Based Manufacturing, Professional
>>> Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>> On Thu, Jan 22, 2015 at 9:05 PM, Ron Wheeler
>>> <[hidden email]
>>>> wrote:
>>>> The TelecomNumber entity seems to be missing a place for an extension.
>>>>
>>>> <entity entity-name="TelecomNumber"
>>>>              package-name="org.ofbiz.party.contact"
>>>>              title="Telecommunications Number Entity">
>>>>        <field name="contactMechId" type="id-ne"></field>
>>>>        <field name="countryCode" type="very-short"></field>
>>>>        <field name="areaCode" type="very-short"></field>
>>>>        <field name="contactNumber" type="short-varchar"></field>
>>>>        <field name="askForName" type="name"></field> <!-- person or
>>>> department to ask for at this number -->
>>>>        <prim-key field="contactMechId"/>
>>>>        <relation type="one" fk-name="TEL_NUM_CMECH"
>>>> rel-entity-name="ContactMech">
>>>>          <key-map field-name="contactMechId"/>
>>>>        </relation>
>>>>        <index name="COUNTRY_CODE_IDX">
>>>>          <index-field name="countryCode"/>
>>>>        </index>
>>>>        <index name="AREA_CODE_IDX">
>>>>          <index-field name="areaCode"/>
>>>>        </index>
>>>>        <index name="CONTACT_NUMBER_IDX">
>>>>          <index-field name="contactNumber"/>
>>>>        </index>
>>>>      </entity>
>>>>
>>>> --
>>>> Ron Wheeler
>>>> President
>>>> Artifact Software Inc
>>>> email: [hidden email]
>>>> skype: ronaldmwheeler
>>>> phone: 866-970-2435, ext 102
>>>>
>>>>
>>
>>
>
Free forum by Nabble Edit this page