Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Resource Import

Compare Page Revisions



« Older Revision - Back to Page History - Current Revision


Page Revision: Wed, 16 Jan 2019 08:18



General Info

Default Menu Location: Transaction >> Importers/Exporters >> Tasks and Time Billing >> Resource Import

Screen Name: IMPORTRES

Function: The Resource Import screens allows you to import resource attribute details for existing contact records.

Resource Import screen

Resource Import screen


Import File Name/Browse: Use the Browse button to locate and select the completed Resource Import template file (in XLS format).

Export Template: Generates a blank Resource Import template file

Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.

Validate to XLS File: Generates an XLS file of errors that will prevent the import from completing. The file will only be created if there are errors.



Resource Import File Definitions

Required fields are indicated with an *

*f1 - Custno - Organization customer number for the target contact record

f2 - ContID - Contact ID from the VCONTACT table. This field is no longer used.

*f3 - FirstName - First name for the target contact record. This must exactly match the first name of an existing contact record in Adjutant.

*f4 - LastName - Last name for the target contact record. This must exactly match the last name of an existing contact record in Adjutant.

f5 - TabCode - Schedule Tab code from the Schedule Tab Names (TABS) rule to populate the Schedule Tab.

*f6 - RName - Resource full name

f7 - DefSkill - Default Skill Code from the Resource Skill Codes (SKILL) rule

f8 - ShowSch - Enter a 'Y' to check the Show on Schedule box. Leave blank or enter 'N' to leave the box unchecked.

f9 - IsSuper - Enter a 'Y' to check the Supervisor box. This defines the resource record as an available Supervisor in the Supervisor drop-down list. Leave blank or enter 'N' to leave the box unchecked.

f10 - WOForm - Enter the complete form name and .FRX extension to default a specific work order form for the resource.

f11 - EquipID - Enter a valid Asset Tag ID to associate a default piece of equipment for the resource. The Asset Tag ID must exist in Adjutant.

f12 - ResNo - Resource ID (RID) number for the resource (max 10 characters, alphanumeric)

f13 - EmplID - Accounting system employee ID used for third party integrations. (max 9 characters, alphanumeric)

f14 - DefWHSE - Default Warehouse name

f15 - DefBCode - Default Billing Code from the Billing Codes (BILLCODE) rule

f16 - GLGroup - GL Group name associated with the resource. The GL Group must exist in Adjutant.

f17 - DCode - Department Code from the Departments (DEPT) rule

f18 - SHour - Schedule start hour. Must be entered in HH:MMAM or HH:MMPM format, and the Excel column should be formatted as text

f19 - EHour - Schedule end hour. Must be entered in HH:MMAM or HH:MMPM format, and the Excel column should be formatted as text

f20 - Email - Resource email address

f21 - CostFact - Resource cost factor, or labor rate per hour, in 999.99 format. This field is only used with certain setup options, and it can adversely affect accounting balances if not set up correctly. Do not import this value unless you are absolutely clear on the reflexes.

f22 - StartTab - Schedule Tab code from the Schedule Tab Names (TABS) rule to populate the Start on Tab.

f23 - AssHour - Number of hours for the Default Hours per Day field

f24 - ResHour - Number of hours for the Daily Schedule Load (Hrs) field

f25 - AllOver - Enter a 'Y' to allow overscheduling.

f26 - ParentOnly - Enter a 'Y' to check the Assign to Parent Company Only box. Leave blank or enter 'N' to leave the box unchecked.

f27 - GMTOff - Schedule offset from Greenwich Mean Time in whole hours (valid entries are -## to ##)

f28 - DST - Enter a 'Y' to check the DST (Daylight Savings Time) box. Leave blank or enter 'N' to leave the box unchecked.

f29 - HireDate - Resource hire date in MM/DD/YY format

f30 - TermDate - Resource termination date in MM/DD/YY format

f31 - SCodes - Enter Skill Code(s) from the Resource Skill Codes (SKILL) rule. To enter multiple skills for a resource, separate each code by a comma.

f32 - BCodes - Enter Billing Code(s) from the Billing Codes (BILLCODE) rule. To enter multiple billing codes for a resource, separate each code by a comma.

f33 - Attributes - Enter Resource Attribute name(s) from the Resource Attributes (ATT_RES) rule (not the codes). To assign multiple attributes for a resource, separate each attribute name by a comma.





Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions