How to create a report from the data added to your Ouvvi App so then you know what has changed, and how to mark those items as sent in your App so that they are not included in the report going forward unless something changes.
Create your Ouvvi App to hold the data. The full details to do this can be seen on our Ouvvi Apps Page.
Create a Project within Ouvvi to hold your Data Sync Project step that will add data to your Ouvvi App. Create the Data Sync Step and then open the Data Sync Project.
Connect to your source data (this can be from any of the connectors) e.g. a CSV file, and connect the target to your Ouvvi App.
To connect to your Ouvvi App go to
Connect Datasource >
Simego Ouvvi App.
Make sure the URL to your Ouvvi site is entered in the URL field and then choose your App from the
ListName dropdown menu.
Connect to connect to the App or
Connect & Create Library Connection if you wish to store the connection in the connection library.
Make sure your mapping contains everything you want to include and that a key column has been selected.
You can now either run the compare and synchronisation to add the data to the app, or you can save the project and return to Ouvvi to run this later.
Now we are going to add a reporting step where an email is sent with the data that has been added to your Ouvvi App.
You will need to make sure the SMTP settings have been configured under
SMTP Email. The
Fromemail address can be set under
Email Address. Please note that Ouvvi does not support anonymous server settings so you will need to enter in valid user credentials in the SMTP settings.
Add a reporting step to your Ouvvi project (the one that holds your data sync step to add the data to the App).
The specific step type you want to add is
Report to Email.
Configure this with the
To field of the email/s you want this to be sent to. Then type in a subject title for the email.
We have added a few user settings to differentiate between the different emails such as the date and time at the end of the subject.
You then need to add the URL to your html output of your Ouvvi App which will look something like
http://localhost:8080/apps/html/testapp?limit1000&pivot=1&filter=Sent+eq+0. Remember you can add filters to limit the view, such as filtering out all the items marked as sent (we will be configuring the sent status in the next steps). This will be the data that will show in your email report.
To add a column to differentiate between the data that has been sent in the email report and the data that has not, go back to your Ouvvi app and select
Now type in a name for the column, in this example it is
Nulls and set the data type to
Boolean as our option is going to be either true or false.
Create Column to create it.
To mark an item as sent add another Data Sync step to your Ouvvi Project (third Step).
Open the Data Sync Project and configure it so that it connects to your Ouvvi App for the source and the target.
True on both the source and the target, and refresh the schema on both sides to show the internal Ouvvi Apps columns.
In the Data Sync Project add a column to your source data that returns
TRUE(). You can do this with calculated columns.
Now configure the mapping so that you include the system ID column and the new
IsSent column. And map them to the ID and
Sent column of the target.
In the first Data Sync project, the one that is adding data to the Ouvvi App, we need to update a few settings so that if any items are updated they are included in the reporting email.
To do this add a new Calculated Column that returns
FALSE() and map this to the sent column in the Ouvvi App (target).
Select the sent column in the schema map and change the schema properties so that
Ignore is set to
True. This will set the sent status back to False if any change is made to the record so that it will be included in the report.
Now to finish off the Ouvvi project, it is best to add in a step to capture if the project fails.
To do this add a fourth step that is a
Ouvvi Project Status Report. Configure it so that the run condition is on
Failure, add in a
To email address.
The subject line is pre populated but you can change this if you wish.