Labor Team

<< Click to Display Table of Contents >>

Navigation:  System Manager > Data Import > Import Parameters >

Labor Team

Previous pageReturn to chapter overviewNext page

 

To successfully import Labor Team records, take note of the following general conditions when creating your import source file:

 

•There can be any number of entries in the source file, one following immediately after the other.

 

•The first line in the source file is not imported. Be sure to enter the first entry after the first line.

 

•You must enter the data field's name in the first line as a column heading. The data import is case-sensitive so be sure that each column name is spelled correctly and that it matches with the actual data field's name.

 

•Each line in your source file after the first line will be treated as a separate record.

 

There are certain validations that the data import feature performs which differs depending on the import function selected. Validation checks are in place to ensure that data to be entered are acceptable to the system. Below are the data-specific requirements you need to successfully import team records:

 

 

Required Module: Manufacturing (MA)

 

Required Import Field(s):

•TeamCode

•Description

•ShortDescription

•LaborCode (Labor worksheet)

 

The import file for team must have the three (3) worksheets required. Each worksheet has it's own set of data required for a successful import. The worksheets must be in the following order:

 

•Team

•Labor

•Work Center

 

The Import Team function allows multiple Labor or Work Center per Team code.

 

 

notes_c

Note: You can view all available data fields for importing Team records by downloading the sample import file from this link.

 

 

 

 

Illustration:

 

The following example shows you how to format the source file properly to successfully import Team records. The sample import template below shows you the following:

 

•It is for importing three (3) different team records.

•It includes the required fields TeamCode, Description, and ShortDescription, respectively.

•It also contains values for the the selected data fields to be included in the data import. You have the option to include all data fields in your source file or to select only a few fields. For those non-required fields that you opt not to include in the source file, the system will auto-populate them with the default values.

 

Team Worksheet

 

TeamCode

Description

ShortDescription

Status

TC10001

Material Preparation Team

Material prep

1

TC10002

Cleaning Team

Cleaning

1

TC10003

Packaging Team

Packaging

1

 

 

Labor Worksheet

 

TeamCode

LaborCode

TC10001

ASY02

TC10001

FW02

TC10002

FW01

TC10002

LO01

TC10003

ASY02

TC10003

SAW02

 

 

WorkCenter Worksheet

 

TeamCode

WorkCenterCode

TC10001

PWC01

TC10002

MWC02

TC10003

PWC01

 

 

 

 

 

© 2026 AccountMate Software Corporation