LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: edith

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
Attachments:
BREProblemReport3.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

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.
Attachments:
feedEntryExample.brg