{"id":15743,"date":"2011-11-21T07:17:40","date_gmt":"2011-11-21T07:17:40","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=434"},"modified":"2011-11-21T07:17:40","modified_gmt":"2011-11-21T07:17:40","slug":"error-in-uploading-companies-using-csv-file-with-date-integer-columns-2","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/","title":{"rendered":"Error in Uploading companies using CSV file with Date & Integer columns"},"content":{"rendered":"

As you might be familiar with the standard import processes, you can upload data using CSV as well as Excel files. Excel stores the data column-wise hence we don\u2019t get data type conflict errors so often. However in CSV the data is stored comma separated and sometimes programs don\u2019t understand the data type of the columns like Date, Integer etc. We start getting warning messages that Integer field is not recognized as Integer\/ Date field is not recognized as Date time. There is a simple and effective workaround to make this work.
\nWhen a Date field is used in CSV file and same has been used to upload data into CRM through standard upload functionality at that time CSV file considers the date column as a text. So, whenever this data sheet is uploaded to CRM it gives error message. To resolve this, what you need to do is to use the date in specific format i.e. DDMMYYYY <\/strong>in the columns you want to use as Date.
\nFor handling Integer field values, you have to make some changes in your Registry. To do the same refer the steps below.
\n1.\u00a0 Go to Start<\/strong>.
\n2.\u00a0 Select RUN <\/strong>and type \u201cRegedit<\/strong>\u201d.
\n3.\u00a0 Go to this Path: \u201cMy Computer <\/strong>–> HKEY_LOCAL_MACHINE\u00a0<\/strong>–> SOFTWARE\u00a0<\/strong>–> Microsoft <\/strong>–> Jet <\/strong>–> 4.0<\/strong> –> Engines <\/strong>–> Text<\/strong>\u201d.
\n4.\u00a0 In Text<\/strong>, Set MaxScanRows <\/strong>= 0.
\n5.\u00a0 Click on \u201cOK<\/strong>\u201d button. Refer the screenshot below.
\n

\"Registry\"<\/a>

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

As you might be familiar with the standard import processes, you can upload data using CSV as well as Excel files. Excel stores the data column-wise hence we don\u2019t get data type conflict errors so often. However in CSV the data is stored comma separated and sometimes programs don\u2019t understand the data type of the\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":[71,184,332],"tags":[],"class_list":["post-15743","post","type-post","status-publish","format-standard","hentry","category-company","category-import-sage-crm","category-sage-crm"],"yoast_head":"\nError in Uploading companies using CSV file with Date & Integer columns - 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\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error in Uploading companies using CSV file with Date & Integer columns - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As you might be familiar with the standard import processes, you can upload data using CSV as well as Excel files. Excel stores the data column-wise hence we don\u2019t get data type conflict errors so often. However in CSV the data is stored comma separated and sometimes programs don\u2019t understand the data type of the\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-21T07:17:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg\" \/>\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\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/\",\"name\":\"Error in Uploading companies using CSV file with Date & Integer columns - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg\",\"datePublished\":\"2011-11-21T07:17:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error in Uploading companies using CSV file with Date & Integer columns\"}]},{\"@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":"Error in Uploading companies using CSV file with Date & Integer columns - 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\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/","og_locale":"en_US","og_type":"article","og_title":"Error in Uploading companies using CSV file with Date & Integer columns - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As you might be familiar with the standard import processes, you can upload data using CSV as well as Excel files. Excel stores the data column-wise hence we don\u2019t get data type conflict errors so often. However in CSV the data is stored comma separated and sometimes programs don\u2019t understand the data type of the\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2011-11-21T07:17:40+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg","type":"","width":"","height":""}],"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\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/","name":"Error in Uploading companies using CSV file with Date & Integer columns - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg","datePublished":"2011-11-21T07:17:40+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2011\/11\/screen11.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/11\/21\/error-in-uploading-companies-using-csv-file-with-date-integer-columns-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Error in Uploading companies using CSV file with Date & Integer columns"}]},{"@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\/15743","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=15743"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/15743\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=15743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=15743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=15743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}