PROTIME - Timesheet import
This import template allows inserting/editing:
- Timesheet.
For the insertion of each one of these items, the standard documented below must be followed.
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 | Code of the system for which the integration will be performed: 41 - Code of the SoftExpert Project component. |
FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 1 - Insert timesheet. |
NMFIELD01 | X | TEXT | 255 | Object ID #. |
NMFIELD02 | X | TEXT | 255 | Task ID #. |
NMFIELD03 | TEXT | 255 | Task WBS. | |
NMFIELD04 | X | TEXT | 255 | Timesheet date. Date 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 times 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. |