Results 1 to 2 of 2

Thread: Tabular XML File returning Error: Compiling the node.

  1. #1

    Default Tabular XML File returning Error: Compiling the node.

    Any ideas ?

    My file looks like the following and
    <feed xml:base="https://team.collaborate.tsl.telus.com/sites/CSsmbA/ba/_vti_bin/ListData.svc/" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom">
    <title type="text">DDCP</title>
    <id>https://team.collaborate.tsl.telus.com/sites/CSsmbA/ba/_vti_bin/ListData.svc/DDCP/</id>
    <updated>2013-11-05T20:12:55Z</updated>
    <link rel="self" title="DDCP" href="DDCP" />
    <entry m:etag="W/&quot;1&quot;">
    <id>https://team.collaborate.tsl.telus.com/sites/CSsmbA/ba/_vti_bin/ListData.svc/DDCP(1)</id>
    <title type="text"></title>
    <updated>2013-11-01T18:31:56-06:00</updated>
    <author>
    <name />
    </author>
    <link rel="edit" title="DDCPItem" href="DDCP(1)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy" type="application/atom+xml;type=entry" title="CreatedBy" href="DDCP(1)/CreatedBy" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="DDCP(1)/ModifiedBy" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Cause" type="application/atom+xml;type=entry" title="Cause" href="DDCP(1)/Cause" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Attachments" type="application/atom+xml;type=feed" title="Attachments" href="DDCP(1)/Attachments" />
    <category term="Microsoft.SharePoint.DataService.DDCPItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <content type="application/xml">
    <m:properties>
    <d:ContentTypeID>0x0100C51040D7EF387C49A17DAFCB96E 49BC0</d:ContentTypeID>
    <d:Title m:null="true" />
    <d:Order_Number>TESTORder</d:Order_Number>
    <d:FinalDueDate m:type="Edm.DateTime">2013-09-09T00:00:00</d:FinalDueDate>
    <d:OriginalDueDate m:type="Edm.DateTime">2013-09-09T00:00:00</d:OriginalDueDate>
    <d:WFMCallID>1223466</d:WFMCallID>
    <d:CreatedById m:type="Edm.Int32">61</d:CreatedById>
    <d:ModifiedById m:type="Edm.Int32">61</d:ModifiedById>
    <d:FirstPassCCMDDM m:type="Edm.Boolean">true</d:FirstPassCCMDDM>
    <d:NewDueDate m:type="Edm.DateTime">2013-10-01T00:00:00</d:NewDueDate>
    <d:CauseValue>Customer WIP</d:CauseValue>
    <d:TechActualCompletedDate m:type="Edm.DateTime">2013-10-01T00:00:00</d:TechActualCompletedDate>
    <d:Notes>Testing</d:Notes>
    <d:Id m:type="Edm.Int32">1</d:Id>
    <d:ContentType>Item</d:ContentType>
    <d:Modified m:type="Edm.DateTime">2013-11-01T18:31:56</d:Modified>
    <d:Created m:type="Edm.DateTime">2013-11-01T18:31:56</d:Created>
    <d:Owshiddenversion m:type="Edm.Int32">1</d:Owshiddenversion>
    <d:Version>1.0</d:Version>
    <d:Path>/sites/CSsmbA/ba/Lists/DDCP</d:Path>
    </m:properties>
    </content>
    </entry>
    <entry m:etag="W/&quot;1&quot;">
    <id>https://team.collaborate.tsl.telus.com/sites/CSsmbA/ba/_vti_bin/ListData.svc/DDCP(2)</id>
    <title type="text"></title>
    <updated>2013-11-01T18:39:55-06:00</updated>
    <author>
    <name />
    </author>
    <link rel="edit" title="DDCPItem" href="DDCP(2)" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CreatedBy" type="application/atom+xml;type=entry" title="CreatedBy" href="DDCP(2)/CreatedBy" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="DDCP(2)/ModifiedBy" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Cause" type="application/atom+xml;type=entry" title="Cause" href="DDCP(2)/Cause" />
    <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Attachments" type="application/atom+xml;type=feed" title="Attachments" href="DDCP(2)/Attachments" />
    <category term="Microsoft.SharePoint.DataService.DDCPItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
    <content type="application/xml">
    <m:properties>
    <d:ContentTypeID>0x0100C51040D7EF387C49A17DAFCB96E 49BC0</d:ContentTypeID>
    <d:Title m:null="true" />
    <d:Order_Number>TELUS Order 2</d:Order_Number>
    <d:FinalDueDate m:type="Edm.DateTime">2013-09-01T00:00:00</d:FinalDueDate>
    <d:OriginalDueDate m:type="Edm.DateTime">2013-09-01T00:00:00</d:OriginalDueDate>
    <d:WFMCallID>2293848585868</d:WFMCallID>
    <d:CreatedById m:type="Edm.Int32">61</d:CreatedById>
    <d:ModifiedById m:type="Edm.Int32">61</d:ModifiedById>
    <d:FirstPassCCMDDM m:type="Edm.Boolean">false</d:FirstPassCCMDDM>
    <d:NewDueDate m:type="Edm.DateTime" m:null="true" />
    <d:CauseValue>Customer WIP</d:CauseValue>
    <d:TechActualCompletedDate m:type="Edm.DateTime">2013-10-30T00:00:00</d:TechActualCompletedDate>
    <d:Notes m:null="true" />
    <d:Id m:type="Edm.Int32">2</d:Id>
    <d:ContentType>Item</d:ContentType>
    <d:Modified m:type="Edm.DateTime">2013-11-01T18:39:55</d:Modified>
    <d:Created m:type="Edm.DateTime">2013-11-01T18:39:55</d:Created>
    <d:Owshiddenversion m:type="Edm.Int32">1</d:Owshiddenversion>
    <d:Version>1.0</d:Version>
    <d:Path>/sites/CSsmbA/ba/Lists/DDCP</d:Path>
    </m:properties>
    </content>
    </entry>
    </feed>


    And just put in the following in XML node,

    node:Tabular_XML_File
    bretype:lal1::Tabular XML File
    editor:sortkey=5279837f17e012d0
    output:@4ff6f823382e2d4b/=
    prop:FieldNameXPath=/feed/entry/content/properties/*
    prop:File=/data/nsa-analytics/output/SMB/DDCP_load.xlm
    prop:FileParamType=Literal
    prop:RecordXPath=/feed/entry
    editor:XY=500,380
    end:Tabular_XML_File
    Attached Files Attached Files

  2. #2
    Lavastorm Employee
    Join Date
    Aug 2009
    Location
    Cologne
    Posts
    513

    Default

    Hi,

    Sorry for the delay in responding.

    This looks like a potential incompatibility between the version of LAL installed on the client and the server.
    One thing to check is that the same versions are installed on both client and server.
    If you are using a Lavastorm Desktop installation, then perhaps reinstalling LAL will help - as it looks like it is missing the jar files that get shipped with the LAL install required by the Tabular XML node..


    In addition, we've just released a new version of LAL (2.16) with a new node XML Data used for processing complex XML data with little to no configuration.

    This should make acquiring such formats much easier.

    I've attached an example of this node designed to read the data you have posted above.

    In the first example "All", the node will simply output all data in the input XML.
    In the second example, "Content Properties", it will output all data under the "feed/entry/content/properties" path.

    Hope this helps,
    Tim.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •