Search:
Market Journal Home
What is Market Journal
MJ's Ag Market Pages
Subscribe to MJ Updates
Contact us
Previous Programs
Subscribe to Podcast
Browse by Topic
Select one
All Topics
Ag Policy
Animal Health
Biotechnology
Crop Production
Economics
Environ & Nat. Resources
Farm Management
Feed & Forage
Grain
Journal Tips
Livestock
Managing Risk
Markets
Merchandising
Special Topics
Weather
Work
Recommended Sites
AgAlmanac.unl.edu
Beef.unl.edu
CropWatch.unl.edu
IanrHome.unl.edu
IanrPubs.unl.edu
PorkCentral.unl.edu
VetExt.unl.edu
WebVideo.unl.edu
Web Site Maintenance
Step 1
MJ is a database driven web site.
(Database Design and Maintenance) is used for
contents maintenance
. For each new MJ program, new data needs to be saved into the marketjournal database - program description, clips descriptions, and MJ newsletter contents -
prior to generating new program's web pages
.
The following programs are used for the
web site maintenance
. Clicking on a link, you are
requesting the chosen program to do its work.
Step 2
This program (staticLinks.cgi) does multiple things:
creates index (home) page, containing current program description and the upcoming program's announcement, provided one is previously saved into the database.
generates archive pages by date and by topic.
creates drop-down list SSI with archive categories
creates drop-down list SSI with search area names
creates pages for indexing by the search engine and FTPs them to ianrsearch.unl.edu server
Step 3
Pulls the most recently saved newsletter from the database table MJupdates and sends it to MJ subscribers. Which means that newsletter needs to be saved into the database
first
, and then only it can be emailed.
MJupdates table (in DBDM/marketjournal) contains the following radio button group:
Not Sent
Already Sent
When creating a new table row (new newsletter), the default value of this indicator is set to "Not Sent". Program emailUpdates.cgi fetches this newly created newsletter record, emails it to MJ subscribers, and sets the indicator to "Already Sent" so it won't be from then on sending the same newsletter multiple times.
The indicator must not be set or reset manually! And don't click the link twice in a row, since it will send two copies of updates to our subscribers.
Step 4
A series of local
County Extension
web sites,
AG Almanac
web site, and
UNL Extension
home page, all contain a set of webcast programs' teasers announcing our current video production. The program addProgsGen.cgi, in the ianrhome web space, updates webcast teasers and saves them into a new Perl program named AddProgs.cgi for delivery to the consumer web sites. Must be run after new MJ teaser data is saved into the
ianrnews
database,
TeaserCast
table.
Step 5
Similar to the teaser created in
Step 4
, but the difference is that the targeted page is
IANR Home
, and the teaser is saved into a SSI file - not into a Perl program.Uses the same database table,
TeaserCast
.
Step 6
This program selects the most recent Al Dutcher's weather report, either from 'drought' or from 'marketjournal' database, whichever was last updated and saves it as a SSI in the ianrhome.unl.edu/drought web space.
Step 7
Since MJ web reports are enhanced by the MJ programs and clips delivery overview, it can be used in some cases as a debugging tool. Namely, sometimes a "Wrongly described clip" shows up on the list - particularly at the beginning of the month, before such clip is pushed out of the rating list by other, correctly titled clips. By viewing the clip's URL, it is not difficult to find and correct it in the database.
©2007 UNL - CIT - Institute of Agriculture and Natural Resources, Lincoln, NE
Web Development by IANR's
Communications and Information Technology
