Analyst's Notebook can import data that is stored in XML files
if the files are converted to another format or you provide a style sheet that transforms the data
to a compatible format.
About this task
You could convert XML files to CSV or XLS format and build a specification to import your data.
Alternatively, you can transform XML data into Analyst's Notebook Exchange files with an XLST style
sheet. XML data that is converted into ANX XML structure can be imported into Analyst's Notebook without an import specification.
Procedure
To import XML data in Analyst's Notebook Exchange, you specify the location of the source
file and some processing instructions.
-
Click the Home tab, and then click .
Note: Despite its name, this command supports importing data in any XML format, not only Analyst's
Notebook Exchange files.
-
In the Select Data File to Import window, locate the file that contains
your data, and then click Open.
- In the Import XML window, configure the behavior of the XML
import wizard:
| Apply Style Sheet |
If you are not importing an Analyst's Notebook Exchange (.anx) file,
select this option and specify an XSLT style sheet. The style sheet must transform the XML so that
it validates against the Analyst's Notebook schema. |
| Create New Chart |
Select this option to import the data into a new chart instead of the current
chart. |
| Layout Imported Items |
Select this option to apply a peacock layout to the imported data. Any items that are
already on the chart are not affected. |
| Enable Enhanced Validation Rules |
Select this option to perform more careful validation before the data is
imported. |
-
Click OK to import the data from the XML file that you selected.
When the import process finishes, the application displays a message that indicates the success
or failure of the process. If the import fails, the message includes the location of a log file.
Note: Data imports from XML files cannot be used to create records in i2 Analyze.
