Overview
Get started in Logica using your data in an easy and fast way. The CSV Importer moves data from a CSV file into Logica and can be used to import data from a wide range of tools.
File Requirements
File Formats
Logica's import feature can be used with CSV UTF-8 files (ending in .csv).
Data Structure
Requirements
The data to be imported needs to be organized in rows.
There needs to be one header row with field names listed in columns. The header row needs to be the top row.
Files can contain a single time period or multiple time periods.
Example with Single Time Period
Example with Multiple Time Periods
Logica Model Setup
Component Setup
Before importing any data, a component leader needs to be built that contains all of the necessary fields that will map to the data being imported. Check out our library for pre-built templates of components that can be further customized to fit a wide range of data formats and use cases.
Importing Data
To import data into a Logica model, follow these steps:
Review file requirements to confirm the data file is ready for import.
Confirm the Logica model is set up properly.
Click on the blue arrow button, select "Import", and then "Data".
Select or drag the CSV file to upload and click "Next".
Input information about how this data will be imported into the model:
Component - Select the specific component that will contain the data to be imported.
Scenario - Select the specific scenario to be updated.
Match criteria (optional) - Select the component field(s) that uniquely identify each data row. This is needed to update any data that has previously been imported into Logica.
Map the column(s) in the data file to the corresponding component fields.
Click "Import".
What's Next?
Check out our template library for more ways to leverage Logica.