{"id":8216,"date":"2023-08-16T01:45:38","date_gmt":"2023-08-16T08:45:38","guid":{"rendered":"https:\/\/membermouse.com\/?post_type=ht_kb&#038;p=8216"},"modified":"2025-03-05T10:13:19","modified_gmt":"2025-03-05T15:13:19","slug":"importar-membros-com-o-assistente-de-importacao","status":"publish","type":"ht_kb","link":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/","title":{"rendered":"Importar membros com o assistente de importa\u00e7\u00e3o"},"content":{"rendered":"<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Importar membros com o assistente de importa\u00e7\u00e3o\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/2Fhvs62GNx4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">O Assistente de Importa\u00e7\u00e3o importar\u00e1 todos os seus membros, suas informa\u00e7\u00f5es de conta e seus direitos de acesso apropriados para o MemberMouse. Antes de importar, pode ser \u00fatil&nbsp;<a href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/gerenciamento-dos-niveis-de-associacao\/#creating-a-membership-level\">criar todos os n\u00edveis de associa\u00e7\u00e3o<\/a>&nbsp;e&nbsp;<a href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/gerenciamento-de-pacotes\/#creating-a-bundle\">feixes<\/a>&nbsp;que voc\u00ea sabe que precisar\u00e1 no MemberMouse. Se estiver migrando de um site de associa\u00e7\u00e3o existente, o artigo&nbsp;<a href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/migrar-membros-de-uma-solucao-de-associacao-existente\/\" rel=\"noreferrer noopener\" target=\"_blank\">Migrar membros de um site de associa\u00e7\u00e3o existente<\/a>&nbsp;tem etapas \u00fateis de fluxo de trabalho relacionadas \u00e0 cria\u00e7\u00e3o de n\u00edveis de associa\u00e7\u00e3o e transfer\u00eancia de faturamento.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The Import Wizard can also be used to update information on member accounts. &nbsp;If an existing user is imported, only the fields with information will be updated, any fields left blank will be ignored. &nbsp;Only the fields to be updated and the user&#8217;s email address needs to be filled into the template before uploading. &nbsp;Please note that only the member&#8217;s account information will be updated. &nbsp;Any other associated processes will not be prompted. &nbsp;For example, you can update the membership level status by inputting the new status into the template, but if a user is cancelled via the import wizard, any associated subscriptions will&nbsp;<em><strong>n\u00e3o<\/strong><\/em>&nbsp;ser cancelado.&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/migrar-membros-de-uma-solucao-de-associacao-existente\/\" target=\"_blank\"><\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Observa\u00e7\u00e3o:<\/strong>&nbsp;MemberMouse integrates seamlessly with WordPress&#8217; user system. This means that when a MemberMouse member is created, a WordPress user is automatically created as well. At that time, WordPress will send out a Change Password Email to those new users. If you import members with an email address that matches an existing WordPress user, then the import wizard will automatically convert them to MemberMouse members while keeping their original WordPress user account intact.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Importante: <\/strong>If you are unfamiliar with the import process, <span style=\"margin: 0px; padding: 0px;\">it is best to perform these steps with a few test members to get a feel for <\/span>the process before attempting a larger list of real members.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Como usar o assistente de importa\u00e7\u00e3o<\/h5>\n\n\n\n<ol class=\"wp-block-list\">\n<li>No<em>&nbsp;MembroMouse&nbsp;<\/em>menu ir para&nbsp;<em>Gerenciar membros&nbsp;<\/em>e clique no \u00edcone&nbsp;<em>Importar membros <\/em>bot\u00e3o.<br><br><\/li>\n\n\n\n<li>Isso o levar\u00e1 para o<em>&nbsp;Assistente de importa\u00e7\u00e3o<\/em>&nbsp;p\u00e1gina.<br><br><\/li>\n\n\n\n<li>Em seguida, clique no bot\u00e3o&nbsp;<em>Download do modelo de importa\u00e7\u00e3o <\/em>bot\u00e3o. Isso solicitar\u00e1 o download de um arquivo .csv em seu computador:&nbsp;<em>mm_import_template.csv<\/em><br><br><strong>Observa\u00e7\u00e3o:<\/strong>&nbsp;Fa\u00e7a o download de um novo arquivo .csv para cada n\u00edvel de associa\u00e7\u00e3o e renomeie o arquivo como o n\u00edvel de associa\u00e7\u00e3o para ajudar a manter a organiza\u00e7\u00e3o.<br><br><img decoding=\"async\" class=\"wp-image-10217\" style=\"width: 450px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/070bfd8d-screen-shot-2023-09-24-at-3.56.14-pm.png\" alt=\"\"><br><br><\/li>\n\n\n\n<li>Open the file and add a row for each member you want to import. The column headers represent the fields that MemberMouse will recognize when importing your member&#8217;s information. <br><br><strong>Todas as colunas devem estar presentes e na ordem em que aparecem no modelo<\/strong> para que o assistente de importa\u00e7\u00e3o processe os dados corretamente; portanto, certifique-se de n\u00e3o excluir nenhuma das colunas nem reorganiz\u00e1-las.<br><br>Se voc\u00ea quiser adicionar dados adicionais de membros n\u00e3o inclu\u00eddos em um dos cabe\u00e7alhos de coluna, consulte Campos personalizados na tabela abaixo e leia a se\u00e7\u00e3o&nbsp;<a href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/criar-um-campo-de-checkout-personalizado\/\">Criar um campo personalizado<\/a>&nbsp;artigo.<br><br><\/li>\n\n\n\n<li>As importa\u00e7\u00f5es s\u00e3o feitas um n\u00edvel de associa\u00e7\u00e3o de cada vez, portanto, crie um arquivo .csv para cada n\u00edvel de associa\u00e7\u00e3o para o qual voc\u00ea deseja importar membros e preencha-o com os dados apropriados dos membros.<br><br><\/li>\n\n\n\n<li>Em seguida, volte para o&nbsp;<em>Assistente de importa\u00e7\u00e3o<\/em>&nbsp;no MemberMouse e carregue o arquivo de importa\u00e7\u00e3o .csv clicando no bot\u00e3o&nbsp;<em>Selecionar arquivo <\/em>e navegar at\u00e9 o arquivo .csv apropriado. Opcionalmente, voc\u00ea tamb\u00e9m pode especificar um URL onde o arquivo .csv est\u00e1 hospedado.<br><br><img decoding=\"async\" class=\"wp-image-10221\" style=\"width: 500px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/2c1ee5eb-screen-shot-2023-09-24-at-4.00.37-pm.png\" alt=\"\"><br><br><\/li>\n\n\n\n<li>Em seguida, selecione o n\u00edvel de associa\u00e7\u00e3o no menu suspenso que corresponde aos dados do associado contidos no arquivo .csv que voc\u00ea selecionou.<br><br><img decoding=\"async\" class=\"wp-image-10219\" style=\"width: 325px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/13c6f4b1-screen-shot-2023-09-24-at-3.56.00-pm.png\" alt=\"\"><br><br><\/li>\n\n\n\n<li>You can optionally choose to send a welcome email to all new members being imported by checking the box next to &#8216;Send welcome email to new members&#8217;.<br><br>Note that if you&#8217;re having MemberMouse automatically generate passwords, you can&nbsp;<a href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/criar-um-e-mail-de-boas-vindas\/\">configurar o e-mail de boas-vindas<\/a>&nbsp;para entregar as senhas aos seus membros. Se voc\u00ea quiser fazer isso, certifique-se de configurar o modelo de e-mail de boas-vindas para os n\u00edveis de associa\u00e7\u00e3o apropriados antes de fazer uma importa\u00e7\u00e3o.<br><br><\/li>\n\n\n\n<li>Clique no bot\u00e3o&nbsp;<em>Importar membros <\/em>bot\u00e3o.<br><br><img decoding=\"async\" class=\"wp-image-10218\" style=\"width: 300px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/bebfd092-screen-shot-2023-09-24-at-3.56.07-pm.png\" alt=\"\"><br><\/li>\n\n\n\n<li>Ap\u00f3s a importa\u00e7\u00e3o, o MemberMouse exibir\u00e1 os resultados da importa\u00e7\u00e3o, incluindo quais membros foram importados, quais pacotes foram aplicados \u00e0 conta deles e se foram encontrados erros.<br><br><img decoding=\"async\" class=\"wp-image-10222\" style=\"width: 300px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/c42bbf71-117714.png\" alt=\"\"><br><img decoding=\"async\" class=\"wp-image-10223\" style=\"width: 350px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/545cf70a-126328.png\" alt=\"\"><br><br><\/li>\n\n\n\n<li>Clique no bot\u00e3o&nbsp;<em>Importar mais membros <\/em>para repetir o processo e importar membros adicionais.<\/li>\n<\/ol>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Campos do modelo de importa\u00e7\u00e3o<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Abaixo est\u00e1 uma lista de todos os campos contidos no modelo de importa\u00e7\u00e3o, juntamente com uma descri\u00e7\u00e3o dos valores aceit\u00e1veis:<\/p>\n\n\n\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong><em>Nome de usu\u00e1rio<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s username. If you leave the username field blank, then MemberMouse will automatically assign the email as the username.<\/td><\/tr><tr><td><strong><em>E-mail<\/em><\/strong><br><em>necess\u00e1rio<\/em><\/td><td>Enter the member&#8217;s email address. This field is required and must be unique.<\/td><\/tr><tr><td><strong><em>Telefone<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s phone number. Phone numbers require no particular format. Example:&nbsp;123-123-1234&nbsp;or&nbsp;12312312345<\/td><\/tr><tr><td><strong><em>Data de registro<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s registration date. <br><br>Registration date should be expressed as a date: MM\/DD\/YYYY (i.e.&nbsp;1\/25\/2013). If you choose to leave this field blank, the new member&#8217;s registration date will be set to today&#8217;s date.<\/td><\/tr><tr><td><strong><em>Data de expira\u00e7\u00e3o<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s expiration date. <br><br>You only need to pay attention to this field if you&#8217;re importing members into a Membership Level that&#8217;s configured to expire. <br><br>Expiration Date should be expressed as a date: MM\/DD\/YYYY (i.e.&nbsp;1\/25\/2013). If you choose to leave this field blank, the new member&#8217;s expiration date will be calculated based on their registration date and the expiring membership level&#8217;s configuration. <br><br>For example, if the membership level is configured to expire after a month and the registration date is&nbsp;1\/1\/2013, if you don&#8217;t specify an expiration date, it will be set to&nbsp;2\/1\/2013.<\/td><\/tr><tr><td><strong><em>Senha<\/em><\/strong><br><em>opcional<\/em><\/td><td>If you have access to a member&#8217;s current password or you want to create a default password that members can change when they first log in, enter it here in a human-readable format (i.e.&nbsp;Password1234!). <br><br>MemberMouse will take care of encrypting the password when it&#8217;s inserted in your member database. If you do not enter anything into this field, MemberMouse will automatically generate a random password for each member. <br><br>Voc\u00ea pode enviar senhas para membros importados por meio do e-mail de boas-vindas associado ao n\u00edvel de associa\u00e7\u00e3o.<br><br><strong>IMPORTANTE:<\/strong>&nbsp;If you&#8217;re importing members with email addresses or usernames that are already associated with existing WordPress users then the password field will be completely ignored. WordPress users that are migrated to MemberMouse members will just login using the same password they&#8217;re already using. <br><br>As a result of this, MemberMouse will have no knowledge of what the member&#8217;s password is so using the&nbsp;Member_Data name=&#8217;password&#8217;&nbsp;SmartTag will return nothing for these members.<\/td><\/tr><tr><td><strong><em>Primeiro nome<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s first name.<\/td><\/tr><tr><td><strong><em>Sobrenome<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s last name.<\/td><\/tr><tr><td><strong><em>Endere\u00e7o de cobran\u00e7a<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s billing address.<\/td><\/tr><tr><td><strong><em>Linha 2 do endere\u00e7o de cobran\u00e7a<\/em><\/strong><br><em><em>opcional&nbsp;<\/em><\/em><\/td><td>Enter further information for the member&#8217;s billing address, such as apartment or suite number.<br><br><strong>Observa\u00e7\u00e3o<\/strong>: Esse recurso s\u00f3 est\u00e1 dispon\u00edvel no MemberMouse vers\u00e3o 2.4.1+. As vers\u00f5es anteriores n\u00e3o podiam importar ou exportar essas informa\u00e7\u00f5es.<\/td><\/tr><tr><td><strong><em>Cidade de cobran\u00e7a<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s billing city.<\/td><\/tr><tr><td><strong><em>Estado de faturamento<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s billing state.<\/td><\/tr><tr><td><strong><em>C\u00f3digo postal de cobran\u00e7a<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s billing zip code.<\/td><\/tr><tr><td><strong><em>Pa\u00eds de faturamento<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s billing country. Use two-digit&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/en.wikipedia.org\/wiki\/ISO_3166-1_alpha-2#Officially_assigned_code_elements\" target=\"_blank\">C\u00f3digos de pa\u00eds ISO<\/a>.<\/td><\/tr><tr><td><strong><em>Endere\u00e7o de entrega<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s shipping address.<\/td><\/tr><tr><td><strong><em>Linha 2 do endere\u00e7o de remessa<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter further information for the member&#8217;s shipping address, such as apartment or suite number.<br><br><strong>Observa\u00e7\u00e3o<\/strong>: Esse recurso s\u00f3 est\u00e1 dispon\u00edvel no MemberMouse vers\u00e3o 2.4.1+. As vers\u00f5es anteriores n\u00e3o podiam importar ou exportar essas informa\u00e7\u00f5es.<\/td><\/tr><tr><td><strong><em>Cidade de expedi\u00e7\u00e3o<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s shipping city.<\/td><\/tr><tr><td><strong><em>Estado da remessa<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s shipping state.<\/td><\/tr><tr><td><strong><em>C\u00f3digo postal de remessa<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s shipping zip code.<\/td><\/tr><tr><td><strong><em>Pa\u00eds de envio<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the member&#8217;s shipping country. Use two-digit&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/en.wikipedia.org\/wiki\/ISO_3166-1_alpha-2#Officially_assigned_code_elements\" target=\"_blank\">C\u00f3digos de pa\u00eds ISO<\/a>.<\/td><\/tr><tr><td><strong><em>Status<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the status you want to apply to the member&#8217;s account by supplying the desired status ID. If no status is specified, accounts will be marked as Active. See this article to&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/ciclo-de-vida-do-status-de-membro\/\" target=\"_blank\">Saiba mais sobre os status da conta<\/a>. <br><br>Abaixo est\u00e1 uma lista de IDs de status v\u00e1lidos:<br><br>1 = Ativo<br>2 = Cancelado<br>3 = Bloqueado<br>4 = Pausado<br>5 = Atrasado<br>6 = Pendente<br>7 = Erro<br>8 = Expirado<\/td><\/tr><tr><td><strong><em>Pacotes<\/em><\/strong><br><em>opcional<\/em><\/td><td>If you want to apply one or more bundles to a member&#8217;s account, enter the bundle ID(s) in this field. You can look up bundle IDs right from the Import Wizard by clicking the&nbsp;<em>IDs de pesquisa <\/em>bot\u00e3o. <br><br><img decoding=\"async\" class=\"wp-image-10215\" style=\"width: 200px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/6c86e32b-126291.png\" alt=\"\"><br><br><br>Ser\u00e1 exibida uma caixa de di\u00e1logo de pesquisa de ID. Selecione<em>&nbsp;Pacotes&nbsp;<\/em>no menu suspenso para ver a lista de pacotes no sistema, juntamente com a ID associada a cada pacote encontrado no&nbsp;<em>ID<\/em>&nbsp;coluna.<br><br>In order to assign multiple bundles to a member&#8217;s account just separate each bundle ID with a pipe character (&nbsp;|&nbsp;).&nbsp;For example:&nbsp;1|3|8<\/td><\/tr><tr><td><strong><em>Status do pacote<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the status you want to apply to the each bundle being applied to the member&#8217;s account by supplying the desired status ID. If no status is specified, bundles will be marked as Active. See this article to&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/ciclo-de-vida-do-status-de-membro\/\" target=\"_blank\">Saiba mais sobre os status dos pacotes<\/a>. <br><br>Abaixo est\u00e1 uma lista de IDs de status v\u00e1lidos:<br><br>1 = Ativo<br>2 = Cancelado<br>4 = Pausado<br>5 = Atrasado<br>8 = Expirado<br><br><br>In order to set the status for multiple bundles just separate each status ID with a pipe character (&nbsp;|&nbsp;). For example:&nbsp;1|2|4<br><br>Observe que cada ID de status deve estar corretamente correlacionada a uma ID de pacote listada no&nbsp;<em>Pacotes<\/em>&nbsp;column. For example, if you have&nbsp;1|4&nbsp;in the&nbsp;<em>Pacotes<\/em>&nbsp;column, this means that you want to apply bundles 1 and 4 to the member&#8217;s account. So if you want to set the status of bundle 1 to Canceled (status ID of 2) and the status of bundle 4 to Active (status ID of 1) you would enter this&nbsp;2|1.<\/td><\/tr><tr><td><strong><em>Datas de in\u00edcio do pacote<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the start date you want to use for each bundle being applied to the member&#8217;s account by supplying a date in the format MM\/DD\/YYYY (i.e.&nbsp;1\/25\/2013). <br><br>If you choose to leave this field blank, the bundle&#8217;s start date will be set to today&#8217;s date.<br><br>In order to set the start date for multiple bundles just separate each date with a pipe character (&nbsp;|&nbsp;). For example:&nbsp;1\/1\/12|2\/3\/12|3\/5\/12<br><br>Observe que cada data deve estar corretamente correlacionada a uma ID de pacote listada no&nbsp;<em>Pacotes<\/em>&nbsp;column. For example, if you have&nbsp;1|4&nbsp;in the&nbsp;<em>Pacotes<\/em>&nbsp;column, this means that you want to apply bundles 1 and 4 to the member&#8217;s account. So if you want to set the start date of bundle 1 to&nbsp;1\/1\/12&nbsp;and the start date of bundle 4 to&nbsp;3\/5\/12&nbsp;you would enter this&nbsp;1\/1\/12|3\/5\/12.<\/td><\/tr><tr><td><strong><em>Datas de vencimento do pacote<\/em><\/strong><br><em>opcional<\/em><\/td><td>Enter the expiration date you want to use for each bundle being applied to the member&#8217;s account by supplying a date in the format MM\/DD\/YYYY (i.e.&nbsp;1\/25\/2013).<br><br>You only need to pay attention to this field if you&#8217;re applying bundles that configured to expire. If you choose to leave this field blank, the bundle&#8217;s expiration date will be calculated based on the bundle&#8217;s start date and the expiring bundle&#8217;s configuration. For example, if the bundle is configured to expire after a month and the start date is&nbsp;1\/1\/2013, if you don&#8217;t specify an expiration date, it will be set to&nbsp;2\/1\/2013.<br><br>In order to set the expiration date for multiple bundles just separate each date with a pipe character (&nbsp;|&nbsp;). For example:&nbsp;1\/1\/12|2\/3\/12|3\/5\/12<br><br>Observe que cada data deve estar corretamente correlacionada a uma ID de pacote listada no&nbsp;<em>Pacotes<\/em>&nbsp;column. For example, if you have&nbsp;1|4&nbsp;in the&nbsp;<em>Pacotes<\/em>&nbsp;column, this means that you want to apply bundles 1 and 4 to the member&#8217;s account. So if you want to set the expiration date of bundle 1 to&nbsp;1\/1\/12&nbsp;and the expiration date date of bundle 4 to&nbsp;3\/5\/12&nbsp;you would enter this&nbsp;1\/1\/12|3\/5\/12.<\/td><\/tr><tr><td><strong><em>Colunas de campos personalizados<\/em><\/strong><br><em>opcional<\/em><\/td><td>Se voc\u00ea tiver&nbsp;<a href=\"https:\/\/membermouse.com\/pt\/documentos-3-2\/criar-um-campo-de-checkout-personalizado\/\">campos personalizados<\/a>&nbsp;configurados no MemberMouse e voc\u00ea deseja importar dados para esses campos personalizados, \u00e9 necess\u00e1rio adicionar colunas adicionais ao arquivo .csv ap\u00f3s a op\u00e7\u00e3o&nbsp;<em>Datas de vencimento do pacote<\/em>&nbsp;coluna. O nome da coluna \u00e9 extremamente importante e precisa estar no seguinte formato:<br><br>Campo personalizado {custom_field_id}<br><br>Where&nbsp;{custom_field_id}&nbsp;will be replaced by the ID of the custom field in MemberMouse. For example, if you have a custom field that stores a member&#8217;s birthday and the ID of that custom field is 4, you would need to name the column&nbsp;Custom Field 4.<br><br>Voc\u00ea pode procurar IDs de campos personalizados diretamente no Assistente de importa\u00e7\u00e3o, clicando no bot\u00e3o&nbsp;<em>IDs de pesquisa <\/em>bot\u00e3o.<br><br><img decoding=\"async\" class=\"wp-image-10214\" style=\"width: 200px;\" src=\"https:\/\/storage.googleapis.com\/wpgcbucket\/wp\/2023\/09\/eafe5f48-126309.png\" alt=\"\"><br><br><br>Uma caixa de di\u00e1logo ser\u00e1 exibida. Selecione<em>&nbsp;Campos personalizados&nbsp;<\/em>no menu suspenso para ver a lista de campos personalizados no sistema, juntamente com a ID associada a cada campo personalizado encontrado no&nbsp;<em>ID<\/em>&nbsp;coluna.<br><br>Now for each member you&#8217;ll just enter the appropriate data for each custom field you&#8217;ve added.<br><br><strong>Observa\u00e7\u00e3o:&nbsp;<\/strong>When importing data for a custom field that&#8217;s a check box, use the following values to indicate checked or unchecked:&nbsp;&#8216;mm_cb_on&#8217;&nbsp;and&nbsp;&#8216;mm_cb_off&#8217;.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>","protected":false},"excerpt":{"rendered":"<p>O Assistente de importa\u00e7\u00e3o importar\u00e1 todos os seus membros, suas informa\u00e7\u00f5es de conta e seus direitos de acesso apropriados para o MemberMouse. Antes de importar, pode ser \u00fatil criar todas as informa\u00e7\u00f5es de...<\/p>","protected":false},"author":21411,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"ht-kb-category":[198],"ht-kb-tag":[],"class_list":["post-8216","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-member-basics"],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO Pro 5.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Curt Noble\"\/>\n\t<meta name=\"google-site-verification\" content=\"RIQFHn-t5QxsuMU4pLG9xaceb-mmGuRaOWAEU1Q078U\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO Pro (AIOSEO) 5.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"MemberMouse |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Import Members with the Import Wizard | MemberMouse\" \/>\n\t\t<meta property=\"og:description\" content=\"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-08-16T08:45:38+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-03-05T15:13:19+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/membermouse\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@MemberMouse\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Import Members with the Import Wizard | MemberMouse\" \/>\n\t\t<meta name=\"twitter:description\" content=\"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@MemberMouse\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/membermouse.com\\\/pt\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/members\\\/#listItem\",\"name\":\"Manage Members\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/members\\\/#listItem\",\"position\":2,\"name\":\"Manage Members\",\"item\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/members\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/member-basics\\\/#listItem\",\"name\":\"Member Basics\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/member-basics\\\/#listItem\",\"position\":3,\"name\":\"Member Basics\",\"item\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/member-basics\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/#listItem\",\"name\":\"Import Members with the Import Wizard\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/members\\\/#listItem\",\"name\":\"Manage Members\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/#listItem\",\"position\":4,\"name\":\"Import Members with the Import Wizard\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/article-categories\\\/member-basics\\\/#listItem\",\"name\":\"Member Basics\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/#organization\",\"name\":\"MemberMouse\",\"url\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/membermouse\",\"https:\\\/\\\/twitter.com\\\/MemberMouse\",\"https:\\\/\\\/www.instagram.com\\\/membermouse\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/membermouse\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/membermouse\\\/\",\"https:\\\/\\\/soundcloud.com\\\/membermouse\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/author\\\/curtcaseproof-com\\\/#author\",\"url\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/author\\\/curtcaseproof-com\\\/\",\"name\":\"Curt Noble\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/#authorImage\",\"url\":\"https:\\\/\\\/membermouse.com\\\/wp-content\\\/litespeed\\\/avatar\\\/69cacd8325ef9810065b0b177318f497.jpg?ver=1787204323\",\"width\":96,\"height\":96,\"caption\":\"Curt Noble\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/#webpage\",\"url\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/\",\"name\":\"Import Members with the Import Wizard | MemberMouse\",\"description\":\"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/docs\\\/import-members-with-the-import-wizard\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/author\\\/curtcaseproof-com\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/author\\\/curtcaseproof-com\\\/#author\"},\"datePublished\":\"2023-08-16T01:45:38-04:00\",\"dateModified\":\"2025-03-05T10:13:19-05:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/#website\",\"url\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/\",\"name\":\"MemberMouse\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/membermouse.com\\\/pt\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO Pro -->\r\n\t\t<title>Import Members with the Import Wizard | MemberMouse<\/title>\n\n","aioseo_head_json":{"title":"Importar membros com o Assistente de importa\u00e7\u00e3o | MemberMouse","description":"O Assistente de Importa\u00e7\u00e3o importar\u00e1 todos os seus membros, suas informa\u00e7\u00f5es de conta e seus direitos de acesso apropriados para o MemberMouse. Antes de importar, pode ser \u00fatil criar todos os n\u00edveis e pacotes de associa\u00e7\u00e3o que voc\u00ea sabe que precisar\u00e1 no MemberMouse. Se estiver migrando de um site de associa\u00e7\u00e3o existente, o artigo Migrar membros de um site de associa\u00e7\u00e3o existente tem","canonical_url":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"RIQFHn-t5QxsuMU4pLG9xaceb-mmGuRaOWAEU1Q078U","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt#listItem","position":1,"name":"Home","item":"https:\/\/membermouse.com\/pt","nextItem":{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/article-categories\/members\/#listItem","name":"Manage Members"}},{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/article-categories\/members\/#listItem","position":2,"name":"Manage Members","item":"https:\/\/membermouse.com\/pt\/article-categories\/members\/","nextItem":{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/article-categories\/member-basics\/#listItem","name":"Member Basics"},"previousItem":{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/article-categories\/member-basics\/#listItem","position":3,"name":"Member Basics","item":"https:\/\/membermouse.com\/pt\/article-categories\/member-basics\/","nextItem":{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/#listItem","name":"Import Members with the Import Wizard"},"previousItem":{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/article-categories\/members\/#listItem","name":"Manage Members"}},{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/#listItem","position":4,"name":"Import Members with the Import Wizard","previousItem":{"@type":"ListItem","@id":"https:\/\/membermouse.com\/pt\/article-categories\/member-basics\/#listItem","name":"Member Basics"}}]},{"@type":"Organization","@id":"https:\/\/membermouse.com\/pt\/#organization","name":"MemberMouse","url":"https:\/\/membermouse.com\/pt\/","sameAs":["https:\/\/www.facebook.com\/membermouse","https:\/\/twitter.com\/MemberMouse","https:\/\/www.instagram.com\/membermouse\/","https:\/\/www.youtube.com\/user\/membermouse","https:\/\/www.linkedin.com\/company\/membermouse\/","https:\/\/soundcloud.com\/membermouse"]},{"@type":"Person","@id":"https:\/\/membermouse.com\/pt\/author\/curtcaseproof-com\/#author","url":"https:\/\/membermouse.com\/pt\/author\/curtcaseproof-com\/","name":"Curt Noble","image":{"@type":"ImageObject","@id":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/#authorImage","url":"https:\/\/membermouse.com\/wp-content\/litespeed\/avatar\/69cacd8325ef9810065b0b177318f497.jpg?ver=1787204323","width":96,"height":96,"caption":"Curt Noble"}},{"@type":"WebPage","@id":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/#webpage","url":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/","name":"Import Members with the Import Wizard | MemberMouse","description":"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/membermouse.com\/pt\/#website"},"breadcrumb":{"@id":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/#breadcrumblist"},"author":{"@id":"https:\/\/membermouse.com\/pt\/author\/curtcaseproof-com\/#author"},"creator":{"@id":"https:\/\/membermouse.com\/pt\/author\/curtcaseproof-com\/#author"},"datePublished":"2023-08-16T01:45:38-04:00","dateModified":"2025-03-05T10:13:19-05:00"},{"@type":"WebSite","@id":"https:\/\/membermouse.com\/pt\/#website","url":"https:\/\/membermouse.com\/pt\/","name":"MemberMouse","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/membermouse.com\/pt\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"MemberMouse |","og:type":"article","og:title":"Import Members with the Import Wizard | MemberMouse","og:description":"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has","og:url":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/","article:published_time":"2023-08-16T08:45:38+00:00","article:modified_time":"2025-03-05T15:13:19+00:00","article:publisher":"https:\/\/www.facebook.com\/membermouse","twitter:card":"summary_large_image","twitter:site":"@MemberMouse","twitter:title":"Import Members with the Import Wizard | MemberMouse","twitter:description":"The Import Wizard will import all of your members, their account information and their appropriate access rights into MemberMouse. Before importing, you may find it helpful to create all of the membership levels and bundles you know you will need in MemberMouse. If you are migrating from an existing membership site, the article Migrate Members from an Existing Membership Site has","twitter:creator":"@MemberMouse"},"aioseo_meta_data":{"post_id":"8216","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"limit_modified_date":false,"reviewed_by":null,"open_ai":"{\"title\":{\"suggestions\":[],\"usage\":0},\"description\":{\"suggestions\":[],\"usage\":0}}","created":"2023-10-11 18:46:55","updated":"2026-06-03 05:15:39","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":"2026-06-03 03:57:29","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/membermouse.com\/pt\" title=\"Home\">Home<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/membermouse.com\/pt\/article-categories\/members\/\" title=\"Manage Members\">Manage Members<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/membermouse.com\/pt\/article-categories\/member-basics\/\" title=\"Member Basics\">Member Basics<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\tImport Members with the Import Wizard\n<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/membermouse.com\/pt"},{"label":"Manage Members","link":"https:\/\/membermouse.com\/pt\/article-categories\/members\/"},{"label":"Member Basics","link":"https:\/\/membermouse.com\/pt\/article-categories\/member-basics\/"},{"label":"Import Members with the Import Wizard","link":"https:\/\/membermouse.com\/pt\/docs\/import-members-with-the-import-wizard\/"}],"_links":{"self":[{"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/ht-kb\/8216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/users\/21411"}],"replies":[{"embeddable":true,"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/comments?post=8216"}],"version-history":[{"count":1,"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/ht-kb\/8216\/revisions"}],"predecessor-version":[{"id":20905,"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/ht-kb\/8216\/revisions\/20905"}],"wp:attachment":[{"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/media?parent=8216"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/ht-kb-category?post=8216"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/membermouse.com\/pt\/wp-json\/wp\/v2\/ht-kb-tag?post=8216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}