Import Projects

This feature allows for the importing of Project information into the Unanet system.

Roles

This screen is available to users having any of the following roles: Administrator and P&R Administrator

License

This feature is available with any Unanet edition.

Performance Tip Note:  Depending on the number of users in your installation and other factors such as the overall performance of your platform, the activity of importing one or many files may take up to several minutes.  Should this be the case with your installation, you may want to consider running these processes at non-peak times to minimize database contention.

 

Topics covered on this help page include:


Import File Record Layout

IMPORTANT: Note that there are multiple places within this documentation that say you MUST use double quotes for the strings in your import. If you are working in Excel, Excel will provide the double quotes and thus you do not need to add them in manually. Manually adding double quotes within Excel would result in multiple sets of double quotes in the resulting .csv file and thus cause an error (should you attempt to import that resulting file). Please see Excel Tips for more information.

 

 

 

Field Header Name

Required/Comments

1

A

Project_Org_Code

ALWAYS REQUIRED.  This code uniquely identifies the Organization to which the project belongs.  This value must match an existing Project Organization Code value defined in your system.  If the Organization you are trying to import does not already exist in the database, the entire record will be rejected.

You can use the project import to change a project organization code for an existing project by supplying the following syntax in this field.

"!RENAME!,old_project_org_code,new_project_org_code"  -- this entire string must be enclosed in double quotes.

For example, if you were attempting to change:

1) Existing Project Org Code "Org1" to "Org_One", the import file would include:
"!RENAME!,Org1,Org_One"

See the Excel Tips regarding the use of double quotes and more.

 

Note for Non-Administrator Data Import Users - Can only access those projects to which they have access via an Organization Access relationship. Only those projects to which the user has both Project AND Owning Organization Access visibility will appear in their resulting list.  

 

Customer Organization Requirement

When using Unanet Financials (Use Financial Organizations (unanet.financials.use_financial_orgs) property enabled), the Project Organization must be designated as a Customer for the Legal Entity of the Project's Owning Organization (this is enforced during various posting procedures if the project is configured to participate in Unanet Invoicing, that is, the Generate Unanet Invoice check box is checked on the Project Profile >> Invoice Setup screen).  An Organization is identified as being a customer for a Legal Entity on the Organization >> Customer Profile screen.

2

B

Project_Code

CONDITIONALLY REQUIRED.  This project code uniquely identifies the Project.  The project code is unique within an Organization.

Automatic Project Code Generation

This field is always required for add and update unless you are using the Automatic Project Code Generation functionality.  When this feature is enabled, leaving the Project Code field blank will result in the creation of a new project having an automatically generated project code.  If this feature is not enabled and this value is not supplied, the record will be rejected.

You can use the project import to change a project code for an existing project by supplying the following syntax in this field.

"!RENAME!,old_project_code,new_project_code"  -- this entire string must be enclosed in double quotes.

For example, if you were attempting to change:

1) Existing Project Code "Project1" to "Project_One", the import file would include:
"!RENAME!,Project1,Project_One"

Maximum Length: 30 characters

Note for Non-Administrator Data Import Users - Can only access those projects to which they have access via an Organization Access relationship. Only those projects to which the user has both Project AND Owning Organization Access visibility will appear in their resulting list.  

See the Excel Tips regarding the use of double quotes and more.

3

C

Project_Type

ALWAYS REQUIRED on ADD. If the Project Type value you are trying to import does not exist in the database, the entire record will be rejected.  The project type must be active if the project is active.

4

D

Project_Status

ALWAYS REQUIRED on ADD. If the Project Status value you are trying to import does not exist in the database, the entire record will be rejected.

5

E

Project_Manager

This is the userid (username) of the person in charge of this project. This userid must already exist in the database and must have the Project Manager role. If this userid does not exist, the entire record will be rejected.  If you leave this field blank, the system will populate the field with the user id of the person running the import.

Note: If the person assigned as the Project Manager has the Resource Planner, Resource Assigner, or Resource Requestor role, that individual will also be assigned as the Primary Resource Planner, Assigner, Requestor for that project. If that user does not have any of those global level roles,  you can associate them via this import or via the Project Profile >> Administrators screen. This same defaulting does not occur when updating an existing project.

6

F

Open_Edit

This field is no longer used, however, this column remains as to not effect existing import layouts.   Any values specified in this field will be ignored.

7

G

Self_Signup

Valid values include Y or N (if not provided, Y is the default for a new entry).  Grant whether any user can apply time and/or expenses to this project or only the users who are assigned to this project (User Self Assign).

8

H

Self_Plan

This field is only used if you have Resource Planning module (otherwise this data will be saved -- but ignored by the system). Grant whether any users can plan their own time for this project.

Valid values include:

C - Closed - no users can plan themselves to this project - This is the default value on add if not supplied
O - Open - all UnaSource users can plan to this project
A  - Plan if Assigned - only those UnaSource users that are assigned can create their own plans

9

I

Self_Assign_Plans

This field is only used if you have Resource Planning module (otherwise this data will be saved -- but ignored by the system).  This setting is used to determine if UnaSource users can create Assignments from Planned Work entries for projects defined as allowing Self SignUp.  

Valid values include Y or N (if not provided, N is the default for a new entry).  

10

J

Allows_Future_Time

Valid values include Y or N (if not provided, Y is the default for a new entry).   Defines whether users will be able to charge time to dates beyond the current date.   

 

Note that this validation is based on the users PC date setting.  The following property can be used to base the validation on the server's date setting Use Server Time When Determining Future Charges (unatime.use_server_clock).

11

K

Approve_Time

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether the project manager will be the default project approver for timesheets. A value of "Y" also implies that approval is required.

Note that you can utilize the project administrator import to define other users as the project approver as necessary.

12

L

Approve_Expense

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether the project manager will be the default project approver for expense reports and requests. A value of "Y" also implies that approval is required.

Note that you can utilize the project administrator import to define other users as the project approver as necessary.

13

M

Time_Requires_Task

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether a task must be selected when a user attempts to charge time to a project.

In the event the Task_Level_Assignment indicator is Y, this value will be set to Y, and a warning message will be displayed if the provided value is something other than Y).   

14

N

Expense_Requires_Task

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether a task must be selected when a user attempts to charge time to a project.

In the event the Task_Level_Assignment indicator is Y, this value will be set to Y, and a warning message will be displayed if the provided value is something other than Y.  

15

O

Allows_Expenses

Valid values include Y or N (if not provided, Y is the default for a new entry).  Defines whether people can charge expenses to this project.  

16

P

Original_Start_Date

This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

Recommended date format:   yyyy-MM-dd    See Allowable Date Formats for more options.

17

Q

Original_End_Date

This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

Recommended date format:   yyyy-MM-dd    See Allowable Date Formats for more options.

18

R

Revised_Start_Date

On the add of a new record, if this field is left blank it will be defaulted to either the Original_Start_Date (if provided) or BOT.  

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

Recommended date format:   yyyy-MM-dd    See Allowable Date Formats for more options.

19

S

Revised_End_Date

On the add of a new record, if this field is left blank it will be defaulted to either the Original_End_Date (if provided) or EOT.   

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

Recommended date format:   yyyy-MM-dd    See Allowable Date Formats for more options.

20

T

Completed_Date

The completed date field is used on a number of Unanet reports.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

Recommended date format:   yyyy-MM-dd    See Allowable Date Formats for more options.

21

U

Budget_Hours

Total Budgeted hours for the project. This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

22

V

Budget_Labor_Dollars_Bill

Total Bill Labor Dollars budgeted for this project.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative (to support budgeting of discounts).

23

W

Budget_Expense_Dollars_Bill

Total Bill Expense Dollars budgeted for this project.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative (to support budgeting of discounts).

24

X

ETC_Hours

Estimate to complete hours. This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

25

Y

ETC_Labor_Dollars_Bill

Estimate to complete bill labor dollars.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative (to support budgeting of discounts).

26

Z

ETC_Expense_Dollars_Bill

Estimate to complete bill expense dollars.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative (to support budgeting of discounts).

27

AA

Est_Tot_Hours

Estimated Total Hours expected for this project.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

28

AB

Est_Tot_Labor_Dollars_Bill

Estimated Total Bill Labor Dollars expected for this project. This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative (to support budgeting of discounts).

29

AC

Est_Tot_Expense_Dollars_Bill

Estimated Total Bill Expense Dollars expected for this project. This field can be blank.   You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative (to support budgeting of discounts).

30

AD

External_System_Code

This field can be used to contain a value associated with a project. This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

Maximum Length: 128 characters

Note: This field used to be named Account_Number.  Beginning with v10.0, the account number functionality has been altered and the fields previously referred to as account_number have been changed to external_system_code.  While the import column header Account_Number will continue to be a recognized alias for some time, you may want to update any automated imports to use the new name.

31

AE

Title

The title of the project -- a more descriptive name than the actual Project Code.  This field shows up on several screens and reports throughout the system. This field can be blank. You can use the special tag !BLANK! to remove an existing entry in this field.  

Maximum Length: 2000 characters

32

AF

Comments

This field (formerly referred to as Purpose) is simply a free form text field for whatever purpose you'd like.  This field is available for display on the Project Status report.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

Maximum Length: 2000 characters

33

AG

Assigned_Person_Orgs

This field can contain one to many organization codes.  If multiple organizations are listed, they must be separated by commas and contained within double quotes.  (e.g., Field32,"org1,org2,org3", Field34). This field is used to automatically assign all people within a given organization to a particular project.  

Whether projects assigned via Org Assignments will appear by default on a users timesheet or expense report depends on how the Default to Assign Projects (unanet.org_assignment.my_projects.select_by_default) property is configured.  When enabled, these projects will appear in the right "Selected Projects" window (on their My Projects screen) by default, otherwise, when disabled, they will appear in the left "Available Projects" window by default (and thus, not automatically appearing on the timesheet or expense report).

This field can be left blank.

You can use the special tag !BLANK! to remove an existing entry in this field.

If importing information to an existing project, this field will be ignored if no value is supplied (that is -- no change will occur).  If this field contains any organizations, all existing assigned organizations will be replaced by the new list included in the import.

The organization listed in this field must be a valid Unanet organization, otherwise an error message will be produced.

Financial Org Restriction  When the Use Financial Organizations (unanet.financials.use_financial_orgs) property is enabled, valid person organizations to be assigned will be limited to those Organizations having the same Legal Entity as that of the Project's Owning Organization.

If you would like to add an additional organization code to the list without supplying any previously supplied values, you can use the special tag !APPEND!.    "!APPEND!,additional_Org,additional_Org"  -- this entire string must be enclosed in double quotes (note that if you are working in Excel, Excel will provide the double quotes and thus you do not need to add them in manually).

Similarly, if you would like to remove one or several entries from an existing list, you can use the special tag !REMOVE!.   "!REMOVE!,Org1,Org2"  -- this entire string must be enclosed in double quotes.

See the Example below for syntax help.

See the Excel Tips regarding the use of double quotes and more.

34

AH

Pay_Code_List

This field can contain one to many valid pay codes (each must be a valid existing pay code within Unanet). If one or more pay codes are listed on a given import record, then any existing pay codes listed for that project will be removed and replaced by the new list. If multiple pay codes are listed, they must be separated by commas and contained within double quotes  

  (e.g. Field33,"paycode1,paycode2,paycode3").

If importing information to an existing project, this field will be ignored if left empty (that is -- no change will occur).

If you would like this project to use the system's list of initial project default pay codes as defined by the administrator in the pay code maintenance screen, simply leave the field empty when inserting new records.  If you leave this field empty, but no pay codes have been designated as initial project default pay codes, then the effect will be a blank list of project pay codes.

If you would like to modify an existing project, changing an explicit list of pay codes to instead use the list of initial project default pay codes, then you can import the special tag !BLANK! value in this field.

If you would like to add an additional pay code to the list without supplying any previously supplied values, you can use the special tag !APPEND!.    "!APPEND!,additional_pay_code,additional_pay_code"  -- this entire string must be enclosed in double quotes (note that if you are working in Excel, Excel will provide the double quotes and thus you do not need to add them in manually).

Similarly, if you would like to remove one or several entries from an existing list, you can use the special tag !REMOVE!.   "!REMOVE!,Pay_Code1,Pay_Code2"  -- this entire string must be enclosed in double quotes.

See the Example below for syntax help.

See the Excel Tips regarding the use of double quotes and more.

35

AI

Default_Pay_Code

This field can contain one distinct valid pay code (must be a valid existing pay code within Unanet) or the field can also be blank.  

If importing information to an existing project, this field will be ignored if left empty (that is -- no change will occur).

On a new project insert, if you would like this project to use the systems default pay code, then simply leave this field empty (and the system will derive the pay code to use).  When the default pay code is left blank, the system will lookup the current 'system wide default' as it is processing information.

If you have supplied a list of valid pay codes in the Pay_Code_List field, then this value must be one of those valid pay codes for this project.

If you want to update an existing project, changing the existing value to begin using the system wide default pay code, you can import the special !BLANK! tag which will null out this field which equates to instructing the system to derive the default pay code.

36

AJ

Task_Level_Assignment

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether Resource Assigners can assign individuals at the Project Level or at the Task Level.  

Y indicates the assignments will be managed at the Task level, while N indicates the assignments will be managed at the Project level.

Note: When updating this value, any existing assignments will be deleted from the system.  Further, you will need to check the 'Allow Project/Task Assignment Level updates" option on the import screen if you intend to alter this value on an existing project (in order to prevent the accidental removal of existing assignments).

37

AK

Probability_Percent

The project Probability Percentage field can be used to specify a numeric percentage (values should range between 1 and 100 -- but the field will accept values up to 999).  Several of the Unanet financial reports can optionally use the value of this field when calculating bill and cost information.  This field is required in the database, and if not provided, a default value of 100 will be stored.

Maximum Length: 3 numeric positions

38

AL

Percent_Complete

The project Percent Complete field can be used to specify a numeric percentage (values should range between 0 and 100 supporting 3 digits to the right of the decimal).  Several of the Unanet reports will use the value of this field in their calculations.  

This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

Maximum Length: 3 numeric positions to the left of the decimal and 3 numeric positions to the right of the decimal.

39

AM

TITO_Required

This field is used to define whether Time In / Out entries are required for this project when users enter time on their timesheets.  The valid values for this field include:

  • "N" - meaning Time In/Out entries are NOT REQUIRED for this project

  • "Y" - meaning Time In/Out entries are required for this project (despite the user level Time In/Out setting)

  • "U" - which indicates that whether Time In/Out entries are required depends on the User Time In/Out setting defined on the Admin -- Person screen.  

 

A value of "U" will be supplied on newly imported projects if no other value is supplied.  During an update, if this field is blank, this field will not be updated (the existing database entry will remain).

40

AN

Bill_Rate_Source

Valid values include P or L (if not provided, P is the default for a new entry).  Defines the default data source for bill rate information.  "P" for person rate and "L" for labor category rate.  

41

AO

Cost_Rate_Source

Valid values include P or L (if not provided, P is the default for a new entry).  Defines the default data source for cost rate information.  "P" for person rate and "L" for labor category rate.   If Cost Dilution is enabled, this field must be a "P".

42

AP

Use_Labor_Category

This field is used to specify whether a labor category is required "Y", optional "O", or forbidden "N", when users charge time to this project.  The default value if not supplied is "O" for a new entry.

43

AQ

Enforce_WBS_Dates

Valid values include Y or N (if not provided, N is the default for a new entry).  Determines if the project / task dates will be used to constrain time and expense entry.

44

AR

Leave_Ind

Valid values include Y or N (if not provided, N is the default for a new entry).   Determines if this project should be designated as a "Leave" project.  

45

AS

User01

OPTIONALLY REQUIRED.  Depending on how you have configured the user defined fields in your system, this field may be a Date, Numeric, String or value that matches a Pick List entry.  This field can be left blank if not configured to be required.  You can use the special tag !BLANK! to remove an existing entry in this field.

Maximum Length: 128 characters

Click here for more information about user defined fields for projects.

46

AT

User02

See note for User Defined 1 above

47

AU

User03

See note for User Defined 1 above

48

AV

User04

See note for User Defined 1 above

49

AW

User05

See note for User Defined 1 above

50

AX

User06

See note for User Defined 1 above

51

AY

User07

See note for User Defined 1 above

52

AZ

User08

See note for User Defined 1 above

53

BA

User09

See note for User Defined 1 above

54

BB

User10

See note for User Defined 1 above

55

BC

Budget_Labor_Dollars_Cost

Total Cost Labor Dollars budgeted for this project.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

56

BD

Budget_Expense_Dollars_Cost

Total Cost Expense Dollars budgeted for this project.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

57

BE

ETC_Labor_Dollars_Cost

Estimate to complete cost labor dollars.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

58

BF

ETC_Expense_Dollars_Cost

Estimate to complete cost expense dollars.  This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

59

BG

Est_Tot_Labor_Dollars_Cost

Estimated Total Cost Labor Dollars expected for this project. This field can be blank.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

60

BH

Est_Tot_Expense_Dollars_Cost

Estimated Total Cost Expense Dollars expected for this project. This field can be blank.   You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

61

BI

Pct_Complete_Rule

This field can be used to indicate which method should be used to estimate / calculate percent complete values for a particular project (when not explicitly entered, the percent complete is estimated on several reports).  The valid values include:

H  -- Hours
L  -- Labor Cost
T  -- Total Cost

 

If not provided on an add, the default saved will be H.

62

BJ

Project_Color

This field can be used to indicate that a particular project is in Red, Green or Yellow status.  The valid values include:

red
green
yellow

If not provided on an add, the default saved will be green.

63

BK

Proj_Access_Proj_Manager

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Project Managers have access to this project.  

64

BL

Proj_Access_Proj_Viewer

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Project Viewers have access to this project.  

65

BM

Proj_Access_Resource_Manager

Beginning with version 9.3, the Resource Manager role is no longer recognized within Unanet.   It was replaced by two new roles (Resource Planner and Resource Assigner).  For backward compatibility purposes, if this field is included in a project import file, the value may be used under the following circumstances:  

  • If a value is supplied in either of the "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields, those values will be used and any value in this field will be ignored.  

  • If no values are supplied in the "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields, then the value supplied in this field will be used for both of the two fields.   

  • If no values are supplied for any of these three fields, the normal defaulting logic for the  "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields will apply.

 

Valid values include Y or N.  The original intended purpose was to controls whether all Organizational Resource Managers had access to this project.  

66

BN

Allows_Time

Valid values include Y or N (if not provided, Y is the default for a new entry).  Defines whether people can charge time to this project.  

67

BO

Delete

This field is used to trigger the system to delete a Project (including any of it's relationships to other project entities such as Project Orgs, Assignments, Plans, Tasks, etc).  In order for the delete to happen, you must have the following text string !DELETE! in this field.

Note that you will not be allowed to delete a project if time or expense actuals have been charged against the project or if the project is designated as a 'Lead Project' in an Invoice Group.

68

BP

Owning_Organization

CONDITIONALLY REQUIRED.  This value is used to identify the Owning Organization for a project (which may be different than the Project Organization).   

You may be able to use the special tag !BLANK! to remove an existing entry in this field.

This value must match an existing Organization Code value defined in your system.  If the Organization you are trying to import does not already exist in the database, the entire record will be rejected.

When Required?

When using Unanet Financials (Use Financial Organizations (unanet.financials.use_financial_orgs) property enabled), this is a required field and must be associated with an Organization that is designated as a Financial Organization.  This designation occurs on the Organization Edit >> Financials tab.  

Regardless of whether you use Unanet Financials and the state of the property mentioned above, if this project is to be configured to participate in Invoicing, this is a required field.

69

BQ

Billing_Type

This value is used to identify a particular billing type to be associated with this project.  You can use the special tag !BLANK! to remove an existing entry in this field.

This value must match an existing Billing Type value defined in your system.  If the Billing Type you are trying to import does not already exist in the database, the entire record will be rejected.

Note there are limitations with respect to allowable combinations of project and task level billing types (see Project Profile for more information).  Also note that there are limitations with respect to when a billing type can be changed (i.e., once an item has been included in a post process, the billing type can no longer be changed).  Further, if a billing type change is allowed, any previously configured information on the Project >> Billing screens will be removed.

When importing a new record and the billing type is 'billable' (i.e., CP, TM, or FP), note that the Project >> Billing >> Accounts entries will be established using system default values.

You will need to check the 'Allow Billing Type updates" option on the import screen if you intend to alter this value on an existing project (in order to prevent the accidental removal of any related fixed price items).

70

BR

Cost_Structure

This field is used to assign a particular Cost Structure to a project.  Once any expense actuals have been recorded against this project, the Cost Structure association cannot be removed or changed. You can use the special tag !BLANK! to remove an existing entry in this field (as long as no expense actuals exist).

This field can be blank.  

This value must match an existing Cost Structure code value in your system.  If the Cost Structure you are trying to import does not already exist in the database, the entire record will be rejected.

71

BS

Fee_Factor

For backwards compatibility, support for importing a single Fee Factor can be facilitated via this project import.  If you need to manage multiple fee factors for a single project, you can use the Project Fee Import.  

CONDITIONALLY REQUIRED. This field is used to specify a value related to Project Accounting fee calculations.  This value is required if a value is supplied for Fee_Calculation_Method and is used in conjunction with the Fee_Factor_Type field to determine if this is a factor or percent. The values for this field can range from -999 to 999 (with up to 2 decimal places of precision).  

You can use the special tag !BLANK! to remove an existing entry in this field.

Rules related to handling Fee entries considering there may be many:
-- If no fee details exist in the project_fee table for this project, we will insert a new fee entry for this project if one is provided.
-- If one entry exists and we are receiving an update for the same fee method, we will update the fee entry.
-- If one entry exists and we are receiving a different fee method, we will update/replace the existing fee entry.
-- If more than one fee entries exist and we are receiving one of the existing fee methods, we will update that entry.
-- If more than one fee entries exist and we are receiving a new fee method, we will error out.
-- If we receive a !BLANK! expression, we will delete all fee entries for this project.
-- If the user wants to provide Fixed Amount for a fee method, they have to use the Project Fee Import.

 

72

BT

Fee_Calculation_Method

For backwards compatibility, support for importing a single Fee Calculation Method can be facilitated via this project import.  If you need to manage multiple fee calculation methods for a single project, you can use the Project Fee Import.  

CONDITIONALLY REQUIRED. This field is used to specify which fee calculation method is to be used for calculating a Project Accounting related fee for this project.  The values supplied in this field must match an existing Fee Method in your system (defined by an Administrator on the Admin >> Setup >> Fee Calculation Method screen).   If the Fee Method you are trying to import does not already exist in the database, the entire record will be rejected.  

This field is used in conjunction with the Fee_Factor field.   For each project, a Fee_Calculation_Method can only appear once. 

You can use the special tag !BLANK! to remove an existing entry in this field. 

See Fee Factor -- Rules above for detail regarding the handling of Fee entries considering there may be many.

73

BU

Total_Value

This field is used to store a total project value and is sometimes the same as the Funded Value, but often holds a larger amount which has not yet been approved.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, then the Total_Value cannot exceed the ceiling amount of the contract.

You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

74

BV

Funded_Value

This field is used to store a funded project value.

You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right, and can be either positive or negative.

75

BW

Budget_Labor_Dollars_Cost_Burdened

This field is used to store the budgeted burdened labor cost for the project.  You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

76

BX

Budget_Expense_Dollars_Cost_Burdened

This field is used to store the budgeted burdened expense cost for the project.

You can use the special tag !BLANK! to remove an existing entry in this field.

This field accepts a numeric value up to 13 positions to the left of the decimal and 2 positions to the right.

77

BY

Require_Time_Comments

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether timesheet cell comments are required for all time charged to a project (or task on a project).

78

BZ

Proj_Access_Resource_Planner

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Resource Planners have access to this project.  

Beginning with version 9.3, the Resource Manager role is no longer recognized within Unanet.   It was replaced by two new roles (Resource Planner and Resource Assigner).  For backward compatibility purposes, if the "Proj_Access_Resource_Manager" column is included in a project import file, the value in that field may be used under the following circumstances:  

  • If a value is supplied in either of the "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields, those values will be used and any value in the "Proj_Access_Resource_Manager" field will be ignored.  

  • If no values are supplied in the "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields, then the value supplied in the "Proj_Access_Resource_Manager" field will be used for both of those two fields.   

  • If no values are supplied for any of these three fields, the normal defaulting logic for this field will apply.

79

CA

Proj_Access_Resource_Assigner

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Resource Assigners have access to this project.  

Beginning with version 9.3, the Resource Manager role is no longer recognized within Unanet.   It was replaced by two new roles (Resource Planner and Resource Assigner).  For backward compatibility purposes, if the "Proj_Access_Resource_Manager" column is included in a project import file, the value in that field may be used under the following circumstances:  

  • If a value is supplied in either of the "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields, those values will be used and any value in the "Proj_Access_Resource_Manager" field will be ignored.  

  • If no values are supplied in the "Proj_Access_Resource_Planner" or "Proj_Access_Resource_Assigner" fields, then the value supplied in the "Proj_Access_Resource_Manager" field will be used for both of those two fields.   

  • If no values are supplied for any of these three fields, the normal defaulting logic for this field will apply.

80

CB

Proj_Access_Resource_Requestor

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Resource Requestors have access to this project.  

81

CC

Default_Location

CONDITIONALLY REQUIRED.  This value will represent a default Location for a particular project.  When the Location_Required field is set to Y, this field becomes a required field.  This value must match an existing Location value defined in your system.  If the Location you are trying to import does not already exist in the database, the entire record will be rejected.  See Admin >> Setup >> Locations for additional information about Location Defaulting Rules usage.

82

CD

Location_Required

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether a Location value is required when charging Time against this project.  When this value is set to Y, a Default_Location must also be provided.

83

CE

Fee_Factor_Type

For backwards compatibility, support for importing a single Fee Calculation Method can be facilitated via this project import. If you need to manage multiple fee calculation methods for a single project, you can use the Project Fee Import.  

This field is used to indicate whether the value supplied in the Fee_Factor field is to be treated as a numeric factor or a percentage.   

Valid values include P or N (if not provided, P is the default for a new entry).  

  • P - Percent -- amounts will be multiplied by a factor of .10
  • N - Numeric -- amounts will be multiplied by a factor of 10     

 

See Fee Factor -- Rules above for detail regarding the handling of Fee entries considering there may be many.

84

CF

Proj_Access_Billing_Manager

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Billing Managers have access to this project.  

85

CG

Proj_Access_Billing_Viewer

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Billing Viewers have access to this project.  

86

CH

Limit_Bill_To_Funded

Valid values include Y or N (if not provided, N is the default for a new entry).  This field is used to determine if billed amounts for this project should be limited to the Project's Funded Value less Fixed Fee.  

When this field is set to Y, then the project must have a Funded_Value defined (either within this import file or previously existing in the database).

87

CI

Limit_Rev_To_Funded

Valid values include Y or N (if not provided, N is the default for a new entry).  This field is used to determine if revenue recognition amounts for this project should be limited to the Project's Funded Value less Fixed Fee.  

When this field is set to Y, then the project must have a Funded_Value defined (either within this import file or previously existing in the database).

88

CJ

Posting_Group

This field is used to indicate whether posting procedures should use system default account settings or if the current project should have custom account settings (to override the system default settings).  

This value must match an existing Posting Group value defined in your system.  If the Posting Group you are trying to import does not already exist in the database, the entire record will be rejected.

Changing the Posting Group associated with a project is permitted and will impact any posting activity going forward.

Posting Groups attributes are defined on the Admin >> Setup >> Posting Group screen.  

89

CK

TS_Non_Emp_PO_Required

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether a Purchase Order number is required on PO timesheets for Non-Employees working on this project.  

90

CL

Exp_Non_Emp_PO_Required

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether a Purchase Order number is required on PO expense reports for Non-Employees working on this project.

91

CM

Allows_Item

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether people can charge items to this project.  

92

CN

Item_Requires_Task

Valid values include Y or N (if not provided, N is the default for a new entry).  Defines whether a task must be selected when a user attempts to charge items to a project.

In the event the Task_Level_Assignment indicator is Y, this value will be set to Y, and a warning message will be displayed if the provided value is something other than Y.   

93

CO

User11

See note for User Defined 1 above

94

CP

User12

See note for User Defined 1 above

95

CQ

User13

See note for User Defined 1 above

96

CR

User14

See note for User Defined 1 above

97

CS

User15

See note for User Defined 1 above

98

CT

User16

See note for User Defined 1 above

99

CU

User17

See note for User Defined 1 above

100

CV

User18

See note for User Defined 1 above

101

CW

User19

See note for User Defined 1 above

102

CX

User20

See note for User Defined 1 above

103

CY

Proj_Access_Proj_Doc_Viewer

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational Project Document Viewers have access to this project.  

104

CZ

Proj_Access_PO_Viewer

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational PO Viewers have access to this project.  

105

DA

Proj_Access_PR_Viewer

Valid values include Y or N (if not provided, Y is the default for a new entry).  Controls whether all Organizational PR Viewers have access to this project.  

106

DB

Contract_Code

CONDITIONALLY REQUIRED.  Billable projects (determined by the Billing_Type field) must be associated to a contract if the project's Original or Revised Begin Date is on or after the date in the Billable Projects Require Contracts As Of (YYYY-MM-DD) (unanet.billable.projects.asof.date)  property.

You can use the special tag !BLANK! to remove an existing entry in this field.

107

DC

Total_Cost

Must be a positive value. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

108

DD

Total_Fee

Must be a positive value. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

109

DE

Funded_Cost

Value can be positive or negative. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

110

DF

Funded_Fee

Value can be positive or negative. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

111

DG

Orig_Funded_Cost

Value can be positive or negative. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

112

DH

Orig_Funded_Fee

Value can be positive or negative. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

113

DI

Orig_Funded_Value

Value can be positive or negative. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

114

DJ

Orig_Total_Cost

Must be a positive value. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

115

DK

Orig_Total_Fee

Must be a positive value. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

116

DL

Orig_Total_Value

Must be a positive value. You can use the special tag !BLANK! to remove an existing entry in this field.

Note: If this is a Billable project (determined by the Billing_Type field), and it has a Contract_Code, and the Billable Project Changes Require Contract Modification (unanet.billable.projects.contractmod.asof.date) property is true, then you cannot change this field on an import. You must enter a contract modification in Unanet.

117

DM

Intercompany_Effort

This field can only be populated if your system has multi-entity accounting enabled (see Setup Multi-Entity). Valid values are "Y" or "N". Defaults to "N".

118

DN

Intercompany_Support_Provided_By

CONDITIONALLY REQUIRED. This field can only be populated if your system has multi-entity accounting enabled (see Setup Multi-Entity). If Intercompany_Effort is "Y", then this field is required. You can enter  one legal entity or multiple legal entities separated by commas. Legal entities must already exist in the system and must have an intercompany association with the project's owning legal entity defined in Setup Multi-Entity Associations.

 

Note: Check out the Unanet Data Model for specific field data types, lengths, and other attributes. Navigate to Unanet Support and search for "Data Model".


Import File Format

The file to import must be saved in a comma delimited format.   The fields can be enclosed in double quotes -- which would be particularly necessary should the data being imported contain commas.

Importing a Sub-Set of Columns using a Field Header Record

If you are not using the default column layout sequence as defined above, you must include a header record (prefixed with an asterisk *), containing the column Header Names for those columns you are including in the import file (to indicate what data is contained in each column).  The specific Header Names for each column are listed in the table above.

Example:

#Delete example
*Organization_Code,Project_Code,Delete
Org1,Project1,!DELETE!

#Append example
#this will append three additional organizations (OrgX, OrgY and OrgZ) onto the already existing list of assigned person organizations for this project.

*Organization_Code,Project_Code,Assigned_Organizations
Org1,Project1,"!APPEND!,OrgX,OrgY,OrgZ"

#Remove example
#this will remove an organization (OrgX) from the existing list of assigned person organizations for this project.  
*Organization_Code,Project_Code,Assigned_Organizations
Org1,Project1,"!REMOVE!,OrgX"


Excel Template

You can create the comma delimited import file with any number of tools.  For those interested in using an Excel spreadsheet to create the file, you can download an Excel Template with predefined headers.  

See the Excel Tips regarding the use of double quotes and more.


Import Screen

The Import Projects screen simply looks like:

 

Field Descriptions:

Field

Description

Type of Import

Select the appropriate import type from the list of available types of imports.

File to Import

Enter (or browse for) the file that you would like to import.

Output Options

Specify the level of detail included in the output.

Assignments

This flag must be checked (it defaults to unchecked) if your intention is to allow for the update of the Project/Task Assignment Level indicator (in order to prevent the accidental removal of existing assignments).

Note that when updating the Project/Task Assignment Level field, any existing project or task level assignments will be deleted from the system for that project.

Billing Type

This flag must be checked (it defaults to unchecked) if your intention is to allow for the update of the Billing Type indicator (in order to prevent the accidental removal of any existing Fixed Price items).

Note that when updating the Billing Type field, any existing Fixed Price items previously defined for that project will be deleted from the system.  Updating of a project level Billing Type is only allowed if the project has not participated in a Post process.  If it has, the update will be prevented.

 

The import process is triggered by pressing the Import button.  All Warnings and Error messages are written to the screen and can then be saved if desired.  While some line items may be found invalid and rejected, the remaining line items will be successfully imported and saved in the database.  The rejected line items will be written out to a file on the Unanet server as well as displayed at the bottom of the Import results page. The rejected record file name will be the import name (from the Type of Import drop-down on the Admin>> Import page) , concatenated with a space and "Errors.csv" (e.g., Item - Master Errors.csv, Alternate.csv, etc.). The file will be placed in the Unanet temporary directory (which is defined by the Temp Directory (Fully Qualified Directory Name) (unanet.temp_directory) Unanet property). You can also click on the Download the error file link at the bottom of the Import results page (sample image follows).

 

Related Topics