{"id":7445,"date":"2014-03-20T14:04:30","date_gmt":"2014-03-20T14:04:30","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=7445"},"modified":"2014-03-20T14:04:30","modified_gmt":"2014-03-20T14:04:30","slug":"get-rid-of-demo-data-on-crm-install","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/","title":{"rendered":"Get rid of demo data on CRM install"},"content":{"rendered":"

While installing Sage CRM, most of the times we install demo data either purposely or by mistake. Demo data does help in case of product Demos, testing etc. however at the time of going live with implementation we do have to flush out the same.
\nGUMU Sage CRM Integrations: <\/strong><\/em>Sage 100 ERP<\/a> | Sage 500 ERP<\/a> | Sage Pro ERP<\/a> | QuickBooks<\/a><\/strong><\/span><\/span>
\n<\/a>
\nNow coming back to our topic, easiest way to get rid of the data is by truncating entity tables. But it seems quite difficult job for non-technical users. Here is more \u00a0simpler approach.
\nNote<\/strong><\/span> – Please ensure proper backups are taken before you do this.<\/span>
\nSage CRM installation creates \u201cnodemodata.es\u201d file at the path \u201cC:\\Program Files (x86)\\Sage\\CRM\\CRM\\Setup\\ES\u201d. This file is utilised by SageCRM installation process to flush demo data. This component itself can be run manually to truncate demo data. Here is how.
\n1. Prepare component folder structure for nodemodata.es by creating .ecf file. While doing the same, you need to remove few lines of code in nodemodat.es file. You have to remove syntax of the if loop.
\ne.g. After opening nodemodata.es file, you will see code written as below.
\nif (iDatabase == IOracle){
\nRunSQL(‘delete from Address’);
\nRunSQL(‘delete from Address_Link’);
\nRunSQL(‘delete from Campaigns’);
\nRunSQL(‘delete from CaseProgress’);
\nRunSQL(‘delete from Cases’);
\nRunSQL(‘delete from Communication’);
\nRunSQL(‘delete from Comm_Link’);
\nRunSQL(‘delete from Company’);
\nRunSQL(‘delete from Currency’);
\nRunSQL(‘delete from Email’);
\nRunSQL(‘delete from Marketing’);
\n\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026. continue
\n}
\nYou need to modify code as below and save the file. I have removed only if loop.
\nRunSQL(‘delete from Address’);
\nRunSQL(‘delete from Address_Link’);
\nRunSQL(‘delete from Campaigns’);
\nRunSQL(‘delete from CaseProgress’);
\nRunSQL(‘delete from Cases’);
\nRunSQL(‘delete from Communication’);
\nRunSQL(‘delete from Comm_Link’);
\nRunSQL(‘delete from Company’);
\nRunSQL(‘delete from Currency’);
\nRunSQL(‘delete from Email’);
\nRunSQL(‘delete from Marketing’);
\n\u2026\u2026\u2026\u2026\u2026\u2026\u2026..continue
\n2.Place these files under the \u201cinf\u201d folder under CRM directory with proper component.
\n3. Now go to Administration<\/b> || Customization<\/b> || Component Manager<\/b>
\n4. You will see respective component under Component<\/b>s Tab in Available Components<\/b> window.
\n5. Select that component and Install. Refer below screenshot.<\/b><\/p>\n

\"PIC1\"<\/a><\/p>\n

6. After running you will see notification on screen as \u201cComponent Installed<\/b>\u201d then click on \u201cContinue<\/b>\u201d button and check.
\n7. You will see all demo data is deleted from system.
\nAlso Read:<\/strong><\/em><\/span>
\n1) Advanced Options in Component Manager<\/a>
\n2) Creating Component and generating Script files<\/a>
\n3) Run SQL Queries through Sage CRM Components<\/a>
\n4) Sage CRM 7.2 Facebook Component<\/a>
\n5) Sage CRM Mapping Component<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

While installing Sage CRM, most of the times we install demo data either purposely or by mistake. Demo data does help in case of product Demos, testing etc. however at the time of going live with implementation we do have to flush out the same. GUMU Sage CRM Integrations: Sage 100 ERP | Sage 500\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":[72,112,113,158,332,1],"tags":[736,945,952,1162],"class_list":["post-7445","post","type-post","status-publish","format-standard","hentry","category-component-sage-crm","category-deleted","category-demo-data","category-flush","category-sage-crm","category-uncategorized","tag-component","tag-delete","tag-demo-data","tag-flush"],"yoast_head":"\nGet rid of demo data on CRM install - 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\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get rid of demo data on CRM install - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"While installing Sage CRM, most of the times we install demo data either purposely or by mistake. Demo data does help in case of product Demos, testing etc. however at the time of going live with implementation we do have to flush out the same. GUMU Sage CRM Integrations: Sage 100 ERP | Sage 500\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-20T14:04:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/\",\"name\":\"Get rid of demo data on CRM install - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png\",\"datePublished\":\"2014-03-20T14:04:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get rid of demo data on CRM install\"}]},{\"@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":"Get rid of demo data on CRM install - 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\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/","og_locale":"en_US","og_type":"article","og_title":"Get rid of demo data on CRM install - Sage CRM \u2013 Tips, Tricks and Components","og_description":"While installing Sage CRM, most of the times we install demo data either purposely or by mistake. Demo data does help in case of product Demos, testing etc. however at the time of going live with implementation we do have to flush out the same. GUMU Sage CRM Integrations: Sage 100 ERP | Sage 500\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-03-20T14:04:30+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/","name":"Get rid of demo data on CRM install - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png","datePublished":"2014-03-20T14:04:30+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/03\/PIC1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/03\/20\/get-rid-of-demo-data-on-crm-install\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Get rid of demo data on CRM install"}]},{"@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\/7445","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=7445"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/7445\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=7445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=7445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=7445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}