| Issue Number | 5221 |
|---|---|
| Summary | Word Macro Turbo Needed |
| Created | 2023-03-24 15:06:58 |
| Issue Type | Improvement |
| Submitted By | Englisch, Volker (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2023-04-26 16:29:24 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.341949 |
~vshields told me that her summary macro takes a long time to run, especially on larger documents. It appears that the conversion of the document finished but the user has to wait for a while before the macro finished completely.
The summary macros are a combination of lots of smaller macros doing individual pieces of the conversion. It may be useful to identify which of these pieces is using the bulk of the processing time and it may be possible to improve performance merely by rearranging the order of processing.
I have setup a new macro named "ReplaceFontSize12to10" which is replacing the old macro "ChangeFontSizeLoopTo10". On my DEV machine the old macro ran for about 14 minutes to convert the Breast Cancer Treatment summary. With the new macro replacement the document is converted in about 8 seconds.
I still have to test the macro for the DIS conversion before I'll hand this over to ~vshields for testing.
It turns out that nobody on Christina's team is using the macro for DIS. Therefore it doesn't need to be updated and I have removed it from the macro file.
I ran the new macro on the Breast Cancer summary and the time to run went from about 6 minutes to 6 seconds! Amazing!
The macro file has been updated on the network and copied to git.
CDR_macros.dotm
https://github.com/NCIOCPL/cdr-client/commit/9f0c4e5
CDR_macros.bas
https://github.com/NCIOCPL/cdr-client/commit/9f0c4e5
Since Victoria has the new macro file already installed on her computer and she's the only board manager who's using that updated macro I'm closing this ticket.
~vshields , does Bonnie use the macro for treatment summaries?
Bonnie does use this macro! Good memory! Should I send her the directions you sent me, or it is more complicated for her because she runs macros for several different Boards?
No, it's not more complicated. All she would have to do is to copy the file from the network to her computer just like you did.
Feel free to let her know I can look over her shoulder if she prefers that.
Elapsed: 0:00:00.000704