Welcome!

You will be redirected in 30 seconds or close now.

ColdFusion Authors: Yakov Fain, Jeremy Geelan, Maureen O'Gara, Nancy Y. Nee, Tad Anderson

Related Topics: ColdFusion

ColdFusion: Article

Using Syndicated Content in Spectra

Using Syndicated Content in Spectra

Managing and displaying content stored in the Spectra object store will be a major feature of any Spectra project. Content will come from a variety of places: self-service applications, system-generated messages and objects, and externally provided articles and data from a variety of content providers. The latter is called "syndicated content." This article demonstrates how one might automate the insertion of syndicated content from an outside news service.

Getting Started
There are two methods of getting syndicated content in Allaire Spectra: the hard way...and the easy way. The easy way is to transfer content over HTTP from one Spectra machine to another using the Syndication features of the COAPI (Content Object API) (see Figure 1, Scenario 3). This content syndication process gets a terrific write-up in chapter 14, "Syndication and Remote Access," of the Programming with Allaire Spectra manual.

Alternatively, content vendors wouldn't need their own Spectra servers, but would simply package the data in an XML format, WDDX, that Spectra understands (Figure 1, Scenario 2). Allaire will soon begin to promote WDDX, as implemented by the COAPI, for this purpose. Spectra users and content providers can also use XSL transformation engines to normalize XML data before or after syndication. Allaire may soon bundle Granularity Information Architecture's GIAXT XSL transformation engine (www.granularity.com) to provide such translation services.

In the meantime we'll need to process newsfeeds ourselves and programmatically funnel them into the object store through the COAPI (Figure 1, Scenario 1). It's not elegant, but it's easy to implement and works quite well.p> If you want real-time news from a variety of sources and you want it fast, one of the best places to start is Screaming Media (www.screamingmedia.net). Screaming Media is a nice solution because they aggregate content from hundreds of traditional and nontraditional sources, provide data in a consistent format, allow you to pay only for what you use and don't require impression-based royalties. For $2,500 up-front and $500/month (and up), Screaming Media will send piping-hot, filtered news to a proprietary Java component, Siteware, that sits on your server. Reuters, Wavo and iSyndicate provide a similar service and each has its own proprietary or third-party syndication components.

Installing the Siteware component first requires installing the Java 1.1.8 Run-time Environment (JRE) from http://java.sun.com. You then unzip some files and add a "siteware.bat" shortcut (on NT) to the start-up (C:\WINNT\Profiles\All Users\Start Menu\Programs\Startup) directory. This file includes the JDBC:OBDC driver that Siteware uses to communicate with MS SQL Server. Make sure you install this in the default directory.

When you order news from Screaming Media, you specify filters describing the type of news you want, industry segments, keywords and so forth. Each filter becomes a feed that has its own configuration files specifying field delimiter characters, escape character policies, headers and footers. Siteware "wakes up" every 15 minutes and pulls your feeds off the Screaming Media servers. It then processes the feeds in one of four ways as Hclient, DBClient, fClient or pClient.

If you're running MS SQL server or have access to a JDBC driver for your favorite database, using the DBClient database insertion method is a no-brainer (tell Screaming Media this is how you want Siteware set up). The Hclient method is quite interesting since it will write content into templates using variable substitution. Once we build our Screaming Media News object type, we could create a sample object and use it as a prototype template for use with this method. Since databases are more flexible than flat files, I've chosen to use DBClient for my own installation. fClient and pClient can also write out delimited text files but you need to parse them and process them yourself - no fun.

To store Screaming Media content temporarily, you'll need to create a table in your SQL database with the columns listed in Table 1.

I've set up a DSN in the ODBC administrator called "SyndicatedContent" that points to my "SyndicatedContent" database and defaults to the "ScreamingContent" table.

If you're getting sports scores from Screaming Media, you'll need to add additional fields to your ScreamingContent table or create a new table ("ScreamingSportsContent," perhaps!). For more information on sports scores, contact Screaming Media directly.

Screaming Media's technical staff will edit Siteware's configuration files to match the DSN and table names you've created. Extract the *.zip file they send you and run siteware.bat (located in the IMDSJServer/bin directory) from the command prompt. When you see two "SUCCESS" prompts and a blinking cursor beneath, Siteware has initialized successfully and has begun dumping content into your database. Look into your database table and you'll see the stories that meet your filter criteria.

The next step is moving the content from the syndication table into Spectra. The first thing we need to do is create a ScreamingNews object type that defines how the data will be stored in the Spectra database. This requires some "data modeling" in the Webtop. After logging in under the admin account, go to System Design > Site Object Designer > Property Definitions and create the properties in Table 2.

I've added the bCleaned property to those in the database as a flag to denote whether the default text has been reviewed to clean up any formatting inconsistencies from the feed. I also added properties that allow me to bind photographs to ScreamingNews objects. You can license photos from several places on the Internet including Reuters and the Associated Press. Spectra ships with a "core" system object type IMAGE (70E7DFB6-A67E-11D2-B3AC00C04FA35A23) that you can define as an embedded property in any object type. We'll embed an IMAGE property into the news article as well as provide a vertical alignment control variable and useimage flag.

Once the properties are created, you can actually create the object type itself (you must follow this sequence). Go to the Type Designer, create a new object type called "ScreamingNews" and map in the property definitions as indicated. Then add the method handlers given in Table 3.

Note that we didn't include "create", "edit" and "delete" methods as they are implicit and use the default handlers. If you write any of them yourself, write the edit handler - the default is quite ugly. There's no special "create" or "delete" functionality required, so there's no need to declare these methods and write your own handlers. Beware of the embedded image object - implementing embedded objects in handlers is an "advanced" skill.

This is public news, so there aren't any permissions on this object type. Applying permissions in Spectra slow down the application considerably - less so for object types than for objects themselves. Caching permissions in the CF administrator is virtually essential.

The last step in getting the data into the object store is to build the handler, syndicate_import.cfm, that manages the process (see Listing 1). This handler is nothing more than a simple query against your syndicated content database, and a loop that copies the data into the Spectra object store and then updates the foreign key in the syndicated content database. It then calls a cleanup routine to mark articles older than 30 days as "inactive" and "archived" since it's illegal for you to keep them around. Note that we've created but not coded syndicate_push and syndicate_pull. These method handlers are used at a later time to manage syndication directly between Spectra servers in the organization or with partners (you'll need to discuss licensing with Screaming Media, of course).

You can test the handler in Listing 1 by calling it from a dummy page with the following code:

<cfa_contentobject
datasource="#request.cfa.objectstore.dsn#"
objectid="Put a test object ID in here"
method="syndicate_import"
bsecure="No"
babortonunauthorizedaccess="No"
blogging="No"
busecache="No"
>

The syndication stream invoker (which we'll call next) doesn't care that syndicate_import doesn't require an ObjectID; however, CFA_ContentObject does care so we need to provide a dummy ObjectID in our testing code.

Once you see that this handler is working properly, you need to set up a schedule in Webtop to call it every few minutes. In System Design > Programming Objects > Syndication Streams you can easily add an event to run the syndicate_import method every 15 minutes or at whatever polling interval you've established in Siteware (see Figure 2).

While Screaming Media does channel its content providers' various feed formats into the fields listed above, providers format their stories differently so it's strongly suggested that you edit each article within Spectra prior to posting it on your site. You can see the results of your hard work in the Webtop object finder (see Figure 3).

Sample handler code and the content object types I created above are available in their entirety on the CFDJ Web site and may be installed all at once using the Spectra object type package install function. You'll also want to check the Allaire Tag Gallery and/or the Screaming Media Web site for the latest code as Screaming Media, along with other content providers, has become increasingly interested in the Spectra platform as a turnkey content subscriber and publishing solution.

Conclusion and Next Steps
In this article I've described some of the "heavy lifting" you'll need to perform to get syndicated content into your Spectra object store. Since object type definitions and properly coded handlers are reusable, you won't need to start from scratch; use and modify the source code provided here at your discretion.

It won't be long before syndicated content providers are cognizant of the huge installed base of Spectra servers. When that occurs, they may give you the ability to pull content directly into your Spectra servers by providing it over HTTP in the appropriate format. When this happens, you'll download and install an object type definition file from the content provider and set up a syndication stream handler that polls their database every so often for your content. Alternatively, they could push content directly to Spectra through the remote method invoker interface after you provide them with the appropriate username and password, your IP address and any other default values you care about (e.g., don't publish this article until I see it first!). In these scenarios you may use a syndicate_pull or syndicate_push method handler rather than the kludgy but functional syndicate_import routine provided here.

As a premium service, content providers may also map their metadata keywords to ones you provide, actually marking up the content with metadata before sending it over. They might even write Spectra news-viewer applications that use the content object types they provide. What better way to get you started with their content fast!

Syndicating graphics is going to be a bit more difficult, but easier with ColdFusion 4.5's new facilities for Base 64 encoding. For now, write or use default handlers that bind your downloaded graphics separately to articles you've syndicated and are ready to publish.

In the next article we'll explore how the Spectra syndication API allows transparent syndication of content and applications between Spectra servers.

More Stories By Anthony Krinsky

Anthony Krinsky is an intranet and extranet
application developer with Interactive Documents (www.interactivedocuments.com).

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
As businesses adopt functionalities in cloud computing, it’s imperative that IT operations consistently ensure cloud systems work correctly – all of the time, and to their best capabilities. In his session at @BigDataExpo, Bernd Harzog, CEO and founder of OpsDataStore, will present an industry answer to the common question, “Are you running IT operations as efficiently and as cost effectively as you need to?” He will expound on the industry issues he frequently came up against as an analyst, and...
Your homes and cars can be automated and self-serviced. Why can't your storage? From simply asking questions to analyze and troubleshoot your infrastructure, to provisioning storage with snapshots, recovery and replication, your wildest sci-fi dream has come true. In his session at @DevOpsSummit at 20th Cloud Expo, Dan Florea, Director of Product Management at Tintri, will provide a ChatOps demo where you can talk to your storage and manage it from anywhere, through Slack and similar services ...
SYS-CON Events announced today that HTBase will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. HTBase (Gartner 2016 Cool Vendor) delivers a Composable IT infrastructure solution architected for agility and increased efficiency. It turns compute, storage, and fabric into fluid pools of resources that are easily composed and re-composed to meet each application’s needs. With HTBase, companies can quickly prov...
SYS-CON Events announced today that Linux Academy, the foremost online Linux and cloud training platform and community, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Linux Academy was founded on the belief that providing high-quality, in-depth training should be available at an affordable price. Industry leaders in quality training, provided services, and student certification passes, its goal is to c...
SYS-CON Events announced today that SoftLayer, an IBM Company, has been named “Gold Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York, New York. SoftLayer, an IBM Company, provides cloud infrastructure as a service from a growing number of data centers and network points of presence around the world. SoftLayer’s customers range from Web startups to global enterprises.
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), will provide an overview of various initiatives to certifiy the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldw...
SYS-CON Events announced today that Technologic Systems Inc., an embedded systems solutions company, will exhibit at SYS-CON's @ThingsExpo, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Technologic Systems is an embedded systems company with headquarters in Fountain Hills, Arizona. They have been in business for 32 years, helping more than 8,000 OEM customers and building over a hundred COTS products that have never been discontinued. Technologic Systems’ pr...
SYS-CON Events announced today that Auditwerx will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Auditwerx specializes in SOC 1, SOC 2, and SOC 3 attestation services throughout the U.S. and Canada. As a division of Carr, Riggs & Ingram (CRI), one of the top 20 largest CPA firms nationally, you can expect the resources, skills, and experience of a much larger firm combined with the accessibility and attent...
SYS-CON Events announced today that CA Technologies has been named “Platinum Sponsor” of SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY, and the 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business – from apparel to energy – is being rewritten by software. From ...
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend @CloudExpo | @ThingsExpo, June 6-8, 2017, at the Javits Center in New York City, NY and October 31 - November 2, 2017, Santa Clara Convention Center, CA. Learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
SYS-CON Events announced today that Loom Systems will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Founded in 2015, Loom Systems delivers an advanced AI solution to predict and prevent problems in the digital business. Loom stands alone in the industry as an AI analysis platform requiring no prior math knowledge from operators, leveraging the existing staff to succeed in the digital era. With offices in S...
SYS-CON Events announced today that T-Mobile will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. As America's Un-carrier, T-Mobile US, Inc., is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The Company's advanced nationwide 4G LTE network delivers outstanding wireless experiences to 67.4 million customers who are unwilling to compromise on ...
SYS-CON Events announced today that Infranics will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Since 2000, Infranics has developed SysMaster Suite, which is required for the stable and efficient management of ICT infrastructure. The ICT management solution developed and provided by Infranics continues to add intelligence to the ICT infrastructure through the IMC (Infra Management Cycle) based on mathemat...
SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 20th Cloud Expo, which will take place on June 6-8, 2017 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 add...
SYS-CON Events announced today that Cloudistics, an on-premises cloud computing company, has been named “Bronze Sponsor” of SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Cloudistics delivers a complete public cloud experience with composable on-premises infrastructures to medium and large enterprises. Its software-defined technology natively converges network, storage, compute, virtualization, and management into a ...
SYS-CON Events announced today that SD Times | BZ Media has been named “Media Sponsor” of SYS-CON's 20th International Cloud Expo, which will take place on June 6–8, 2017, at the Javits Center in New York City, NY. BZ Media LLC is a high-tech media company that produces technical conferences and expositions, and publishes a magazine, newsletters and websites in the software development, SharePoint, mobile development and commercial UAV markets.
"I think that everyone recognizes that for IoT to really realize its full potential and value that it is about creating ecosystems and marketplaces and that no single vendor is able to support what is required," explained Esmeralda Swartz, VP, Marketing Enterprise and Cloud at Ericsson, in this SYS-CON.tv interview at @ThingsExpo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Why do your mobile transformations need to happen today? Mobile is the strategy that enterprise transformation centers on to drive customer engagement. In his general session at @ThingsExpo, Roger Woods, Director, Mobile Product & Strategy – Adobe Marketing Cloud, covered key IoT and mobile trends that are forcing mobile transformation, key components of a solid mobile strategy and explored how brands are effectively driving mobile change throughout the enterprise.
My team embarked on building a data lake for our sales and marketing data to better understand customer journeys. This required building a hybrid data pipeline to connect our cloud CRM with the new Hadoop Data Lake. One challenge is that IT was not in a position to provide support until we proved value and marketing did not have the experience, so we embarked on the journey ourselves within the product marketing team for our line of business within Progress. In his session at @BigDataExpo, Sum...
Keeping pace with advancements in software delivery processes and tooling is taxing even for the most proficient organizations. Point tools, platforms, open source and the increasing adoption of private and public cloud services requires strong engineering rigor - all in the face of developer demands to use the tools of choice. As Agile has settled in as a mainstream practice, now DevOps has emerged as the next wave to improve software delivery speed and output. To make DevOps work, organization...