{"id":104,"date":"2019-09-22T20:22:31","date_gmt":"2019-09-22T20:22:31","guid":{"rendered":"https:\/\/gurumybusinesspos.com\/hints\/?p=104"},"modified":"2019-09-22T20:22:31","modified_gmt":"2019-09-22T20:22:31","slug":"error-al-importar-articulos-desde-excel","status":"publish","type":"post","link":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/","title":{"rendered":"Error al Importar Articulos desde Excel"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-medium wp-image-100\" src=\"https:\/\/i0.wp.com\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg?resize=300%2C225&#038;ssl=1\" alt=\"\" width=\"300\" height=\"225\" \/>Button_Click ProdsExcel<br \/><!--StartFragment--><\/p>\n\n\n<p class=\"has-text-color has-background has-drop-cap has-very-light-gray-color has-vivid-red-background-color wp-block-paragraph\">Este error se genera por que MyBusiness Pos no menciona que de acuerdo al archivo de Excel Articulos.XLS, que se encuentra en la carpeta de instalaci\u00f3n del programa, contiene una columna con el nombre: Linea<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Es preciso por lo menos poner la palabra SYS, para que cuando se realice la importaci\u00f3n no este vac\u00edo ese campo.<\/p>\n\n\n\n<p class=\"has-background has-light-green-cyan-background-color wp-block-paragraph\">Para evitar otro de estos errores hay que capturar primero las lineas en MyBusiness Pos que se vayan a usar en la lista de productos. Ojo debe de ponerse el nombre clave de la linea, NO la descripci\u00f3n.<\/p>\n\n\n<p><!--EndFragment--><br>\n<br>\n<\/p>","protected":false},"excerpt":{"rendered":"<p>Button_Click ProdsExcel Este error se genera por que MyBusiness Pos no menciona que de acuerdo al archivo de Excel Articulos.XLS, que se encuentra en la carpeta de instalaci\u00f3n del programa, contiene una columna con el nombre: Linea Es preciso por lo menos poner la palabra SYS, para que cuando se realice la importaci\u00f3n no este<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[14],"tags":[33,54,274,305,353,448],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry","category-errores-comunes","tag-33","tag-54","tag-excel","tag-foreign-key","tag-lineas","tag-prodsexcel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Error al Importar Articulos desde Excel - Guru MyBusinessPos<\/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:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error al Importar Articulos desde Excel - Guru MyBusinessPos\" \/>\n<meta property=\"og:description\" content=\"Button_Click ProdsExcel Este error se genera por que MyBusiness Pos no menciona que de acuerdo al archivo de Excel Articulos.XLS, que se encuentra en la carpeta de instalaci\u00f3n del programa, contiene una columna con el nombre: Linea Es preciso por lo menos poner la palabra SYS, para que cuando se realice la importaci\u00f3n no este\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Guru MyBusinessPos\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/doncarloslozao\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-22T20:22:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DonMyBusiness\" \/>\n<meta name=\"twitter:site\" content=\"@DonMyBusiness\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/#\\\/schema\\\/person\\\/ca38407de0944c4b4ec791790b07fec7\"},\"headline\":\"Error al Importar Articulos desde Excel\",\"datePublished\":\"2019-09-22T20:22:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/\"},\"wordCount\":108,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg\",\"keywords\":[\"-2147217873\",\"118\",\"Excel\",\"foreign key\",\"lineas\",\"prodsexcel\"],\"articleSection\":[\"Errores Comunes\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/\",\"url\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/\",\"name\":\"Error al Importar Articulos desde Excel - Guru MyBusinessPos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg\",\"datePublished\":\"2019-09-22T20:22:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/#\\\/schema\\\/person\\\/ca38407de0944c4b4ec791790b07fec7\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg\",\"contentUrl\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/2019\\\/09\\\/22\\\/error-al-importar-articulos-desde-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error al Importar Articulos desde Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/#website\",\"url\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/\",\"name\":\"Guru MyBusinessPos\",\"description\":\"Soporte y Asistencia\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\\\/#\\\/schema\\\/person\\\/ca38407de0944c4b4ec791790b07fec7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/40f37c68d68a66dba6621b239bdf45a95def8a69cc765ebc5df652982b325018?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/40f37c68d68a66dba6621b239bdf45a95def8a69cc765ebc5df652982b325018?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/40f37c68d68a66dba6621b239bdf45a95def8a69cc765ebc5df652982b325018?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/gurumybusinesspos.com\\\/hints\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Error al Importar Articulos desde Excel - Guru MyBusinessPos","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:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Error al Importar Articulos desde Excel - Guru MyBusinessPos","og_description":"Button_Click ProdsExcel Este error se genera por que MyBusiness Pos no menciona que de acuerdo al archivo de Excel Articulos.XLS, que se encuentra en la carpeta de instalaci\u00f3n del programa, contiene una columna con el nombre: Linea Es preciso por lo menos poner la palabra SYS, para que cuando se realice la importaci\u00f3n no este","og_url":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/","og_site_name":"Guru MyBusinessPos","article_publisher":"http:\/\/www.facebook.com\/doncarloslozao","article_published_time":"2019-09-22T20:22:31+00:00","og_image":[{"url":"https:\/\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@DonMyBusiness","twitter_site":"@DonMyBusiness","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#article","isPartOf":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/"},"author":{"name":"admin","@id":"https:\/\/gurumybusinesspos.com\/hints\/#\/schema\/person\/ca38407de0944c4b4ec791790b07fec7"},"headline":"Error al Importar Articulos desde Excel","datePublished":"2019-09-22T20:22:31+00:00","mainEntityOfPage":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/"},"wordCount":108,"commentCount":0,"image":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg","keywords":["-2147217873","118","Excel","foreign key","lineas","prodsexcel"],"articleSection":["Errores Comunes"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/","url":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/","name":"Error al Importar Articulos desde Excel - Guru MyBusinessPos","isPartOf":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/#website"},"primaryImageOfPage":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#primaryimage"},"image":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg","datePublished":"2019-09-22T20:22:31+00:00","author":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/#\/schema\/person\/ca38407de0944c4b4ec791790b07fec7"},"breadcrumb":{"@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#primaryimage","url":"https:\/\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg","contentUrl":"https:\/\/gurumybusinesspos.com\/hints\/wp-content\/uploads\/2019\/09\/Error-al-importar-Lineas-ProdsExcel-300x225.jpeg"},{"@type":"BreadcrumbList","@id":"https:\/\/gurumybusinesspos.com\/hints\/2019\/09\/22\/error-al-importar-articulos-desde-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/gurumybusinesspos.com\/hints\/"},{"@type":"ListItem","position":2,"name":"Error al Importar Articulos desde Excel"}]},{"@type":"WebSite","@id":"https:\/\/gurumybusinesspos.com\/hints\/#website","url":"https:\/\/gurumybusinesspos.com\/hints\/","name":"Guru MyBusinessPos","description":"Soporte y Asistencia","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gurumybusinesspos.com\/hints\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/gurumybusinesspos.com\/hints\/#\/schema\/person\/ca38407de0944c4b4ec791790b07fec7","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/40f37c68d68a66dba6621b239bdf45a95def8a69cc765ebc5df652982b325018?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/40f37c68d68a66dba6621b239bdf45a95def8a69cc765ebc5df652982b325018?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/40f37c68d68a66dba6621b239bdf45a95def8a69cc765ebc5df652982b325018?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/gurumybusinesspos.com\/hints"]}]}},"jetpack_featured_media_url":"","wps_subtitle":"","blog_post_layout_featured_media_urls":{"thumbnail":"","full":""},"categories_names":{"14":{"name":"Errores Comunes","link":"https:\/\/gurumybusinesspos.com\/hints\/category\/errores-comunes\/"}},"tags_names":{"33":{"name":"-2147217873","link":"https:\/\/gurumybusinesspos.com\/hints\/tag\/2147217873\/"},"54":{"name":"118","link":"https:\/\/gurumybusinesspos.com\/hints\/tag\/118\/"},"274":{"name":"Excel","link":"https:\/\/gurumybusinesspos.com\/hints\/tag\/excel\/"},"305":{"name":"foreign key","link":"https:\/\/gurumybusinesspos.com\/hints\/tag\/foreign-key\/"},"353":{"name":"lineas","link":"https:\/\/gurumybusinesspos.com\/hints\/tag\/lineas\/"},"448":{"name":"prodsexcel","link":"https:\/\/gurumybusinesspos.com\/hints\/tag\/prodsexcel\/"}},"comments_number":"0","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":0,"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"wp:attachment":[{"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gurumybusinesspos.com\/hints\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}