Task 1: Testing .xml Files on a TEST Instance Without Creating Time Sheets

Test some .xml files on a TEST instance, as follows:

  1. For testing purposes, create a project with tasks and integrate the project with Time Management such that actuals entered for tasks on time sheets are reflected in the project. See the Project Management User Guide.

  2. For testing purposes, create one or more .xml files, each with one or two time sheets, for one or two resources. For at least one time sheet line, include data for time logged against a task in the project that is integrated with Time Management.

    Make sure the time sheet data in each file conforms to the formats specified in the timeConversion.xsd file. Make sure all the .xml files containing the time sheets are in the same directory, and note the path to that directory.

  3. Run the script in test mode to verify the test.xml files on the TEST instance. In test mode, no time sheets are created, but logs describing errors that can be detected in the .xml files are created. See Running the Time Sheet Data Importer Script.

    You can abort the script at any time by pressing Q + Enter or E + Enter. The file the script is operating on will be left in its current location and indicated as aborted in the main progress log and in the itg_tm_data_loader_progress database table.

  4. When the script completes, review the logs to identify specific or systematic errors that should be corrected in the .xml files.

    The .xml files, unchanged, are moved to subdirectories named SUCCESS, PARTIAL, and FAILURE, and copies that include only the time sheet data that caused failures are added to the resubmissions subdirectory. For more information, see Files Generated While Running the Time Sheet Data Importer.

  5. To correct the original .xml files that were moved to the PARTIAL and FAILURE subdirectories:

    1. Use the error logs and the data in the resubmissions subdirectory to understand what to correct.

    2. Correct the original .xml files in the PARTIAL and FAILURE subdirectories.

    3. Move those corrected .xml files back to the original directory you used when you ran the script (see step 2).

    4. Delete the files in the resubmissions subdirectory.

  6. Starting at step 2, repeatedly run the script in test mode against corrected source .xml files until all errors in the files are corrected, that is, until the script moves all of the .xml files to the SUCCESS subdirectory.

  7. Repeat this procedure with increasingly complex .xml data representing time sheets, until the script options and the variety of time sheet data applicable to your business have been tested and corrected.

  8. When all the .xml files are in the SUCCESS subdirectory, move them back to the original directory you used in step 2 to prepare to create test time sheets from them.