I’m using the PSOBatchImporter from the community marketing solution. It was originally setup many moons ago for importing an external RSS feed, unfortunately the business that provided that feed went out of business, so we never did complete this importer.
Now I’m trying to get it running again on a different rss feed but I’m having a little difficulty. The import is shown as successful but nothing is actually created in Rhythmyx. In the log file for the import I see the following types of entries:
[java] DEBUG [FeedParser] - executing field import_uri expression: $item.Uri;
[java] DEBUG [FeedParser] - Jexl Expression returned null
[java] DEBUG [FeedParser] - executing field import_source_url expression: $item.Link;
[java] DEBUG [FeedParser] - Jexl Expression returned null
[java] DEBUG [FeedParser] - executing field sys_lang expression: ‘en-ca’;
[java] DEBUG [FeedParser] - Setting field sys_lang to value en-ca
[java] DEBUG [FeedParser] - executing field sys_title expression: $item.Title;
[java] DEBUG [FeedParser] - Jexl Expression returned null
This is the RSS feed sample:
<?xml version="1.0" encoding="utf-8" ?>
<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss/" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<item>
<Uri>1234</Uri>
<Link>http://www.google.ca</Link>
<Title>Application of Computer-Assisted Audit Techniques, second edition</Title>
<PublishedDate>1999-Jun-15</PublishedDate>
<Keywords>IFRS, Test</Keywords>
<Description>
Designed to assist internal and external auditors of both large and small enterprises, as well as to CFOs, CIOs and other executives and their staff who can benefit from the use of computer-assisted audit techniques (CAATs) in their work, to perform more effective and efficient risk assessment, certification, and compliance audits.
</Description>
<Category>Accounting and Assurance</Category>
<SubCategory>Accounting</SubCategory>
<ImgURL>http://www.castore.ca//ContentImages/kStore/Covers/638.gif</ImgURL>
</item>
<item>
<Uri>5678</Uri>
<Link>http://www.google.ca</Link>
<Title>Application of Computer-Assisted Audit Techniques, second edition</Title>
<PublishedDate>1999-Jun-15</PublishedDate>
<Keywords>IFRS, Test</Keywords>
<Description>
Designed to assist internal and external auditors of both large and small enterprises, as well as to CFOs, CIOs and other executives and their staff who can benefit from the use of computer-assisted audit techniques (CAATs) in their work, to perform more effective and efficient risk assessment, certification, and compliance audits.
</Description>
<Category>Accounting and Assurance</Category>
<SubCategory>Accounting</SubCategory>
<ImgURL>http://www.castore.ca//ContentImages/kStore/Covers/638.gif</ImgURL>
</item>
</channel>
</rss>
And this is the mapping in the spring.xml for the importer:
<property name="fieldMap">
<map>
<entry key="import_uri">
<value>$item.Uri;</value>
</entry>
<entry key="import_source_url">
<value>$item.Link;</value>
</entry>
<entry key="sys_lang">
<value>'en-ca';</value>
</entry>
<entry key="sys_title">
<value>$item.Title;</value>
</entry>
<entry key="displaytitle">
<value>$item.Title;</value>
</entry>
<entry key="sys_contentstartdate">
<value>$item.PublishedDate;</value>
</entry>
<entry key="sys_contentexpirydate">
<value>$now=$tools.date.getCalendar();$weekday=$now.get(7); $days = ( 7 - $weekday ) + 1;$now.add(6,$days.intValue());$tools.date.format('yyyy-MM-dd',$now.getTime());</value>
</entry>
<entry key="keywords">
<value>$item.Keywords;</value>
</entry>
<entry key="description">
<value>$item.Description;</value>
</entry>
<entry key="category">
<value>$item.Category;</value>
</entry>
<entry key="subcategory">
<value>$item.SubCategory;</value>
</entry>
<entry key="imgURL">
<value>$item.ImgURL;</value>
</entry>
<entry key="teaser">
<value>$item.Description;</value>
</entry>
</map>
</property>
Does anyone have any thoughts on this?
Shane