Tags |
|
|
Links |
|
|
Useful Advices - The Google News RSS Feed / Google Reader Mashup
My current employer is an executive search firm recruiting candidates for the real estate development and construction industries. I lead their internet marketing efforts; I also am in charge of market research. If I can deliver competitive industry intelligence to the recruiters in our office, they can u
According to USFDA, a combination product is one composed of any combination of a drug and device; biological product and device; drug and biological product
tilize it to match executive job candidates with employers who need them but can?t find them on their own.
The Challenge
There are a very large number of companies worthy of being tracked by my company. ENR (Engineering News & Record) creates different authoritative topic-specific lists containing names
The Challenge
There are a very large number of companies worthy of being tracked by my company. ENR (Engineering News & Record) creates different authoritative topic-specific lists containing names
; or drug, device, and biological product and fixed dose combination would include two or more combinations of drug.
Examples of combination products may in
Examples of combination products may in
of the biggest commercial construction firms. Builder Online lists the largest residential homebuilding firms. Between these two sources, I?ve identified about 1,700 companies where it would be valuable to track each & every news story about them. Fortunately, on any given day, only a small percentage of
lude drug-coated devices, drugs packaged with delivery devices in medical kits, and drugs and devices packaged separately but intended to be used together.
hese companies will make noteworthy news…however, in order to make sure I catch all the valuable information, I need to monitor all of them.
Most logically, I would have to implement some sort of RSS solution in order to track 1,700 companies. Manual entry of 1,700 feeds into a feedreader isn?t an option
Most logically, I would have to implement some sort of RSS solution in order to track 1,700 companies. Manual entry of 1,700 feeds into a feedreader isn?t an option
here is enormous increase in the number of combination products entering the market in the recent years. Combination products have proven advantages but fixe
I don?t have any programming skills; and I don?t have a budget to find someone to program a solution.
So what did I do?
The Solution: Part 1
When I examined a typical Google News RSS URL, I can determine that the only variable information within each lengthy URL is the term being searched:
http://new
So what did I do?
The Solution: Part 1
When I examined a typical Google News RSS URL, I can determine that the only variable information within each lengthy URL is the term being searched:
http://new
d dose combinations are still in the process of convincing regulatory authority on their advantages over the single ingredient formulations.
Combination pro
Combination pro
.google.com/news?sourceid=navclient&ie=UTF-8&rls=GGLJ,GGLJ:2006-37,GGLJ:en&oe=UTF-8&tab=wn&q=builder+magazine&output=rss
From this information, I can quickly and simply reproduce a Google News RSS URL for each item in my list quickly and easily in Excel.
I then do the following (which is more clearly il
From this information, I can quickly and simply reproduce a Google News RSS URL for each item in my list quickly and easily in Excel.
I then do the following (which is more clearly il
ucts have become life saving products for the pharmaceutical companies who doesn’t have many innovative molecules in their product pipeline and have been inc
ustrated in the attached spreadsheet that I strongly encourage you to download by clicking this link):
1) Once I open Excel, I place my entire list of relevant companies into Column B.
2) In Column A, I place the first portion of the Google RSS URL (from http:// up to the variable portion).
3) In Colum
1) Once I open Excel, I place my entire list of relevant companies into Column B.
2) In Column A, I place the first portion of the Google RSS URL (from http:// up to the variable portion).
3) In Colum
easingly used in the product life cycle management. Even the companies having product patents are trying to extend their product life cycle through the combi
C, I place the final portion of the URL (&output=rss).
4) I also know from experience that in order to make my feed as relevant as possible, I want to use exact match wherever I can. “%22” is the symbol used for “quote”. I append “%22” as the last characters in Column A and the first characters in Colum
4) I also know from experience that in order to make my feed as relevant as possible, I want to use exact match wherever I can. “%22” is the symbol used for “quote”. I append “%22” as the last characters in Column A and the first characters in Colum
nation products and maximize the revenues. But the companies involved in this practice are overlooking that they are burdening the patients both economically
C.
5) I make sure that the code in Columns A & C is copied onto every row containing a relevant company in Column B.
I also need to perform the following global steps in Column B:
1) Replace “space” and “&” with “+”
2) Replace “++” with “+”
3) Delete all instances of “apostrophe”.
Here come
5) I make sure that the code in Columns A & C is copied onto every row containing a relevant company in Column B.
I also need to perform the following global steps in Column B:
1) Replace “space” and “&” with “+”
2) Replace “++” with “+”
3) Delete all instances of “apostrophe”.
Here come
and physically. They need to rightly judge the benefits of the combination products and they have to even look at the risks involved when combining the produ
the fun part:
1) I widen the columns so that there is plenty of white space to the right of the text in each column.
2) I save the document as a Formatted Text Space Delimited (.prn) document.
3) I reopen the document, choose “Delimited”, click “Next”, and then click “Finish”.
4) I then g
1) I widen the columns so that there is plenty of white space to the right of the text in each column.
2) I save the document as a Formatted Text Space Delimited (.prn) document.
3) I reopen the document, choose “Delimited”, click “Next”, and then click “Finish”.
4) I then g
ts. Some of the combination products were well accepted by physicians while others suffered. Companies involved in development of combination products are fi
obally replace “space” with nothing, generating the list of long RSS URL?s.
The Solution: Part 2
(…catches breath…)
In each of the feed readers I?ve used, I?ve noticed that one can bulk import feeds into them if they are in OPML, something I admit to not understanding too well. I realized that if I
The Solution: Part 2
(…catches breath…)
In each of the feed readers I?ve used, I?ve noticed that one can bulk import feeds into them if they are in OPML, something I admit to not understanding too well. I realized that if I
ding difficulty in defining their combination products and facing various challenges from selecting a combination to marketing it.
Following aspects would a
Following aspects would a
could convert my URL?s into OPML, I can then get my entire list of company news RSS feeds into a feedreader. I found Feedshow Goodies (http://www.feedshow.com/goodies/opml/OPMLBuilder-create-opml-from-rs
dd to the challenges in developing combination products:
Which markets to tap where the combination products can do fairly well?
Which combination prod
Which markets to tap where the combination products can do fairly well?
Which combination prod
-list.php) through Google, dropped my URL?s into the form located on this page, and clicked “Create OPML” (note that it will process up to about 200 URL?s at once). I then saved each OPML file to my hard drive.
I then made the mistake of thinking that my trusty Feedreader 3.07 would cleanly accept 1
I then made the mistake of thinking that my trusty Feedreader 3.07 would cleanly accept 1
cts are meaningful and rational?
Which therapeutic categories to select?
Which Combinations can address unmet needs of the patients?
Do combin
Which therapeutic categories to select?
Which Combinations can address unmet needs of the patients?
Do combin
700 new feeds. The first OPML import of 200 feeds ate up all my internet bandwidth and slowed my computer to a crawl. Google Reader was the only other feedreader that I?ve used, so I signed into it and uploaded 9 large OPML files.
It worked. Google Reader allowed me to seamlessly (if somewhat slowly) imp
It worked. Google Reader allowed me to seamlessly (if somewhat slowly) imp
tions increase the patient compliance?
What would be the developing cost?
How to tackle the risks encountered during combination product developmen
What would be the developing cost?
How to tackle the risks encountered during combination product developmen
rt 1,700 feeds and read them all together, allowing me to get a real time news update of all the commercial & residential construction companies that I desired to track.
My Public Feed (http://www.goog
My Public Feed (http://www.goog
t?
As combination products don't fit into the traditional categories of drugs, medical devices, or biological products, the USFDA is in the process of devel
As combination products don't fit into the traditional categories of drugs, medical devices, or biological products, the USFDA is in the process of devel
e.com/reader/shared/user/14537180468496839026/label/main-folder) (Note I configured it somewhat differently than in the sample above).
Suggestions
1) Even though the Google Reader is doing all the “heavy lifting”, having it open tracking 1,700 feeds will hog your memory, especially in IE. I found t
Suggestions
1) Even though the Google Reader is doing all the “heavy lifting”, having it open tracking 1,700 feeds will hog your memory, especially in IE. I found t
ping new procedures for reviewing their safety, efficacy and quality.
Professional from academic institutions, pharmaceutical industries, health care indust
Professional from academic institutions, pharmaceutical industries, health care indust
at opening Google Reader in Firefox or Opera instead cut significantly the amount of memory used.
2) The one drawback to this process is that the “title” of each feed is the long ugly Google RSS URL instead of something more descriptive.
3) If you have a lot of stories in your Google Reader, go to Prefe
2) The one drawback to this process is that the “title” of each feed is the long ugly Google RSS URL instead of something more descriptive.
3) If you have a lot of stories in your Google Reader, go to Prefe
y and representatives from various regulatory agencies are working out to design the regulatory requirements for manufacture and sale of combination products
ences and check “In Expanded View, Mark Items as Read as You Scroll Past Them”. This feature is a tremendous help in wading through voluminous amounts of data.
4) I found that creating Google News feeds for all news created “in the past week” gave me the best results. A Google News feed for all company n
4) I found that creating Google News feeds for all news created “in the past week” gave me the best results. A Google News feed for all company n
.
As there is an increasing trend of the combination products companies manufacturing such products should be able to tackle the problems involved in the de
As there is an increasing trend of the combination products companies manufacturing such products should be able to tackle the problems involved in the de
ws for each company led to too much information and news feed covering just the past day?s news seemed to miss stories. In this example, I used News RSS URL?s for all company news because they are the most user-friendly. To use this mashup with “time-restricted” Google News, you will need to click on “Adv
elopment. They need to be wiser in analyzing the market trends and the regulatory requirements.
Companies that provide selfless information through particip
Companies that provide selfless information through particip
nced News Search”, do a sample search with a defined time period, generate the News RSS URL and copy the first portion of it into Column A of your spreadsheet before following the proscribed process.
I now can track news from all 1,700 companies in my Google Reader. Kudos to those good folks at the ?Plex
I now can track news from all 1,700 companies in my Google Reader. Kudos to those good folks at the ?Plex
tion in industry events and feedback to regulatory authorities would be able to face the challenges and will be successful in developing combination products
HTTP = HTML link (for blogs, profiles,phorums):
<a href="http://www.usefuladvices.org.ua/article/74589/usefuladvices-The-Google-News-RSS-Feed--Google-Reader-Mashup.html">The Google News RSS Feed / Google Reader Mashup</a>
BB link (for phorums):
[url=http://www.usefuladvices.org.ua/article/74589/usefuladvices-The-Google-News-RSS-Feed--Google-Reader-Mashup.html]The Google News RSS Feed / Google Reader Mashup[/url]
Related Articles:
Are You Using Technology As A Crutch
Bookmark it:
|