Skip to content

Support

Debugging Load of Project Review Excel Files

The load is nasty and often causes problems.

Here is the easiest way to debug the data load:

  1. in sample_review_file_1, sort files by modify date (descending)

  2. Filter any suspicious file
    1-filter.png

  3. Review the function transform_project_review_query. If it runs through, go to the next suspicious file. Else “Go To Error”
    9-function.png

  4. Identify the error lines
    9-identify.png

  5. Analyse the file (or the code)