WRTIME - Timesheet import
This import template allows inserting/editing:
- Timesheets.
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 | Primary key - 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: 205 - Code of the SoftExpert Time control 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. |
| 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; 7 - Verification activity; 8 - Calibration activity; 9 - Maintenance activity. |
| 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. |