Viewpoint Load File Format

Viewpoint loads accept comma separated (CSV) and Excel files, as well as ZIP files containing CSV and Excel files. This topic describes the requirements for those files.

Considerations

  • All viewpoint load files must contain a header record with at least these required fields:
    • Hierarchy viewpoints: Name (or Node), Parent, Node Type, Parent Node Type
    • List viewpoints: Name (or Node), Node Type
  • Column headers in the load file are matched against the property name, the full property name (with the namespace), and the viewpoint property label. For example, a column with the heading "Account Type" will match against either Account Type or PLN.Account Type.

    Note:

    If a column header matches on more than one property (for example, from different namespaces), an error is displayed instructing you to use fully qualified property names or viewpoint labels.
  • Ensure that your load file contains the full set of data for the viewpoint being loaded.
  • Only properties that are included in the header are added or updated. Existing properties in the viewpoint that are not included in the load file are ignored.
  • For Excel files, the worksheet name must match the viewpoint name that you are loading into, and the first row must be the header record.
  • For ZIP files, the files must be in Excel or CSV format.
    • If there is only one file in the ZIP, it will be loaded into the viewpoint regardless of the file name.
    • If there are multiple files in the ZIP:
      • If only one file ends with a viewpoint name, it is loaded into the viewpoint.
      • If multiple files end with the same viewpoint name, none of the files are loaded and an error is displayed.

    Caution:

    Some Microsoft 365 environments automatically apply a sensitivity label to new or saved Excel workbooks. Certain sensitivity labels apply encryption to the file’s contents. When an Excel file is encrypted, uploading the file into Oracle Fusion Cloud Enterprise Data Management will typically fail. If you encounter issues loading an Excel file, either upload the file in CSV format or open the workbook in Excel and change the file’s sensitivity label to a less restrictive option (for example, Public or your organization’s equivalent) that does not apply encryption. Then save the file and upload it again.
  • Load files should be encoded in UTF-8.

    Tip:

    To preserve Unicode characters, save your load file with the following option in Excel: CSV UTF-8 (Comma delimited) (*.csv).