Introduction
In terms of Epicflow system management we have functionality which grants an ability to seamlessly Import/Upload (further Import will be used) and Export data files such as: Resource Pool, Attributes, Calendars, Competences, Availability of Resources and Project directly through User Interface. Additionally, for Export there is system logs option, which provides valuable insights into operations. Worth to say that such operation is critical in prospective of data consistency and further analysis, so only System Administrator and PO are allowed to assign corresponding permission for the role.
#Screen 1 System Maintenance: Competences- Export, Update, Upload
With this functionality, users gain the capability to seamlessly upload and update data directly from their desktops. For those seeking to automate this process, we encourage reaching out to Epicflow Support at support@epicflow.net.
Options overview
Maintenance Page
- Attributes – An attribute is a feature of a project, its item, or resource that distinguishes it from others. More about attributes you can read in this article.
- Availability – Availability is a data that show us the accessibility of resources.
- Calendar – Each company that uses Epicflow has it’s own calendar, allowing them to specify holidays, weekends, and the number of working hours, which can vary depending on company policies and practices.
- Competences – Competence for employees in the system refers to the specific skills, knowledge, and abilities that individuals possess to perform their job roles effectively. More about competences you can read in this article.
- Resource Pool – A resource pool is a data file containing information about all available employees within an organization, including details such as their names, availability, skills, and other relevant attributes.
- Logs – System logs are concise records generated by a computer system, capturing events, actions, and errors that occur during its operation. Due to the nature of these data, which are used for system analysis, only exporting is possible.
Pipeline Page
- Project – In project management, a project refers to a endeavor undertaken to create a unique product, service, or result. Projects have defined objectives, constraints, and a timeframe within which they are executed.
Permissions configuration
Be aware that Import\Export functionality is critical in prospective of data consistency and further analysis, so its usage is limited only to those users to which corresponding permission is assigned by System Administrator or PO.
For relevant permissions adjustment “Administrator” role is required. Generic permissions description can be found in this article.
In case of Import\Export Data Files functionality you need to set “System Maintenance” permission from the “Global Permission” group.
Important to say that “System Maintenance” is also required for Projects Import\Upload via the Pipeline page.
![](https://wiki.epicflow.com/wp-content/uploads/2024/03/Maintenance-Setting.gif)
#Screen 1 “System Maintenance” permission
Guidelines for Uploading Data: Understanding the Different Methods
Depending on the type of data you’re working with, there are two methods for uploading it into our system. Below, we outline the different categories of data and the corresponding upload methods:
- Resource Pool, Attributes, Availability, Calendars, Competences:
- These types of data can be conveniently uploaded using the Maintenance Page feature.
- Project Data:
- For uploading Project data, we utilize the Pipeline Page.
#Screen 2 System Maintenance: Resource Pool, Calendar, Competences, Attributes, Availability, Logs
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/Maintenance-Project-1024x508.png)
#Screen 3 System Maintenance: Project
Templates
To successfully import data, it’s crucial to ensure that files are prepared correctly. To assist you in this process, we have a set of templates that you can download and utilize as examples.
Please visit Downloads Website to download template files from the corresponding subsection labeled as ‘System Maintenance – Import\Export’.
If you have already data in the system it’s also good approach to export data, edit and upload it again
CSV File Structure Overview
This section outlines the key requirements and formats for CSV files used within the Epicflow system, ensuring users can manage their data with precision and efficiency. Understanding and implementing the correct CSV file structure is crucial for various system operations, including importing, exporting, updating, and deleting data.
– Competences
This CSV file provides a way to specify competences and their structure.
- Example #1: Create Competences in the system
1. Below, you can see the table representing competence headers and values.
RecordType | Id | Name | ParentId |
C | Analytical thinking |
The 1st row – contains column names.
The 2nd row – contains record name: C that stand for competence and competence’s name which is Analytical Thinking.
2. In CSV File this example looks like this:
C;;Analytical thinking;
3. After upload in Epicflow this example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-4.png)
#Screen 4 Competences in Epicflow
Minimum Required Fields to Upload Competences
RecordType: C, Name
Upload:
Read here how to upload competences to the system.
Export:
Read here how to export competences from the system.
Update:
To update competences, you must first obtain their unique IDs. This requires exporting the competences file to access this information. Once you have retrieved the IDs, you can proceed with updating the competences by modifying the desired fields, excluding the ID. Once your file is prepared you can update competences by uploading the file to the system.
- Example #2: Update Competences in the system.
1. You have exported file that looks like this:
C;;Analytical thinking;
RecordType | Id | Name | ParentId |
C | 1 | Analytical thinking |
The 1st row – contains column names.
The 2nd row – contains record name: C that stand for competence and competence’s name which is Analytical Thinking.
2. To update Competence in the system your file needs to look like this:
C;1;New_name_for_Analytical_thinking;
RecordType | Id | Name | ParentId |
C | 1 | New_name_for_Analythical_thinking |
The 1st row – contains column names.
The 2nd row – contains record name: C that stand for competence, competence’s Id and updated competence’s name which is New_name_for_Analythical_thinking.
Add:
Previously, you saw an example of uploading new competences to the system when none were present. Now, we’ll demonstrate the correct procedure for adding additional competences to existing ones. This procedure is very similar to the update procedure. You need to export Competences file from the system, then edit this file by adding a new competence without specified ID.
- Example #3: Add additional competences to existing ones in the system.
1. You have exported file that looks like this:
C;;Analytical thinking;
RecordType | Id | Name | ParentId |
C | 1 | Analytical thinking |
The 1st row – contains column names.
The 2nd row – contains record name: C that stand for competence and competence’s name which is Analytical Thinking.
2. To add new Competence to the system your file needs to looks like this:
C;1;Analytical thinking;
C;;New_Competence;
RecordType | Id | Name | ParentId |
C | 1 | Analytical thinking | |
C | New_Competence |
The 1st row – contains column names.
The 2nd row – contains record name: C that stand for competence and competence’s name which is Analytical Thinking.
The 3rd row – defining new competence named ‘”‘New_Competence’ that will be added to the system.
Delete:
To delete all competences from the system, you can upload a file containing only column names with empty values. This action will remove all competences from the system.
- You can remove all competences via uploading this file.
- Upload file to the system via Maintenance page as described in header: Import Resource Pool, Calendar, Attributes and Competences
Competences Structure: Nesting
It’s possible to build a nested structure for competences by first creating a Competences Group, where later we will nest its values.
To refer to the created Competences_Group, you should specify an unique Id. You do this to inform the system about the new record and references to it. Please note that the system will assign its own ID values, so they won’t be the same when you export competences from the system. You can read more about the requirements regarding the CSV file here.
- Example #4: Build a nested structure for competences.
1. Below you can see the table that represents competences headers and values in nested structure.
RecordType | Id | Name | ParentId |
G | 1 | Competences _Group | |
C | Competence_1 | 1 |
The 1st row – contains column names.
The 2nd row – contains the Record Type: ‘G’, which stands for a Competences Group named Competences_Group with an ID of 1, which we will later use as a reference to this group.
The 3rd row – contains record Type C that stands for a Competence named Competence_1 with ParentId 1. That means that this competence belongs to group Competences_Group.
2. CSV File this example looks like this:
G;1;Competences;
C;;Competence_1;1
3. After upload in Epicflow this example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-5.png)
#Screen 4 Competences nested in Group in Epicflow
Competences CSV file contains next columns:
- RecordType – Indicates the type of record, in this case, “C” stands for competence record and “G” stands for competences Group.
- Id – Represents the unique identifier for the competence or competences group.
- Name – The name of the competence or group.
- ParentId – Specifies the identifier of the parent competence(competences group).
More Examples
- Example #5: Build an advanced nested structure for competences.
1. Here you can learn how to build a more advanced nested structure for competences with usage of an ID with an unique ID, such as ‘1’, to refer to the IDs while nesting competences within the groups. You can read more about the requirements regarding the CSV file here.
RecordType | Id | Name | ParentId |
G | 1 | Competences_Group1 | |
G | 2 | Competences_Group2 | |
C | Competence_1 | 1 | |
C | Competence_2 | 2 |
The 1st row – contains column names.
The 2nd row – contains the Record Type: ‘G’, which stands for a Competences Group named Competences_Group1 with an ID of 1, which we will later use as a reference to this group.
The 3rd row – contains the Record Type: ‘G’, which stands for a Competences Group named Competences_Group2 with an ID of 2, which we will later use as a reference to this group.
The 4th row – contains record Type C that stands for a Competence named Competence_1 with ParentId 1. That means that this competence belongs to group Competences_Group1.
The 5th row – contains record Type C that stands for a Competence named Competence_2 with ParentId 2. That means that this competence belongs to group Competences_Group2.
2. In CSV File this example looks like this:
G;1;Competences_Group1;
G;2;Competences_Group2;
C;;Competence_1;1
C;;Competence_2;2
3. After upload in Epicflow this example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-6.png)
#Screen 5 Competences nested in Groups in Epicflow
– Attributes
This CSV file provides a way to specify attributes and their structure.
- Example #1: Create attributes in the system
1. From this example, you can learn how to create a basic csv attributes file to create attributes in the system.
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Location | 1 | ||||||||||||||
T | Location | 1 | List | |||||||||||||
V | Germany | 1 |
The 1st row – contains column names.
The 2nd row – contains information about record Type: A that stand for attribute. Attribute Name that is Location and 1 TypeId that will let us refer to this attribute in next rows to associate them with this attribute.
The 3rd row – This record contains information about Type: T, which stands for Type and specifies whether it is a hierarchy or a list in the TypeKind column. Additionally, the Name field mirrors the attribute name associated with this record through the utilization of the same TypeId.
The 4th row – This record contains Record Type: V, representing a Value named “Germany.” It specifies values for the Attribute Location, as indicated in the TypeId column, which references the Attribute Location Id.
2. In CSV Format this example looks like this:
A;Location;;1;;;;;;;;;;;;;
T;Location;;1;List;;;;;;;;;;;;
V;Germany;;1;;;;;;;;;;;;;
3. In Epicflow this example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-7.png)
#Screen 6 Attributes in Epicflow
Minimum Required Fields to Upload Attributes File
RecordType: T, Name, TypeId, TypeKind: Hierarchy/List
RecordType: V, Name, TypeId
Upload:
Read here how to upload attributes to the system.
Export:
Read here how to export attributes from the system.
Update:
To update attributes, you must first obtain their unique IDs. This requires exporting the attributes file to access this information. Once you have retrieved the IDs, you can proceed with updating the attributes by modifying the desired fields, excluding the ID. Once your file is prepared you can proceed with importing attributes to the system.
- Example #2: Update Attribute in the System
1. You have exported file that looks like this:
A;Location;;1;;;;;;;;;;;;;
T;Location;;1;List;;;;;;;;;;;;
V;Germany;;1;;7;;;;;;;;;;;
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Location | 1 | ||||||||||||||
T | Location | 1 | List | |||||||||||||
V | Germany | 1 | 2 |
The 1st row – contains column names.
The 2nd row – contains information about record Type: A that stand for attribute. Attribute Name that is Location and its ID: 1
The 3rd row – This record contains information about attribute type which is List.
The 4th row contains Record Type: V, representing a value named ‘Germany.’ This value belongs to the attribute Location, as indicated by the TypeId that refers to the mentioned attribute. Furthermore, we see ValueId, which is 2. This ID is necessary to proceed with any updates to this value
2. To update the Attributes in the system your file needs to look like this
A;Location;;1;;;;;;;;;;;;;
T;Location;;1;List;;;;;;;;;;;;
V;New_Name_for_Germany;;1;;2;;;;;;;;;;;
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Location | 1 | ||||||||||||||
T | Location | 1 | List | |||||||||||||
V | New_Name_for_Germany | 1 | 2 |
The 1st row – contains column names.
The 2nd row – contains information about record Type: A that stand for attribute. Attribute Name that is Location and its ID: 1
The 3rd row – This record contains information about attribute type which is List.
The 4th row – contains a record with Record Type: V, representing a value previously named ‘Germany,’ but now we can see that its name is being updated to ‘New_Name_For_Germany’.
Add:
Previously, you saw an example of uploading new attributes to the system when none were present. Now, we’ll demonstrate the correct procedure for adding additional attributes to existing ones. This procedure is very similar to the update procedure.
- Example #3: Add additional attributes to the existing ones in the system
1. You have exported file that looks like this:
A;Location;;1;;;;;;;;;;;;;
T;Location;;1;List;;;;;;;;;;;;
V;Germany;;1;;2;;;;;;;;;;;
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Location | 1 | ||||||||||||||
T | Location | 1 | List | |||||||||||||
V | Germany | 1 | 2 |
The 1st row – contains column names.
The 2nd row – contains information about record Type: A that stand for attribute. Attribute Name that is Location and its ID: 1
The 3rd row – This record contains information about attribute type which is List.
The 4th row contains Record Type: V, representing a value named ‘Germany.’ This value belongs to the attribute Location, as indicated by the TypeId that refers to the mentioned attribute. Furthermore, we see ValueId, which is 2. This ID is necessary to proceed with any updates to this value
2. To Add new Attribute your file needs to look like this:
A;Location;;1;;;;;;;;;;;;;
T;Location;;1;List;;;;;;;;;;;;
V;Germany;;1;;2;;;;;;;;;;;
V;Netherlands;;1;;;;;;;;;;;;;
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Location | 1 | ||||||||||||||
T | Location | 1 | List | |||||||||||||
V | Germany | 1 | 2 | |||||||||||||
V | Netherlands | 1 |
The 1st row – contains column names.
The 2nd row – contains information about record Type: A that stand for attribute. Attribute Name that is Location and its ID: 1
The 3rd row – This record contains information about attribute type which is List.
The 4th row contains a new record with Record Type: V, representing a value previously named ‘Netherlands.’ The TypeID is 1, which means that this value belongs to the attribute Location.
Delete:
You can remove attributes values by uploading file containing only columns names. It’s not possible to remove attributes types by uploading CSV File.
Attributes Structure: Nesting
Attributes, as opposed to competences, always have a nested structure. It is not possible to send only the attribute value; its type must always be specified: hierarchy or list. The distinction between hierarchy and list lies in the fact that a hierarchy can be developed, meaning values can be nested within other values, while a list is like a Category Group for Attributes, exactly the same as the Category Group for Competences.
To refer to the created Attributes and its Values, you should specify an unique ID. You do this to inform the system about the new record and references to it. Please note that the system will assign its own ID values, so they won’t be the same when you export attributes from the system. You can read more about the requirements regarding the CSV file here.
To specify the parent value for an attribute, we should provide a unique ID for the parent value in the ValueId column. Subsequently, for the child attribute, we should specify this ID in the ValueParentId column.
- Example #4: Build Nested Structure for Attributes.
1. Below, you can see a table representing attributes with a Hierarchy type that allows nesting values within values.
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Technology | 1 | ||||||||||||||
T | Technology | 1 | Hierarchy | |||||||||||||
V | Hardware | 1 | 2 | |||||||||||||
V | Keyboard | 1 | 2 |
The 1st row contains column names.
The 2nd row contains information about record Type: A that stand for attribute. Attribute Name that is Technology and 1 TypeId that will let us refer to this attribute in next rows to associate them with this attribute.
The 3rd row This record contains information about Type: T, which stands for Type and specifies whether it is a hierarchy or a list in the TypeKind column. Additionally, the Name field mirrors the attribute name, and this record is associated with the Attribute through the utilization of the same TypeId.
The 4th row of this record contains Record Type: V, representing a Value named ‘Hardware.’ It specifies values for the Attribute Technology, as indicated in the TypeId column, which references the Attribute Technology Id. Additionally, we can specify a ValueId, which we’ll later use to nest another value within the Hardware Value.
The 5th row This record contains Record Type: V, representing a Value named “Keyboard.” It specifies values for the Attribute Technology, as indicated in the TypeId column, which references the Attribute Technology Id. Additionally, we observe that this record has a Value Parent Id 2, indicating that it is nested under the value Hardware.
2. In CSV Format this example looks like this
A;Technology;;1;;;;;;;;;;;;;
T;Technology;;1;Hierarchy;;;;;;;;;;;;
V;Hardware;;1;;2;;;;;;;;;;;
V;Keyboard;;1;;;2;;;;;;;;;;
3. In Epicflow this example looks like this
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-8.png)
#Screen 7 Attributes: Value nested in Value in Epicflow
Attributes CSV file contains next columns:
- RecordType – Specifies the type of record (A for Attribute, T for Type: Hierarchy, List, V for Value).
Hierarchy is used when you want to have a nested structure.
- Name – Name of the attribute.
- ShortName – Short name or abbreviation for the attribute.
- TypeId – Identifier for the type of attribute.
- TypeKind – Kind of attribute type.
- ValueId – Identifier for the attribute value.
- ValueParentId – Identifier for the parent attribute value.
- ValueCode1 – First code associated with the attribute value.
- ValueCode2 – Second code associated with the attribute value.
- AttributeExtraId – Extra identifier for the attribute.
- AttributeScope – Scope of the attribute.
- AttributeVisibility – Visibility of the attribute.
- AttributeIsSingle – Indicates if the attribute is single.
- AttributeValueOrder – Order of attribute values.
- AttributeNameIsHidden – Indicates if the attribute name is hidden.
- AttributeRepresentation – Representation of the attribute.
- AttributeDetailedRepresentation – Detailed representation of the attribute.
More Examples:
- Example #5: Create Attributes in the system: filling additional fields.
1. Below, you can see a table representing attributes as a List with specified Scope and Visibility.
RecordType | Name | ShortName | TypeId | TypeKind | ValueId | ValueParentId | ValueCode1 | ValueCode2 | AttributeExtraId | AttributeScope | AttributeVisibility | AttributeIsSingle | AttributeValueOrder | AttributeNameIsHidden | AttributeRepresentation | AttributeDetailedRepresentation |
A | Language | 1 | User, Group, Step, Project, ProjectGroup | Public | ||||||||||||
T | Language | 1 | List | |||||||||||||
V | English | 1 |
The 1st row contains column names.
The 2nd row contains information about record Type: A that stand for attribute. Attribute Name that is Language and *1 TypeId that will let us refer to this attribute in next rows to associate them with this attribute.
The 3rd row This record contains information about Type: T, which stands for Type and specifies Type Kind that is list in this example. Additionally, the Name field mirrors the attribute name, and this record is associated with the Attribute through the utilization of the same TypeId.
The 4th row – This record contains Record Type: V, representing a Value named “English.” It specifies values for the Attribute Language, as indicated in the TypeId column, which references the Attribute Language Id.
2. In CSV Format this example looks like this
A;Technology;;1;;;;;;;User, Group, Step, Project, ProjectGroup;Public;;;;;
T;Technology;;1;List;;;;;;;;;;;;
V;English;;1;;;;;;;;;;;;;
– Calendar
This CSV file provides a way to specify different average hours for different days of the week or for specific date ranges.
- Example #1: Creating Calendar CSV File.
1. Below, you can see a table representing calendar headers and values.
Calendar1 | sfsIdCalendar1 | ppmIdCalendar1 | |
AvgHours | DayOfWeek(optional) | StartDate(optional) | EndDate(optional) |
8 | |||
0 | Sunday | ||
4 | 25-12-2023 | 26-12-2023 |
The first row contains column names that we have replaced with values. The first column is for CalendarId, which remains empty during the addition of new calendars. The second column is for Calendar Name, and the name of the calendar is ‘Calendar1’. The third column is for SuccessFactorsID, where you can observe that we keep the column name and immediately specify sfsId as ‘Calendar1’. The fourth column is for ppmId, with its value being ‘Calendar1’, just as in the third column – we keep column name and right after this we specify its Id.
The 2nd row contains column names.
The 3rd row specifies the Average Hours for all days in the system for 8 hours per day.
The 4th row specifies 0 Average Hours for Sundays.
The 5th row specifies 4 hours as Average Hours in the date range 25-12-2023 to 26-12-2023
2. In CSV Format this example looks like this
;Calendar1;sfsIdCalendar1;ppmIdCalendar1
8;;;
0;Sunday;;
4;;25-12-2023;26-12-2023
Minimum Required Fields to Upload Calendar
CalendarName, AvgHours
Upload:
Read here how to upload Calendar CSV file to the system.
Export:
Read here how to export Calendar from the system.
Update:
To update the calendar, you must first obtain its ID. It’s necessary to export the calendar file to access this information. Once you have retrieved the calendar’s id, you can proceed with updating the calendar records by modifying the desired fields, excluding the calendar name.
- Example #2: Updating the Calendar.
In the example below, you can see the correct procedure for updating calendars in the system.
1. You have exported file that looks like this:
1;My Calendar;sfsId;ppmId
26-12-2023
AvgHours;DayOfWeek(optional);StartDate(optional);EndDate(optional)
8;;;
0;;25-12-2023;
1 | MyCalendar | sfsId | ppmId |
AvgHours | DayOfWeek(optional) | StartDate(optional) | EndDate(optional) |
8 |
The 1st row contains either column names or values. In this example we can Calendar ID specified as value ‘1’ and CalendarName specified as ‘My Calendar’
The 2nd row contains column names.
The 3rd row specifies the Average Hours for all days in the system for 8 hours per day.
2. To update the calendar, keep the calendar ID, sfsId and ppmId as they are and edit the desired fields such as average hours values, calendar name and dates.
In below example you can update of Calendar Name.
1;NewName;sfsId;ppmId
26-12-2023
AvgHours;DayOfWeek(optional);StartDate(optional);EndDate(optional)
8;;;
0;;25-12-2023;
1 | NewName | sfsId | ppmId |
AvgHours | DayOfWeek(optional) | StartDate(optional) | EndDate(optional) |
4 | 26-12-2023 |
The 1st row contains value calendar ID which is ‘1’ and updated Calendar Name which is ‘NewName’
The 2nd row contains column names.
The 3rd row specifies the Average Hours for all days in the system for 4 hours per day.
Add:
To add a new calendar to the system, you need to upload it without specifying the calendar’s ID. To add a new calendar to the system, you need to upload it without specifying the calendar’s ID. Additionally, you have to specify a unique calendar name, sfsId, and ppmId. These values must differ from those already present in the system.
- Example #3: Adding new Calendar to the system.
;NewCalendar;sfsIdNewCalendar;ppmIdNewCalendar
AvgHours;DayOfWeek(optional);StartDate(optional);EndDate(optional)
4;;;
NewCalendar | sfsIdNewCalendar | ppmIdNewCalendar | |
AvgHours | DayOfWeek(optional) | StartDate(optional) | EndDate(optional) |
4 |
The 1st row doesn’t contain the Calendar ID, which is desirable behavior when adding new calendars. Additionally, we can see the name of the calendar, which is specified for ‘NewCalendar’. Furthermore we can see specified Ids for sfsId which is ‘NewCalendar’ and ppmId which is ‘NewCalendar’
The 2nd row contains column names.
The 3rd row specifies the Average Hours for all days in the system for 4 hours per day.
Delete:
It’s not possible to delete the calendar from the system by uploading a CSV file or manually. To do so, you need to contact Epicflow Support by sending an email to support@epicflow.net
Calendar CSV file contains next columns:
- Calendar’s ID – The Calendar’s ID is a unique identifier assigned to each calendar within a system. This ID distinguishes one calendar from another.
- Calendar Name – The Calendar Name is a textual label or identifier given to a calendar within a system. Like the Calendar’s ID, it serves as a unique identifier for different calendars. While the Calendar’s ID is a numerical code used for internal referencing, the Calendar Name provides a human-readable description of the calendar.
- sfsd – SuccessFactorsID, refers to a unique identifier associated with objects or entities within the SuccessFactors Human Capital Management (HCM) suite. It’s needed if you use this system.
- ppmId -ppmId refers to a unique identifier associated with objects or entities within the SAP system.
- AvgHours – This column represents the average hours for users.
- DayOfWeek(optional) – This column, marked as optional, likely denotes the day of the week for which the average hours are specified. If this field is left empty, it means the average hours apply for all days.
- StartDate(optional) – This optional column specifies the start date for which the average hours apply.
- EndDate(optional) – This optional column specifies the end date for which the average hours apply.
– Availability
This CSV file provides a way to specify availability for resources.
Download Availability Template
- Example #1: Add Availability
1. Below, you can see the table representing availability headers and values.
Name | Start Date | End Date | Availability |
Anne U | 19-08-2024 | 21-08-2024 | 4 |
The 1st row contains column names.
The 2nd row specifies ‘Anne U’ as the named resource. The date range is from 19.08.2024, to 21.08.2024 with the user available for 4 hours.
2. In CSV Format this example looks like this
Name;Start Date;End Date;Availability
Anne U;19-08-2024;21-05-2020;4
3. in Epicflow this example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/05/image.png)
#Screen 8 Resource Card: Availability
Minimum Required Fields to Upload Availability File
All fields are required.
Upload:
Read here how to upload an Availability file to the system.
Export:
Read here how to export Availability file from the system.
Update:
To update a user’s availability, you have two options: either export the existing availability from the system and make updates, or prepare a new file. Keep in mind that the past date threshold can be specified for a maximum of 60 days, so all availability date ranges before this date must be removed from the exported file.
- Example #2: Updating the Resource Availability.
In the example below, you can see the correct procedure for updating resource’s availability in the system.
1. You have exported file that looks like this:
Name;Start Date;End Date;Availability
Anne U;19-05-2020;20-05-2020;8
Anne U;21-05-2020;26-05-2020;4
Anne U;27-05-2020;;8
Name | Start Date | End Date | Availability |
Anne U | 19-05-2024 | 20-05-2024 | 8 |
Anne U | 21-05-2024 | 26-05-2024 | 4 |
Anne U | 27-05-2024 | 8 |
The 1st row contains column names.
The 2nd row contains Resource Name that is Anne U and availability specified for 8 hours in date range from 19-05-2024 until 20-05-2024.
The 3rd row contains Resource Name that is Anne U and availability specified for 4 hours in date range from 21-05-2024 until 26-05-2024.
The 4rd row contains Resource Name that is Anne U and availability specified for 8 hours starting from day 27-05-2024.
2. To update the availability of the resource, keep its name and change the desired data.
In below example you can see how to update average working hours specified in above date ranges.
Name;Start Date;End Date;Availability
Anne U;19-05-2024;20-05-2024;2
Anne U;21-05-2024;26-05-2024;4
Anne U;27-05-2024;;1
Name | Start Date | End Date | Availability |
Anne U | 19-05-2024 | 20-05-2024 | 2 |
Anne U | 21-05-2024 | 26-05-2024 | 4 |
Anne U | 27-05-2024 | 1 |
The 1st row contains column names.
The 2nd row contains Resource Name that is Anne U and availability specified for 8 hours in date range from 19-05-2024 until 20-05-2024.
The 3rd row contains Resource Name that is Anne U and availability specified for 4 hours in date range from 21-05-2024 until 26-05-2024.
The 4rd row contains Resource Name that is Anne U and availability specified for 1 hour starting from day 27-05-2024.
Add:
To add availability for the user, you’ll need to prepare a file containing the user’s name and specified dates and hours that you would like to add. Keep in mind that if you intend to add different date ranges for one user, you’ll need to add 2 rows or even more, depending on how many ranges you want to include.
- Example #3: Adding the Resource Availability.
In the example below, you can see the correct procedure for adding resource’s availability in the system.
1. You have exported file that looks like this:
Name;Start Date;End Date;Availability
Anne U;19-05-2020;20-05-2020;8
Name | Start Date | End Date | Availability |
Anne U | 19-05-2024 | 20-05-2024 | 8 |
The 1st row contains column names.
The 2nd row contains Resource Name that is Anne U and availability specified for 8 hours in date range from 19-05-2024 until 20-05-2024.
2. To add the availability, add new line with resource name that in this case is used as id.
In below example you can see how to add new line with availability.
Name;Start Date;End Date;Availability
Anne U;19-05-2024;20-05-2024;8
Anne U;21-05-2024;26-05-2024;4
Name | Start Date | End Date | Availability |
Anne U | 19-05-2024 | 20-05-2024 | 8 |
Anne U | 21-05-2024 | 26-05-2024 | 4 |
The 1st row contains column names.
The 2nd row contains Resource Name that is Anne U and availability specified for 8 hours in date range from 19-05-2024 until 20-05-2024.
The 3rd row contains Resource Name that is Anne U and availability specified for 4 hours in date range from 21-05-2024 until 26-05-2024.
Availability CSV file contains next columns:
Name – Refers to the resource name.
Start Date – Indicates the beginning date of the date range for which you want to specify working hours.
End Date – Represents the end date of the date range for which you want to specify working hours.
Availability – Refers to the working hours you wish to specify within the specified date range.
– Resource Pool
This template contains a structured format for importing resource data into a resource management system.
- Example #1: Creating a Resource Pool CSV FIle: including Multigroup.
1. Below you can see a table that represents Resource Pool headers and values such as Multigroup, Group and Resource.
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | Teams | |
Marketing | G | True | ||||||||||||||||||||||||
Research | G | Marketing | ||||||||||||||||||||||||
Amelia T | R | Research | User |
The 1st row contains column names.
The 2nd row specifies Group named ‘Marketing’ that is Multi Group.
The 3rd row specifies group named ‘Research’ that isn’t Multi Group; however it belongs to the Multi Group specified in the 2nd row.
The 4th row Specifies a Resource Named Amelia T, with a ‘User’ Role and assigned to the Group ‘Research’.
2. In CSV Format this example looks like this
;Marketing;G;;True;;;;;;;;;;;;;;;;;;;;;
;
;Research;G;Marketing;;;;;;;;;;;;;;;;;;;;;;
;
;Amelia T;R;;;;;;;;Research;;;;;;;;;;;;;;;
;
Minimum Required Fields to upload Resource via Resource Pool:
ResName, Type: R, Groups
Minimum Required Fields to upload Group via Resource Pool:
GroupName, Type: G
Upload:
Read here how to upload Resource Pool to the system.
Export:
Read here how to export Resource Pool from the system.
Update:
To update Resources, you must first obtain their unique IDs. This requires exporting the Resource Pool file to access this information. Once you have retrieved the IDs, you can proceed with updating the resources by modifying the desired fields, preserving received IDs.
- Example #2: Updating Resource Pool
1. You have exported file that looks like this:
;Research;G;;;;;;;;;;;;;;;;;;;;;;;
;
;Amelia T;R;;;;;;;;Research;;;;;;;;;;;;;;;
;
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | Teams | |
1 | Research | G | ||||||||||||||||||||||||
2 | Amelia T | R | Research | User |
The 1st row contains column names.
The 2nd row specifies a Group named ‘Research’ with ID 1. This ID is necessary to proceed with updates of this resource
The 3rd row specifies a Resource named ‘Amelia T’ with ID 2. This ID is necessary to proceed with updates of this resource.
2. To update the Resource Pool your file needs to look like this
;Research;G;;;;;;;;;;;;;;;;;;;;;;;
;
;NewUserName;R;;;;;;;;Research;;;;;;;;;;;;;;;
;
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | Teams | |
1 | Research | G | ||||||||||||||||||||||||
2 | NewUserName | R | Research | User |
The 1st row contains column names.
The 2nd row specifies a Group named ‘Research’ with ID 1. Everything remains the same, which means this record is not updated.
The 3rd row changes the previous Resource name ‘Amelia T’ to ‘NewUserName’. This change is possible with the record ID, which is 2.
Add:
Previously, you saw an example of uploading new resources to the system when none were present. Now, we’ll demonstrate the correct procedure for adding additional resources to existing ones. This procedure is very similar to the update procedure. You need to export the resource pool from the system, then add a new resource with a specified unique ID.
- Example #3 Adding New Resources to the Resource Pool
1. You have exported file that looks like this:
1;Research;G;;;;;;;;;;;;;;;;;;;;;;;
;
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | Teams | |
1 | Research | G |
The 1st row contains column names.
The 2nd row specifies a Group named ‘Research’ with ID 1.
2. To add the Resource your file needs to look like this:
1;Research;G;;;;;;;;;;;;;;;;;;;;;;;
;
;New_Group;G;;;;;;;;;;;;;;;;;;;;;;;
;
;New_User;R;;;;;;;;New_Group;;;;;;;;;;;;;;;
;
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | Teams | |
1 | Research | G | ||||||||||||||||||||||||
New_Group | G | |||||||||||||||||||||||||
New_User | R | New_Group |
The 1st row contains column names.
The 2nd row specifies a Group named ‘Research’ with ID 1. It remains the same as in the exported file.
The 3rd row specifies a new group named ‘New_Group’.
The 4th row specifies a new resource named ‘New_User’ that belongs to ‘New_Group’.
Delete:
To remove resources from the system, you must first obtain their unique IDs by exporting the Resource Pool file. Once you have retrieved the IDs, you can proceed to remove the resources by specifying “-” before their IDs.
Competenies Levels in Resource Pool:
It’s possible to specify competences levels in Resource Pool.
- Example #4: Defining Competencies Levels in Resource Pool
- Below, you can see a table representing resource pool headers with defined resources and their competences, including competences levels.
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | |
Research | G | ||||||||||||||||||||||||
Tomas Z | R | Research | User | Graphic Design | CalendarName | ||||||||||||||||||||
Amber U | R | Research | ProjectManager | Graphic Design[4], Analytical thinking[1..5] | CalendarName |
The 1st row contains column names.
The 2nd row specifies a Group named ‘Research’
The 3rd row specifies a resource named ‘Tomas Z’ that belongs to group research. User’s role is User, and Competences: Graphic Design. In this example in system will see competences levels as from 1-5 (see picture below.)
The 4th row specifies a resource named ‘Amber U’ that belongs to group research. User’s roles is ProjectManager and competences: Graphic Design[1], Analytical thinking[1..4]
2. In CSV File this example will look like this:
;Research;G;;;;;;;;;;;;;;;;;;;;;;;
;Tomas Z;R;;;;;;;;;;ProjectManager;Graphic Design;AU;;;;CalendarName;;;;;;;
;Amber U;R;;;;;;;;;;ProjectManager; Graphic Design[1], Analytical thinking[1..4];AU;;;;CalendarName;;;;;;;
3. In Epicflow File this example will look like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/Competencies-Levels-Tomas-Z.png)
#Screen 8 Competences Tomas Z
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-14.png)
#Screen 9 Competences Amber U
Resource Pool CSV file contains next columns:
- ResID – This field represents the unique identifier for each resource. It’s a numeric value used to distinguish one resource from another within the system. During removing resources you need to specify “-” before Resource ID.
- ResName – This field contains the name or title of the resource. It provides a human-readable identifier for the resource.
- Type – Indicates the type of the resource. For example, it might specify whether the resource is a person or a group or any other relevant type.
- Parent – This field establishes a hierarchical relationship between resources. It indicates the parent resource for each entry, helping to organize resources into groups or subgroups.
- IsMulti – This field likely indicates whether the resource is multigroup.
- Color – Defines color of the group. Specify # before defining color
- RiskFactor – Indicates the risk factor associated with the resource.
- BookingId – Defines booking id of the group.
- GroupType – Specifies the type of group: Material or UCLT, in case the type of group is ordinary levae this field empty
- Email – Represents the email address associated with the resource
- Groups – Specifies any specific groups to which the resource belongs.
- Generic – This field might indicate whether the resource is considered generic or not.
- Roles – Specifies the roles associated with the resource.
- Competences – Indicates the competences possessed by the resource.
- Initials – represents the initials of the resource’s name
- Tags – Provides tags associated with the resource.
- Attributes – Provides attributes associated with the resource
- Rate – Specifies the rate associated with the resource.
- Calendar – Indicates the calendar associated with the resource
- Availability – Represents the availability of the resource.
- StartDate and EndDate – Specify the start and end dates for the resource’s availability.
- MaterialName, MaterialShortName, MaterialCost, MaterialRate – These fields are specific to materials associated with the resource, providing details such as name, cost, and rate.
- Teams – – Specifies any specific Teams to which the resource belongs.
More Examples:
- Example #5: Define Group in Resource Pool
1. Below, you can see a table where the group name is specified as ‘Promotion.’ This group does not belong to a multi-group.
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | |
Promotion | G |
The 1st row contains column names.
The 2nd row specifies Group named ‘Promotion’
2. In CSV Format this example looks like this
;Promotion;G;;;;;;;;;;;;;;;;;;;;;;;
- Example #6
1.Below, you can see a table where the group name is specified as ‘Procurement’ and the resource is named ‘Lukas A.’ Other values such as Groups, Competences, Initials, Calendar, and StartDate are also filled.
ResID | ResName | Type | Parent | IsMulti | Color | RiskFactor | BookingId | GroupType | Groups | Generic | Roles | Competences | Initials | Tags | Attributes | Rate | Calendar | Availability | StartDate | EndDate | MaterialName | MaterialShortName | MaterialCost | MaterialRate | |
Procurement | G | ||||||||||||||||||||||||
Lukas A | R | Procurement | User, Administrator | LA | CalendarName | 08-02-2023 |
The 1st row contains column names.
The 2nd row specifies Group named ‘Procurement’
The 3rd row Specifies a Resource Named Lukas A with ‘User’ and ‘Administrator’ Roles assigned to the Group ‘Procurement’. Additionally, we have initials specified as ‘LA’, a calendar assigned to the user named ‘CalendarName’, and the user’s start date specified as 08-02-2023.
2. In CSV Format this example looks like this
;Procurement;G;;;;;;;;;;;;;;;;;;;;;;;
;Lukas A;R;;;;;;;;Procurement;;User, Administrator;;LA;;;;CalendarName;;08-02-2023;;;;;
– Project
This CSV file provides a way to specify project data and their structure.
Be aware that Project can be only introduced into the system but further update must be done only via Epicflow User Interface.
- Example #1: Creating Project in CSV File
- Below, you can see a table that represents the project headers and values. Here, you can observe the basic structure, including references such as nesting tasks under a summary and defining predecessors for tasks.
Task_Type | Project_ID | Project_Name | Task_UID | Priority | Task_Name | UID_Summary | Res_UID | Res_Name | Group_UID | Group_Name | Unique_ID_Predecessors | Remaining_Work | Actual_Work | Scheduled_Work | Deadline | Start | Finish | Baseline_Work | Assignment_ID | Proj_Manager | Hyperlink | ReadyToStartByPM | Assignment_Units | Task_Remark1 | Task_Remark2 | Task_Remark3 | Skill | Notes | Duration UCLT | ShortName | PhaseType | Color | Task_Phases | PhaseStage | Tags | Attributes |
projsum | Project 1 | 02-01-2024 | 31-12-2026 | Amelia T | ||||||||||||||||||||||||||||||||
edd | Project external end | |||||||||||||||||||||||||||||||||||
sms | Project start | 01-01-2024 | ||||||||||||||||||||||||||||||||||
idd | Project end | 31-12-2026 | ||||||||||||||||||||||||||||||||||
Milestone | 1 | Milestone Name | ||||||||||||||||||||||||||||||||||
Summary | 2 | Summary Name 1 | ||||||||||||||||||||||||||||||||||
Task | Task Name 1 | 2 | Promotion | 1 |
The 1st row – contains column names.
The 2nd row – ProjSum – specifies project data such as project name (Project 1), start date (02-01-2024), end date (31-12-2026), and Project Manager (Amelia T.).
The 3rd row – Edd – specifies the project end date for 31-12-2026. Same as IDD (5th row). Both are needed due to technical reasons.
The 4th row – Sms- specifies the project start date for 01-01-2024.
The 5th row – Idd – same as the 3rd row, specifies the project end date for 31-12-2026. Both are needed due to technical reasons.
The 6th row – Milestone- specifies information regarding milestone such as ID in the column Task_UID (1), which we will later use to refer to this Milestone as a task predecessor. Milestone Name (Milestone Name) and Milestone Deadline (26-04-2024)
The 7th row – Summary – specifies information regarding summaries such as Summaries ID in the column Task_UID – 2, which we will later use to place tasks in a summary.
The 8th row – Task – specifies information regarding tasks such as the task name (Task Name 1), UID_Summary (which will place tasks in a summary), Group Name (Promotion), and Unique_ID_Predecessors 1 (which refers to previously defined milestones).
2. In CSV Format this example looks like this:
projsum;;Project 1;;;;;;;;;;;;;;02-01-2024;31-12-2026;;;Amelia T;;;;;;;;;;;;;;;
edd;;;;;Project external end;;;;;;;;;;31-12-2026;;;;;;;;;;;;;;;;;;;;;
sms;;;;;Project start;;;;;;;;;;01-01-2024;;;;;;;;;;;;;;;;;;;;;
idd;;;;;Project end;;;;;;;;;;31-12-2026;;;;;;;;;;;;;;;;;;;;;
Milestone;;;1;;Milestone Name;;;;;;;;;;26-04-2024;;;;;;;;;;;;;;;;;;;;; Summary;;;2;;Summary Name 1;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Task;;;;;Task Name 1;2;;;;Promotion;1;;;;;;;;;;;;;;;;;;;;;;;;;
3. In Epicflow this Example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-10.png)
#Screen 10 Project Card First Example
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-11-1024x278.png)
#Screen 11 Project Structure First Example
Minimum Required Fields to Upload Project
– For Project: Task_Type: ProjSum, Project_Name
Minimum Required Fields to Upload Additional Items: Task, Milestone, Summary, Phase Data Records
– For Task: Task_Type, Task_Name, Group UID or Group_Name
– For Milestone, Summary, Phase: Task_Type, Task_Name
Upload:
Read here how to upload Project to the system.
Export:
Read here how to export Project from the system.
There is no possibility to remove project within CSV file usage and that must be done directly from Web User Interface. For additional information please refer to the next article “Project Card“
Delete:
There is no possibility to remove project within CSV file usage and that must be done directly from Web User Interface. For additional information please refer to the next article “Deleting a Project“
Project CSV file contains next columns:
- Task_Type – Type of Item. In Epicflow’s Projects, we distinguish five types of items here is how you should refer to them in csv file.
ProjSum
– defines beginning of the Project’s information blockPhase
– refers to phase,Milestone
– refers to Milestone,Summary
– refers to SummaryTask
– refers to Task,SMS
– refers to a Project Start Date,EDD
andIDD
both refer to the Project End Date (External and Internal correspondingly)
- Project_ID – Unique identifier for the project.
- Project_Name – Name of the project.
- Task_UID – Unique identifier for the item.
- Priority – Priority of the item.
- Task_Name – Name of the item.
- UID_Summary – Summary task’s unique identifier.
- Res_UID – Unique identifier for the resource assigned to the task.
- Res_Name – Name of the resource assigned to the task.
- Group_UID – Unique identifier for the group assigned to the task.
- Group_Name – Name of the group assigned to the task.
- Unique_ID_Predecessors – Unique identifiers of task predecessors.
- Remaining_Work – Remaining work required for task completion.
- Actual_Work – Actual work completed on the task.
- Scheduled_Work – The work scheduled for the task is for export purposes and it is displaying the total work. During importing only the remaining work and actual work (spent hours) are required and used by the system to calculate the total hours for the task.
- Deadline – Item deadline or due date.
- Start – Start date of the item.
- Finish – Finish date of the item.
- Baseline_Work – Baseline work for the task.
- Assignment_ID – Identifier for the task assignment. This column is filled when exporting project. When importing new project this column should be left empty.
- Proj_Manager – Project manager responsible for the project.
- Hyperlink
- ReadyToStartByPM – It means that task has status “Force Ready to Start”
- Assignment_Units – Assignment units for the task.
- Task_Remark1 – Remark or additional information about the task (1st remark).
- Task_Remark2 – Remark or additional information about the task (2st remark).
- Task_Remark3 – Remark or additional information about the task (3st remark).
- Skill – Skill/Competence required for task completion.
- Notes – Additional notes or comments about the task.
- Duration UCLT
- ShortName
- PhaseType – Type of project phase: Sprint, Release, Customized. (If you would like to refer to phase item you need to specify Task_UID for this phase. f.e “1”, and then you can specify this ID in Task_Phases field “1”)
- Color – Only for Customized Phase Type.
- Task_Phases – Phases associated with the task
- PhaseStage – Stage of the project phase
- Tags – Tags associated with the task.
- Attributes – Attributes associated with the task.
More Examples
- Example #2: Creating Project in CSV File Including Phases.
- Below, you can see a table representing the project headers and values. Here, you can observe the structure, including phases and defining these phases for tasks.
Task_Type | Project_ID | Project_Name | Task_UID | Priority | Task_Name | UID_Summary | Res_UID | Res_Name | Group_UID | Group_Name | Unique_ID_Predecessors | Remaining_Work | Actual_Work | Scheduled_Work | Deadline | Start | Finish | Baseline_Work | Assignment_ID | Proj_Manager | Hyperlink | ReadyToStartByPM | Assignment_Units | Task_Remark1 | Task_Remark2 | Task_Remark3 | Skill | Notes | Duration UCLT | ShortName | PhaseType | Color | Task_Phases | PhaseStage | Tags | Attributes |
projsum | Project 1 | 02-01-2024 | 31-12-2026 | Joan G | ||||||||||||||||||||||||||||||||
edd | Project external end | |||||||||||||||||||||||||||||||||||
sms | Project start | 01-01-2024 | ||||||||||||||||||||||||||||||||||
idd | Project end | 31-12-2026 | ||||||||||||||||||||||||||||||||||
Phase | 1 | Phase 1 | Sprint | |||||||||||||||||||||||||||||||||
Phase | 2 | Phase 2 | Release | |||||||||||||||||||||||||||||||||
Milestone | Milestone Name | |||||||||||||||||||||||||||||||||||
Summary | 4 | Summary Name 1 | Tag1, Tag2 | Attribute1, Attribute2 | ||||||||||||||||||||||||||||||||
Task | Task Name 1 | 4 | Promotion | 4 | 4 | 1, 2 |
The 1st row – contains column names.
The 2nd row – ProjSum – specifies project data such as project name (Project 1), start date (02-01-2024), end date (31-12-2026), and Project Manager (Joan G.).
The 3rd row – Edd – specifies the project end date for 31-12-2026. Same as IDD (5th row). Both are needed due to technical reasons.
The 4th row – Sms- specifies the project start date for 01-01-2024.
The 5th row – Idd – same as the 3rd row, specifies the project end date for 31-12-2026. Both are needed due to technical reasons.
The 6th row – Phase – specifies information regarding Phase, such as Phase Name (Phase 1) and Phase Type (Sprint). We have also specified information regarding the Phase’s ID in the column Task_UID (1), which we will later use to refer to this Phase as a Task Phase.
The 7th row – Phase – specifies information regarding Phase, such as Phase Name (Phase 2) and Phase Type (Release). We have also specified information regarding the Phase’s ID in the column Task_UID (2), which we will later use to refer to this Phase as a Task Phase.
The 8th row – Milestone- specifies information regarding milestone such as Milestone Name (Milestone Name) and Milestone Deadline (26-04-2024)
The 9th row – Summary – specifies information regarding summaries, such as the Summaries ID in the column Task_UID – 4, which we will later use as a reference to place tasks in a summary. Additionally, we can see tags and attributes added to the summary in columns Tags (Tag1, Tag2) and Attributes (Attribute1, Attribute2).
The 10th row – Task – specifies information regarding tasks, such as the task name (Task Name 1), UID_Summary (ID: 4 from the 9th row), Group Name (Promotion), Remaining Work (4), Actual Work (4), and Task_Phases (1, 2), which refer to previously defined phases.
2. In CSV Format this example looks like this:
projsum;;Project Name;;;;;;;;;;;;;;02-01-2024;31-12-2026;;;;;;;;;;;;;;;;;;Tag1, Tag2;
sms;;;;;Project start;;;;;;;;;;01-01-2024;;;;;;;;;;;;;;;;;;;;;
idd;;;;;Project end;;;;;;;;;;31-12-2026;;;;;;;;;;;;;;;;;;;;;
Phase;;;1;;Phase 1;;;;;;;;;;;;;;;;;;;;;;;;;;Sprint;;;;; Phase;;;2;;Phase 2;;;;;;;;;;;;;;;;;;;;;;;;;;Release;;;;;
Milestone;;;3;;Milestone Name;;;;;;;;;;26-04-2024;;;;;;;;;;;;;;;;;;;;; Summary;;;4;;Summary Name 1;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Tag1, Tag2;
Task;;;;;Task Name;4;;;;Marketing;3;4;4;;;;;;;;;;;;;;;;;;;;1, 2;;;
3. In Epicflow this example looks like this:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-12.png)
#Screen 12 Project Structure Second Example
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image-13.png)
#Screen 13 Task Card displaying Phases
Colors in Epicflow
In Epicflow, you have the possibility to choose the color that a group or phase will be represented in. However, in CSV files, the naming is different, and you need to use unique codes to specify specific colors. Here are the codes:
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/image.png)
#Screen 15 Epicflow Colors
#4FC3DE – Light Blue #70B0FF – Sky Blue #7A82D4 – Lavender Blue #B4D769 – Lime Green
#8BC874 – Light Green #60B5AB – Turquoise #FCDA00 – Yellow #F8BC00 – Orange Yellow
#DC7772 – Salmon Pink #E56597 – Pink #00BCD4 – Cyan #2196F3 – Blue
#3F51B5 – Indigo #8FC435 – Green #4CAF50 – Medium Green #009688 – Teal
#FCC400 – Golden Yellow #FA9C00 – Dark Orange #F44336 – Red #E91E63 – Rose
#3396AA – Steel Blue #2D6FDE – Royal Blue #3136A9 – Sapphire Blue #70A100 – Olive Green
#488F14 – Olive #287869 – Dark Green #FFAC00 – Bright Orange #EC8200 – Amber
#F32D45 – Cherry Red #B9225F – Raspberry Pink #1E5F65 – Dark Cyan #1940AB – Cobalt Blue
#1A1787 – Midnight Blue #3C6B00 – Dark Olive Green #295E00 – Deep Olive Green #0074D3 – Azure
#FF7C02 – Deep Saffron #DB5900 – Pumpkin #CA1F07 – Cardinal Red #811355 – Red Wine
Rules and Recommendation for CSV preparation
- New CSV file must be always created in accordance to the defined above CSV file Structure. Such can be downloaded from the page Wiki page.
- Keep in mind that defined changes will override old values for specified range in case of Update.
- Verify used separators and date format right before upload of the file
- Next separators of CSV file must be used
- for columns – ” ; “
- for decimal – ” . “
- Next date format should be used
- DD-MM-YYYY
- Next separators of CSV file must be used
- Structure of the CSV file verification is strongly advised (Example: you should not have extra separators at the end of the line which are not expected in accordance to the file structure)
- Before applying\introducing any new changes (Import) into the system backup preparation is advised. For that you can use Export functionality for the corresponding files.
- During the creation of any items, it’s not required to specify item IDs. However, if you need to build a structure in attributes, competences, or projects, each ID should be unique . This way, the system is informed that this is a new item.
Import and Export
Be aware that Import\Export functionality is critical in prospective of data consistency and further analysis, so its usage is limited only to those users to which corresponding permission is assigned by System Administrator or PO.
For relevant permissions adjustment please refer to Permission configuration item.
Be aware that only CSV files of the corresponding structure are allowed for upload. Please use templates beforehand for data preparation. Do not hesitate to follow-up our Recommendations at CSV file preparation. Once you have all of the above, you can proceed with the Import or Export file functionalities.
Be aware that in contradistinction to Import \ Export of the Resource Pool, Calendar, Attributes, Competences, Logs (Export Only), which is done from the “System Maintenance” frame located at Settings page, Import \ Export of Projects is done from the Pipeline page.
Below more in details about each of such.
Import Project
- Navigate to Pipeline Page.
- Click on + Create New Icon.
- From Drop-Down Menu select option Upload Project From File.
- Select a file.
- Click Upload Button.
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/Upload-Project.gif)
#Screen 17 Import Project
Export Project
- Navigate to Pipeline Page.
- Click on three dots icon next to the Project Name Create New Icon.
- From Drop-Down Menu select option Export Project.
![](https://wiki.epicflow.com/wp-content/uploads/2024/03/Export-Project.gif)
#Screen 18 Export Project
Import Resource Pool, Calendar, Attributes and Competences
- Prepare file: export data from the system or download template
- Navigate to settings.
- In the top right corner click on Maintenance button.
- Choose Import Field.
- Select an appropriate file type: Resource Pool, Calendar, Attributes, Calendar, Competences.
- Select a file.
- Click Import Button
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/Upload-Data-Files.gif)
#Screen 19 Import Data Files
Export Resource Pool, Calendar, Attributes, Competences and Logs
- Navigate to settings.
- In the top right corner click on Maintenance button.
- Choose Export Field.
- Select an appropriate file type: Resource Pool, Calendar, Attributes, Calendar, Competences, Logs.
- Specify date range (required only during logs export).
- Select the saving location on your computer.
- Click Export button.
![](https://wiki.epicflow.com/wp-content/uploads/2024/04/Export-Data-Maintenance-Page.gif)
#Screen 20 Export Data Files