/
Team CSV Export

Team CSV Export

Owned by JeanH (Deactivated)
Mar 12, 2015

 

 

Following grid show all budget fields that are exported and description of their contents.
Note the grid order may differ from the actual export file column order

FOLIO Field

Import Notes

CategoryThe category (always "SALARY")

Type

The role of the team member

Description

The description for the team member

Reporter

The reporter of the data

Start date

The start date of the worked hours period or the date on which the wage is effective.

End date

 The end date of the worked hours period.

Wage

The wage of the team member (hourly rate).

Allocation

The allocation ratio (%) of the team member.

Worked Hours

The hours worked in the period defined by the start date and end date.

Custom fields

The value for a specific custom field.

Note

Export will generate for a member :

  • one row per wages and/or allocations.
  • one row per worked hours
  • no row will be generated for "computed worked hours"
 Exported CSV Example
"Category","Type","Name","Member","Description","Reporter","Wage","Allocation","Worked Hours","Start date","End date"
"SALARY","Administration","admin","admin","Project Manager","admin","45.00","100.0000","","2013/09/02",""
"SALARY","Administration","admin","admin","Project Manager","admin","33.00","50.0000","","2013/11/05",""
"SALARY","Administration","admin","admin","Project Manager","admin","","","35.00","2013/12/01","2013/12/07"
"SALARY","Designers Web","Unassigned","unassigned","Designer Web senior","admin","50.00","100.0000","","2013/09/02",""

Related pages: