Probe for Windows: Export

Probe For Windows can print to paper or pdf, export as text/csv files, build web sites, and send emails 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.

export_1.png

A report is selected from the drop-down list.

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

will generate web pages, and will upload them to a web site


Build Web

export_2.png

As well as printing the report on paper, the output can also be sent to a web site, an rss news feed, or google maps.

The web site will have the same information as the printed output - but see Select Output.

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

When is used...

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

All files are first created on the local PC, and then files, emails and SMS messages are sent to queues on Internet.

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

See 'options' and 'web' for more details.

Items

There are different sections in a report - first a report header; 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.

Items in a report

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.

Sections will only be output if they are Active.

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 (the title at the top of each column) can be printed in the page header; or in the Group header (with the grower name).


All Items 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 - (only in columns section)

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

Items in a column only need a column width entered.

Graphic items can be embedded in the report, and or can be separet, and just a link is shown in the report. 'Separate' graphic items 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 item types are...

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.

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

Items in a report

Whether an item is output to the varous 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.

If the SMS message to be SiteName and Recomemndations, the 'site name and recoomendations items should have SMS , and all other items SMS .


Lookup files

Items in a report

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

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

printing options

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

printing options

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

csv output

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

csv output

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

csv output

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

web, email and SMS configure

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 %WebLink% 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: A file for a grower will be: http://WebAddress/WebDataFolder/GrowerFolder/BaseName.htm.


eg: http://www.irrigation.com/webdata/johnson/schedule.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 (C:\Prwin\Shared\WebData\prwin.css and also on the live web site 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.


Google Earth and Google Maps

Google Earth is a desktop application that is used by many growers to aggregate different types of data.

For example 'yield' output by harvesters; soil maps; ??; and current soil moisture status from Probe For Windows

The latest soil moisture status will be automatically displayed to the grower

Google Maps is available in a browser (eg Edge, Firefox, Chrome), or as an app on mobile devices.

Growers can use My Maps to set up a map of their property (eg Farm Industry News Cotton) , and then add a reference to their soil moisture kmz file (http://WebAddress/WebDataFolder/GrowerFolder/schedule.kmz.

The kmz file can also be shown in a web (html) page.

schedule_map.htm is a simple example of how the kmz file can be used - a satellite map with an icon at each site showing a 'gauge'

When a user clicks on a 'gauge', more details of the site are shown, either in a popup box or in a table below the map.

There are other Geographic Information Sustems (GIS) software that can use kmz files - Marble, NASA World Wind


Files created...

FileNotes
schedule.htmschedulemain report for the grower
schedule_map.htmMapGoogle map report
gr99_1234.pngGraph report (report=99)
g1234.png'Gauge' showing current state of a site relative to Full and Refill
gp1234.png'Gauge' showing previous state of a site relative to Full and Refill
pg1234.pngProfile diagram, showing changes that have occured since the previous reading
b1234.pngA 'bucket' showing how much water remains of the allocated volume
schedule.kmlContains the GPS coordinates of each site; links to the 'gauge' files; and information about each site. Can be used by Google Earth (how???)
schedule.kmzzip of schedule.kml plus all 'gauge' png files. Used by schedule_map.htm and also by Google Earth (how ???)
schedule.rssrss feedPodcast/rss
schedule.wmlWMLCan be used by ???

Gauge Options

gauge and profile 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.