{"id":311,"date":"2011-04-21T12:08:00","date_gmt":"2011-04-21T12:08:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=311"},"modified":"2011-04-21T12:08:00","modified_gmt":"2011-04-21T12:08:00","slug":"phone-and-email-structure-changed-in-sage-crm7-1","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/","title":{"rendered":"Phone and Email Structure Changed in Sage CRM7.1"},"content":{"rendered":"

In the Sage CRM version we found that Sage has done away with the Pers_PhoneCountryCode, Pers_PhoneAreaCode and Pers_PhoneNumber fields for phone and Pers_FaxCountryCode, Pers_FaxAreaCode and Pers_FaxNumber for fax numbers which were part of the person table. Likewise, the pers_emailaddress field has been excluded from the person table.<\/o:p><\/span><\/p>\n

Now this data would be stored in Phone and PhoneLink table and will be linked to the person in the person table. The phone table would store the phone number and the link table would specify if it was linked to company and\/or person. Similarly the Email data is stored in Email and EmailLink table.<\/o:p><\/span><\/p>\n

Pretty neat!! I never quite understood why CRM was storing the same information at two different places. <\/o:p><\/span><\/p>\n

So all the customizations\/scripts that were referring the phone and email fields better watch our when you do the upgrade. These scripts would tend to crash and hence you will have to make the necessary modification to refer the new fields.<\/o:p><\/span><\/p>\n

The next thing on my wish list is to enter any number of phone records and should not be restricted to the ones shown on the screen. I can very well have customers who have 2 business phone numbers in my CRM. I wonder when this idea will see the light of the day. <\/span><\/o:p><\/b><\/p>\n

If you find this content useful, please drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

In the Sage CRM version we found that Sage has done away with the Pers_PhoneCountryCode, Pers_PhoneAreaCode and Pers_PhoneNumber fields for phone and Pers_FaxCountryCode, Pers_FaxAreaCode and Pers_FaxNumber for fax numbers which were part of the person table. Likewise, the pers_emailaddress field has been excluded from the person table. Now this data would be stored in Phone\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[332],"tags":[1025,1517,1765,2357],"class_list":["post-311","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-e-mail","tag-link","tag-phone","tag-structure"],"yoast_head":"\nPhone and Email Structure Changed in Sage CRM7.1 - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Phone and Email Structure Changed in Sage CRM7.1 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In the Sage CRM version we found that Sage has done away with the Pers_PhoneCountryCode, Pers_PhoneAreaCode and Pers_PhoneNumber fields for phone and Pers_FaxCountryCode, Pers_FaxAreaCode and Pers_FaxNumber for fax numbers which were part of the person table. Likewise, the pers_emailaddress field has been excluded from the person table. Now this data would be stored in Phone\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-04-21T12:08:00+00:00\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/\",\"name\":\"Phone and Email Structure Changed in Sage CRM7.1 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2011-04-21T12:08:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Phone and Email Structure Changed in Sage CRM7.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Phone and Email Structure Changed in Sage CRM7.1 - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/","og_locale":"en_US","og_type":"article","og_title":"Phone and Email Structure Changed in Sage CRM7.1 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"In the Sage CRM version we found that Sage has done away with the Pers_PhoneCountryCode, Pers_PhoneAreaCode and Pers_PhoneNumber fields for phone and Pers_FaxCountryCode, Pers_FaxAreaCode and Pers_FaxNumber for fax numbers which were part of the person table. Likewise, the pers_emailaddress field has been excluded from the person table. Now this data would be stored in Phone\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2011-04-21T12:08:00+00:00","author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/","name":"Phone and Email Structure Changed in Sage CRM7.1 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2011-04-21T12:08:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/04\/21\/phone-and-email-structure-changed-in-sage-crm7-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Phone and Email Structure Changed in Sage CRM7.1"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=311"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/311\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}