JC Import Work Centre Plans

You can import a Work Centre Plan using the Work Centre Plan Maintenance form.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Description

Enter the name of the new Work Centre Plan.

Load From File

Click this button to open the form below to enter details for importing.

Load Plan from .csv

Source File

Enter the name of the file with details to be imported, including the path to the file. Click the Browse button to find the file.

Employee and User settings in file Check-box

Select this option to include employee or type and user or team settings in the file.

If you:

Select this option, the file format includes seven lines per level set up as detailed below.
Don't select this option, the file format has one line per level, and each level has:
- All employees selected
- The Edit Completion Permissions All Users option selected
- The Edit Completion Permissions All Users option selected.

Auto create Work Centres

Select this option to create work centres if they do not already exist in the current company.

If you:

Select this option, the work centre codes are auto-created on encountering a Work Centre code in the file that does not exist in the current company. The values created are:
- Company - Current company
- Code - Code supplied in the file.
- Description - Automatically created if no Alternate Description is specified. If an Alternate Description is specified, this is imported into the Work Centre Plan, and the Work Centre Description is Auto-created.
Don't select this option, on encountering a work centre code in the file that does not exist in the current company, the Work Centre code is considered to be invalid, and an error message displays.
When the error message dialog box is closed, the import process is aborted and any processing will be rolled back, returning the system to the state it was before the import began, including deleting the Work Centres that were auto-created by this process.

Assign all Employees

Select this option to give all employees access to work centre branches by default on import. This option is not enabled if the Employee and User Settings in file option is selected.

If you select this option, it assigns all employees to all work centre branches on import. If not selected, then no employees will be assigned to the work centre branches.

Click this button to start the import process.

Cancel

Click is button to close the Load Plan form and not start the import process.

File Formats

Only two file formats are accepted by the import process:

Work Centre Plan with all employees made available and all users allowed permission to complete each level, and
Work Centre Plan with specific settings for available employees and user permissions per level.

The file must be a comma separated value (.csv) file.

Employee and User settings in file is not selected

The file format comprises only lines that define the Work Centre Plan level structure. The line number for each line imported (when the employee and user settings in file is selected) must be 1 for each line processed.

It must be in this format:

1,<Work Centre which defines the branch level>,<Alternate Description>,<Parent Work Centre>,isPostingLevel,isAllActivities,Activity Group,Default % Complete

Field Parameters Definition

Employee and User settings in file is not selected

Line	Item	Description		Required/Default
1	WC	Work Centre, If Parent Work Centre (above) is populated; create this work centre as a child of the parent identified above. If Parent Work Centre is not populated, create a parent level work centre only.		Mandatory
1	Alternate Description	Description for the level on the Work Centre Plan. If this is null, the Work Centre's Description is used on the Plan.		Mandatory Valid entries are: Null String, up to 50 characters Cannot include, (comma)
1	Parent WC	Valid Work Centre or Blank		Optional
1	isPostingLevel	Specifies whether this level is a posting level		Mandatory True or False (or case variations of these; for example, True, true)
1	isAllActivities	Specifies whether this level is to use all JC Activity Codes If isPostingLevel is False, ignore.		Mandatory True or False (or case variations of these; for example, True, true)
1	Activity Group	The Activity Group for this level IF isPostingLevel = False or isAllActivities = True, ignore.		Mandatory Valid JC Activity Group
1	Default % Complete	If not specified, then set to None.		Optional Valid entries are: Budget versus Actual Cost Budget versus Actual Hours Budget versus Actual Sell Elapsed Time None
These lines must all be present if Employee and User settings in file is selected. They must not be present if Employee and User settings in file is not selected. Line 1 of the import file uses exactly the same parameters as defined above.
Line	Item		Description	Required/Default
2	Employee Codes		List of Employee Codes separated by commas.	Can be $ALL (or $all or $All) Can be empty (blank means none)
3	Employee Types		List of Employee Types separated by commas. If Line 2 is $ALL, then ignore this line (since all employees will be selected for this level). If Line 2 is a list of Employee Codes, and Line 3 is $ALL it is assumed that all employees are required. If Line 2 and Line 3 are both blank, it is assumed no employees are required.	Can be $ALL (or $all or $All) Can be blank
4	Completion Permission Users who CAN complete this level		List of User Names separated by commas	Can be $ALL (or $all or $All) Can be blank
5	Completion Permission Users who can complete sub-levels of this level		List of User Names separated by commas Of the Users listed in Line 4, these are the Users who can complete the sub-levels. If any of the Users in this list are not in Line 4, ignore them (since you cannot give sub-level permission to someone who does not have current level permission)	Can be $ALL (or $all or $All) only if Line 4 is $ALL Can be empty (meaning no Users of Line 4 have permission to close sub-levels)
6	Completion Permission Teams who CAN complete this level.		List of Team Names separated by commas	Can be $ALL (or $all or $All) Can be blank
7	Completion Permission Teams who can complete sub-levels of this level		List of Team Names separated by commas Of the Teams listed in Line 6, these are the Teams who can complete the sub-levels. If any of the Teams in this list are not in Line 4, ignore them (since you cannot give sub-level permission to a Team that does not have current level permission)	Can be $ALL (or $all or $All) Can be empty (meaning no Teams of Line 6 have permission to close sub-levels)
	How do we handle conflicts of User settings in Lines 4-7? If the process encounters a value of $ALL in any of Lines 4-7, it will treat the selection criteria in each of the rows as its own separate criteria which will process regardless of what may be present in any other row. Example 1 4,Craig Clark,Cameron Cook 5,Craig Clark 6,ALL 7,ALL Users Clark and Cook can complete this level. User Clark can complete the sub-levels. All Teams can complete this level. All Teams can complete the sub levels. Example 2 4,$All 5,Craig Clark, Cameron Cook 6,ALL 7,SERVMAN All users can complete this level Craig Clark and Cameron Cook can complete sub-levels. All Teams can complete this level. Members of Team SERVMAN can complete sub-levels.