Hi all, here's an interesting one, in my xml imported if I use very simple xpath like this
<field column="property_update_date" xpath="/document/property_update_date" dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss" locale="en"/> I will get the date properly imported, however if I use this expression for another node which is nested: <field column="audience_customers_release_date" xpath="/document/audiences/audience/audience_release_date[../audience_name='Customers']" dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss" locale="en"/> I will receive this type of exception: java.text.ParseException: Unparseable date: "Tue Aug 16 20:10:23 EDT 2011" I have t use the Xpath above as I have a few of those release date nodes and I need to flatten them so we can look at dates per audience/group I've also run just this /document/audiences/audience/audience_release_date and it works, however I need a more precise result then that since different groups could have different release dates. Any help greatly appreciated, Radek. Radoslaw Zajkowski Senior Developer O° proximity CANADA t: 416-972-1505 ext.7306 c: 647-281-2567 f: 416-944-7886 2011 ADCC Interactive Agency of the Year 2011 Strategy Magazine Digital Agency of the Year http://www.proximityworld.com/ Join us on: Facebook - http://www.facebook.com/ProximityCanada Twitter - http://twitter.com/ProximityWW YouTube - http://www.youtube.com/proximitycanada Please consider the environment before printing this e-mail. This message and any attachments contain information, which may be confidential or privileged. If you are not the intended recipient, please refrain from any disclosure, copying, distribution or use of this information. Please be aware that such actions are prohibited. If you have received this transmission in error, kindly notify us by e-mail to mailto:helpd...@bbdo.com. We appreciate your cooperation.
