I am trying to open a document in MS Word desktop (like the online version of viewing MS Word can). This is possible by applying a prefix to the document URL on MS Teams. My code in the page already works good:

var docUrl = await request.$context.PDS_UsrColumn1_u8ye1ig;
const wordUrl = `ms-word:ofe|u|${encodeURIComponent(docUrl)}`;

But using the wordUrl variable on a Webinput field, or even a button.click event doing a window.location.ref always results in Creatio still encoding the Url. Creatio always adds the console message:

Launched external handler for 'ms-word:ofe%7Cu%7Chttps%3A%2F%2Fcompany.sharepoint.com%2F%yadayadayada

where it should be ms-word:ofe|u|https://

Does someone know how to bypass the encoding for a specific handler or for this page?

Like 0

Like

6 comments

Can you share the complete handler code and explain how have you disabled the "To protect you from unsafe content office has blocked opening this file" error message?

Sure, here is the handler. It already opens MS Word, but because of the safe url encoding it won't open the correct document... 

handlers: /**SCHEMA_HANDLERS*/[
            {
                request: "usr.PushButtonRequest",
                /* Implementation of the custom query handler. */
                handler: async (request, next) => {
                    this.console.log("Button Open in MS Word pushed...");
                     var docUrl = await request.$context.PDS_UsrColumn1_u8ye1ig;
                      const wordUrl = `ms-word:ofe|u|${encodeURIComponent(docUrl)}`;

                    // scenario 1: use window.location.href
                    //window.location.href = wordUrl;

                    // scenario 2: use the online found solutioon to add a link with a click
                    const link = document.createElement('a');
                    link.href = wordUrl;
                    link.target = '_blank';
                    link.rel = 'noopener noreferrer';
                    document.body.appendChild(link);
                    link.click();
                    document.body.removeChild(link);
                    
                    this.console.log("MS Word Url set to: " + wordUrl);
                    /* Call the next handler if it exists and return its result. */
                    return next?.handle(request);
                }
            },
        ]/**SCHEMA_HANDLERS*/,

Bas Kroes,

well I get the same URL in both cases (using a regular text field and the web link input) and in both scenarios I get this popup:

Maybe I am testing in the wrong manner?

Oleg Drobina,

It looks like it is a browser issue. I am using Ms Edge. What are you using?

Bas Kroes,

I am testing in Chrome, but I get the same error in Edge.

That's odd indeed using the same code 🤔

But your url did not get unwanted modified?

Show all comments

Hi ,

 

I have installed 64 bit ms word plugin for creatio. In order to connect i am using the same password and user name which is reflected in the account but still it says log in incorrect.

Any inputs on this would be really helpful.

 

Thankyou

Like 0

Like

1 comments

Hello, 

Please note, that logging into Word Plugin with 2-factor authentication turned on is disabled for now, so please make sure it's turned off. Also make sure if the appropriate plugin version has been installed, verify if your System type is in compliance with plugin version 64 bit. 


Instruction for proper installation is available with this link: https://academy.creatio.com/docs/8.x/no-code-customization/customization-tools/print-ready-reports/install-creatio-plug-in-for-ms-word

Also use this insttuction to disactivate 2-FA, go to point 3 and instead of enabling it, please disactivate it: https://academy.creatio.com/docs/8.x/setup-and-administration/administration/user-and-access-management/authentication/set-up-two-factor-authentication

Thank you !

 

Show all comments

In the word report that I have created I want to use the characters  Â« someWords here... ». By default creatio uses these characters to indicate a field name but in my case I have to use these characters on my document as normal characters.

I am using a formula in MS word that makes a sentence appear in my word report only if a specific field is not equal to 0

  • Here is the place I have written the formula that contains special characters (which are not indicating any field name)

 

  • The formula I used: 

Contract Clauses No[#AddTextIfNotEqual|0;words... « someWords here between these chars...  » words again... :#]

 

  • The result I get when report is printed:

words… \« someWords here between the special chars \» words again

 

As you can see Creatio reads these chars (« ») as special chars and adds slashes (\) before them. All I want to do is make these chars appear without the slashes before them.

 

Thanks in advance :)

 

Like 0

Like

1 comments

Hello,

As for now, unfortunately, there is no possibility to use word formulas in compose with printables and our R&D team has a problem regarding this functionality and we hope that it will be updated in one of future versions of the application. 

 

As for now you can try using this marketplace application that can fit your needs https://marketplace.bpmonline.com/app/excel-reports-builder-bpmonline.

Show all comments

I am creating a report in creatio using MSWord plugin.

The report contains a main table that is connected to a detail (ParentTable).

Inside the row of ParentTable i have placed another table with specific filters (ChildTable1).

 

Example:

------------------------------

Row 1 - Text 1

      - Child Table 1 content

------------------------------

Row 2 - Text 2

      - Child Table 2 content

------------------------------

Row 3 - Text 3

      - Child Table 3 content

 

I have checked "Hide the table if it contains no data" for the child table.

When i try to download the report the whole table is hided because one of the ChildTables inside one row had no data.

Does Creatio Word Plugin offer this fetaure (To add report tables inside report tables)? 

Like 1

Like

1 comments

Hello,



I have discussed your case with the responsible R&D team. Unfortunately, as of now, there is no possibility to implement your business task and we do have the correspondent problem registered on our side. The R&D team is currently working on implementing this new functionality in one of the future releases of the application.



Thank you for helping us to make our application better.

Show all comments

Loggin in with the the Word plugin (https://academy.bpmonline.com/documents/administration/7-13/setting-tem…) is not as responsive as I believe it should be.

When I provide the login details when connecting my bpm'online plugin to my environment I do not get any information about wether the login was successful or not. In fact I can provide incorrect password information and the plugin still looks as if I am logged in, using correct details.

 

Pic 1. Invalid login information

 

Pic 2. Looks as If I am logged on anyway.

Is this normal or is my Word plugin not working?

2 comments

Hello!

We have registered the following suggestion for our R&D team and they will consider this enhancement for the upcoming releases.

Best regards,

Matt

We fixed this behavior in new plugin for Creatio 7.16.2

Show all comments

Hi all,

I have followed the instructions on your academy to install MS Word plugin but it doesn't appear in Word.

I tried to re-install it but it didn't help. Please advise

Thanks,

Cathie

File attachments

Like

1 comments

Hello,

If any error occurs during the installation or the plug-in does not appear in MS Word, then it’s likely that the path in the windows registry was incorrect. To solve this issue, you need to execute the file (in the attachment) on the PC where you install the plug-in. register_ms_word.rar

After that repeat the installation of the plug-in from the file of the .msi format (with the Windows Installer package type).

While following these steps, MS Word should be closed.

Please also check that the bpm’online add-in in Word is active. To do this, in MS Word go to "File" -> "Options" -> "Add-ins".

If the plugin is in inactive, then change it to active as in the screenshot below.

Best regards,

Lily

Show all comments