{"id":22895,"date":"2016-12-02T10:24:15","date_gmt":"2016-12-02T02:24:15","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=22895"},"modified":"2017-08-09T14:47:12","modified_gmt":"2017-08-09T06:47:12","slug":"exporting-your-configuration-4-3","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/exporting-your-config\/exporting-your-configuration-4-3\/","title":{"rendered":"Exporting Your Configuration (4.3)"},"content":{"rendered":"

This article applies to version 4.3 of P2 Server. For help on the latest version, see Exporting Your\u00a0Configuration<\/a>.\u00a0<\/p>\n

P2 Server Management allows you to export all the data in the P2 Server database to an Excel\u00ae spreadsheet. The main reason for doing this is so you can more easily update the configuration<\/a>\u00a0in bulk.\u00a0<\/p>\n

Exporting the data is simple.<\/p>\n

    \n
  1. In P2 Server Management, click the Import\/Export icon in the navigation bar.<\/li>\n
  2. Select the \u201cExport\u201d option from the middle panel.<\/li>\n
  3. Click the \u201cExport Server Data\u201d button.<\/li>\n<\/ol>\n

    <\/a><\/p>\n

    \u00a0<\/p>\n

    Note: You can also download a blank version of the spreadsheet by clicking \"Export Template\". It will have the same tabs and column headings, but will not contain any data. You should use this if you are importing configuration into a fresh database<\/a>.<\/p>\n

    The \"Save As\" dialog box opens and you will be prompted to save the Excel spreadsheet to your computer. You can change the name, but the file format MUST be .xlsx.<\/p>\n

    Important!<\/strong><\/span> You must keep the Export page open during the export process. The time taken for the export depends on the size of your database.\u00a0<\/p>\n

    During export, you can see its progress in the download status bar at the bottom of your screen.<\/p>\n

    <\/a><\/p>\n

    When the export has finished, you can open the file directly from the download status bar. The important thing to note here is that the Global Id<\/strong> column has been filled in for all tabs. This is the GUID that corresponds directly to the records\u00a0in the database, and is the field that allows the database to be updated by re-importing this spreadsheet.<\/p>\n

    \"exportfileexcel\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    P2 Server Management allows you to export all the data in the P2 Server database to an Excel spreadsheet. The main reason for doing this is so you can more easily update the configuration in bulk. This article shows you how to do this.<\/p>\n

    Read more<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":18710,"parent":4023,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[87],"class_list":["post-22895","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-export","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/22895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=22895"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/22895\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/4023"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/18710"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=22895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=22895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=22895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}