{"id":7018,"date":"2024-05-13T16:27:16","date_gmt":"2024-05-13T19:27:16","guid":{"rendered":"https:\/\/iclips.com.br\/help\/como-importar-meus-dados-para-studio\/"},"modified":"2024-09-18T16:13:24","modified_gmt":"2024-09-18T19:13:24","slug":"como-importar-meus-dados-para-iClips","status":"publish","type":"post","link":"https:\/\/iclips.com.br\/help\/como-importar-meus-dados-para-iClips\/","title":{"rendered":"Como importar meus dados para iClips?"},"content":{"rendered":"<p>Visando otimizar o cadastro de informa\u00e7\u00f5es, iClips permite que voc\u00ea importe sua lista de clientes, fornecedores e ve\u00edculos atrav\u00e9s de uma planilha csv.<\/p>\n<p>Ao clicar na op\u00e7\u00e3o de importa\u00e7\u00e3o, o pr\u00f3prio sistema vai te oferecer um modelo para ser baixado. N\u00f3s orientamos que os dados sejam preenchidos dentro desse modelo disponibilizado:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-8961\" src=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-2-3-1024x100.png\" alt=\"\" width=\"1024\" height=\"100\" srcset=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-2-3-1024x100.png 1024w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-2-3-300x29.png 300w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-2-3-768x75.png 768w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-2-3-1536x150.png 1536w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-2-3.png 1832w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8959\" src=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-1-1.png\" alt=\"\" width=\"596\" height=\"593\" srcset=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-1-1.png 596w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-1-1-300x298.png 300w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-1-1-150x150.png 150w\" sizes=\"auto, (max-width: 596px) 100vw, 596px\" \/><br \/>\n\u00c9 importante frisar que, para que o procedimento ocorra sem problemas, sua planilha precisa seguir algumas regras:<br \/>\n<strong><br \/>\n<\/strong><strong>1) Campos obrigat\u00f3rios em iClips, tamb\u00e9m ser\u00e3o obrigat\u00f3rios na planilha<\/strong><\/p>\n<p>Isso significa que, se no cadastro de um cliente o campo de Nome e Raz\u00e3o social s\u00e3o de preenchimento obrigat\u00f3rio, na planilha esses campos n\u00e3o podem estar em branco.<\/p>\n<p>Para saber quais campos s\u00e3o obrigat\u00f3rios, basta observar quais possuem a flag vermelha.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-8962\" src=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-3-1-1024x456.png\" alt=\"\" width=\"1024\" height=\"456\" srcset=\"https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-3-1-1024x456.png 1024w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-3-1-300x134.png 300w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-3-1-768x342.png 768w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-3-1-1536x684.png 1536w, https:\/\/iclips.com.br\/help\/wp-content\/uploads\/2024\/05\/print-3-1.png 1915w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong>2) A separa\u00e7\u00e3o da planilha deve ser por ponto e v\u00edrgula (;)<\/strong><\/p>\n<p>Ao abrir o arquivo, os programas de edi\u00e7\u00e3o de texto sugerem uma separa\u00e7\u00e3o, \u00e9 preciso que voc\u00ea escolha separa\u00e7\u00e3o por ponto e v\u00edrgula, por o sistema l\u00ea assim a divis\u00e3o das colunas.<br \/>\n<strong><br \/>\n<img decoding=\"async\" class=\"hs-image-align-none\" src=\"https:\/\/f.hubspotusercontent30.net\/hubfs\/355484\/image-png-Mar-18-2021-07-17-05-29-PM.png\" \/><\/strong><\/p>\n<p>3) O texto na planilha n\u00e3o pode conter ponto e v\u00edrgula (;)<br \/>\nComo vimos no passo anterior, no documento CSV a separa\u00e7\u00e3o das colunas precisa ser feita por ponto e v\u00edrgula (;), por isso, n\u00e3o pode conter essa pontua\u00e7\u00e3o em nenhum texto, porque o sistema vai entender que ali tamb\u00e9m existe uma divis\u00e3o de coluna e quebrar a formata\u00e7\u00e3o.<br \/>\n<strong><br \/>\n<\/strong><strong>4) Limite de caracteres<\/strong><strong><br \/>\n<\/strong><br \/>\nOs campos possuem os seguintes limites de caracteres:<\/p>\n<ul>\n<li aria-level=\"1\">Nome = 100<\/li>\n<li aria-level=\"1\">Email = 100<\/li>\n<li aria-level=\"1\">Cpf\/Cnpj = 20<\/li>\n<li aria-level=\"1\">Raz\u00e3o Social = 200<\/li>\n<li aria-level=\"1\">Inscri\u00e7\u00e3o Estadual\/Municipal = 50<\/li>\n<li aria-level=\"1\">Website = 200<\/li>\n<li aria-level=\"1\">Logradouro = 100<\/li>\n<li aria-level=\"1\">Cep = 15<\/li>\n<li aria-level=\"1\">N\u00famero = 10<\/li>\n<li aria-level=\"1\">Complemento = 60<\/li>\n<li aria-level=\"1\">Bairro = 60<\/li>\n<li aria-level=\"1\">Caixa Postal = 15<\/li>\n<\/ul>\n<p><strong>5) Aten\u00e7\u00e3o para os n\u00fameros de telefone registrados<\/strong><br \/>\n\u00c9 importante deixar somente um telefone cadastrado para n\u00e3o ultrapassar o limite de caracteres.<\/p>\n<p>Ainda precisa de ajuda? \u00c9 s\u00f3 nos chamar no suporte@iclips.com.br ou no chat da plataforma e vamos te ajudar!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Confira as regras de importa\u00e7\u00e3o de planilhas para o sistema.<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[15],"tags":[],"class_list":["post-7018","post","type-post","status-publish","format-standard","hentry","category-settings"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Suporte iClips","author_link":"https:\/\/iclips.com.br\/help\/author\/suporte-iclips\/"},"uagb_comment_info":0,"uagb_excerpt":"Confira as regras de importa\u00e7\u00e3o de planilhas para o sistema.","_links":{"self":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts\/7018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/comments?post=7018"}],"version-history":[{"count":3,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts\/7018\/revisions"}],"predecessor-version":[{"id":8963,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/posts\/7018\/revisions\/8963"}],"wp:attachment":[{"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/media?parent=7018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/categories?post=7018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iclips.com.br\/help\/wp-json\/wp\/v2\/tags?post=7018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}