search

esitarski / CrossMgr

Cyclo Cross Management Application
MIT License
41 stars 21 forks source link

Export Excel/PDF in Team Results not working in MacOS Catalina #43

Open cclague opened 4 years ago

cclague commented 4 years ago

Describe the bug On the Team Results Tab in CrossMgr (tab 18) the export excel/pdf button creates 2 blank files

To Reproduce Steps to reproduce the behavior:

  1. Go to tab 18
  2. Click on Export Excel/PDF
  3. Go to race folder
  4. Files are created but empty

Expected behavior Files should contain results for team rankings as they appear in the window

Screenshots To show race with results page

image

Desktop (please complete the following information):

Additional context Tested also on windows 10 - button 'feel' is the same (in the sense that it feels like it doesn't work in either Windows or MacOS), similarly seeing empty files. Version on Windows 3.0.41 running Windows 10 1909

mbuckaway commented 4 years ago

Can I ask for the following additional info:

I am running basically the same laptop as you, running CrossMgr, v3.0.46-20200115141349 and I managed to export the Teams List from an old race. However, since I build the code locally, there might be some python module missing in the build I have installed which makes it work for me and no one else. The log should point this out.

I am also curious if things like Batch Publish to Excel also works for you?

I would also like to clarify that you can export the data correctly on Windows with 3.0.41? Does v3.0.46-20200115141349 also work?

Thanks, Mark

esitarski commented 4 years ago

Bug does not happen in Linux. Pdf and Excel files created from Team Results correctly.

On Sun, Jan 19, 2020 at 1:57 PM Mark Buckaway notifications@github.com wrote:

Can I ask for the following additional info:

  • version of CrossMgr your are running (CrossMgr menu->About) on your Mac?
  • use the Tools->Copy log to Clipboard, use TextEdit or whatever editor you like, paste the data info a file, and attached the resultant file to this issue.

I am running basically the same laptop as you, running CrossMgr, v3.0.46-20200115141349 and I managed to export the Teams List from an old race. However, since I build the code locally, there might be some python module missing in the build I have installed which makes it work for me and no one else. The log should point this out.

I am also curious if things like Batch Publish to Excel also works for you?

I would also like to clarify that you can export the data correctly on Windows with 3.0.41? Does v3.0.46-20200115141349 also work?

Thanks, Mark

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/esitarski/CrossMgr/issues/43?email_source=notifications&email_token=AABGXKLQCIX2U7PGJCHHVVDQ6SPCXA5CNFSM4KI2YUK2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJKZSEY#issuecomment-576035091, or unsubscribe https://github.com/notifications/unsubscribe-auth/AABGXKIMY2IH5OFCSGCZCEDQ6SPCXANCNFSM4KI2YUKQ .

--

Edward Sitarski

cclague commented 4 years ago

Hi - version is 3.0.46-20200115141349 on the mac. I also built locally and saw the same issue. Batch Publish to excel works fine.

Log below:

2020-01-19T19:36:44 (v3.0.46-20200115141349 Darwin) call: openRace: "/Users/chris/CrossMgrRaces/2020-01-04-Round12/2020-01-04-Round12 - U10 U12 Youth-Youth A B-r1-.cmn" 2020-01-19T19:36:44 (v3.0.46-20200115141349 Darwin) openRace: Excel file "/Users/chris/Dropbox/LCCA2019/archive/crossmgr_files/2020-01-04-Round12/2020-01-04-Round12 - U10 U12 Youth-Youth A B-r1-.xlsx" 2020-01-19T19:36:45 (v3.0.46-20200115141349 Darwin) page: TeamResults 2020-01-19T19:36:47 (v3.0.46-20200115141349 Darwin) call: doExport(<>, <>)

Additional info: - this race was not recorded on this machine but copied to it. Don't know if that makes a difference?

On windows it also generates empty files - I have not tried 3.0.46 on windows, I will do that shortly.

Thanks

mbuckaway commented 4 years ago

If I recall, the CrossMgr Simulation has a team (one I believe). Can I ask you run the simulation through, and then try the team export?

Thanks Mark

cclague commented 4 years ago

Interesting - that worked ok (on the mac), though there were no teams with multiple riders so I set the team count to 1. I have a suspicion that this is maybe something to do with the original source data not coming from this setup (if that makes any sense). When we publish results I have a process that sweeps the race files up from the laptop, zips them up and ftp's them to a cloud server - this then unpacks them and (among other tasks) posts to dropbox (as you can see in the log above). I then picked up the files from dropbox to post-process after the event on a different machine (race machine is windows, desktop is mac).

mbuckaway commented 4 years ago

What happens when you:

It would appear something is getting eaten in your process.

cclague commented 4 years ago

OK, I moved files over using a USB stick (between two windows machines) and have the same issue.

I think it's related to files moving and the original excel file being located in a different place. Log below: 2020-02-01T11:35:44 (v3.0.41 Windows) call: menuOpen(<>, <>) 2020-02-01T11:36:05 (v3.0.41 Windows) CrossMgr 3.0.41: Windows 10 2020-02-01T11:36:05 (v3.0.41 Windows) call: openRace: "C:\Users\LCCA\CrossMgrRaces\Round02 - Jun Sen V40 V50\2019-09-15-Round02 - Jun Sen V40 V50-Juniors and Vet40-49-r2-.cmn" 2020-02-01T11:36:05 (v3.0.41 Windows) openRace: cannot open Excel file "\LARS\Users\LCCA\CrossMgrRaces\Round02 - Jun Sen V40 V50\2019-09-15-Round02 - Jun Sen V40 V50-Juniors and Vet40-49.xlsx" 2020-02-01T11:36:10 (v3.0.41 Windows) openRace: changed Excel file to "C:\Users\LCCA\CrossMgrRaces\Round02 - Jun Sen V40 V50\2019-09-15-Round02 - Jun Sen V40 V50-Juniors and Vet40-49.xlsx" 2020-02-01T11:36:15 (v3.0.41 Windows) page: TeamResults 2020-02-01T11:36:19 (v3.0.41 Windows) call: doExport(<>, <>) 2020-02-01T11:36:19 (v3.0.41 Windows) call: doExport(<>, <>)

Thanks

mbuckaway commented 4 years ago

Can you attached the file to the GitHub issue?

Thanks, Mark

On Feb 1, 2020, at 6:47 AM, cclague notifications@github.com wrote:

OK, I moved files over using a USB stick (between two windows machines) and have the same issue.

I think it's related to files moving and the original excel file being located in a different place. Log below: 2020-02-01T11:35:44 (v3.0.41 Windows) call: menuOpen(<>, <>) 2020-02-01T11:36:05 (v3.0.41 Windows) CrossMgr 3.0.41: Windows 10 2020-02-01T11:36:05 (v3.0.41 Windows) call: openRace: "C:\Users\LCCA\CrossMgrRaces\Round02 - Jun Sen V40 V50\2019-09-15-Round02 - Jun Sen V40 V50-Juniors and Vet40-49-r2-.cmn" 2020-02-01T11:36:05 (v3.0.41 Windows) openRace: cannot open Excel file "\LARS\Users\LCCA\CrossMgrRaces\Round02 - Jun Sen V40 V50\2019-09-15-Round02 - Jun Sen V40 V50-Juniors and Vet40-49.xlsx" 2020-02-01T11:36:10 (v3.0.41 Windows) openRace: changed Excel file to "C:\Users\LCCA\CrossMgrRaces\Round02 - Jun Sen V40 V50\2019-09-15-Round02 - Jun Sen V40 V50-Juniors and Vet40-49.xlsx" 2020-02-01T11:36:15 (v3.0.41 Windows) page: TeamResults 2020-02-01T11:36:19 (v3.0.41 Windows) call: doExport(<>, <>) 2020-02-01T11:36:19 (v3.0.41 Windows) call: doExport(<>, <>)

Thanks

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/esitarski/CrossMgr/issues/43?email_source=notifications&email_token=ADIY4LVLLWU2656EBMRIUTDRAVON3A5CNFSM4KI2YUK2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKQ3GRY#issuecomment-581022535, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADIY4LQ7DKMOIIGER4XVLRDRAVON3ANCNFSM4KI2YUKQ.

cclague commented 4 years ago

Sample file attached - it seems to always reference the original location

Round03 - Jun Sen V40 V50.zip