Probe for Windows: Export

Probe For Windows can print and export to paper, text files, web sites, email and SMS.

Sites to be included in the output can be selected by group, by grower, by crop, or individually selected; and from any season.

A report is selected from the drop-down list.

Preview will show the output in a preview and Print will print the report. This could be a physical printer, or to a PDF file if a PDF print driver has been installed.

Build Web

As well as printing the report, the output can also build a web site.

The web site will have the same information, and in the same order, as the printed output (but see Select Output).

Normally output would be a separate web page for each grower, but all sites can also be output to a single page.

The base name is the name for all files e.g Schedule will output schedule.htm, GoogleMap output in schedule.kml, etc

When the web site is re-built, a notification email or SMS message can be sent to each grower.

As well as building the web site, the data can also be sent to...

An RSS feed that can be subscribed to by the grower.

A WAP file that is a special format for mobiles phones. The link to be entered into their phone will sent in an email.

A KML file that can display in a browser using GoogleMap, or in GoogleEarth on the growers PC - see GoogleEarth

An email with recommendations can be sent to the grower, eiteh ra single SMS message for al sites, aor a separte message for each site.

Emails will only be sent to a grower if they have an email address entered on Edit Grower.

An SMS message with recommendations can be sent to the grower, either a single message for all sites, or a separate message for each site.

SMS message will only be sent to a grower if they have an SMS number enterd on Edit Grower.

When BuildWeb is used all files are generated on the local PC, and then files, emails and SMS messages are sent to queues on Internet.

They can be sent immediately, or check the queues and change emails and messsages before sending.

Items

There are different sections in a report - a page header at the top of each page; a group header at the top of each group for 'GrowerName'; and a column section of the items being output for each site

The Report Header section is output once at the beginning - cover sheet.

The Report Footer section is output once at the end - e.g. credits, disclaimers, copyright, etc.

Each section can have its height set, and whether it will have a page break before or after the section.

If the section height is not entered it will be automatically calculated from the height and position of all active items in the section.

The column headers (title at the top of each column) can be printed in the page header; or in the Group header, with the grower name.

Items that are output in each section are listed in the lower part of the screen.

Only items that are Active will be output.

The title will be printed at the top of the column - (the title is only output for items that are in the columns section)

For paper output, each item needs the position in cm (left, top, right, bottom) of a bounding box that it will print in.

Items in a column just need a column width entered.

Graphic items that are separate need a width for the link text, but the size of the actual graphic is taken from left/top/right/bottom.

A border can be drawn around an item. Items in the columns section will a have a border width set on Options.

An item can be various types - labels (text), or values from the data base for each site.

Other items are...

Gauge

a diagram showing realative position of waer between fill and refill

Profile

showing cahanges in VS down teh profuiel

Graph

a full graph reoport.

Lines

The line width in points is entered at 'font size !

The source of the data can be a data field in the database, or a formula.

There is a drop down list of all fields in the database that can be used. For a graph report, this list will be of all graph reports available.

The comment is for any notes about the item - it is not output.

The font and font size, bold, and colour can be set for each item.

Numeric items can have the display format set, and whether unts (e.g. mm) will be output.

Items can be aligned horizontally (left, centre, right), and vertically (top, middle, bottom) inside the bounding box.

Numeric items can display in red (or any other selected coloor) if it is negative; or if the date is less than todays date (e.g. a scheduled date that is late)

Other optiions can be set for web output.

The CSS class or HTML tag that will be used.

If the output is a graphic (e.g a graph) - the output can be a link to the graph instead of the graph itself. This allows large graphs to be invluded in teh output without taking up too mush space in the main output table.

The link needs entering e.g. click for graph.

Selective Output

Whether an item is output to the varouis destinations can be selected

For example, an item like a line in the page footer could be output to a printed page, but not output to the web page.

SMS messages could just be the 'recommendations' for each site, but nothing else.

Lookup files

Values from a text file can be output with the data from each sites

For example, an area being monitored at a single location could have several valves delivering water.

A report could be printed, or exported as a csv file top a controller, that has a line for each output valve and not just a line for each site.

Sorting and Grouping

The output can be first sorted by, say, Grower, and then by Site Number.

A group break, with an optional new page, can be output - e.g. a break to give a heading for each grower.

A scheduling report could be first sorted by Grower and then by scheduled date, with a break on each grower, and another break on each day.

The output could have all sites due for irrigation on a day printed in a group on a separate page.

Printer

A printer and paper orientation selected, and margins set.

The font size is the the default font size for any items that do not have a font specified.

Where - which sites will be output

Which sites will be output is selected on the main tab, but extra critera can also be set.

For example, only sites scheduled for irrigation in the the next 3 days.

Export as text file

Data can be exported in a file for use by Excel or other software. It is exported as one line per site or lookup file entry, with items separated with commas (or another delimiter).

Only items in the Columns and Group Header sections are output.

The first line in the file can be the column headers.

Numeric values can be formatted (decimal places), or unformatted in order to do further calculations in a spreadsheet.

The data can be in user units (e.g mm or ins, depending on user preferences), or the underlying raw data (metric).

Dates can be formatted with the standard Microsoft format codes, or as as days-since-1-Jan-1900 (as used by Excel)).

Options

The width of the the border that is printed around items and tables can be selected.

If the total width of all columnms is wider than the net width of the paper, the column widths can be automatically adjusted to fit on the page.

When building web sites, the html files are first saved in folders on the local PC. They are then uploaded by frtp to a web server.

This uploading can be done automatically every time a web site is buult, or manually by using {internet}.

SQL

Reports can also output other data - for example a list of all growers, or a list of all neutron probes by serial numbers used.

Web/email

When a web site is updated an email can be sent to each grower notifying them of changes to their web site.

The text of the email can also have '%wildcards%, that are replaced by actual values from the database as the emails are sent.

For example %FarmName% will be replaced with the actual grower name e.g. ABC Grower , and %links% with the links to the growers web site (and to any other output such as kml or rss feeds)

See here for a list of available wildcards.

Growers can also be sent an SMS message to notify changes on the web site.

The message can have the same wildcards as emails, but when expanded the SMS 160 character limit must not exceeded.

The web address is the base address of the web site e.g. www.irrigation.com.

The web data folder is the folder below the web address for files e.g webdata.

Note: The files for each grower will be saved in www.irrigation.com/webdata/grower/*.htm.

The local root folder is where the htm files will be initially created before sending to the web site. e.g. C:\Prwin\Shared\WebData.

All styling for the web pages is done using CSS. The CSSfile must be in the local root folder (e.g.C:\Prwin\Shared\WebData\prwin.cssand also in www.irrigation.com/webdata/prwin.css.

For the web all graphs and diagrams are generated as PNG files, and the font used for text and the background colour can be specified.

Gauge Options

The water status - the relative position between refill and full - can be shown as a Gauge.

Changes in water content at different depth can be shown as a Profile.

The styling and colours can be specified.