Acumatica Add Wiki's to Customization

Question

We have added several Wiki Articles to the Acumatica and now trying to add them to Customization Project to be able to setup them on another System. The problem is that when we add Wiki's Page ID( they all are in the HelpRoot_User) it add all the Wiki Pages and Zip's size is becoming 40 MB. When we tried to import that Customization Zip to another System we got`

File exceeds maximum allowed size (25000 KB).

Has anybody done Wiki's export to Customization?
How can I do this?

When you say it added all the wiki pages... are you saying it included all standard wiki pages (not just the wikis you need)? We do package wikis. I will need to review are setup before I can help to answer. — Brendan
I would say that is your root problem as you could agree. You should only need to package the wiki's you created. We created a new wiki not attached to any other standard wiki. Let me find out the details and post as an answer. — Brendan
added answer. In summary the articles should be self contained into a main wiki. The main wiki is selected in the customization project. Because there is no way to exclude specific articles from the customization project (without possibly editing the project.xml) I would say this is your best solution. — Brendan

Brendan Brendan · Accepted Answer · 2017-06-15T18:32:11

Here is what we did to include our wiki in a package. The idea here is to create a new wiki and include all articles under the new custom wiki. When selecting in the customization you will select the new custom wiki. In My Example I called this "HelpCustom"

Create a new wiki in CONFIGURATION > DOCUMENT MANAGEMENT > MANAGE > WIKI We added the wiki to the main horizontal bar in the help section. You can define where your wiki lives by selecting the location in 'Site Map Location'.
Find your article in the location you picked in the site map location and add any articles you need.
In your customization project, under Wikis, click Add (+) and select the Wiki created from step 1.

Now the problem you have is how do you transfer the articles to the new wiki so you don't have to redo them. I did a quick test to move an article that was created in a different wiki and here is what I did.

Find the main wiki record in wikipage that you created in step 1 above.

SELECT *
FROM dbo.WikiPage
WHERE [CompanyID] = 2
      AND [Name] = 'HelpCustom';

Use the PageID value from the result above as the WikiID and ParentUID in your articles. If you need the articles nested then you will have to adjust the ParentUID to fit (or leave the value as is depending on the row not being at the root of the wiki article tree). I would assume you only need to change the ParentUID value for the top level articles. Otherwise just update WikiID for all articles that need to move.

Here is the script I executed. I could not tell if I needed to update the [Number] column value or not.

UPDATE dbo.WikiPage
SET [ParentUID] = 'F1BF807E-4B0E-414C-B90B-83944AC66D8C', /*Use PageID from parent*/
    [WikiID] = 'F1BF807E-4B0E-414C-B90B-83944AC66D8C'     /*Use PageID from main wiki*/
WHERE [CompanyID] = 2
      AND [Name] = 'TESTDEV1'; /*article name*/

I had to restart/refresh my site to see the article move to my new wiki.

Hope this gives you some direction.

Acumatica Add Wiki's to Customization

3 Answers