{"id":29843,"date":"2017-08-10T14:54:54","date_gmt":"2017-08-10T06:54:54","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=29843"},"modified":"2019-11-19T12:30:53","modified_gmt":"2019-11-19T04:30:53","slug":"tips-on-filling-in-the-import-spreadsheet-4-5-0","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/importexport\/tips-on-filling-in-the-import-spreadsheet\/tips-on-filling-in-the-import-spreadsheet-4-5-0\/","title":{"rendered":"Tips on Filling in the Import Spreadsheet (4.5.0)"},"content":{"rendered":"

<\/p>\n

This article applies to versions 4.5.0 and earlier of P2 Server. For the latest version, see Tips on Filling in the Import Spreadsheet<\/a>.<\/p>\n

The key to a successful import in P2 Server is to make sure that the import spreadsheet is in the correct format and that everything in the spreadsheet is filled in correctly. Here are some tips that should help.<\/p>\n

Tip 1. Know the spreadsheet\u00a0structure<\/h2>\n

A. Object Types
\n<\/strong>The spreadsheet contains several tabs, which should all be completed correctly for a fully-formed asset model. Each\u00a0tab represents an Object Type<\/strong><\/em>,\u00a0\u00a0which relates to an element of\u00a0the Data Dictionary and determines its structure.\u00a0Tab names do not matter, but Object Type does.\u00a0There must always be an Object Type in cell A1.
\nIf a worksheet has more than 1 section, further Object Types may be present in row 1.\u00a0<\/p>\n

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

The supported Object Types in version 4.5 are:<\/p>\n