Adobe Experience Manager Sites & More

prabuj201987 · 2/26/18

Hi,

In AEM, how to read a xml file from file system and store the content as jcr:data into sling:folder node using Java?

Any sample or tutorial available, kindly help.

smacdonald2008 · 3/1/18

Here is the HELPX article that was created based on this thread -- Scott's Digital Community: Creating a Custom Watched Folder Service for Adobe Experience Manager 6.3

View solution in original post

smacdonald2008 · 2/26/18

This would be done via a custom service. You can read a file on the desktop using File API. THen you can use the JCR API to create a node under a folder - which is just a JCR location- and then write the content to the node prop using JCR API logic.

To learn how to use JCR API to write data to a node prop - see this -- Scott's Digital Community: Programmatically Accessing Adobe CQ Content using the JCR API

smacdonald2008 · 2/26/18

I will write sample JCR Java code that shows this. I will post back.

smacdonald2008 · 2/26/18

Here is sample JCR Node API code that writes a file to the AEM JCR:

//Save the uploaded file into the specified client lib path

private String writeToClientLib(InputStream is, String fileName, String path, String mimetype)

{

try

{

//Invoke the adaptTo method to create a Session

ResourceResolver resourceResolver = resolverFactory.getAdministrativeResourceResolver(null);

session = resourceResolver.adaptTo(Session.class);

Node node = session.getNode(path); //Get the client lib node in which to write the posted file

javax.jcr.ValueFactory valueFactory = session.getValueFactory();

javax.jcr.Binary contentValue = valueFactory.createBinary(is);

Node fileNode = node.addNode(fileName, "nt:file");

fileNode.addMixin("mix:referenceable");

Node resNode = fileNode.addNode("jcr:content", "nt:resource");

resNode.setProperty("jcr:mimeType", mimetype);

resNode.setProperty("jcr:data", contentValue);

Calendar lastModified = Calendar.getInstance();

lastModified.setTimeInMillis(lastModified.getTimeInMillis());

resNode.setProperty("jcr:lastModified", lastModified);

session.save();

session.logout();

// Return the path to the document that was stored in CRX.

return fileNode.getPath();

}

smacdonald2008 · 2/26/18

This works - just programmatically uploaded XML.

prabuj201987 · 2/26/18

Hi , Thanks a lot smacdonald2008. So kind of you.!!

prabuj201987 · 2/27/18

hi smacdonald2008,

One more thing, how to schedule the below code as job say every 5 minutes in AEM?

smacdonald2008 · 2/27/18

Like any use case where you want to fire off in given time increments - you can write a scheduler service using AEM APIs. We have an older HELPX article that will point you in the right direction -- Adobe Experience Manager Help | Scheduling Adobe Experience Manager Jobs using Apache Sling

prabuj201987 · 2/28/18

Hi smacdonald2008

Could you please share the complete code?

smacdonald2008 · 2/28/18

I will add this use case to the AEM HELPX Article list!

smacdonald2008 · 2/28/18

This is a neat concept - kind of a concept of building a local Watched Folder. You would drop an XML file into the watched folder and AEM will pick it up even so often - based on the scheduler.

smacdonald2008 · 2/28/18

We will have a HELPX artilce that shows this end to end in a few days!

smacdonald2008 · 2/28/18

My AEM Scheduler Service is grabbing the XML file from the Watched Folder every min and putting it into the JCR Repo--

prabuj201987 · 2/28/18

Thanks smacdonald2008 .

Is this based on AEM workbench process?

Also we need to store the xml file in sling:folder (not nt:folder) as jcr:data (binary), as this is the expected format by the prefill osgi service that we have deployed already. This xml will be read in adaptive form through prefill service

smacdonald2008 · 2/28/18

Its an AEM OSGi service written in Java.. Then anothet AEM scheduler service invokes the custom service that reads the XML file and places it within the JCR.