{"id":776,"date":"2023-05-15T10:47:16","date_gmt":"2023-05-15T10:47:16","guid":{"rendered":"https:\/\/blog.rackemapp.com\/?p=776"},"modified":"2024-04-03T14:57:33","modified_gmt":"2024-04-03T14:57:33","slug":"team-and-player-data-import","status":"publish","type":"post","link":"https:\/\/blog.rackemapp.com\/?p=776","title":{"rendered":"Team and Player Data Import"},"content":{"rendered":"\n<p>In order to make the transition to RackEmApp easier, we have created a data import tool that will import your teams, players and venues as part of the Season Wizard (and only via the Season Wizard)<\/p>\n\n\n\n<p>When you reach the Teams section of the wizard there is a button for <strong>Import Data<\/strong> which will open the function.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5-1024x231.png\" alt=\"\" class=\"wp-image-777\" srcset=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5-1024x231.png 1024w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5-300x68.png 300w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5-768x173.png 768w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5-1536x346.png 1536w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5-1200x270.png 1200w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-5.png 1559w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The import is based upon a predefined template in Excel. This can be downloaded via the button, or for convenience, a link is provided here. <a href=\"https:\/\/www.rackemapp.com\/docs\/ImportTemplate.xlsx\">Download Template<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"527\" height=\"445\" src=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-6.png\" alt=\"\" class=\"wp-image-778\" srcset=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-6.png 527w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-6-300x253.png 300w\" sizes=\"(max-width: 527px) 100vw, 527px\" \/><\/figure>\n\n\n\n<p>The file itself is quite straightforward and instructions are provided in the file. Please do not remove anything above the header or the instructions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-7-1024x335.png\" alt=\"\" class=\"wp-image-779\" srcset=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-7-1024x335.png 1024w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-7-300x98.png 300w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-7-768x251.png 768w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-7.png 1134w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Populate the spreadsheet whoever you need to using Excel, which is outside the scope of what we support. But please remember the following.<\/p>\n\n\n\n<ul>\n<li>This adds data, it does not update. <\/li>\n\n\n\n<li>It looks for exact matches on names, venues and tables when trying to relate data together &#8211; if no match is found it will create<\/li>\n\n\n\n<li>If email addresses are provided, it will generate invitations for captains and players to register their accounts<\/li>\n<\/ul>\n\n\n\n<p>When your spreadsheet is populate, browse to find it and press <strong>Import Data<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"510\" height=\"434\" src=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-8.png\" alt=\"\" class=\"wp-image-780\" srcset=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-8.png 510w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-8-300x255.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/figure>\n\n\n\n<p>Whislt the data is importing, please do not close the window. it will close by itself once the import has finished.<\/p>\n\n\n\n<p>If the process takes longer than 1 minute the chances are it has failed and recommend refreshing the page and contact support.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"514\" height=\"512\" src=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-9.png\" alt=\"\" class=\"wp-image-781\" srcset=\"https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-9.png 514w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-9-300x300.png 300w, https:\/\/blog.rackemapp.com\/wp-content\/uploads\/2023\/05\/image-9-150x150.png 150w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In order to make the transition to RackEmApp easier, we have created a data import tool that will import your teams, players and venues as part of the Season Wizard (and only via the Season Wizard) When you reach the Teams section of the wizard there is a button for Import Data which will open [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=\/wp\/v2\/posts\/776"}],"collection":[{"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=776"}],"version-history":[{"count":2,"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=\/wp\/v2\/posts\/776\/revisions"}],"predecessor-version":[{"id":784,"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=\/wp\/v2\/posts\/776\/revisions\/784"}],"wp:attachment":[{"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rackemapp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}