Save validation messages to a CSV file
From the Baselines Browser or the Jobs Browser, you can save the processing messages for all validation baselines to a comma-separated value (CSV) file that can be opened in a Microsoft Excel spreadsheet.
This file contains all of the columns that the Baselines Browser or the Jobs Browser can display. This information differs between the Baselines Browser and the Jobs Browser. Additionally:
- A file saved from the Baselines Browser contains messages only from validation jobs.
- A file saved from the Jobs Browser contains messages from all types of jobs that appear in the Jobs Browser. These messages can include information from validation, deployment, and import jobs.
To save validation baseline messages from the Baselines tab:
- Open the Baselines Browser.
Note: If the Baselines Browser is not visible, select View > Baselines.
- Click Save As, or right-click the browser, and select Save As.
The Save As dialog box appears.
- Browse to the location in which to save the file.
- Specify a file name, and click Save.
To save validation baseline messages from the Job Log:
- In the row of browser tabs, select the Jobs Browser.
The Jobs Browser appears.
- Select the Jobs tab.
Tip: If you don't see the Jobs tab, at the top left of the page, select View, and make sure Jobs is selected.
- Click Save As, or right-click the browser, and select Save As.
The Save As dialog box appears.
- Browse to the location in which to save the file.
- Specify a file name, and click Save.
Baselines Browser - Option descriptions
Option |
Description |
---|---|
Buttons |
|
Edit |
Edit the name and description of the selected baseline. |
Delete |
Delete the selected baseline. You can only delete a baseline that does not have a deployment package associated with it. |
Ignore Warnings |
View warning messages and either update the study to correct them or indicate that you will ignore the warnings. |
Make Public |
Mark a baseline as public so that other users can view and work with it. |
Show Validation/Hide Validation |
|
Refresh |
Refresh the display of baselines from the Central Designer database. Job results for baselines that are expanded are also refreshed from the database. |
Save As |
Save the contents of the Baselines Browser to a comma-separated value (CSV) file that can be opened in a Microsoft Excel spreadsheet. |
Fields |
Note: Not all fields appear in the default view. Optionally, you can add the other fields to the browser view, and you can rearrange the order of fields. For more information, see Showing and hiding a field. |
Baseline ID |
Unique identifier of the baseline. |
Date Created |
Date and time that the baseline was created. |
Deployed |
Yes or No, indicating whether the baseline has been processed for deployment. |
Description |
Description of the baseline, updated if you edit the baseline. |
Job ID |
Unique identifier of the job in which the baseline was created. |
Name |
Name of the baseline. By default, the name consists of the string Validation baseline, along with the date and time it was created. |
Public |
Yes or No, indicating whether the validation baseline has been made public. |
Revision |
Revision number of the baseline. The revision consists of three numbers: "Major.Minor.Revision," such as 1.0.2.
|
Status |
Status of the baseline:
|
Study ID |
Unique identifier of the study for which the baseline is generated. |
Sub-columns The following columns are in the grid that appears when you click Show Job Results and expand the results for a job. |
|
Code |
Unique identifier for the validation error or warning. You can provide the code when submitting issues to Oracle Support. |
Description |
Description of the baseline message. |
Date Created |
Date and time the validation message was created. |
Issue Name |
Type of issue for which the job result is reporting. This field contains a value only if the job result is a validation error on a rule. Options include Rule Name and sometimes Function Name. |
Job Id |
Unique identifier of the job in which the baseline was created. |
Job Result Id |
Unique identifier of the baseline message. |
Object RefName |
RefName of the study object that is reported in the validation message. This field contains a value only if the job result is a validation error on a rule. |
Object Title |
Title of the study object that is reported in the validation message. This field contains a value only if the job result is a validation error on a rule. |
Path |
Path of the study object that is reported in the validation message. This field contains a value only if the job result is a validation error on a rule. |
Validation Type |
Type of message:
|
Warning Ignored |
Indicates if you have chosen to ignore a warning. |
Job Log Browser - Option descriptions
Note: Not all fields appear in the default view. Optionally, you can add the other fields and rearrange the browser view.
Jobs Browser—Option descriptions
Option |
Description |
---|---|
Buttons |
|
Hide Job Results/ Show Job Results |
|
Refresh |
Refresh the display of jobs from the Central Designer database. When you refresh, the job results for expanded jobs are also refreshed. |
Save As |
Save the contents of the Jobs Browser to a comma-separated value (CSV) file that can be opened in a Microsoft Excel spreadsheet. |
Jobs Since |
Drop-down list specifying how far back the display of job results goes. |
Columns |
|
Finish Time |
Date and time at which the job ended. |
Job State |
Run status of the job, either Started or Finished. |
Job Id |
Unique identifier of the job that generated the listing. |
Job Result |
Indicates whether the job scheduler ran successfully for the specified job. This field is not an indication of the status of the job.
|
Name |
Name of the job:
|
Start Time |
Date and time when the job started. |
Status |
Overall status of the job results for the selected job.
|
Status Icon |
Icon that corresponds to the status of the job. |
Study Id |
Unique identifier of the study for which the job was run. |
Type |
Type of job, either Import, Validation, or BuildDeploymentPackage. |
Sub-columns |
The following columns are in the grid that appears when you click Show Job Results and expand the results for a job. |
Code |
Unique identifier for the validation error or warning. You can provide the code when submitting issues to Oracle Support. |
Date Created |
Date and time the message was generated. |
Description |
Text of the message. |
Issue Name |
Type of issue for which the job result is reporting. This field contains a value only if the job result is a validation error on a rule. Options include Rule Name and sometimes Function Name. |
Job Id |
Unique identifier of the job that generated the listing. |
Job Result Id |
Unique identifier of the job result. |
Object RefName |
RefName of the study object that is reported in the job result. This field contains a value only if the job result is a validation error on a rule. |
Object Title |
Title of the study object that is reported in the job result. This field contains a value only if the job result is a validation error on a rule. |
Path |
Path of the study object that is reported in the job result. This field contains a value only if the job result is a validation error on a rule. |
Target |
Target application for which you validate the study and to which you deploy the study. |
Type |
Type of message:
|
Type Icon |
Icon that corresponds to the type of message. |
Warning Ignored |
True or False, indicating whether you have chosen to ignore the warning message for the purpose of performing additional processing. |