Codeunit 5069 Word Template Interactions
src/Layers/W1/BaseApp/CRM/Interaction/WordTemplateInteractions.Codeunit.al742 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.CRM.Interaction;using Microsoft.CRM.Contact;using Microsoft.CRM.Segment;using Microsoft.CRM.Setup;using Microsoft.CRM.Team;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using System.Email;using System.Globalization;using System.Integration.Word;using System.IO;using System.Reflection;using System.Utilities;codeunit 5069 "Word Template Interactions"{ /// <summary> /// Performs mail merge on the Word templates from the attachments specified by TempDeliverySorterWord /// and sends them according to the correspondence Type. /// </summary> /// <param name="TempDeliverySorterWord">A temporary table containing information about attachments and their recipients.</param> procedure Merge(var TempDeliverySorterWord: Record "Delivery Sorter" temporary) var TempDeliverySorterBuffer: Record "Delivery Sorter" temporary; InteractionLogEntry: Record "Interaction Log Entry"; ZipTempBlob: Codeunit "Temp Blob"; LastAttachmentNo: Integer; LastCorrType: Enum "Correspondence Type"; LastSubject: Text[100]; ZipFileName: Text; LastSendWordDocsAsAttmt: Boolean; FirstRecord: Boolean; LineCount: Integer; NoOfRecords: Integer; ZipInStream: InStream; ZipOutStream: OutStream; begin WindowDialog.Open( MergingInWordTxt + '#1############ @2@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\' + '#3############ @4@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\\' + '#5############ #6################################'); WindowDialog.Update(1, PreparingTxt); WindowDialog.Update(5, ProgramStatusTxt); WindowDialog.Update(6, PreparingMergeTxt); TempDeliverySorterWord.SetCurrentKey( "Attachment No.", "Correspondence Type", Subject, "Send Word Docs. as Attmt."); TempDeliverySorterWord.SetFilter("Correspondence Type", '<>0'); NoOfRecords := TempDeliverySorterWord.Count(); TempDeliverySorterWord.Find('-'); FirstRecord := true; LastAttachmentNo := 0; repeat LineCount := LineCount + 1; WindowDialog.Update(2, Round(LineCount / NoOfRecords * 10000, 1)); WindowDialog.Update(3, Format(TempDeliverySorterWord."Correspondence Type")); if FirstRecord and (NoOfRecords > 1) then EnableZipArchive(); if not FirstRecord and ((TempDeliverySorterWord."Attachment No." <> LastAttachmentNo) or (TempDeliverySorterWord."Correspondence Type" <> LastCorrType) or (TempDeliverySorterWord.Subject <> LastSubject) or (TempDeliverySorterWord."Send Word Docs. as Attmt." <> LastSendWordDocsAsAttmt)) then begin ExecuteMerge(TempDeliverySorterBuffer); TempDeliverySorterBuffer.DeleteAll(); end; TempDeliverySorterBuffer := TempDeliverySorterWord; TempDeliverySorterBuffer.Insert(); LastAttachmentNo := TempDeliverySorterWord."Attachment No."; LastCorrType := TempDeliverySorterWord."Correspondence Type"; LastSubject := TempDeliverySorterWord.Subject; LastSendWordDocsAsAttmt := TempDeliverySorterWord."Send Word Docs. as Attmt."; FirstRecord := false; until TempDeliverySorterWord.Next() = 0; if TempDeliverySorterBuffer.Find('-') then ExecuteMerge(TempDeliverySorterBuffer); if IsZipArchive() then begin ZipTempBlob.CreateOutStream(ZipOutStream); DataCompression.SaveZipArchive(ZipOutStream); DataCompression.CloseZipArchive(); ZipTempBlob.CreateInStream(ZipInStream); if InteractionLogEntry.Get(TempDeliverySorterWord."No.") then ZipFileName := SegmentLbl + ' ' + InteractionLogEntry."Segment No." + ZipExtensionLbl else ZipFileName := TempDeliverySorterWord.Subject + ZipExtensionLbl; FileManagement.DownloadFromStreamHandler(ZipInStream, '', '', '', ZipFileName); end; WindowDialog.Close(); end; local procedure ExecuteMerge(var TempDeliverySorter: Record "Delivery Sorter" temporary) var Attachment: Record Attachment; InteractionLogEntry: Record "Interaction Log Entry"; TempSegmentLine: Record "Segment Line" temporary; InteractionMergeData: Record "Interaction Merge Data"; WordTemplates: Codeunit "Word Template"; AttachmentWordTemplateFileName: Text; NoOfRecords: Integer; Row: Integer; MailToValue: Text; MergeSourceText: Text; EditDoc: Boolean; DataSource: Dictionary of [Text, Text]; DocumentInStream: InStream; SaveFormat: Enum "Word Templates Save Format"; begin WindowDialog.Update(6, TransferringDataToMergeTxt); if TempDeliverySorter.Find('-') then NoOfRecords := TempDeliverySorter.Count(); Row := 2; if TempDeliverySorter."Word Template Code" <> '' then begin WindowDialog.Update(6, MergingTxt); repeat InteractionLogEntry.Get(TempDeliverySorter."No."); InteractionMergeData.SetRange(ID); InteractionMergeData.Id := CreateGuid(); InteractionMergeData."Contact No." := InteractionLogEntry."Contact No."; InteractionMergeData."Salesperson Code" := InteractionLogEntry."Salesperson Code"; InteractionMergeData."Log Entry Number" := InteractionLogEntry."Entry No."; OnExecuteMergeOnBeforeInteractionMergeDataInsert(InteractionMergeData, InteractionLogEntry); InteractionMergeData.Insert(); MailToValue := GetMailToAddress(InteractionLogEntry, TempDeliverySorter); if TempDeliverySorter."Correspondence Type" = TempDeliverySorter."Correspondence Type"::"Hard Copy" then begin if TempDeliverySorter."Attachment No." > 0 then begin Attachment.Get(TempDeliverySorter."Attachment No."); Attachment.CalcFields("Attachment File"); Attachment."Attachment File".CreateInStream(DocumentInStream); WordTemplates.Load(DocumentInStream, InteractionLogEntry."Word Template Code"); end else WordTemplates.Load(InteractionLogEntry."Word Template Code"); SaveFormat := SaveFormat::PDF; OnExecuteMergeOnBeforeMergeWordTemplates(TempDeliverySorter, InteractionLogEntry, SaveFormat); WordTemplates.Merge(InteractionMergeData, false, SaveFormat); // Only merge, do not edit as the document has been edited. WordTemplates.GetDocument(DocumentInStream); SendMergedDocument(DocumentInStream, TempDeliverySorter, MailToValue, InteractionLogEntry); InteractionMergeData.Delete(); end else begin InteractionMergeData.SetRange(ID, InteractionMergeData.ID); // A filter to current Record is needed EditDoc := TempDeliverySorter."Wizard Action" = Enum::"Interaction Template Wizard Action"::Open; if not InteractionLogEntry.Merged then begin if TempDeliverySorter."Attachment No." > 0 then begin Attachment.Get(TempDeliverySorter."Attachment No."); Attachment.CalcFields("Attachment File"); Attachment."Attachment File".CreateInStream(DocumentInStream); WordTemplates.Load(DocumentInStream, InteractionLogEntry."Word Template Code"); end else WordTemplates.Load(InteractionLogEntry."Word Template Code"); if TempDeliverySorter."Send Word Docs. as Attmt." then WordTemplates.Merge(InteractionMergeData, false, Enum::"Word Templates Save Format"::Docx, EditDoc) // Only one document else WordTemplates.Merge(InteractionMergeData, false, Enum::"Word Templates Save Format"::Html); // Only one document and no edit because Email Editor will open WordTemplates.GetDocument(DocumentInStream); // Should combine PDFs? Attach and see end else begin Attachment.Get(TempDeliverySorter."Attachment No."); Attachment.CalcFields("Attachment File"); Attachment."Attachment File".CreateInStream(DocumentInStream); if not TempDeliverySorter."Send Word Docs. as Attmt." then begin WordTemplates.Load(DocumentInStream); WordTemplates.Merge(InteractionMergeData, false, Enum::"Word Templates Save Format"::Html); WordTemplates.GetDocument(DocumentInStream); end; end; SendMergedDocument(DocumentInStream, TempDeliverySorter, MailToValue, InteractionLogEntry); InteractionMergeData.Delete(); end; Row := Row + 1; WindowDialog.Update(4, Round(Row / NoOfRecords * 10000, 1)); until TempDeliverySorter.Next() = 0; end else begin Attachment.Get(TempDeliverySorter."Attachment No."); Attachment.CalcFields("Attachment File"); TempDeliverySorter.SetCurrentKey("Attachment No.", "Correspondence Type", Subject); TempDeliverySorter.Find('-'); AttachmentWordTemplateFileName := FileManagement.ServerTempFileName('doc'); Attachment.Get(TempDeliverySorter."Attachment No."); Attachment.CalcFields("Attachment File"); if not IsWordDocumentExtension(Attachment."File Extension") then Error(IncorrectExtensionErr, Attachment."No."); if not Attachment.ExportAttachmentToServerFile(AttachmentWordTemplateFileName) then Error(AttachmentFileErr); WindowDialog.Update(6, MergingTxt); Attachment.CalcFields("Merge Source"); if Attachment."Merge Source".HasValue() then repeat InteractionLogEntry.Get(TempDeliverySorter."No."); OnExecuteMergeOnAfterGetInteractLogEntry(InteractionLogEntry); MergeSourceText := GetMergeSourceText(Attachment, TempDeliverySorter."No.", TempDeliverySorter."Correspondence Type".AsInteger()); DataSource := GetDataSource(MergeSourceText); GetMergedDocumentStream(AttachmentWordTemplateFileName, DataSource, TempDeliverySorter, DocumentInStream); SendMergedDocument(DocumentInStream, TempDeliverySorter, '', InteractionLogEntry); Row := Row + 1; WindowDialog.Update(4, Round(Row / NoOfRecords * 10000, 1)) until TempDeliverySorter.Next() = 0 else begin if (TempDeliverySorter.Count > 1) and not IsZipArchive() then EnableZipArchive(); repeat InteractionLogEntry.Get(TempDeliverySorter."No."); MailToValue := GetMailToAddress(InteractionLogEntry, TempDeliverySorter); DataSource := GetDataSource(InteractionLogEntry, TempSegmentLine, MailToValue); GetMergedDocumentStream(AttachmentWordTemplateFileName, DataSource, TempDeliverySorter, DocumentInStream); SendMergedDocument(DocumentInStream, TempDeliverySorter, MailToValue, InteractionLogEntry); Row := Row + 1; WindowDialog.Update(4, Round(Row / NoOfRecords * 10000, 1)) until TempDeliverySorter.Next() = 0; end; FileManagement.DeleteServerFile(AttachmentWordTemplateFileName); end; // Update delivery status on Interaction Log Entry if TempDeliverySorter.Find('-') then begin InteractionLogEntry.LockTable(); repeat InteractionLogEntry.Get(TempDeliverySorter."No."); InteractionLogEntry."Delivery Status" := InteractionLogEntry."Delivery Status"::" "; InteractionLogEntry.Modify(); until TempDeliverySorter.Next() = 0; Commit(); end; end; local procedure GetMailToAddress(var InteractionLogEntry: Record "Interaction Log Entry"; var TempDeliverySorter: Record "Delivery Sorter" temporary) MailToValue: Text begin // Specify the recipient of the merged document case TempDeliverySorter."Correspondence Type" of TempDeliverySorter."Correspondence Type"::Email: MailToValue := AttachmentManagement.InteractionEMail(InteractionLogEntry); TempDeliverySorter."Correspondence Type"::"Hard Copy": MailToValue := ''; end; end; local procedure SendMergedDocument(MergedDocumentInStream: InStream; TempDeliverySorter: Record "Delivery Sorter" temporary; ToAddress: Text; InteractionLogEntry: Record "Interaction Log Entry") var Contact: Record Contact; Attachment: Record Attachment; DocumentMailing: Codeunit "Document-Mailing"; DummyTempBlob: Codeunit "Temp Blob"; HtmlBodyTempBlob: Codeunit "Temp Blob"; DummyInStream: InStream; HtmlBodyOutStream: OutStream; FileName: Text; SaveToFile: Text; SourceTableIDs, SourceRelationTypes : List of [Integer]; SourceIDs: List of [Guid]; HideDialog: Boolean; IsHandled: Boolean; begin IsHandled := false; OnBeforeSendMergedDocument(MergedDocumentInStream, TempDeliverySorter, ToAddress, InteractionLogEntry, IsHandled); if IsHandled then exit; HideDialog := TempDeliverySorter."Force Hide Email Dialog" or (not (TempDeliverySorter."Wizard Action" = TempDeliverySorter."Wizard Action"::Open)); Attachment."Read Only" := true; case TempDeliverySorter."Correspondence Type" of TempDeliverySorter."Correspondence Type"::Email: begin SourceTableIDs.Add(Database::"Interaction Log Entry"); SourceIDs.Add(InteractionLogEntry.SystemId); SourceRelationTypes.Add(Enum::"Email Relation Type"::"Primary Source".AsInteger()); if Contact.Get(InteractionLogEntry."Contact No.") then begin SourceTableIDs.Add(Database::Contact); SourceIDs.Add(Contact.SystemId); SourceRelationTypes.Add(Enum::"Email Relation Type"::"Related Entity".AsInteger()); end; Attachment.SetAttachmentFileFromStream(MergedDocumentInStream); Attachment."Attachment File".CreateInStream(MergedDocumentInStream, TextEncoding::UTF8); if TempDeliverySorter."Send Word Docs. as Attmt." then begin FileName := TempDeliverySorter.Subject; if TempDeliverySorter.Subject = '' then FileName := 'Attachment'; FileName += '.docx'; Attachment."File Extension" := 'docx'; Clear(HtmlBodyTempBlob); DocumentMailing.EmailFile(MergedDocumentInStream, FileName, HtmlBodyTempBlob, TempDeliverySorter.Subject, ToAddress, HideDialog, Enum::"Email Scenario"::"Interaction Template", SourceTableIDs, SourceIDs, SourceRelationTypes); end else begin HtmlBodyTempBlob.CreateOutStream(HtmlBodyOutStream, TextEncoding::UTF8); CopyStream(HtmlBodyOutStream, MergedDocumentInStream); Attachment."File Extension" := 'html'; DummyTempBlob.CreateInStream(DummyInStream); DocumentMailing.EmailFile(DummyInStream, TempDeliverySorter.Subject, HtmlBodyTempBlob, TempDeliverySorter.Subject, ToAddress, HideDialog, Enum::"Email Scenario"::"Interaction Template", SourceTableIDs, SourceIDs, SourceRelationTypes); end; Attachment.Insert(true); InteractionLogEntry."Attachment No." := Attachment."No."; InteractionLogEntry.Modify(); end; TempDeliverySorter."Correspondence Type"::"Hard Copy": begin Attachment."File Extension" := 'pdf'; Attachment.SetAttachmentFileFromStream(MergedDocumentInStream); Attachment."Attachment File".CreateInStream(MergedDocumentInStream, TextEncoding::UTF8); Attachment.Insert(true); InteractionLogEntry."Attachment No." := Attachment."No."; InteractionLogEntry.Modify(); if IsZipArchive() then begin if Contact.Get(InteractionLogEntry."Contact No.") then if (Contact.Type = Contact.Type::Person) and (Contact."Company Name" <> '') then SaveToFile := FileManagement.GetSafeFileName(Contact."Company Name" + ' - ' + Contact.Name) + '.pdf' else SaveToFile := FileManagement.GetSafeFileName(Contact.Name) + '.pdf'; DataCompression.AddEntry(MergedDocumentInStream, SaveToFile); end else begin if TempDeliverySorter.Subject = '' then SaveToFile := 'default.pdf' else SaveToFile := FileManagement.GetSafeFileName(TempDeliverySorter.Subject) + '.pdf'; FileManagement.DownloadFromStreamHandler(MergedDocumentInStream, '', '', '', SaveToFile); end; end; end; end; local procedure GetMergedDocumentStream(AttachmentWordTemplateFileName: Text; DataSource: Dictionary of [Text, Text]; TempDeliverySorter: Record "Delivery Sorter"; var MergedDocumentInStream: InStream) var EditDoc: Boolean; begin EditDoc := (TempDeliverySorter."Wizard Action" = Enum::"Interaction Template Wizard Action"::Open) and (TempDeliverySorter."Word Template Code" <> ''); case TempDeliverySorter."Correspondence Type" of TempDeliverySorter."Correspondence Type"::Email: MergedDocumentInStream := GetMergedDocument(AttachmentWordTemplateFileName, DataSource, Enum::"Word Templates Save Format"::Html, EditDoc); TempDeliverySorter."Correspondence Type"::"Hard Copy": MergedDocumentInStream := GetMergedDocument(AttachmentWordTemplateFileName, DataSource, Enum::"Word Templates Save Format"::PDF, EditDoc); end; end; /// <summary> /// Download a merged Word template for a given segment line and attachment. /// </summary> /// <param name="SegLine">Specifies the segment line for which the attachment is for.</param> /// <param name="Attachment">Specifies the attachemnt (Word template) to be downloaded.</param> procedure RunMergedDocument(var SegLine: Record "Segment Line"; var Attachment: Record Attachment) var TempInteractLogEntry: Record "Interaction Log Entry" temporary; AttachmentWordTemplateFileName: Text; MergedDocFilename: Text; MergeSourceText: Text; DataSource: Dictionary of [Text, Text]; begin if not IsWordDocumentExtension(Attachment."File Extension") then Error(IncorrectExtensionErr, Attachment."No."); AttachmentWordTemplateFileName := FileManagement.ServerTempFileName('doc'); if not Attachment.ExportAttachmentToServerFile(AttachmentWordTemplateFileName) then Error(AttachmentFileErr); Attachment.CalcFields("Merge Source"); if Attachment."Merge Source".HasValue() then begin MergeSourceText := GetMergeSourceText(Attachment, SegLine."Line No.", 0); DataSource := GetDataSource(MergeSourceText); end else DataSource := GetDataSource(TempInteractLogEntry, SegLine, ''); MergedDocFilename := 'Attachment for contact ' + Format(SegLine."Contact No.") + '.pdf'; DownloadFromStream(GetMergedDocument(AttachmentWordTemplateFileName, DataSource, Enum::"Word Templates Save Format"::PDF, false), DownloadAttachmentQst, '', '', MergedDocFilename); FileManagement.DeleteServerFile(AttachmentWordTemplateFileName); end; local procedure GetMergedDocument(AttachmentWordTemplateFileName: Text; DataSource: Dictionary of [Text, Text]; WordTemplatesSaveFormat: Enum "Word Templates Save Format"; EditDoc: Boolean): InStream var WordTemplateFile: File; WordTemplateInStream: InStream; DocumentInStream: InStream; begin WordTemplateFile.Open(AttachmentWordTemplateFileName); WordTemplateFile.CreateInStream(WordTemplateInStream); WordTemplate.Load(WordTemplateInStream); WordTemplateFile.Close(); WordTemplate.Merge(DataSource, WordTemplatesSaveFormat, EditDoc); WordTemplate.GetDocument(DocumentInStream); exit(DocumentInStream); end; /// <summary> /// Checks if the provided file extension is a Word document extension. /// </summary> /// <param name="FileExtension">File extension to check.</param> /// <returns>True if the provided extension is a Word document extension, false otherwise.</returns> procedure IsWordDocumentExtension(FileExtension: Text): Boolean begin exit(LowerCase(FileExtension) in ['doc', 'docx', '.doc', '.docx']); end; local procedure GetMergeSourceText(var Attachment: Record Attachment; EntryNo: Integer; CorrespondenceType: Option ,"Hard Copy",Email,Fax): Text var InteractLogEntry: Record "Interaction Log Entry"; MergeSourceInStream: InStream; CurrentLine: Text; NewLine: Text; LineIsFound: Boolean; HeaderIsReady: Boolean; MergeSourceText: Text; begin Attachment.CalcFields("Merge Source"); Attachment."Merge Source".CreateInStream(MergeSourceInStream); repeat MergeSourceInStream.ReadText(CurrentLine); if (StrPos(CurrentLine, '<tr>') > 0) and HeaderIsReady then begin MergeSourceInStream.ReadText(NewLine); if StrPos(NewLine, Format(EntryNo)) > 0 then begin MergeSourceText += CurrentLine; MergeSourceText += NewLine; LineIsFound := true; end; end; if not HeaderIsReady then begin MergeSourceText += CurrentLine; if StrPos(CurrentLine, '</tr>') > 0 then HeaderIsReady := true end until LineIsFound or MergeSourceInStream.EOS(); if LineIsFound then begin MergeSourceInStream.ReadText(NewLine); while StrPos(NewLine, '</tr>') = 0 do begin CurrentLine := NewLine; MergeSourceInStream.ReadText(NewLine); MergeSourceText += CurrentLine; end; if InteractLogEntry.Get(EntryNo) then case CorrespondenceType of CorrespondenceType::Email: MergeSourceText += '<td>' + AttachmentManagement.InteractionEMail(InteractLogEntry) + '</td>'; CorrespondenceType::"Hard Copy": MergeSourceText += '<td></td>'; end; MergeSourceText += NewLine; end; exit(MergeSourceText); end; local procedure GetDataSource(MergeSourceText: Text): Dictionary of [Text, Text] var AllValues: List of [Text]; DataSource: Dictionary of [Text, Text]; DataSourceKey: Text; DataSourceValue: Text; Iterator: Integer; begin AllValues := GetAllValuesFromHtmlTable(MergeSourceText); if AllValues.Count() mod 2 = 1 then Error(IncorrectMergeSourceErr); for Iterator := 1 to AllValues.Count() / 2 do begin DataSourceKey := AllValues.Get(Iterator); DataSourceValue := AllValues.Get(AllValues.Count() / 2 + Iterator); DataSource.Add(DataSourceKey, DataSourceValue); end; exit(DataSource); end; local procedure GetAllValuesFromHtmlTable(HtmlText: Text): List of [Text] var TempMatches: Record Matches temporary; TempGroups: Record Groups temporary; Regex: Codeunit Regex; TableCellPattern: Text; AllCellValues: List of [Text]; begin TableCellPattern := '<td>((.|[\n\r])*?)<\/td>'; Regex.Match(HtmlText, TableCellPattern, TempMatches); repeat Regex.Groups(TempMatches, TempGroups); TempGroups.Get(1); // Group 1 AllCellValues.Add(TempGroups.ReadValue()); until TempMatches.Next() = 0; exit(AllCellValues); end; local procedure GetDataSource(var InteractLogEntry: Record "Interaction Log Entry"; var SegLine: Record "Segment Line"; FaxMailToValue: Text): Dictionary of [Text, Text] var Salesperson: Record "Salesperson/Purchaser"; Country: Record "Country/Region"; Country2: Record "Country/Region"; Contact: Record Contact; CompanyInfo: Record "Company Information"; RMSetup: Record "Marketing Setup"; InteractionLogEntry: Record "Interaction Log Entry"; Language: Codeunit Language; MainLanguage: Integer; DataSource: Dictionary of [Text, Text]; ContactAltAddressCode: Code[10]; LineNo: Text; SalesPersonCode: Code[20]; ContactNo: Code[20]; LanguageCode: Code[10]; ActiveDate: Date; IsHandled: Boolean; begin InitMergeFields(InteractLogEntry, SegLine, ContactAltAddressCode, LineNo, SalesPersonCode, ContactNo, LanguageCode, ActiveDate); MainLanguage := GlobalLanguage; if LanguageCode = '' then begin RMSetup.Get(); if RMSetup."Mergefield Language ID" <> 0 then GlobalLanguage := RMSetup."Mergefield Language ID"; end else GlobalLanguage := Language.GetLanguageIdOrDefault(LanguageCode); CompanyInfo.Get(); if not Country2.Get(CompanyInfo."Country/Region Code") then Clear(Country2); Contact.Get(ContactNo); if not Country.Get(Contact."Country/Region Code") then Clear(Country); if not Salesperson.Get(SalesPersonCode) then Clear(Salesperson); IsHandled := false; OnGetDataSourceOnBeforeAddDataSources(DataSource, InteractionLogEntry, Contact, Salesperson, Country, LineNo, ContactAltAddressCode, LanguageCode, ActiveDate, IsHandled); if not IsHandled then begin DataSource.Add(InteractionLogEntry.FieldCaption("Entry No."), LineNo); DataSource.Add(Contact.TableCaption + MailAddressTxt, GetContactAltAddresses(Contact, ContactAltAddressCode, ActiveDate)); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("No."), Contact."No."); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Company Name"), Contact."Company Name"); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption(Name), Contact.Name); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Name 2"), Contact."Name 2"); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption(Address), Contact.Address); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Address 2"), Contact."Address 2"); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Post Code"), Contact."Post Code"); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption(City), Contact.City); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption(County), Contact.County); DataSource.Add(Contact.TableCaption + ' ' + Country.TableCaption + ' ' + Country.FieldCaption(Name), Country.Name); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Job Title"), Contact."Job Title"); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Phone No."), Contact."Phone No."); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Fax No."), Contact."Fax No."); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("E-Mail"), Contact."E-Mail"); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Mobile Phone No."), Contact."Mobile Phone No."); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("VAT Registration No."), Contact."VAT Registration No."); DataSource.Add(Contact.TableCaption + ' ' + Contact.FieldCaption("Home Page"), Contact."Home Page"); DataSource.Add(FormalSalutationTxt, Contact.GetSalutation("Salutation Formula Salutation Type"::Formal, LanguageCode)); DataSource.Add(InformalSalutationTxt, Contact.GetSalutation("Salutation Formula Salutation Type"::Informal, LanguageCode)); DataSource.Add(Salesperson.TableCaption + ' ' + Salesperson.FieldCaption(Code), Salesperson.Code); DataSource.Add(Salesperson.TableCaption + ' ' + Salesperson.FieldCaption(Name), Salesperson.Name); DataSource.Add(Salesperson.TableCaption + ' ' + Salesperson.FieldCaption("Job Title"), Salesperson."Job Title"); DataSource.Add(Salesperson.TableCaption + ' ' + Salesperson.FieldCaption("Phone No."), Salesperson."Phone No."); DataSource.Add(Salesperson.TableCaption + ' ' + Salesperson.FieldCaption("E-Mail"), Salesperson."E-Mail"); end; if InteractLogEntry.IsEmpty() then begin DataSource.Add(DocumentTxt + SegLine.FieldCaption(Date), Format(SegLine.Date)); DataSource.Add(DocumentTxt + SegLine.FieldCaption("Campaign No."), SegLine."Campaign No."); DataSource.Add(DocumentTxt + SegLine.FieldCaption("Segment No."), SegLine."Segment No."); DataSource.Add(DocumentTxt + SegLine.FieldCaption(Description), SegLine.Description); DataSource.Add(DocumentTxt + SegLine.FieldCaption(Subject), SegLine.Subject); end else begin DataSource.Add(DocumentTxt + SegLine.FieldCaption(Date), Format(InteractLogEntry.Date)); DataSource.Add(DocumentTxt + SegLine.FieldCaption("Campaign No."), InteractLogEntry."Campaign No."); DataSource.Add(DocumentTxt + SegLine.FieldCaption("Segment No."), InteractLogEntry."Segment No."); DataSource.Add(DocumentTxt + SegLine.FieldCaption(Description), InteractLogEntry.Description); DataSource.Add(DocumentTxt + SegLine.FieldCaption(Subject), InteractLogEntry.Subject); end; DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption(Name), CompanyInfo.Name); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Name 2"), CompanyInfo."Name 2"); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption(Address), CompanyInfo.Address); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Address 2"), CompanyInfo."Address 2"); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Post Code"), CompanyInfo."Post Code"); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption(City), CompanyInfo.City); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption(County), CompanyInfo.County); DataSource.Add(CompanyInfo.TableCaption + ' ' + Country.TableCaption + ' ' + Country.FieldCaption(Name), Country2.Name); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("VAT Registration No."), CompanyInfo."VAT Registration No."); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Registration No."), CompanyInfo."Registration No."); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Phone No."), CompanyInfo."Phone No."); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Fax No."), CompanyInfo."Fax No."); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Bank Branch No."), CompanyInfo."Bank Branch No."); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Bank Name"), CompanyInfo."Bank Name"); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Bank Account No."), CompanyInfo."Bank Account No."); DataSource.Add(CompanyInfo.TableCaption + ' ' + CompanyInfo.FieldCaption("Giro No."), CompanyInfo."Giro No."); DataSource.Add(FaxMailToTxt, FaxMailToValue); OnGetDataSourceOnBeforeRestoreGlobalLanguage(DataSource, InteractLogEntry, SegLine); GlobalLanguage := MainLanguage; exit(DataSource); end; local procedure InitMergeFields(var InteractionLogEntry: Record "Interaction Log Entry"; var SegmentLine: Record "Segment Line"; var ContactAltAddressCode: Code[10]; var LineNo: Text; var SalesPersonCode: Code[20]; var ContactNo: Code[20]; var LanguageCode: Code[10]; var ActiveDate: Date) begin if InteractionLogEntry.IsEmpty() then begin ContactNo := SegmentLine."Contact No."; SalesPersonCode := SegmentLine."Salesperson Code"; LineNo := Format(SegmentLine."Line No."); ContactAltAddressCode := SegmentLine."Contact Alt. Address Code"; LanguageCode := SegmentLine."Language Code"; ActiveDate := SegmentLine.Date; end else begin ContactNo := InteractionLogEntry."Contact No."; SalesPersonCode := InteractionLogEntry."Salesperson Code"; LineNo := Format(InteractionLogEntry."Entry No."); ContactAltAddressCode := InteractionLogEntry."Contact Alt. Address Code"; LanguageCode := InteractionLogEntry."Interaction Language Code"; ActiveDate := InteractionLogEntry.Date; end; end; local procedure GetContactAltAddresses(Contact: Record Contact; ContactAltAddressCode: Code[10]; Date: Date): Text var FormatAddr: Codeunit "Format Address"; TypeHelper: Codeunit "Type Helper"; ContactAddresses: array[8] of Text[100]; Iterator: Integer; Addresses: Text; begin FormatAddr.ContactAddrAlt(ContactAddresses, Contact, ContactAltAddressCode, Date); for Iterator := 1 to 8 do if ContactAddresses[Iterator] <> '' then Addresses += ContactAddresses[Iterator] + TypeHelper.NewLine(); exit(Addresses.TrimEnd(TypeHelper.NewLine())); end; local procedure IsZipArchive(): Boolean begin exit(ZipArchive) end; local procedure EnableZipArchive(); begin ZipArchive := true; DataCompression.CreateZipArchive(); end; [IntegrationEvent(false, false)] internal procedure OnBeforeCreateInteractionWordTemplate(var WordTemplateCreationWizard: Page "Word Template Creation Wizard") begin end; var FileManagement: Codeunit "File Management"; WordTemplate: Codeunit "Word Template"; AttachmentManagement: Codeunit AttachmentManagement; DataCompression: Codeunit "Data Compression"; ZipArchive: Boolean; WindowDialog: Dialog; IncorrectExtensionErr: Label 'Attachment %1 must have file extension doc or docx.', Comment = '%1 = Attachment No.'; AttachmentFileErr: Label 'Could not get attachment content.'; FaxMailToTxt: Label 'FaxMailTo'; MailAddressTxt: Label ' Mail Address'; DocumentTxt: Label 'Document '; FormalSalutationTxt: Label 'Formal Salutation'; InformalSalutationTxt: Label 'Informal Salutation'; IncorrectMergeSourceErr: Label 'Incorrect content of the Merge Source'; MergingInWordTxt: Label 'Merging Microsoft Word Documents...\\'; PreparingTxt: Label 'Preparing'; ProgramStatusTxt: Label 'Program status'; PreparingMergeTxt: Label 'Preparing Merge...'; TransferringDataToMergeTxt: Label 'Transferring data to merge...'; MergingTxt: Label 'Merging...'; DownloadAttachmentQst: Label 'Download merged attachment?'; SegmentLbl: Label 'Segment'; ZipExtensionLbl: Label '.zip'; [IntegrationEvent(false, false)] local procedure OnGetDataSourceOnBeforeRestoreGlobalLanguage(var DataSource: Dictionary of [Text, Text]; var InteractLogEntry: Record "Interaction Log Entry"; var SegLine: Record "Segment Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSendMergedDocument(MergedDocumentInStream: InStream; TempDeliverySorter: Record "Delivery Sorter"; ToAddress: Text; InteractionLogEntry: Record "Interaction Log Entry"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnExecuteMergeOnBeforeMergeWordTemplates(TempDeliverySorter: Record "Delivery Sorter" temporary; InteractLogEntry: Record "Interaction Log Entry"; var SaveFormat: Enum "Word Templates Save Format") begin end; [IntegrationEvent(false, false)] local procedure OnExecuteMergeOnAfterGetInteractLogEntry(InteractionLogEntry: Record "Interaction Log Entry") begin end; [IntegrationEvent(false, false)] local procedure OnGetDataSourceOnBeforeAddDataSources(var DataSource: Dictionary of [Text, Text]; var InteractionLogEntry: Record "Interaction Log Entry"; var Contact: Record Contact; var SalespersonPurchaser: Record "Salesperson/Purchaser"; var CountryRegion: Record "Country/Region"; LineNo: Text; ContactAltAddressCode: Code[10]; LanguageCode: Code[10]; ActiveDate: Date; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnExecuteMergeOnBeforeInteractionMergeDataInsert(var InteractionMergeData: Record "Interaction Merge Data"; var InteractionLogEntry: Record "Interaction Log Entry") begin end;}