Specification Custom views that are associated with exported/imported project data have to be imported manually. As with the export/import project, this is a two stage process.
If you have not already done so, you must create a log.txt file in the Smart Instrumentation folder. For more information see Create and Configure a Log File for Exporting/Importing a Project.
Export
When you export a project a log file is generated in the LOG folder. This log file contains the custom view information for importing to your external database.
-
Open the File Explorer and navigate to the LOG folder.
-
Locate the generated Log_xxxxxxxxxx file.
Not the Log file you created with the folder. The log file you require is named Log followed by a string of letters and numbers.
-
In a text editor open the required log file and check that you can see the custom views.
The highlighted lines in red, are the exported custom views (the highlights are for
illustration only and do not appear in the log file). They include the custom view
name, followed by the database components that make up the custom view, enclosed in
brackets ().
-
Save the file and transfer it along with the DDTI file with your project data to your external contractor.
Import
-
Import your DDTI file.
-
Open the text file with the list of the specification custom views and using a database tool such as Smart Instrumentation Internal Setup, Toad, and so forth, run the SQL Statements.
-
You can run the SQL statements one by one or all together. If running the statements all together, remember in the case of view being based on another view the order may matter. You should check that the statements are in the correct order before running them.
-
The Custom Views syntax is the one used in the exported database. If you import the custom views to another platform, then the syntax needs to be adjusted accordingly.