Navigation:  Integration via database > Published interfaces > Project >

PROTIME - Timesheet import

Previous  Top  Next

This import template enables to insert/edit:

Timesheet;

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert/edit timesheet

Column

Required

Type

Precision

Description

OIDINTERFACE

X

TEXT

32

Sequential code - Identifies an item to be imported into SoftExpert Suite.

FGIMPORT

X

NUMERIC

2

Import status:

1 - New;

2 - In progress;

3 - Finished;

4 - Error.

CDISOSYSTEM

X

NUMERIC

10

System code where the integration will be performed to:

41 - Code of component SoftExpert Project.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 - Insert timesheet.

NMFIELD01

X

TEXT

255

Object ID #.

NMFIELD02

X

TEXT

255

Activity ID #.

NMFIELD03

 

TEXT

255

Task WBS.

NMFIELD04

 

X

TEXT

255

Timesheet date. State in the format.

NMFIELD05

X

TEXT

255

Timesheet start time. Required if total is not entered.

NMFIELD06

X

TEXT

255

Timesheet end time. Required if total is not entered.

NMFIELD07

X

TEXT

255

Timesheet total time. Required if start and end time are not entered.

NMFIELD08

X

TEXT

255

Hour type:

1 - Regular hour;

2 - Overtime.

NMFIELD09

X

TEXT

255

Resource ID # or name.

NMFIELD10

X

TEXT

255

Task type:

1 - Project task;

2 - Nonproject task;

3 - Monitored event.

4 - Meeting;

5 - Isolated action;

6 - Action plan action.

NMFIELD22

 

TEXT

255

Attribute ID #.

NMFIELD23

 

TEXT

255

Value of the attribute specified in the NMFIELD22 field.

NMFIELD24

 

TEXT

255

Attribute ID #.

NMFIELD25

 

TEXT

255

Value of the attribute specified in the NMFIELD24 field.

NMFIELD26

 

TEXT

255

Attribute ID #.

NMFIELD27

 

TEXT

255

Value of the attribute specified in the NMFIELD26 field.

NMFIELD28

 

TEXT

255

Attribute ID #.

NMFIELD29

 

TEXT

255

Value of the attribute specified in the NMFIELD28 field.

NMFIELD30

 

TEXT

255

Attribute ID #.

NMFIELD31

 

TEXT

255

Value of the attribute specified in the NMFIELD30 field.

NMFIELD32

 

TEXT

255

Attribute ID #.

NMFIELD33

 

TEXT

255

Value of the attribute specified in the NMFIELD32 field.

NMFIELD34

 

TEXT

255

Attribute ID #.

NMFIELD35

 

TEXT

255

Value of the attribute specified in the NMFIELD34 field.

NMFIELD36

 

TEXT

255

Attribute ID #.

NMFIELD37

 

TEXT

255

Value of the attribute specified in the NMFIELD36 field.

NMFIELD38

 

TEXT

255

Attribute ID #.

NMFIELD39

 

TEXT

255

Value of the attribute specified in the NMFIELD38 field.

NMFIELD40

 

TEXT

255

Attribute ID #.

NMFIELD41

 

TEXT

255

Value of the attribute specified in the NMFIELD40 field.

NMFIELD42

 

TEXT

255

Attribute ID #.

NMFIELD43

 

TEXT

255

Value of the attribute specified in the NMFIELD42 field.

NMFIELD44

 

TEXT

255

Attribute ID #.

NMFIELD45

 

TEXT

255

Value of the attribute specified in the NMFIELD44 field.

NMFIELD46

 

TEXT

255

Attribute ID #.

NMFIELD47

 

TEXT

255

Value of the attribute specified in the NMFIELD46 field.

NMFIELD48

 

TEXT

255

Attribute ID #.

NMFIELD49

 

TEXT

255

Value of the attribute specified in the NMFIELD48 field.

NMFIELD50

 

TEXT

255

Attribute ID #.

NMFIELD51

 

TEXT

255

Value of the attribute specified in the NMFIELD50 field.

NMFIELD52

 

TEXT

255

Attribute ID #.

NMFIELD53

 

TEXT

255

Value of the attribute specified in the NMFIELD52 field;

NMFIELD54

 

TEXT

255

Attribute ID #;

NMFIELD55

 

TEXT

255

Value of the attribute specified in the NMFIELD54 field.

NMFIELD56

 

TEXT

255

Attribute ID #.

NMFIELD57

 

TEXT

255

Value of the attribute specified in the NMFIELD56 field.

NMFIELD58

 

TEXT

255

Attribute ID #.

NMFIELD59

 

TEXT

255

Value of the attribute specified in the NMFIELD58 field.

NMFIELD60

 

TEXT

255

Attribute ID #.

NMFIELD61

 

TEXT

255

Value of the attribute specified in the NMFIELD60 field.

NMFIELD62

 

TEXT

255

Attribute ID #.

NMFIELD63

 

TEXT

255

Value of the attribute specified in the NMFIELD62 field.

NMFIELD64

 

TEXT

255

Attribute ID #.

NMFIELD65

 

TEXT

255

Value of the attribute specified in the NMFIELD64 field.

NMFIELD66

 

TEXT

255

Attribute ID #.

NMFIELD67

 

TEXT

255

Value of the attribute specified in the NMFIELD66 field.

NMFIELD68

 

TEXT

255

Attribute ID #.

NMFIELD69

 

TEXT

255

Value of the attribute specified in the NMFIELD68 field.

NMFIELD70

 

TEXT

255

Attribute ID #.

NMFIELD71

 

TEXT

255

Value of the attribute specified in the NMFIELD70 field.

NMFIELD72

 

TEXT

255

Attribute ID #.

NMFIELD73

 

TEXT

255

Value of the attribute specified in the NMFIELD72 field.

NMFIELD74

 

TEXT

255

Attribute ID #.

NMFIELD75

 

TEXT

255

Value of the attribute specified in the NMFIELD74 field.

DSFIELD01

 

TEXT

4000

Timesheet comments.