Import custom database objects

You can import views, transpose functions, and transpose function tables from XML.

Note: Custom database objects can only be imported if PI SQL Commander Lite is connected to PI OLEDB Enterprise, PI SQL Client OLEDB, or PI SQL Client ODBC.

1. Connect to PI AF Server using PI OLEDB Enterprise, PI SQL Client OLEDB, or PI SQL Client ODBC and expand the schema in the Object Explorer pane.

   

2. Right-click an object in the Object Explorer pane that represents a catalog, and then click Import Custom Database Objects.

   

   The Custom Database Object Import window opens with Input file section.

3. Browse to the XML file that you want to import, and then click Next.

   

   The Available Objects to Import section is displayed. By default, all available objects are selected.

4. Clear the check boxes of objects you want to exclude from the import and click Next.

   

   The Import section is displayed. It reports details about the import, including whether each database object import was successful.

5. Click Execute to start the import.

   

   The database objects are imported. A green icon indicates that the import was successful. A red icon indicates an error.

6. If you see an error after the execution is complete, move the cursor over a red icon to view details about the error.

7. Click Done to close the window.