topic Migrating XML content in Alfresco Archive

Migrating XML content

gidion — Sat, 04 Aug 2007 17:39:46 GMT

Hi,In the website i am creating (using alfrescos wcm) i have created a number of xsd web forms that capture various content typesrofileadvice pageetc.When viewing the content produced from completing one of these forms (which are saved as xml content) I get xml code.My problem is.When i convert a

Re: Migrating XML content

gidion — Sat, 04 Aug 2007 17:44:40 GMT

To note:

here is the view of the manually created form xml.

<?xml version="1.0" encoding="UTF-8" ?>
<prress_release xmlnsr="http://www.alfresco.org/alfresco/pr" xmlns:alf="http://www.alfresco.org" xmlns:chiba="http://chiba.sourceforge.net/xforms" xmlns:ev="http://www.w3.org/2001/xml-events" xmlns:xf="http://www.w3.org/2002/xforms" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<pr:title>test for saturday</pr:title>
<pr:body>test test sat</pr:body>
<pr:keywords>saturday test</pr:keywords>
</prress_release>

here is what i loaded via the "create" >> "add content" upload link:

<?xml version="1.0" encoding="UTF-8" ?>
<prress_release xmlnsr="http://www.alfresco.org/alfresco/pr" xmlns:alf="http://www.alfresco.org" xmlns:chiba="http://chiba.sourceforge.net/xforms" xmlns:ev="http://www.w3.org/2001/xml-events" xmlns:xf="http://www.w3.org/2002/xforms" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<pr:title>test for friday</pr:title>
<pr:body>test test fri</pr:body>
<pr:keywords>friday test</pr:keywords>
</prress_release>

as you can see. Both are the same, just the content of the xml has changed.

Re: Migrating XML content

mark_smithson — Sun, 05 Aug 2007 16:13:21 GMT

Hi gidion

Alfresco are working on this… The xml files need to be associated with the web form in the meta data.

In the meantime, I have written a web script which associates all the xml files in a folder with a particular web form. The code below should get you going, it may need some adjustment for your environment ..

script: {
   var sandbox = args.sb;
   var form = args.form;
   var path = url.extension;
   var storeRoot = avm.lookupStore(sandbox);
   var folder = storeRoot.lookupNode("ROOT/" + path);
   var files = folder.children;
   var updated = new Array();

   for (var i=0; i<files.length;i++){
      var file = files;
      if (file.isDocument && file.properties.content.mimetype == "text/xml"){
         // add aspect to associate the xml file with its form
         if (!hasAspect(file.aspects, "{http://www.alfresco.org/model/wcmappmodel/1.0}forminstancedata")){
            var props = new Array(2);
            props["{http://www.alfresco.org/model/wcmappmodel/1.0}parentformname"] = form;
            props["{http://www.alfresco.org/model/wcmappmodel/1.0}originalparentpath"] = file.parentPath;
            file.addAspect("{http://www.alfresco.org/model/wcmappmodel/1.0}forminstancedata", props);
            updated[updated.length] = file;
         }
      }
   }

   model.folder = folder;
   model.updated = updated;
}

function hasAspect(aspects, aspect){
   if (aspects.length == undefined){
      aspects = aspects.toArray();
   }
   for (var i=0; i< aspects.length; i++){
      if (aspects == aspect){
         return true;
      }
   }
   return false;
}

Re: Migrating XML content

gidion — Mon, 06 Aug 2007 09:54:31 GMT

Hi Mark,

Thanks for that.

Sorry to ask for yet more info but I am unsure of how we get javascript files to run against a space or content item.
I can see how rules are added to spaces outside of the wcm but not within it.

Any help would be great.

Thanks,
Luke

Re: Migrating XML content

mark_smithson — Mon, 06 Aug 2007 09:57:46 GMT

Hi Gidion,

I created a web script and then just call that using a web browser. I have not found a way to do it automatically.

There is some info on creating web scripts in the wiki and also in the Web Scripts space in the Data Dictionary on your Alfresco install.

Re: Migrating XML content

gidion — Tue, 07 Aug 2007 11:11:14 GMT

Ok, thanks again mark. That at least saves our content controllers having to play with xml code.

I believe the feature i spoke of above is present in 2.1.0E.

Just a shame I am using the community version.

Re: Migrating XML content

mark_smithson — Tue, 07 Aug 2007 17:51:21 GMT

me ot at the moment, but that may be changing …

Re: Migrating XML content

jeyush — Wed, 09 Jan 2008 13:27:25 GMT

Hey mark ,thank you very much to put that script .

but i have some que for you.i hope u reply me.

your code:

script: {
var sandbox = args.sb;
var form = args.form;
var path = url.extension;
var storeRoot = avm.lookupStore(sandbox);
var folder = storeRoot.lookupNode("ROOT/" + path);
var files = folder.children;
var updated = new Array();

for (var i=0; i<files.length;i++){
var file = files[i];
if (file.isDocument && file.properties.content.mimetype == "text/xml"){
// add aspect to associate the xml file with its form
if (!hasAspect(file.aspects, "{http://www.alfresco.org/model/wcmappmodel/1.0}forminstancedata")){
var props = new Array(2);
props["{http://www.alfresco.org/model/wcmappmodel/1.0}parentformname"] = form;
props["{http://www.alfresco.org/model/wcmappmodel/1.0}originalparentpath"] = file.parentPath;
file.addAspect("{http://www.alfresco.org/model/wcmappmodel/1.0}forminstancedata", props);
updated[updated.length] = file;
}
}
}

model.folder = folder;
model.updated = updated;
}

function hasAspect(aspects, aspect){
if (aspects.length == undefined){
aspects = aspects.toArray();
}
for (var i=0; i< aspects.length; i++){
if (aspects[i] == aspect){
return true;
}
}
return false;
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Que
[size=150]1)if i dont pass the argument from url so what i supposed to write in this line

var storeRoot = avm.lookupStore(sandbox);
what(path) i write in lookupStore instead of sandbox?
2)in this lines,if i dont pass arg from url then what should i write, instead of path?
var path = url.extension;
var folder = storeRoot.lookupNode("ROOT/" + path);[/size]

if you have any suggestion then pls rep-ly me.
thx in advance.
bye

Re: Migrating XML content

kvc — Thu, 10 Jan 2008 10:20:22 GMT

Hey everyone -

Mark, that looks like a great customization. Do you mind opening a JIRA feature request, and attaching your code? That may help us expedite adding this to the core.

Also, please note that if you have an imported XML that is not generated via a Web Form, when you click EDIT and are prompted to download, there is a link on that very same page that allows you to associate it with an existing Web Form. If you click on that link, you get to pick from a list of all Web Forms associated with your current Web Project. You do have to select the correct one. If you do, the XML will open in the form, and upon a subsequent save, the appropriate property will be set.

This does mean that the association happens on a file-by-file basis. Ideally, we'd have a general action you can run against your entire site to auto-associate any and all XMLs to remove this additional bootstrap effort currently required by your individual content authors.

Kevin

Re: Migrating XML content

dooley — Wed, 13 Feb 2008 23:14:47 GMT

Quick question, can you give me an example of what value you are passing in for sandbox

Re: Migrating XML content

tommorris — Thu, 14 Feb 2008 12:40:35 GMT

Dooley, I think this would be the name of one of the folders that you'd see in the root of the AVM mount.

For example, if you you've created a web-project with the DNS name 'myproject', then when you browse (using CIFS/FTP etc) you'd see the folders:

myproject
myproject–tmorris
myproject–otheruser

The first is the staging sandbox, the second is my personal sandbox.

So, to get to 'media' folder (for example) within the staging sandbox:

var storeRoot = avm.lookupStore("myproject");
var folder = storeRoot.lookupNode("ROOT/media");

Tom
http://www.ixxus.com

Re: Migrating XML content

dooley — Thu, 14 Feb 2008 16:36:36 GMT

Thanks for the reply. Another question, were receiving a NPE when we try to view the file we just updated in the webform. Here is the stack trace tomcat throws:


10:29:23,562 ERROR [xml.xforms.Container] dispatch: exception during event flow
org.chiba.xml.xforms.exception.XFormsException: java.lang.NullPointerException
        at org.chiba.xml.xforms.Container.dispatch(Container.java:503)
        at org.chiba.xml.xforms.Container.dispatch(Container.java:459)
        at org.chiba.xml.xforms.Container.initModels(Container.java:701)
        at org.chiba.xml.xforms.Container.init(Container.java:325)
        at org.chiba.xml.xforms.ChibaBean.init(ChibaBean.java:410)
        at org.alfresco.web.forms.xforms.XFormsBean.setXFormsSession(XFormsBean.java:270)
        at org.alfresco.web.forms.xforms.XFormsProcessor.process(XFormsProcessor.java:140)
        at org.alfresco.web.forms.xforms.XFormsProcessor.process(XFormsProcessor.java:121)
        at org.alfresco.web.ui.wcm.component.UIFormProcessor.encodeBegin(UIFormProcessor.java:123)
        at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
        at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
        at org.apache.jsp.jsp.wcm.create_002dweb_002dcontent_002dwizard.create_002dxml_jsp._jspx_meth_wcm_005fformProcessor_005f0(create_002dxml_jsp.java:97)
        at org.apache.jsp.jsp.wcm.create_002dweb_002dcontent_002dwizard.create_002dxml_jsp._jspService(create_002dxml_jsp.java:70)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at org.apache.jsp.jsp.wizard.container_jsp._jspService(container_jsp.java:524)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:419)
        at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
        at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)
        at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
        at org.chiba.xml.xforms.ui.Upload.initializeUpload(Upload.java:182)
        at org.chiba.xml.xforms.ui.Upload.init(Upload.java:169)
        at org.chiba.xml.xforms.Initializer.initializeUIElements(Initializer.java:288)
        at org.chiba.xml.xforms.ui.AbstractUIElement.initializeChildren(AbstractUIElement.java:220)
        at org.chiba.xml.xforms.ui.Group.init(Group.java:142)
        at org.chiba.xml.xforms.Initializer.initializeUIElements(Initializer.java:288)
        at org.chiba.xml.xforms.Initializer.initializeUIElements(Initializer.java:299)
        at org.chiba.xml.xforms.Initializer.initializeUIElements(Initializer.java:254)
        at org.chiba.xml.xforms.core.Model.modelConstructDone(Model.java:889)
        at org.chiba.xml.xforms.core.Model.performDefault(Model.java:750)
        at org.chiba.xml.events.impl.DefaultXMLEventService.dispatch(DefaultXMLEventService.java:286)
        at org.chiba.xml.xforms.Container.dispatch(Container.java:481)
        … 59 more
10:29:23,562 ERROR [forms.xforms.XFormsProcessor] org.chiba.xml.xforms.exception.XFormsException: java.lang.NullPointerException
10:29:23,562 ERROR [ui.common.Utils] org.chiba.xml.xforms.exception.XFormsException: java.lang.NullPointerException
org.alfresco.web.forms.FormProcessor$ProcessingException: org.chiba.xml.xforms.exception.XFormsException: java.lang.NullPointerException
        at org.alfresco.web.forms.xforms.XFormsProcessor.process(XFormsProcessor.java:150)
        at org.alfresco.web.forms.xforms.XFormsProcessor.process(XFormsProcessor.java:121)
        at org.alfresco.web.ui.wcm.component.UIFormProcessor.encodeBegin(UIFormProcessor.java:123)
        at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
        at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
        at org.apache.jsp.jsp.wcm.create_002dweb_002dcontent_002dwizard.create_002dxml_jsp._jspx_meth_wcm_005fformProcessor_005f0(create_002dxml_jsp.java:97)
        at org.apache.jsp.jsp.wcm.create_002dweb_002dcontent_002dwizard.create_002dxml_jsp._jspService(create_002dxml_jsp.java:70)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at org.apache.jsp.jsp.wizard.container_jsp._jspService(container_jsp.java:524)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:419)
        at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
        at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)
        at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.chiba.xml.xforms.exception.XFormsException: java.lang.NullPointerException
        at org.chiba.xml.xforms.Container.dispatch(Container.java:503)
        at org.chiba.xml.xforms.Container.dispatch(Container.java:459)
        at org.chiba.xml.xforms.Container.initModels(Container.java:701)
        at org.chiba.xml.xforms.Container.init(Container.java:325)
        at org.chiba.xml.xforms.ChibaBean.init(ChibaBean.java:410)
        at org.alfresco.web.forms.xforms.XFormsBean.setXFormsSession(XFormsBean.java:270)
        at org.alfresco.web.forms.xforms.XFormsProcessor.process(XFormsProcessor.java:140)
        … 53 more
Caused by: java.lang.NullPointerException
        at org.chiba.xml.xforms.ui.Upload.initializeUpload(Upload.java:182)
        at org.chiba.xml.xforms.ui.Upload.init(Upload.java:169)
        at org.chiba.xml.xforms.Initializer.initializeUIElements(Initializer.java:288)
        at org.chiba.xml.xforms.ui.AbstractUIElement.initializeChildren(AbstractUIElement.java:220)
        at org.chiba.xml.xforms.ui.Group.init(Group.java:142)
        at org.chiba.xml.xforms.Initializer.initializeUIElements(Initializer.java:288)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any idea on what could be going wrong?

Thanks