Read xml file and convert it to aem page

[#1]

Hi all,

I have a requirement where I need to read xml file and convert it to aem page. Is there a way to do it?

Regards,

[rk39193348 · Accepted solution]

Hi,

Please check below link 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-read-xml-file-from-...

[rk39193348 · Accepted solution]

Thanks for your reply. The article mentioned by you stores xml in JCR, which I have achieved, how can I convert it to html page?

[rk39193348 · Accepted solution]

Thanks for your reply. The link mentioned by you stores xml into JCR that i have achieved. How to Convert it to HTML?

[Ravi_Pampana · Accepted solution]

You can read the values stored in the jcr and using pageManager API, we can create page and add values in as required.

First it will be helpful if you come up with the mapping of fields and where/how it should stored under the page. Some of them will go to jcr:content and some go to a component. 

Once the mapping is done and you have required template and components created, programmatically we can add components under jcr:content and the values from xml file.  

Refer : https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-can-i-create-new-cq-pa... for creating pagesprogrammatically

[rk39193348 · Accepted solution]

Thanks. I have gone through the link provided, this line is giving depricated resolver = resolverFactory.getAdministrativeResourceResolver(null);. How do I replace this line?

[Manjunathh · Accepted solution]

Hi @rk39193348 

Check below code snippet to get service resource resolver & create service user with required permission for the same.

@Reference
private ResourceResolverFactory resourceResolverFactory;

private static final String SERVICE_USER = "service-user"; //create new service user with required permission
private static final Map<String, Object> SERVICE_USER_DETAILS = ImmutableMap
        .of(ResourceResolverFactory.SUBSERVICE, (Object) SERVICE_USER);

private static final Logger LOGGER = LoggerFactory.getLogger(ReplicationServlet.class);

@Override
protected void doGet(SlingHttpServletRequest request, SlingHttpServletResponse response) throws IOException {
    
    if(resourceResolverFactory!= null) {
        try (ResourceResolver resourceResolver = resourceResolverFactory.getServiceResourceResolver(SERVICE_USER_DETAILS)) {
            if (resourceResolver != null) {

            }
        } catch (LoginException e) {
            LOGGER.error("LoginException occurred", e);
        }
    }
}

[rk39193348 · Accepted solution]

Thanks for your reply. I am still getting null using the above code.

[Manjunathh · Accepted solution]

@rk39193348

Have you created service user? if not please create service user & pass subServiceName in place of  "service-user" as mentioned below.

private static final String SERVICE_USER = "service-user"; //pass subServiceName given to the service which is created with required permission.

https://docs.adobe.com/content/help/en/experience-manager-learn/forms/adaptive-forms/service-user-tu...

[rk39193348 · Accepted solution]

I have added service_user, Still it is null.

[#11]

@rk39193348,

Here's how I would do it.

1. Upload the XML into AEM. The XML should either be a section of your website (including with all it's children)
2. Create an OSGI service or servlet, Java Backend, to execute the migration logic. (somehow referencing to the XML file)
3. Implement the migration logic with the Uber Jar AEM libraries such as the PageManager API or the JCR API to clone/create page and edit pages... of course you will need to parse the XML.

[rk39193348]

@rk39193348 

There are two options available.

1. Import XML data by scheduler, store it in UGC & use that data on the page based on your requirement.

2. Say storing it in UGC not required, then you can skip saving it in UGC & create page whenever scheduler runs using the xml data.

refer this blog to import & store xml data in UGC.

https://aem.redquark.org/2019/05/import-xml-data-into-aem.html

[rk39193348]

Thanks for your reply. The article mentioned by you stores xml in jcr, which I have achieved, how can I convert it to html page?

[Manjunathh]

Hi @rk39193348 

Can you add screenshot/code snippet where you are getting service resource resolver null, it will be helpful to find out the issue.

[rk39193348]

 @reference
private ResourceResolverFactory resourceResolverFactory;

private static final String SERVICE_USER = "service-user"; //create new service user with required permission
private static final Map<String, Object> SERVICE_USER_DETAILS = ImmutableMap
.of(ResourceResolverFactory.SUBSERVICE, (Object) SERVICE_USER);

public String createPage(String pageName) {
log.info("inside createpage****");
try {
ResourceResolver resourceResolver =resourceResolverFactory.getServiceResourceResolver(SERVICE_USER_DETAILS);
//ResourceResolver resourceResolver = slingrequest.getResourceResolver();
log.info("resourceResolver****"+resourceResolver.toString());
}

catch (Exception ex) {
log.info("AEMWatchFolderImpl error$$" + ex.getMessage());
}
return pageName;
}

using resourceResolver I am trying to create a page, but I am getting null. Can you please help?

pageManager = resourceResolver.adaptTo(PageManager.class);

newPage = pageManager.create(pagePath, pageName, templatePath, pageTitle);

[Manjunathh]

@rk39193348 

Can you please highlight the line in above code where you are getting null.

[rk39193348]

I did this - newPage = getPageManager().create(pagePath, "ABC", templatePath, pageTitle); without using resourceResolver it worked.

Now how do I add HTML into it, programmatically?

[Manjunathh]

@rk39193348 

Assuming as per you comment you are getting null here getPageManager().create(). once we get service resource resolver possibility of getting null return value from this method is less because this method returns page if provide parameters are valid & in some cases throws below error. so please cross check after this method execution whether page is created below this pagePath/rootPath.

Path not found exception : when provide pagePath not exist. (/content/site/root-page)

Access denied : when service user does not have create permission at this pagePath/rootPath. 

newPage = getPageManager().create(pagePath, "ABC", templatePath, pageTitle); 

[rk39193348]

Now how do I add html dynamically and programmatically to the page?

[rk39193348]

Hi @rk39193348 ,

First we need to write OSGI service to read data and persist key value properties in CRX repo using JCR API's and once the XML data is available in JCR node properties, we can access and display it on any page.

Regards,

Santosh

[rk39193348]

Thanks for your reply. I want to convert xml to page, how can that be achieved?

[rk39193348]

Can you please share sample code?

[santhosh_kumark]

Hope this would helpful. https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/auotmate-the-process-of-im...