FO Set Import - CSV

Also see FO Tables as the preferred method for importing FO data.

This style of import is designed to work with a specified Financial Object . Rather than reading in data that varies over time, this import reads in data for a single period, but can include Constants, Line Items, FO Attributes, and titles.

An import of this type is treated as a one-time event. Subsequent imports will replace the value of the original import if it is for the same Layer Start Date (see below), including value layers. However if the Start Date is changed, the data will be re-imported.

Note: If the re-import is in the same Overlay used in a previous import, you will need to make a Priority Adjustment (see below).

Preparing to Import

  1. Right click to bring up the Add menu, select New FO Set Import, then select from CSV File.
  2. Title the import and type in any Annotations (notes) concerning the import, or attach a document.
  3. From the FO Type list, select the FO that will receive the data. Click Save.
  4. Select the Group that the newly created FO Instances will be placed.

Note: If the FO is based on a Basic Duration Line Item FO or Basic Instant Line Item, you will need to create a group in User Defined if none exist.

  1. If you want to automatically create a new group within the group selected in Step 4 above, type in a name for the new group in New Group Title.
  2. Select the Identity to be used for mapping data store records to FOs.
  3. Re-title FO by clicking on title components to change, add or delete text, or FO Attributes
  4. Select the Overlay that will receive the data.
  5. If the selected overlay already has Layers for the line item(s) that will receive the data, enter a LAYER Priority Adjustment.

If more than one layer is created for the same line item and is assigned to the same overlay (or one with the same priority), a potential conflict could occur. The software handles the potential conflict by using the time of creation for layer, with the layer created last taking priority.

  1. Select the Date for which the incoming data applies for LAYER Start Date.
  1. For Skip first line? select yes if the first line CSV file has column head information rather than data that is to be imported.
  2. Date Format
    • MM/dd/yyyy e.g. 03/15/1962
    • MM/dd/yy e.g. 03/15/62
    • dd/MM/yyyy e.g. 15/03/1962
    • dd/MM/yy e.g. 15/03/62
    • dd/MMM-yyyy e.g. 15-Mar-1962
    • dd-MM-yy e.g. 15-Mar-62
    • MMMMM dd, yyyy e.g. March 15, 1962

 

Reading in the file

  1. Once Steps 1-11 have been completed above, click Read-CSV-FIle from the menu.
  2. Click Choose File, and navigate to the location of the file you want to read in.
  3. Click Upload File.

Mapping the data

Now that the data has been read in, you will need to map the columns in the file to the attributes and parameters of the FO Instances; Each column represents a attribute or parameter and each row represents an FO Instance An FO Instance inherits all parameters and any logic(formulas) contained in the FO. Any change in the FO is immediately updated in all instances.. Another way to think about the data being read in is as a database record.

Example: If you created an employee object that includes the employee's name, employee number, and salary and want to automatically create the FO Instances and populate the values, an FO Set import is the solution. Create a CSV file with a column each for the name, number, and salary.

When the mapping is complete, click Save. Then click Import FO data.

 

Related Links:

FO Set Import

FO Set Import - SQL

Data Store Import

FO Tables