{"id":23013,"date":"2016-12-05T14:54:19","date_gmt":"2016-12-05T06:54:19","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=23013"},"modified":"2017-08-10T14:03:52","modified_gmt":"2017-08-10T06:03:52","slug":"importing-configuration-from-scratch-4-3","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/importing-from-scratch\/importing-configuration-from-scratch-4-3\/","title":{"rendered":"Importing Configuration From Scratch (4.3)"},"content":{"rendered":"\n

This article applies to version 4.3 of P2 Server. For help on the latest version, see Importing Configuration from Scratch<\/a>.\u00a0<\/p>\n

When you first install P2 Server, you will most likely need to import data into a blank database. The best way to do this is to use P2 Server Management to import a specially formatted Excel\u00ae spreadsheet. The spreadsheet has been formatted so that the Data Dictionary has the required information to accurately model your data\u00a0for use in other applications such as P2 Explorer<\/a>.<\/p>\n

Importing data into a blank database is a 3-step process.<\/p>\n

    \n
  1. Export a\u00a0blank spreadsheet.<\/li>\n
  2. Fill in the spreadsheet<\/a>.<\/li>\n
  3. Import the spreadsheet.<\/li>\n<\/ol>\n

    Let's look at this process, step by step.<\/p>\n

    Step 1. Export a\u00a0blank spreadsheet<\/h2>\n

    Because the format of the import spreadsheet is crucial to a successful import, we've made it easier for you by providing a blank template for you to fill in. All you need to do is download or export this from P2 Server Management.<\/p>\n

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

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

      The Excel spreadsheet will download and you will be prompted to save it to your computer.<\/p>\n

      Step 2. Fill in the spreadsheet<\/h2>\n

      The key to a successful import is to make sure that everything in the spreadsheet is filled in correctly.\u00a0<\/p>\n

      Related: Tips on Filling in the Import Spreadsheet<\/a><\/p>\n

      On the header rows in the spreadsheet, there are help comments for every column. This should provide you with enough information on what should be entered in the column. Click the little red comment indicator on the header row to see the help.<\/p>\n

      \"importcomments\"<\/a><\/p>\n

      You may find further information on crucial aspects of the Data Dictionary in the \"Server Primers<\/a>\" section of the Help Center.<\/p>\n

      Important<\/span><\/strong>:\u00a0Templates<\/a> will not appear in P2 Explorer unless they are marked as Primary<\/strong>. Marking a template as primary is now done through the use of time ranges<\/strong><\/em>, as these are now historised.\u00a0In the example below, we have an Oil Producing Well<\/strong> that is Primary<\/strong> from Forever<\/em> (null) to Forever<\/em> (null). The Other Template<\/strong> is not primary for any time period, because the start and end times are blank for the Primary Time Periods.<\/p>\n

      \"primarytemplate\"<\/a><\/p>\n

      \u00a0<\/p>\n

      Step 3. Import the spreadsheet<\/h2>\n

      When importing, P2 Server first checks the file for errors and then asks for your permission to proceed. This is a fail-safe mechanism to ensure no errors propagate into the system.<\/p>\n

      Note: During import, P2 Server Management is locked and other users will not be able to make any changes until the import has finished and the session is released.<\/p>\n

      The first part of the import process is similar to the export process:<\/p>\n

      1. In P2 Server Management, click the Import\/Export icon in the navigation bar.<\/p>\n

      2. Select the \"Import\" option from the middle panel.<\/p>\n

      3. Drag and drop your file into the box, or click the box to browse for your file and upload it.<\/p>\n

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

      The process continues\u00a0as soon as P2 Server detects your file.\u00a0First, the file is checked for errors and an overview of the upload\u00a0is displayed. The overview tells you how many rows have been counted for each worksheet, and highlights any errors that may be encountered. The overview for an error-free spreadsheet looks a bit like this:<\/p>\n

      \"workbookoverview\"<\/a><\/p>\n

      You must explicitly allow the import to proceed. You may continue to import a file with errors, but the system will disregard the errors and\u00a0only import the correctly filled in sheets.<\/p>\n

      There are 2 import options you can choose from:<\/p>\n