Skip to content

Project list not complete #69

@Dr-Peter-A-Kropp

Description

@Dr-Peter-A-Kropp

When starting excel sync, the project list is downloaded in order to get a full list of projects (being seen by the user).
This list is incomplete and stops before the last page.
The reason is a wrong Lopp-End-Condition in GetProjects(URLStr, APIKeyStr) of module OpenProjectAPIModul where it says
Loop Until OffsetCountLng >= WorksheetFunction.RoundUp(JsonObj("total") / JsonObj("pageSize"), 0)
whereas is works for me only using
Loop Until OffsetCountLng > WorksheetFunction.RoundUp(JsonObj("total") / JsonObj("pageSize"), 0)

This is only an issue if you have more projects than pagesize values. But we have.
For me, the project list stops at line 151 with v0.6.17 and correctly adds another 45 lines when correcting the line.

Since inside the loop we have the if-condition
If JsonObj("pageSize") = Empty Or JsonObj("count") = JsonObj("total") Then JsonObj("pageSize") = JsonObj("total")
I think it is completely safe to correct the Loop-End-condition as proposed.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions