CSV: Difference between revisions

From PHENOM Portal Knowledgebase
Jump to navigation Jump to search
Nathalie (talk | contribs)
No edit summary
Josh (talk | contribs)
Update to the CSV import page after refactor
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
The CSV import tool allows users to bulk import data into their model.
The CSV import tool allows users to bulk import data into their model, both creating new nodes and editing existing nodes.


[[File:Phenom-data model-import csv.png|1200px|border]]
[[File:Csv before import.png|frameless|1199x1199px]]


To import a CSV file,
Simply select a CSV file to import which is less than 5MB, and press the import button. Depending on the size of the file, it may take some time to process.  
* Select the type of data from the Import Type dropdown. Selecting the "... UPDATE" option for any type of data will overwrite existing information.
* Under Import File, select a properly formatted CSV file (formatting rules are provided below)
* Click the Import button on the lower right side


The import might take some time depending on the size of the file. After the import finishes, a success message or an Import Errors message with each error and its respective row will be displayed.
When the processing is finished, an error message will appear if the columns in the CSV file do not fit any of the acceptable formats. If the imported CSV file is valid, a table will appear for review displaying all of the created and edited nodes, as well as a summary of the import.


[[File:Phenom-data model-import csv update.png|1200px|border]]
[[File:Csv after import.png|frameless|1190x1190px]]


The types of data the user can import are:
Visible in the list is the following information about the processed node:
* View characteristic (see [[Formatting a CSV for View Import]])
 
* Enumeration literal (see [[Formatting a CSV for Enum Import]])
* Row Number (corresponding to the CSV line number in which the node was created or edited)
* Entity and Association (see [[Formatting a CSV for Model Content Import]])
* Node Name
* Constraint
* Node Validity
* Platform Type
* Node Type
* Node Guid (If this would be a new node, the guid would be replaced with "New")
 
There are many actions to take on this table, including:
 
* Nodes may be manually selected or unselected to be saved using the check box in the far left of the row. All rows are selected by default.
* Select a node to see and potentially edit its attributes. If the node is not valid, the node must be edited before finishing the import.
* Reset any manual edits made to the node using the far right column in the row.
 
To save the changes displayed to the model, press the "FINISH IMPORT" button. Navigating away before pressing this button will not save any of the processed nodes.
 
== CSV Header Formats ==
Valid formats a user can import are:
* Views & View Characteristics (see [[Formatting a CSV for View Import]])
* Enumerations (see [[Formatting a CSV for Enum Import]])
* Entities & Associations (see [[Formatting a CSV for Entities and Associations Import]])
* Constraints
* Platform Types
* UoPs

Latest revision as of 15:49, 15 December 2025

The CSV import tool allows users to bulk import data into their model, both creating new nodes and editing existing nodes.

Simply select a CSV file to import which is less than 5MB, and press the import button. Depending on the size of the file, it may take some time to process.

When the processing is finished, an error message will appear if the columns in the CSV file do not fit any of the acceptable formats. If the imported CSV file is valid, a table will appear for review displaying all of the created and edited nodes, as well as a summary of the import.

Visible in the list is the following information about the processed node:

  • Row Number (corresponding to the CSV line number in which the node was created or edited)
  • Node Name
  • Node Validity
  • Node Type
  • Node Guid (If this would be a new node, the guid would be replaced with "New")

There are many actions to take on this table, including:

  • Nodes may be manually selected or unselected to be saved using the check box in the far left of the row. All rows are selected by default.
  • Select a node to see and potentially edit its attributes. If the node is not valid, the node must be edited before finishing the import.
  • Reset any manual edits made to the node using the far right column in the row.

To save the changes displayed to the model, press the "FINISH IMPORT" button. Navigating away before pressing this button will not save any of the processed nodes.

CSV Header Formats

Valid formats a user can import are: