Versions Compared

Version Old Version 1 New Version 2
Changes made by

JeanH

FrancoisL

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Div
stylewidth:100%
idkt-documentation-section
aligncenter
HTML Table
cellpadding10px
Table Row (tr)
Table Cell (td)
width70%
valigntop
Below are some helpful tips when importing data from your CSV file into a specific folio team:

 

FOLIO Field

Import Notes

Type

Defines the role of the team member

(info) Default value if none specified : *With no role

Member

Defines the username of the JIRA user

(star) Mandatory - Must be a valid JIRA user

Description

You can specify a description for the team member

(info) Optional

Reporter

Defines the reporter of the data

(info) Default value if none specified : The importer

Start date

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

(star) Mandatory - must be specified in either case

End date

 Defines the end date of the worked hours period

(warning) Mandatory - must be specified in the case of a worked hours entry

Wage

Defines the wage of the team member (hourly rate).

(info) Optional if the consulting revenue already exists in folio else must be defined.

Allocation

Defines the allocation ratio (%) of the team member

(info) Default value if none specified : 100%

Worked Hours

Defines the hours worked in the period defined by the start date and end date

(info) Default value if none specified : Computed based on allocation table

Overtime Hours

Defines the overtime hours in the period defined by the start date and end date
Will be ignored if no overtime rule associated with the member

(info) Default value if none specified : Computed based on allocation table and Overtime rule

Overtime Rule NameThe name of the overtime rule to associate the member with.
(info) Optional
If name not found in the overtime list, no rules will be associated
Custom fields

Defines the value for a specific custom field

(info) Optional

Synchronized with JIRA worklogs

Specified if the team member worked hours must be synchronized with JIRA worklogs

(info) Default value if none specified : false

Info

You must have the edit rights on the folio to be able to import data.

 

 

Expand
titleCSV Example for team members

"Category","Type","Name","Member","Description","Reporter","WageCost Rate","Allocation","Worked Hours","Overtime Hours","Start date","End date","Synchronized with JIRA worklogs","Overtime Rule Name"
"SALARY","Administration","admin"admin1,"admin","Big ChefProject Manager","admin","4645.00","",""100.00,"","2014/07/13","","false",""
"SALARY","Administration","admin","admin","Project Manager","admin","","100.0000","","","2014/07/13","20132015/0803/3130","truefalse",""
"AdministrationSALARY","Developers","Michel dupont","admin2mdupont","Medium ChefIntermediate J2EE developer","admin","44.0035.00","","","","2014/07/13","","false",""
"SALARY","Developers","Michel dupont","mdupont","Intermediate J2EE developer","admin","","100.000000","","","2014/07/13","20132015/08/3103/30","false",""
"Administration"SALARY","Developers","Erika Lee","admin3elee","Small ChefWeb designer","admin","5635.00",","80.00","40","10","2013/08/31","40h per week - 2x","","","2014/07/13","","false","OT 1.5"
"SALARY","Developers","Erika Lee","elee","Web designer","admin","","100.0000","","","2014/07/13","2015/03/30","false","OT 1.5"



Expand
titleCSV Example for importing woked hours

"Member","Worked Hours","Overtime Hours","Start date","End date"
"admin","100.00","10","2013/08/31","2013/09/30"
"admin","110.00","","2013/10/01","2013/10/31"
"admin","115.00","","2013/11/01","2013/11/30"

Expand
titleCSV Example for importing allocations and wages

"Member","Wage","Allocation","Start date"
"admin","46.00","100.00","2013/08/31"
"admin","44.00","100.00","2013/09/30"
"admin","56.00","80.00","2013/10/31"

 


 

Style
#breadcrumb-section {margin-bottom: 10px;}
#breadcrumbs li,#breadcrumbs li a{color: #999;}
#main-header {margin: 10px 0 0;}
#title-text a {color: #3B73AF !important;}
.page-metadata {transition: opacity .25s ease-in-out;-moz-transition: opacity .25s ease-in-out;-webkit-transition : opacity .25s ease-in-out;}
.page-metadata {opacity: 0; margin: 0 0 30px;}
.page-metadata:hover {opacity: 1.0;}
#title-text {font-family: "kulturista-web",sans-serif;font-weight: 300;font-size: 50px;line-height: 75px;padding-bottom: 5px}
#splitter-sidebar img{top: 17px;position: relative;}
#splitter-sidebar h1 { font-size: 1.2em; margin: 0; padding-bottom: 20px; padding-top: 0;}