Versions Compared

Version Old Version 5 New Version 6
Changes made by

Andrew Tuma

Ricky Villa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

History Report

We have created a Create History Report Form that allows the user to search for points and create a job that will email a CSV file containing the points' history on a one-time, daily, weekly, or monthly basis.

How to use History Report

First the finHtmlReporting.pod file needs to be added to "fan" folder located within the "lib" folder of the FIN Stack folder directory. Contact support regarding the finHtmlReporting.pod.

...

  • Title: This will be the title of the report so user can easily identify it. This title will become the name of the job and will be part of the file name.
  • Filter: Type in a axon query or use the Filter button to the right to select which points history should be gathered for.
  • Select a time frame: This combo box contains options for the history time span. 
  • Select a user email: This combo box contains available users with emails to have the report sent to.
  • Send the report: This comb box contains options for when to generate the report.
  • Organize Columns: Checking this box will allow the user to organize the order of the columns of the history report.

Select a Time Frame

This combo box contains the following options:

  • Today: This will gather the history for the current day.
  • Yesterday: This will gather the history for the previous day.
  • Current X: This will gather the history of the current X, where X can be week, month, or year.
  • Previous X: This will gather the history of the previous X, where X can be week, month, or year.

Select a User Email

This combo box will contain all the emails of users.

Send the Report

This combo box will contain the following options:

  • Now: This will not create a job, but create the CSV file and email it, only.
  • Daily: This will create a job to be ran on a daily basis.
  • Weekly: This will create a job to be ran weekly. If the original job was created on a Tuesday, then the report will be created and emailed every Tuesday.
  • Monthly: This will create a job to be ran monthly. The report will be created and emailed every 1st of the month at 9:00 AM.

Organize Columns

After the user has filled out the "Create CSV History Report" form, if they have selected "Organize Columns" and clicked "Apply" the following form will appear:

...

Once the desired order is added, the user will click the "Apply" button and a job (or report, if "Now" was selected) will be created.

Additional Information

Edit or Delete Jobs

To edit or delete the job created, the user can go into the Job app.

...

The job can be identified by looking for the title given to the report.

File Location

All reports generated by History Report can be found by going to the io folder of the project. EX: C:/Program Files(x86)/FIN Stack/db/demo/io/CSV.

...