{"id":724,"date":"2017-05-23T13:01:47","date_gmt":"2017-05-23T16:01:47","guid":{"rendered":"http:\/\/www.rcodigital.com.br\/blog\/?p=724"},"modified":"2024-02-26T19:12:03","modified_gmt":"2024-02-26T19:12:03","slug":"como-importar-seus-dados-de-planilhas-para-o-sap-business-one","status":"publish","type":"post","link":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/","title":{"rendered":"Saiba como importar seus dados de planilhas para o SAP Business One"},"content":{"rendered":"<h1><span class=\"goog-text-highlight\">Saiba como importar seus dados de planilhas para o\u00a0<em>SAP Business One, <\/em>utilizando o\u00a0<em>Data Transfer Workbench<\/em>(<em>DTW<\/em>) <\/span><\/h1>\n<p><span class=\"goog-text-highlight\">Sempre que falamos sobre o uso e <a href=\"http:\/\/www.intergate.net.br\/blog\/sinais-que-seu-negocio-precisa-da-implementacao-de-um-erp\/\" target=\"_blank\" rel=\"noopener noreferrer\">implanta\u00e7\u00e3o<\/a> do <em>ERP<\/em> em uma organiza\u00e7\u00e3o, essa organiza\u00e7\u00e3o pode ter algum sistema legado do qual eles gostariam de importar seus dados de <a href=\"http:\/\/www.intergate.net.br\/blog\/gerencie-o-seu-negocio-com-planilhas-de-gestao\/\" target=\"_blank\" rel=\"noopener noreferrer\">planilhas<\/a> para o <em>SAP Business One<\/em>.\u00a0<\/span>Ou pode ser que eles estejam introduzindo um novo portal <em>web,<\/em> e precisam exportar os dados do<em> ERP\u00a0<\/em>para o respectivo<em>.<\/em><span class=\"Apple-converted-space\">\u00a0<\/span><\/p>\n<p><strong>Esta importa\u00e7\u00e3o e exporta\u00e7\u00e3o de dados parece f\u00e1cil de ouvir, mas \u00e9 incrivelmente complexa e dif\u00edcil se n\u00e3o for feito corretamente.<\/strong><span class=\"Apple-converted-space\">\u00a0<\/span><\/p>\n<p>Portanto, fa\u00e7a algo errado e voc\u00ea pode ter que limpar alguns <em>GB<\/em> de dados de lixo, pois esses s\u00e3o dados de neg\u00f3cios cr\u00edticos para os quais voc\u00ea precisa garantir o seu tratamento e integridade.<\/p>\n<h3>Veja como realizar os procedimentos passo a passo com <em>DTW<\/em><\/h3>\n<p><!--more--><\/p>\n<p><strong>O <em>Data Transfer Workbench<\/em>(<em>DTW<\/em>) suporta a transfer\u00eancia autom\u00e1tica, ou seja, permite\u00a0<span class=\"goog-text-highlight\">importar seus dados de planilhas <\/span><span class=\"goog-text-highlight\">para o <\/span><em><span class=\"goog-text-highlight\">SAP Business One<\/span><\/em><span class=\"goog-text-highlight\"> facilmente<\/span><\/strong>, concebido especificamente para transfer\u00eancias internas e, por vezes, externas.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/slideplayer.org\/7452059\/24\/images\/4\/Data+Transfer+Workbench+%28DTW%29.jpg\" alt=\"\" width=\"600\" height=\"450\" \/><\/p>\n<h3>Fun\u00e7\u00f5es<\/h3>\n<ul class=\"arrow\" style=\"margin: 0px 0px 1.25em; padding: 0px 0px 0px 2em; border: 0px; outline: 0px; font-size: 15px; vertical-align: baseline; background: #ffffff; list-style-image: url('\/\/www.appseconnect.com\/wp-content\/themes\/ignition\/images\/bullet.png'); line-height: 1.5em; color: #000000; font-family: Montserrat, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; text-align: justify;\">\n<li>Convers\u00e3o de dados usando o<em> Legacy System Migration Workbench<\/em><\/li>\n<li>Entrada em Lote<\/li>\n<li>Interface <em>BAPI<\/em><\/li>\n<li>T\u00e9cnicas de carregamento de dados<\/li>\n<li>Registro e integra\u00e7\u00e3o de seus pr\u00f3prios programas de transfer\u00eancia \/ ajuda de dados<\/li>\n<li>Integra\u00e7\u00e3o de programas de transfer\u00eancia de dados padr\u00e3o<\/li>\n<li>Ferramenta de an\u00e1lise de estrutura <em>SAP<\/em><\/li>\n<li>Administra\u00e7\u00e3o e Organiza\u00e7\u00e3o de Projetos de Transfer\u00eancia de Dados<\/li>\n<\/ul>\n<p>Essencialmente <strong>este \u00e9 o pipeline para o sistema<\/strong>, a rota entre sistemas de dados e de banco de dados.<\/p>\n<h3>Fonte<\/h3>\n<p>Quando <span class=\"goog-text-highlight\">importar seus dados de planilhas para o <a href=\"http:\/\/www.intergate.net.br\/blog\/porque-voce-precisa-do-sap-business-one\/\" target=\"_blank\" rel=\"noopener noreferrer\"><em>SAP Business One<\/em><\/a><\/span>, a fonte \u00e9 muito importante.<span class=\"Apple-converted-space\">\u00a0<\/span>Muitas vezes, <strong>a fonte de dados mais comumente utilizada para <a href=\"https:\/\/help.sap.com\/saphelp_nw70\/helpdata\/en\/0d\/e211c5543e11d1895d0000e829fbbd\/frameset.htm\" target=\"_blank\" rel=\"noopener noreferrer\"><em>DTW<\/em><\/a>\u00a0s\u00e3o documentos do\u00a0<em>MS Excel.<\/em><\/strong><em><span class=\"Apple-converted-space\">\u00a0<\/span><\/em><\/p>\n<p>A planilha utilizada\u00a0deve conter duas linhas na parte superior, uma linha de origem e uma linha de destino, com dados nas linhas seguintes. Para usar esse tipo de estrutura de arquivo dentro <em>DTW<\/em>, <strong>salve-o no formato<\/strong> &#8220;<em><strong>.cvs<\/strong>&#8220;<\/em> <strong>para que ele possa ser importado<\/strong>.<\/p>\n<h3><span class=\"goog-text-highlight\">Importar seus dados de planilhas para o <em>SAP Business One<\/em><\/span><\/h3>\n<ul class=\"arrow\" style=\"margin: 0px 0px 1.25em; padding: 0px 0px 0px 2em; border: 0px; outline: 0px; font-size: 15px; vertical-align: baseline; background: #ffffff; list-style-image: url('\/\/www.appseconnect.com\/wp-content\/themes\/ignition\/images\/bullet.png'); line-height: 1.5em; color: #000000; font-family: Montserrat, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; text-align: justify;\">\n<li>Abra o <em>DTW<\/em> e fa\u00e7a <em>login<\/em> na empresa onde voc\u00ea gostaria de importar os dados<\/li>\n<li>Uma vez conectado, selecione &#8220;Importar&#8221;, escolha o tipo de dados conforme os dados que deseja importar e clique em &#8220;Avan\u00e7ar&#8221;<\/li>\n<li>Especifique o tipo de opera\u00e7\u00e3o, escolha Objeto comercial a importar e clique em &#8220;Avan\u00e7ar&#8221;<\/li>\n<li>Escolha a fonte de dados, este deve ser o arquivo <em>&#8220;.cvs&#8221;,<\/em> e continue.<span class=\"Apple-converted-space\">\u00a0<\/span>Na p\u00e1gina &#8220;Campos de objeto de mapa&#8221;, certifique-se de que os dados de origem e os dados de destino est\u00e3o mapeados corretamente, incluindo as regras de mapeamento<\/li>\n<li>Siga os passos acima mencionados at\u00e9 o final e clique em &#8220;importar&#8221;.<span class=\"Apple-converted-space\">\u00a0<\/span>Ap\u00f3s a conclus\u00e3o voc\u00ea obter\u00e1 se algum erro ocorreu ou se tudo \u00e9 bem sucedido<\/li>\n<li>Agora voc\u00ea pode abrir o <em>SAP Business One<\/em> e localizar os dados rec\u00e9m-importados nos formul\u00e1rios correspondentes<\/li>\n<\/ul>\n<div id=\"attachment_726\" style=\"width: 875px\" class=\"wp-caption alignnone\"><img decoding=\"async\" aria-describedby=\"caption-attachment-726\" class=\"wp-image-726 size-full\" title=\"DTW - Tela de logon\" src=\"http:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/logon.png\" alt=\"Importar seus dados de planilhas para o SAP Business One\" width=\"865\" height=\"640\" srcset=\"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/logon.png 865w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/logon-600x444.png 600w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/logon-300x222.png 300w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/logon-768x568.png 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><p id=\"caption-attachment-726\" class=\"wp-caption-text\">DTW &#8211; Tela de logon<\/p><\/div>\n<div id=\"attachment_733\" style=\"width: 875px\" class=\"wp-caption alignnone\"><img decoding=\"async\" aria-describedby=\"caption-attachment-733\" class=\"wp-image-733 size-full\" title=\"DTW - sele\u00e7\u00e3o de tipo de dado (setup, master ou transacional)\" src=\"http:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/datatype.png\" alt=\"Importar seus dados de planilhas para o SAP Business One\" width=\"865\" height=\"640\" srcset=\"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/datatype.png 865w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/datatype-600x444.png 600w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/datatype-300x222.png 300w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/datatype-768x568.png 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><p id=\"caption-attachment-733\" class=\"wp-caption-text\">DTW &#8211; sele\u00e7\u00e3o de tipo de dado (setup, master ou transacional)<\/p><\/div>\n<div id=\"attachment_734\" style=\"width: 875px\" class=\"wp-caption alignnone\"><img decoding=\"async\" aria-describedby=\"caption-attachment-734\" class=\"wp-image-734 size-full\" title=\"DTW - Sele\u00e7\u00e3o de tipo de objeto de neg\u00f3cio\" src=\"http:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/businessobject.png\" alt=\"Importar seus dados de planilhas para o SAP Business One\" width=\"865\" height=\"640\" srcset=\"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/businessobject.png 865w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/businessobject-600x444.png 600w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/businessobject-300x222.png 300w, https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/businessobject-768x568.png 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><p id=\"caption-attachment-734\" class=\"wp-caption-text\">DTW &#8211; Sele\u00e7\u00e3o de tipo de objeto de neg\u00f3cio<\/p><\/div>\n<h2>Saiba mais&#8230;<\/h2>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-728\" src=\"http:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/download-e1495553506878.png\" alt=\"\" width=\"20\" height=\"21\" \/>\u00a0MANUAL PDF\u00a0&#8211; <a href=\"http:\/\/www.dei.isep.ipp.pt\/~jmendes\/SINFI-2005\/SAPB1_Documentation\/_Material\/Exercices\/02_Introduction\/02_DataTransferWB\/Data_Migration\/Documentation\/Data%20Transfer%20Workbench.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Data Transfer Workbench for SAP Business One &#8211; Release 1.1<\/a>\u00a0[26 p\u00e1g]<\/p>\n<p><a href=\"http:\/\/www.intergate.net.br\/blog\/category\/sap-business-one\/\"><\/a><\/p>\n<hr \/>\n<p><strong>FONTE<\/strong>: <em><a href=\"https:\/\/www.appseconnect.com\/how-to-do-data-transfer-workbench-in-sap-business-one\/\" target=\"_blank\" rel=\"noopener noreferrer\">APPSeConnect<\/a>, SAP<\/em><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o\u00a0Data Transfer Workbench(DTW) Sempre que falamos sobre o uso e implanta\u00e7\u00e3o do ERP em uma organiza\u00e7\u00e3o, essa organiza\u00e7\u00e3o pode ter algum sistema legado do qual eles gostariam de importar seus dados de planilhas para o SAP Business One.\u00a0Ou [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":725,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[7,10],"tags":[175,261,391,438],"class_list":["post-724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-integracao-de-sistemas","category-sap-business-one","tag-dtw","tag-implementacao-de-um-erp","tag-planilhas","tag-sap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Saiba como importar seus dados de planilhas para o SAP Business One<\/title>\n<meta name=\"description\" content=\"Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o Data Transfer Workbench(DTW) que suporta a transfer\u00eancia autom\u00e1tica.\" \/>\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.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Saiba como importar seus dados de planilhas para o SAP Business One\" \/>\n<meta property=\"og:description\" content=\"Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o Data Transfer Workbench(DTW) que suporta a transfer\u00eancia autom\u00e1tica.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog InterGATE\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-23T16:01:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-26T19:12:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/DTW-in-SAP-B11-e1510252740580.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"601\" \/>\n\t<meta property=\"og:image:height\" content=\"244\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Rafael Ogeda\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rafael Ogeda\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/\"},\"author\":{\"name\":\"Rafael Ogeda\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#\\\/schema\\\/person\\\/8efea68df8f7120ea0cf5bd5d855f919\"},\"headline\":\"Saiba como importar seus dados de planilhas para o SAP Business One\",\"datePublished\":\"2017-05-23T16:01:47+00:00\",\"dateModified\":\"2024-02-26T19:12:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/\"},\"wordCount\":579,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/DTW-in-SAP-B11-e1510252740580.jpg\",\"keywords\":[\"DTW\",\"Implementa\u00e7\u00e3o de um ERP\",\"planilhas\",\"SAP\"],\"articleSection\":[\"Integra\u00e7\u00e3o de Sistemas\",\"SAP Business One\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/\",\"url\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/\",\"name\":\"Saiba como importar seus dados de planilhas para o SAP Business One\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/DTW-in-SAP-B11-e1510252740580.jpg\",\"datePublished\":\"2017-05-23T16:01:47+00:00\",\"dateModified\":\"2024-02-26T19:12:03+00:00\",\"description\":\"Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o Data Transfer Workbench(DTW) que suporta a transfer\u00eancia autom\u00e1tica.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/DTW-in-SAP-B11-e1510252740580.jpg\",\"contentUrl\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/DTW-in-SAP-B11-e1510252740580.jpg\",\"width\":601,\"height\":244,\"caption\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Saiba como importar seus dados de planilhas para o SAP Business One\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/\",\"name\":\"Blog InterGATE\",\"description\":\"Integra\u00e7\u00e3o de Sistemas com os ERPs SAP Business One ou Totvs Protheus\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#organization\",\"name\":\"InterGATE Consultoria Digital\",\"url\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/intergateLogo_original.jpg\",\"contentUrl\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/intergateLogo_original.jpg\",\"width\":512,\"height\":512,\"caption\":\"InterGATE Consultoria Digital\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/35540154\",\"https:\\\/\\\/www.youtube.com\\\/@intergateconsultoriadigita8503\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/#\\\/schema\\\/person\\\/8efea68df8f7120ea0cf5bd5d855f919\",\"name\":\"Rafael Ogeda\",\"url\":\"https:\\\/\\\/www.intergate.net.br\\\/blog\\\/author\\\/rfr27j\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Saiba como importar seus dados de planilhas para o SAP Business One","description":"Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o Data Transfer Workbench(DTW) que suporta a transfer\u00eancia autom\u00e1tica.","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.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/","og_locale":"pt_PT","og_type":"article","og_title":"Saiba como importar seus dados de planilhas para o SAP Business One","og_description":"Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o Data Transfer Workbench(DTW) que suporta a transfer\u00eancia autom\u00e1tica.","og_url":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/","og_site_name":"Blog InterGATE","article_published_time":"2017-05-23T16:01:47+00:00","article_modified_time":"2024-02-26T19:12:03+00:00","og_image":[{"width":601,"height":244,"url":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/DTW-in-SAP-B11-e1510252740580.jpg","type":"image\/jpeg"}],"author":"Rafael Ogeda","twitter_misc":{"Escrito por":"Rafael Ogeda","Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#article","isPartOf":{"@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/"},"author":{"name":"Rafael Ogeda","@id":"https:\/\/www.intergate.net.br\/blog\/#\/schema\/person\/8efea68df8f7120ea0cf5bd5d855f919"},"headline":"Saiba como importar seus dados de planilhas para o SAP Business One","datePublished":"2017-05-23T16:01:47+00:00","dateModified":"2024-02-26T19:12:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/"},"wordCount":579,"commentCount":0,"publisher":{"@id":"https:\/\/www.intergate.net.br\/blog\/#organization"},"image":{"@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/DTW-in-SAP-B11-e1510252740580.jpg","keywords":["DTW","Implementa\u00e7\u00e3o de um ERP","planilhas","SAP"],"articleSection":["Integra\u00e7\u00e3o de Sistemas","SAP Business One"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/","url":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/","name":"Saiba como importar seus dados de planilhas para o SAP Business One","isPartOf":{"@id":"https:\/\/www.intergate.net.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#primaryimage"},"image":{"@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/DTW-in-SAP-B11-e1510252740580.jpg","datePublished":"2017-05-23T16:01:47+00:00","dateModified":"2024-02-26T19:12:03+00:00","description":"Saiba como importar seus dados de planilhas para o\u00a0SAP Business One, utilizando o Data Transfer Workbench(DTW) que suporta a transfer\u00eancia autom\u00e1tica.","breadcrumb":{"@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#primaryimage","url":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/DTW-in-SAP-B11-e1510252740580.jpg","contentUrl":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2017\/05\/DTW-in-SAP-B11-e1510252740580.jpg","width":601,"height":244,"caption":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.intergate.net.br\/blog\/como-importar-seus-dados-de-planilhas-para-o-sap-business-one\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.intergate.net.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Saiba como importar seus dados de planilhas para o SAP Business One"}]},{"@type":"WebSite","@id":"https:\/\/www.intergate.net.br\/blog\/#website","url":"https:\/\/www.intergate.net.br\/blog\/","name":"Blog InterGATE","description":"Integra\u00e7\u00e3o de Sistemas com os ERPs SAP Business One ou Totvs Protheus","publisher":{"@id":"https:\/\/www.intergate.net.br\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.intergate.net.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/www.intergate.net.br\/blog\/#organization","name":"InterGATE Consultoria Digital","url":"https:\/\/www.intergate.net.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/www.intergate.net.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2025\/06\/intergateLogo_original.jpg","contentUrl":"https:\/\/www.intergate.net.br\/blog\/wp-content\/uploads\/2025\/06\/intergateLogo_original.jpg","width":512,"height":512,"caption":"InterGATE Consultoria Digital"},"image":{"@id":"https:\/\/www.intergate.net.br\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/35540154","https:\/\/www.youtube.com\/@intergateconsultoriadigita8503"]},{"@type":"Person","@id":"https:\/\/www.intergate.net.br\/blog\/#\/schema\/person\/8efea68df8f7120ea0cf5bd5d855f919","name":"Rafael Ogeda","url":"https:\/\/www.intergate.net.br\/blog\/author\/rfr27j\/"}]}},"_links":{"self":[{"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/posts\/724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/comments?post=724"}],"version-history":[{"count":0,"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/posts\/724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/media\/725"}],"wp:attachment":[{"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/media?parent=724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/categories?post=724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.intergate.net.br\/blog\/wp-json\/wp\/v2\/tags?post=724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}