Per popular request I am revisiting this article. I made some edits and also now you can download the the demo file.
Someone sent an email to our FileMaker group to request information about importing RSS feed into FileMaker. Since I have done this and it’s actually quite easy, I thought I’d post the method here.
Ingredients
FileMaker (8.5 or later because you need Web Viewer);
A FileMaker database ;
An XSLT style sheet; (I found this style sheet somewhere some time ago; didn’t write it myself)
A web host where you can post the XSLT file;
An RSS feed that actually works with this (e.g. Yahoo Stocks: http://rss.news.yahoo.com/rss/stocks);
A script that pulls the info (which now can be run on server if you have FMS 9 or 10);
A table in your DB for storing the RSS feeds;
A portal on your layout that shows the list of RSS feeds;
A web viewer in your database that can display the resulted web page;
A script that tells the web viewer to show the requested article.
Directions
Create a new table called ‘RSS_Feed’ in your solution (since this only works in FM 8.5 and later, there’s no need for a separate file). Create the following fields: ID, Title, Description, Link, PubDate, SelectedLink;
Link the new table to your preferred table (Global, Solution, etc.) by showing all records (’x’ symbol);
Create a new layout in your solution, place a portal on it showing the records from the RSS Feed table (link and description fields, minimum). Place a web viewer next to it. Name your web viewer object “article”;
Create a script similar to this example to refresh the feed (you can run this script from a button on your layout or at certain intervals from the server):
Go to Layout [ “Layout Name” (Table Name) ]
Enter Browse Mode
Show All Records
Delete All Records
[ No dialog ]
Import Records [ XML (from http): http://rss.news.yahoo.com/rss/stocks; XSL (from http): http://www.website.com/folder/rss2fmp.xsl ]
[ No dialog ]
Go to Layout [ original layout ]
Create a script for showing the article:
Set Field [ RSS_Feed::SelectedLink; RSS_Feed::Link ]
Set Web Viewer [ Object Name: "article"; URL: RSS_Feed::SelectedLink ]
Turn your title field on your portal into a button and link to perform the script above.
This is most likely not the only method; it may not be the best method either. It is, however a working method.
There’s a really nifty apple Dashboard Widget called Reminder. That’s exactly what it does: you tell it what you want to be reminded of and when and it will remind you. 2.0 only runs on Leopard, but they have a 1.0 version for Tiger users.
One of the features that has made the Blackberry (among others) the ultimate business device was the ability to create and edit office documents right on the handheld. (I’m not going to get into the differences between Palm and Blackberry. Having had multiple versions of both devices, the Blackberry is superior to me for a lot of reasons.) Then came the iPhone. With its lacking business capabilities, a lot of companies and IT departments had to wait to upgrade because it would not meet today’s business needs. We are officially one step closer. According to ZDNet, Quickoffice will be demoing their new office suit for the iPhone at MWC. They already have office products for the Symbian, Blackberry and Palm OSs, and now they are expanding their offerings for the iPhone. They already have one iPhone app: MobileFiles.
LONG BEACH, California — Students at the MIT Media Lab have developed a wearable computing system that turns any surface into an interactive display screen. The wearer can summon virtual gadgets and Internet data at will, then dispel them like smoke when they’re done.
The technology’s use is endless. I already love the idea of going to stores and checking out products. Although, reading reviews on everything you buy can significantly slow down shopping. The thought of knowing everything about a person you’re just about to talk to might be daunting. On the other hand, knowing the person you’re just about to leave your kids with is not a sex offender is priceless.
I tend to think of myself as a forward thinker. Having worked in technology for many years, I have the latest gadgets, and even if I don’t have them, I try to to follow technology, so I know what I’m missing.
I’m not a fan of too much control. I know people need to learn things from their own mistakes, even though I try to prevent the foreseeable. All of these new social media concepts and applications are great if you are into educating yourself, want to see what’s hip, who’s doing what, who’s eating what, etc. I haven’t decided if this is scary or a good idea.
I recently discovered two new ways of getting info about your neighbors:
Klick, an iPhone app to show you can pictures of your neighborhood from flickr (and your neighbor’s kids)
If you have nothing better to do with your time, you can certainly be a voyeour without leaving your armchair. Let’s just hope sex offenders won’t find smart ways of collecting and analyzing the data to fit their needs.
Are you managing your friends websites or are a professional developer managing tons of websites? Do you find it difficult to remember their FTP log in database access, which MySQL table their data stored in? I have just some across this handy application called DomainBrain that will do just that for you and even more. It can even tell you (through a WHOIS query) when you need to renew the domain.
The image below will tell you what type of information you can store in DomainBrain. Then with a mouse click on the arrow icon next to the URLs, it will launch your FTP program (Fetch, e.g.) and log you in automatically. Now, I know, we all have our login information stored in our FTP programs (rather in our Keychain App), bu having everything centralized is worth the exploration.
With the free version you can manage up to 4 domains, or if you have more to handle you can have unlimited domains with a mere $14. It is Mac ONLY.
After reading several articles on Google one would think it’s a horrendous task to get all your feeds from Google Reader to NetNewsWire. But, really, it isn’t. Export your feeds from Google Reader, then import them into NetNewsWire. It’s that simple. You’ll get a folder with the freshly imported feeds, then you can just do a little organization. Then you can sync your feeds with NewsGator and read them on any computer or your iPhone. It’s that simple!
Having a little fondness for design, I always feel like I’ve just eaten lemon when I look at somene’s hard work in coding, and the design was just an afterthought. One of these areas that are usually lacking in database development is icons. You can buy icons or download free sets that never really communicate the point. Or you can design your own, but it’s a it of work. Now anymore! I just found this beautiful application for drawing: DrawIt. I will certainly buy it, especially now that the Euro is affordable. For all of those who cannot afford $37 (with today’s conversion rate of 29 Euros), there’s a DrawItLite version for free.
The company’s other application is Fontcase that let’s you view fonts like you’ve never seen them before, preview paragraphs, tag your fonts and even share them on your network, sort of like songs with iTunes, but it let’s you preview and download fonts from another vomputer on the same network. Currently on sale for 35 Euros.
Envato has been a great place to find all design-related resources. The have given us the psdtuts.com,vectortuts.com, flashden.com for tutorials and free graphic downloads, themeforest.com for downloading beautiful themes (see my website: www.zerobluetech.com) and now they have launched appstorm.com, a Mac Apps Blog. They introduce you to new and exciting apps, and you can follow them by RSS or on twitter.
In recent months, American Express has gone far beyond simply checking your credit score and making sure you pay on time. The company has been looking at home prices in your area, the type of mortgage lender you’re using and whether small-business card customers work in an industry under siege. It has also been looking at how you spend your money, searching for patterns or similarities to other customers who have trouble paying their bills.
If AMEX is doing it, other credit card companies are doing it, too. I noticed my JCREW card credit limit dropped overnight to 1/5th, and I was on time with payments and way below the credit limit.
Maybe it’s wise for us to check on our credit limits and report strange credit drops to the Better Business Beaurou. Maybe it’s best for us to pay our credit cards off and not use them anymore. It’s just a sad thing that in this country buying a car or a house is based on whether you have good standing with these companies. What about whether they have good standing with us? They spy on us, scrutinize us if we are a little late with our payments, treat us like criminals if we manage to default on our agreements, even though we might be sick or laid off. They certainly don’t deserve our business.
