{"id":5502,"date":"2023-08-01T13:40:30","date_gmt":"2023-08-01T11:40:30","guid":{"rendered":"https:\/\/sare.pl\/baza-wiedzy\/uncategorized\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/"},"modified":"2023-08-01T13:40:30","modified_gmt":"2023-08-01T11:40:30","slug":"create-an-effective-database-of-e-mail-addresses-and-gsm-numbers","status":"publish","type":"post","link":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/","title":{"rendered":"Create an effective database of e-mail addresses and GSM numbers"},"content":{"rendered":"<p>We would like to help you optimize the way you prepare your database of email addresses and GSM numbers for import. Accordingly, we have developed some simple guidelines to help you organize and format your data effectively. <\/p>\n<h2>Preparing the base in Excel<\/h2>\n<p>This data is most easily prepared using Excel or any other spreadsheet editor. We encourage you to save your database in <strong>.csv<\/strong> format, which is not only widely accepted, but also easy to process. Below are our guidelines for a database prepared in Excel:  <\/p>\n<ul>\n<li>Save the file with the .csv extension<\/li>\n<li>Put each record (email address and features) in a separate row<\/li>\n<li>Enter the characteristics of each record in separate columns<\/li>\n<li>Remove column headers such as first name, last name, company, email, etc.<\/li>\n<li>Set cell formatting to &#8220;general&#8221;<\/li>\n<li>Keep the entire base on one sheet (removing unnecessary sheets)<\/li>\n<\/ul>\n<p>In addition, if there are GSM numbers in your database, make sure they are stored in the correct format: +48123456789 and the column with GSM numbers has text formatting.<\/p>\n<p>An example database.csv file structure might look like this:<\/p>\n<p><!-- You could insert a table here --><\/p>\n<h2>Preparing the base in Notepad<\/h2>\n<p>If you prefer the simplicity of Notepad, you can also prepare your database in this tool. Below are the guidelines for use: <\/p>\n<ul>\n<li>Save the file with a .txt extension<\/li>\n<li>Place records in separate rows<\/li>\n<li>Separate the record features with the same character (&#8221; ,&#8221; or &#8221; ;&#8221;)<\/li>\n<li>Disable line wrapping option<\/li>\n<\/ul>\n<p>An example structure of a database.txt file might look like this:<\/p>\n<p><!-- You could insert a table here --><\/p>\n<h2>Important notes on database import<\/h2>\n<p>There are a few important considerations you need to take into account to ensure a smooth import of your database:<\/p>\n<ul>\n<li>A necessary data in each record is the email address!<\/li>\n<li>If the record does not contain an e-mail address, a replacement e-mail address will be generated based on the GSM number, e.g. +48123456789 <\/li>\n<li>If the record does not contain either an email address or GSM number, it will not be imported into our system!<\/li>\n<\/ul>\n<p><!-- Insert a picture here --><\/p>\n<p>Understanding and following these guidelines will help you get the most out of our services. Thank you for your cooperation and we are ready to assist you with any questions or concerns. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Assistance with data organization and formatting. Guidelines for database prepared in Excel and csv file for import into mailing system. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1631],"tags":[2145,2070,2141,2142,2143,2144],"class_list":["post-5502","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-guidelines","tag-database-import","tag-database-of-e-mail-addresses","tag-gsm-number-database","tag-data-organization","tag-data-formatting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create an effective database of e-mail addresses and GSM numbers - SARE | Baza wiedzy<\/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:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create an effective database of e-mail addresses and GSM numbers - SARE | Baza wiedzy\" \/>\n<meta property=\"og:description\" content=\"Assistance with data organization and formatting. Guidelines for database prepared in Excel and csv file for import into mailing system.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\" \/>\n<meta property=\"og:site_name\" content=\"SARE | Baza wiedzy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SAREpl\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-01T11:40:30+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/person\/167ecfd76cdd32904d33a8c56f137e3a\"},\"headline\":\"Create an effective database of e-mail addresses and GSM numbers\",\"datePublished\":\"2023-08-01T11:40:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\"},\"wordCount\":363,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#organization\"},\"keywords\":[\"guidelines\",\"database import\",\"database of e-mail addresses\",\"GSM number database\",\"data organization\",\"data formatting\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\",\"url\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\",\"name\":\"Create an effective database of e-mail addresses and GSM numbers - SARE | Baza wiedzy\",\"isPartOf\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#website\"},\"datePublished\":\"2023-08-01T11:40:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Centrum pomocy\",\"item\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/uncategorized\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Create an effective database of e-mail addresses and GSM numbers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#website\",\"url\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/\",\"name\":\"SARE | Baza wiedzy\",\"description\":\"SARE | Baza wiedzy\",\"publisher\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#organization\",\"name\":\"SARE | Baza wiedzy\",\"url\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sare.pl\/baza-wiedzy\/wp-content\/uploads\/2023\/11\/Frame-7540-1.png\",\"contentUrl\":\"https:\/\/sare.pl\/baza-wiedzy\/wp-content\/uploads\/2023\/11\/Frame-7540-1.png\",\"width\":372,\"height\":160,\"caption\":\"SARE | Baza wiedzy\"},\"image\":{\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SAREpl\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/person\/167ecfd76cdd32904d33a8c56f137e3a\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c41b30fd9393eb744de159dd22162b679cd7596c81b8e0495338a751f97227f2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c41b30fd9393eb744de159dd22162b679cd7596c81b8e0495338a751f97227f2?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/sare.pl\/baza-wiedzy\"],\"url\":\"https:\/\/sare.pl\/baza-wiedzy\/en\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create an effective database of e-mail addresses and GSM numbers - SARE | Baza wiedzy","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:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/","og_locale":"en_US","og_type":"article","og_title":"Create an effective database of e-mail addresses and GSM numbers - SARE | Baza wiedzy","og_description":"Assistance with data organization and formatting. Guidelines for database prepared in Excel and csv file for import into mailing system.","og_url":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/","og_site_name":"SARE | Baza wiedzy","article_publisher":"https:\/\/www.facebook.com\/SAREpl","article_published_time":"2023-08-01T11:40:30+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/#article","isPartOf":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/"},"author":{"name":"admin","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/person\/167ecfd76cdd32904d33a8c56f137e3a"},"headline":"Create an effective database of e-mail addresses and GSM numbers","datePublished":"2023-08-01T11:40:30+00:00","mainEntityOfPage":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/"},"wordCount":363,"commentCount":0,"publisher":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#organization"},"keywords":["guidelines","database import","database of e-mail addresses","GSM number database","data organization","data formatting"],"articleSection":["Database management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/","url":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/","name":"Create an effective database of e-mail addresses and GSM numbers - SARE | Baza wiedzy","isPartOf":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#website"},"datePublished":"2023-08-01T11:40:30+00:00","breadcrumb":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/sare-system\/database-management\/create-an-effective-database-of-e-mail-addresses-and-gsm-numbers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Centrum pomocy","item":"https:\/\/sare.pl\/baza-wiedzy\/en\/"},{"@type":"ListItem","position":2,"name":"Uncategorized","item":"https:\/\/sare.pl\/baza-wiedzy\/en\/uncategorized\/"},{"@type":"ListItem","position":3,"name":"Create an effective database of e-mail addresses and GSM numbers"}]},{"@type":"WebSite","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#website","url":"https:\/\/sare.pl\/baza-wiedzy\/en\/","name":"SARE | Baza wiedzy","description":"SARE | Baza wiedzy","publisher":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sare.pl\/baza-wiedzy\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#organization","name":"SARE | Baza wiedzy","url":"https:\/\/sare.pl\/baza-wiedzy\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/logo\/image\/","url":"https:\/\/sare.pl\/baza-wiedzy\/wp-content\/uploads\/2023\/11\/Frame-7540-1.png","contentUrl":"https:\/\/sare.pl\/baza-wiedzy\/wp-content\/uploads\/2023\/11\/Frame-7540-1.png","width":372,"height":160,"caption":"SARE | Baza wiedzy"},"image":{"@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SAREpl"]},{"@type":"Person","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/person\/167ecfd76cdd32904d33a8c56f137e3a","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sare.pl\/baza-wiedzy\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c41b30fd9393eb744de159dd22162b679cd7596c81b8e0495338a751f97227f2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c41b30fd9393eb744de159dd22162b679cd7596c81b8e0495338a751f97227f2?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/sare.pl\/baza-wiedzy"],"url":"https:\/\/sare.pl\/baza-wiedzy\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/posts\/5502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/comments?post=5502"}],"version-history":[{"count":0,"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/posts\/5502\/revisions"}],"wp:attachment":[{"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/media?parent=5502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/categories?post=5502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sare.pl\/baza-wiedzy\/en\/wp-json\/wp\/v2\/tags?post=5502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}