Q-Flex Satellite Modem Installation and Operating Handbook
6-36
The information is sent in Comma Separated Value (CSV) format, which allows the data
to be copied into any spreadsheet from where it can be viewed in a number of formats
(e.g. as a graph or a table) and from which reports can be generated.
The relevant data is appended to the email as separate attachments.
The modem needs to know where to send all emails in order for them to be forwarded to
individual email accounts. This is the outgoing SMTP mail server name (e.g.
smtp.yourmailserver.com). An account name and password may be necessary. The
recipient’s email address, subject (email title) and email reporting interval should be set
as required.
The
Reply to
address field is optional and is the address used to deliver failure
notifications in the event that an email cannot be delivered to the recipient’s email
address.
The following example demonstrates how to graph modem constellation data in a
spreadsheet:
•
Configure the SMTP mail server and recipient email details.
•
Select the
Constellation data
check box and click the
Send email now
button.
•
Wait for the email to be received at the recipient’s account and open it.
•
To import the constellation data into a spreadsheet program (Microsoft Excel is
used in this example) double click on the email attachment
constellation.csv
to
open it (this should automatically start the spreadsheet application - if not, then
save the attachment and open it directly from within the spreadsheed application).
•
Within Excel, highlight the A and B columns.
•
Select the Chart Wizard from the toolbar (or alternatively select the
Insert
menu
followed by
Chart
).
•
Select
XY (Scatter)
as the chart type.
•
Select the
Scatter
(topmost) sub-chart type.
•
Select
Next
and then accept the defaults for
Data Range
and
Series
.
•
Add a chart title and X and Y titles as desired.
•
Select
Finish
and then resize the resulting graph as desired.
An example of the output is shown in
Figure 6-13
.
