{"id":9732,"date":"2015-02-18T05:12:35","date_gmt":"2015-02-18T05:12:35","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=9732"},"modified":"2015-02-18T05:12:35","modified_gmt":"2015-02-18T05:12:35","slug":"new-tables-views-and-log-files-introduced-in-sage-crm-7-3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/","title":{"rendered":"New Tables, Views and Log files introduced in Sage CRM 7.3"},"content":{"rendered":"

With the release of new version of Sage CRM always there comes a question in our mind \u201cWhat database and other changes will be there?\u201d From a technical consultants point of view we also need to think about the expected changes we need to make, as and when it comes to upgrading from previous version to a newer version of CRM. We also need to check whether our previous customizations will be supported after upgrade or not.
\nNew Stuff:<\/strong>\u00a0\u00a0<\/em><\/span>Error exporting reports to excel in CRM part 3<\/a>
\nThe above question made me think and write something about it, I found various information\u2019s in Sage CRM 7.3 documents and putting some of them together.
\nNew tables introduced:<\/strong>
\n1) MailChimpOpens
\n2) MailChimpSegments
\n3) MailChimpUnsubscribed
\n4) MailMergeRelatedInfo
\n5) EMarketingMessage
\n6) MailChimpBounced
\n7) MailChimpCampaign
\n8) MailChimpClicks
\n9) MailChimpClicksByEmail
\n10) SocialConnection
\nSocialConnection table is not in use but under scope of future implementation.
\nNew views introduced:\u00a0<\/strong>
\n1) vMailChimpBounced
\n2) vMailChimpCampaign
\n3) vMailChimpClicksByEmail
\n4) vMailChimpOpens
\n5) vMailChimpUnsubscribed
\n6) vOpposClosedYearOnYear
\n7) vSalesVsForecast
\nNew log files introduced:<\/strong>
\n1) 20150112mailchimp.log
\n2) 20150112social.log
\nAll tables, views and log file names are self-explanatory in nature due to their nomenclature.
\nAlthough it don\u2019t seems\u00a0 the normalization in 7.3 version requires major changes after upgrade but still we need to be doubly sure and\u00a0 test all the functionalities, I hope above information will be helpful in the process.
\nAlso Read:<\/strong><\/em><\/span>
\n1) Sage CRM 7.3 \u2013 Introduction of New Opportunity Workflow<\/a>
\n2) Troubleshooting MailChimp integration issue with Sage CRM 7.3<\/a>
\n3) Mailing reports after converting from Crystal Reports to PDF format<\/a>
\n4) File to PDF conversion using FOP<\/a>
\n5) Export To PDF functionality for Quotes in Sage CRM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

With the release of new version of Sage CRM always there comes a question in our mind \u201cWhat database and other changes will be there?\u201d From a technical consultants point of view we also need to think about the expected changes we need to make, as and when it comes to upgrading from previous version\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":[102,332,342,393,1,423],"tags":[921,1538,2143,2405],"class_list":["post-9732","post","type-post","status-publish","format-standard","hentry","category-database-sage-crm","category-sage-crm","category-sage-crm7-3","category-tables","category-uncategorized","category-view","tag-database","tag-log-files","tag-sage-crm7-3","tag-tables"],"yoast_head":"\nNew Tables, Views and Log files introduced in Sage CRM 7.3 - 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\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New Tables, Views and Log files introduced in Sage CRM 7.3 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"With the release of new version of Sage CRM always there comes a question in our mind \u201cWhat database and other changes will be there?\u201d From a technical consultants point of view we also need to think about the expected changes we need to make, as and when it comes to upgrading from previous version\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-18T05:12:35+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\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/\",\"name\":\"New Tables, Views and Log files introduced in Sage CRM 7.3 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2015-02-18T05:12:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New Tables, Views and Log files introduced in Sage CRM 7.3\"}]},{\"@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":"New Tables, Views and Log files introduced in Sage CRM 7.3 - 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\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/","og_locale":"en_US","og_type":"article","og_title":"New Tables, Views and Log files introduced in Sage CRM 7.3 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"With the release of new version of Sage CRM always there comes a question in our mind \u201cWhat database and other changes will be there?\u201d From a technical consultants point of view we also need to think about the expected changes we need to make, as and when it comes to upgrading from previous version\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-02-18T05:12:35+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\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/","name":"New Tables, Views and Log files introduced in Sage CRM 7.3 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2015-02-18T05:12:35+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/02\/18\/new-tables-views-and-log-files-introduced-in-sage-crm-7-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"New Tables, Views and Log files introduced in Sage CRM 7.3"}]},{"@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\/9732","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=9732"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9732\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=9732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=9732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=9732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}