{"id":11570,"date":"2015-12-07T08:41:44","date_gmt":"2015-12-07T08:41:44","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=11570"},"modified":"2015-12-07T08:41:44","modified_gmt":"2015-12-07T08:41:44","slug":"error-with-account-manager-field-while-uploading-company-data","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/","title":{"rendered":"Error with Account Manager field while uploading Company Data"},"content":{"rendered":"

As we all know that using Data Upload feature of Sage CRM<\/a> we can update our system with required information and then the system can be handed over to user to make use of functionality. The Data Upload feature comes with default options to upload Company, Contacts and Leads.<\/p>\n

New Stuff:<\/strong><\/span>\u00a0<\/em>IIS Configuration for Sage CRM<\/a><\/p>\n

Recently, while working on company data upload for one of the customer we encountered with an error which says \u201cInvalid Integer Value\u201d <\/strong>for Account Manager <\/strong>Field. See below screenshot for your reference.<\/p>\n

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

On checking the upload sheet I found that Account Manager Field was containing full name of the user i.e. System Administrator<\/strong> and system was considering it as integer value. So, to rectify this we entered the User Logon<\/strong> name instead full name and uploaded the sheet once again.<\/p>\n

Once the upload sheet is rectified, user has to map the Account Manager<\/strong> Field with User Logon Id <\/strong>from data upload mapping screen as shown below and data will be uploaded successfully.
\n\"DataFile\"<\/a>
\nAlso Read:<\/span><\/em><\/strong>
\n1.<\/strong> Sage CRM Mapping component to upload data from Excel<\/a>
\n2.<\/strong> Troubleshooting Sage CRM\u2019s Customized Data Upload Routine Issue<\/a>
\n3.<\/strong> Data Upload using Deduplication<\/a>
\n4.<\/strong> Error in Uploading companies using CSV file with Date & Integer columns<\/a>
\n5.<\/strong> Create log file using .net API<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

As we all know that using Data Upload feature of Sage CRM we can update our system with required information and then the system can be handed over to user to make use of functionality. The Data Upload feature comes with default options to upload Company, Contacts and Leads. New Stuff:\u00a0IIS Configuration for Sage CRM\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,101,332,1],"tags":[490,724,718,916,1431],"class_list":["post-11570","post","type-post","status-publish","format-standard","hentry","category-customer","category-data-upload","category-sage-crm","category-uncategorized","tag-account-manager-field","tag-company-data-upload","tag-comp_primaryuserid","tag-data-upload","tag-integer-value"],"yoast_head":"\nError with Account Manager field while uploading Company Data - 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\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error with Account Manager field while uploading Company Data - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As we all know that using Data Upload feature of Sage CRM we can update our system with required information and then the system can be handed over to user to make use of functionality. The Data Upload feature comes with default options to upload Company, Contacts and Leads. New Stuff:\u00a0IIS Configuration for Sage CRM\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-07T08:41:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.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\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/\",\"name\":\"Error with Account Manager field while uploading Company Data - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.jpg\",\"datePublished\":\"2015-12-07T08:41:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error with Account Manager field while uploading Company Data\"}]},{\"@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 with Account Manager field while uploading Company Data - 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\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/","og_locale":"en_US","og_type":"article","og_title":"Error with Account Manager field while uploading Company Data - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As we all know that using Data Upload feature of Sage CRM we can update our system with required information and then the system can be handed over to user to make use of functionality. The Data Upload feature comes with default options to upload Company, Contacts and Leads. New Stuff:\u00a0IIS Configuration for Sage CRM\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-12-07T08:41:44+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.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\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/","name":"Error with Account Manager field while uploading Company Data - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.jpg","datePublished":"2015-12-07T08:41:44+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/12\/ErrorPage.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/12\/07\/error-with-account-manager-field-while-uploading-company-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Error with Account Manager field while uploading Company Data"}]},{"@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\/11570","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=11570"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/11570\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=11570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=11570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=11570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}