Show Menu
TOPICS×

Import numeric 2 classifications

The ability to import Numeric 2 and Date-Enabled classifications has been removed from the codebase. This change will take effect with the July 2019 Maintenance Release. If you have Numeric or Date-Enabled columns in your import file, those cells will be silently ignored, and any other data within that file will be imported as normal. Existing classifications can still be exported through the standard classification workflow, and will continue to be available in reporting.
The import and export file includes six columns for each numeric 2 classification.
The following definitions assume that your numeric 2 classification name is MyCost.
~MyCost: A descriptive name for the row.
~MyCost^~id~: The ID for editing an existing row. When you add a new row, this should be blank. An ID is automatically assigned when you export from the Classification Manager.
**~MyCost^~value~: **The value for the row. If the rate column is fixed, then this is a flat value distributed over the whole period. If the rate column is an event, then this is the multiplier for that event. This entry should not contain commas.
~MyCost^~period~: The period of time to which this row corresponds. This must include a beginning and ending date, separated by a dash. The dash must be enclosed in spaces. The definition should be formatted as follows:
YYYY/MM/DD - YYYY/MM/DD
~MyCost^~rate~: The event to multiply by the Value column. Valid values are:
  • fixed - used to indicate that value is a flat value to be spread over the period.
  • revenue
  • order
  • unit
  • scopen
  • scviews
  • instance
  • click
  • checkout
  • scadd
  • scremove
  • event 1
  • event 2
  • etc
~MyCost^~hinge~: The event to use to distribute the value during a breakdown. This value is often the same as ~MyCost^~rate~, unless you are using fixed. The valid values for this column are identical to that of ~MyCost^~rate~, with the addition of none.