Using the .Net API, I hat developped a custom DotNet module that was creating a MsWord DOCX using the Microsoft.Interop.Word for a complex Merge situation, creating a documents with many tables.
It was working for small documents, but it was very slow (3 min for a 3 page document).
Timed out after 20 minutes for an expected 19 pages document.
I read many posts on-line recommending to use the "Open XML SDK" which is supposed to be much much faster (6 seconds instead of 5 minutes for example), but I can't get it to work with SageCRM .Net API.
1) I used NuGet in VS 2019 to install the latest version of "Open XML SDK" (DocumentFormat.OpenXml - v2.18 dated 2022-09-06)
2) Added the reference to my project and set "Copy Local = True"
3) Created a simple Test project
4) When deploying, the files DocumentFormat.OpenXml.dll and DocumentFormat.OpenXml.xml are copied to the "Sage\CRM\CRM\CustomDotNet" folder with the Project's DLL
I get this error at runtime:
Sep 12 2022 16:52:58.063 6884 1148 1 Class: CRMWrapper - Method: ExecWebPageNew - Error: An error has occurred on PreBuildContents or BuildContents
Sep 12 2022 16:52:58.070 6884 1148 5 StackTrace:
Error: Could not load file or assembly 'DocumentFormat.OpenXml, Version=188.8.131.52, Culture=neutral, PublicKeyToken=8fb06cb64d019a17' or one of its dependencies. The system cannot find the file specified.
at Sage.CRM.Wrapper.CRMWrapper.ExecWebPageNew(String fullFileName, String callFunction)
There is no dependencies for OpenXml with .Net 3.5.
I lost a lot of time this week trying to make this work.
Has anyone been able to work with the "Open XML SDK" in SageCRM ?