clarivate/wos-excel-converter

Export Settings range does not start at 1

eschares opened this issue · 7 comments

Describe the bug
When changing export settings range, program moves range from 1 to 101 by itself

To Reproduce
Steps to reproduce the behavior:

  1. usrQuery=OG="Iowa State University" AND PY=2021 and databaseID=WOS; 3,694 records found
  2. File formats Excel only
  3. Export Settings range changed to 1-200
  4. Click run, range changes to [101,200]

Expected behavior
Expect exported range to match what I specify, 1-200

Screenshots
If applicable, add screenshots to help explain your problem.
Attached

Desktop (please complete the following information):

  • wos-api-exporter-setup-1.0.0-rc1.exe
  • OS: Windows 10 Enterprise

Additional context
The running and exporting also seems much slower than previous version.
Capture
Capture2

@eschares Thanks for the report. Actually, the range is intentionally done this way. The range is synchronized with the pagination of API. The way I see it, in case it goes something wrong, you know at which page it failed so that you can continue to export the rest of the documents without needing to start at 1.

Exporting gets a bit slower when you include multiple formats and it gets much slower if you choose to export cited references. You can disable cited references in Query settings by disabling the toggle box. The reason for that is that cited references require a separate request for each document, ie, for 3k documents, you would need 30 requests, but with cited references, you need 3030 requests.

image

If this solves your problem, please let us know so that we can close this issue. Thank you.

Hello,
This has not solved my problem. How can I get records 1-100? I specify 1-3758, but the tool exports 101-3758.

Capture3

Additionally

  • up arrows let me go past the max record number
  • export errors out and fails with attached error message

Capture4

Hello there, I wanted to add that am having very similar issues with my own query attempts in case there's been any progress towards finding potential solutions to this issue. Thank you!

Hi all, I am not able to reproduce this one. I tried the above query with all possible combinations 1-200, with and without cited references. I am still able to export the exact number of documents. Please note that the cursor range will increase during export, and this is an intention.

@eschares please follow the 'ERR_ACTION_ACCESS_UNDEFINED' issue here: #18. It seems to occur when 'cited references' is toggled on.