Follow

ID311 - MPS Monitor of Americas Integration Overview

This integration process will automatically import your MPS Monitor meters (both MPS Monitor and HP SDS Action Center). Use our app to complete one time mapping of Meter Types and let the integration do the work for you!

Jump to Overview | Variables | Sample | API Details | App | Validating Meters | OnDemand SSRS 

Click to Subscribe 

*  *  *

Overview

Overview

This integration process will automatically import your MPS Monitor meters (both MPS Monitor and HP SDS Action Center are available). Use our app to complete one time mapping of Meter Types and let the integration do the work for you!

Data pushes into eAuto daily, sends email showing results AND provides OnDemand SSRS Report to view activity and errors. We will only push in meters that are due to bill per your Contract Record, devices not due to bill will not be listed on our reporting.

Please see API Details link below for instructions on how/where to get needed API details to CEO Juice.

**Requires MINIMUM .Net version 4.7 on server for CEO Juice.**

 

Run Schedule: Weeknights

Type of Output: Email/App/On Demand SSRS Report

 

*  *  *

Variables

Variables

ID311Variables.PNG

Variable1: Select which DCA Platform you are using with MPS Monitor (MPS Monitor OR HP SDS Action Center)

VariableW: Indicate eAuto Meter Source to be assigned to meters entered

 

If you would like to integrate BOTH MPS Monitor and HP SDS Action Center, please subscribe to ID311 twice using the plus (+) sign after your first subscription is completed populating Variable1 with the other DCA Platform and its own eAuto Meter Source:

 

ID311Clone.PNG

 

*  *  *

 

Sample

Sample

Daily email and On Demand SSRS Report shows meters pushed in AND meters unable to push in per error indicated:

ID311SSRSPushed.PNG

 

ID311SSRSErrors.PNG

 

 

*  *  *

API 

API Details

We need your API Details entered by you on our website as shown below. The user entering on our website will need 'Customer Admin' security role - ask us at help@ceojuice.com if you need to know who has.

Please enter credentials on our website (https://www.ceojuice.com/CustomerAdmin/Integrations) via Profile / Integrations:

ID311Profile.PNG

13.PNG

 

Select MPS Monitor or HP SDS Action Center:

5.PNG

Enter API credentials here: (see below on where to set):

6.PNG

 

Credentials needed for MPS Monitor:

Credentials needed:

 

These values will need to be created from Developers Menu / API Key Management (requires elevated user rights inside MPSM and HP SDS Action Center).

Instructions below provided by Oberon Americas (right click on images to view larger size format).

Please reach out to Support@oberonamericas.com with any questions related to creating credentials.

**Do not reuse any existing Keys or Users used elsewhere**

 

1.PNG

2.PNG

3.PNG

4.PNG

Please email us at help@ceojuice.com once credentials are entered on our website.

*  *  *

APP

APP

You will need to tell our app which eAuto Meters correspond to the DCA Meters, so we know which meters to insert where in eAuto.

Go to your CEO Juice apps (if you don't know the URL use http://localhost:8888)

Select model-mapping-and-key-services:

1.PNG

The two hyper links at top take you to

(1) Metertypes 

(2) Meter Mappings

2.PNG

Metertypes shows the DCA Meter Type names and eAuto Meter Type names, indicating if mapped and/or if ignored for mapping:

3.PNG

To get started go to Meter Mappings to start mapping your MP Monitor or HP Action Center (DCA) Meter Types to eAuto Meter Types:

Once you have mapped all your meters, the app can determine which meters to insert into eAuto.

4.PNG

When you select Add Mapping you will need to select the EA Metertype to be mapped to DCA Metertype:

 

5.PNG

 

The 'Fallback DCA Metertype (optional)' is only needed when the same EA Metertype applies to more than one DCA Metertype.

For example:

B\W only device has DCA Metertype of Total Meter which needs to be mapped to EA Metertype of B\W. But a color device has DCA Metertypes of Total Total Meter, Total B\W, and Total Color. You don't want DCA Metertype of Total Meter to go into eAuto as Total B\W clicks. 

So you want the DCA Metertype = Total B\W and the Fallback DCA Metertype = Total Meter

Essentially you are telling the app, if Total B\W from DCA does NOT exist, then use DCA Metertype of Total Meter for my eAuto B\W meter.

 

IF you have any questions or need changes on what DCA Metertypes are being pushed in, please contact support@oberonamericas.com as they can help you set which meters report.

*  *  *

Validating Meters

Validating Meters

Required Meters and Considering Valid:

Required Meters and Considering Valid:

Our integration will only consider meters set as required on Equipment Record AND due for billing today or past due per Contract Record.

6.PNG

We then use your eAuto Meter Validation Buffer to check the meter is valid:

This can be seen via Tool / Options / Equipment:

7.PNG

We are NOT consider these meter tolerance settings:

8.PNG

Devices with more than one meter:

Devices with more than one meter:

We look for the serial number in eAuto and the meters required to compare what DCA meters are being pushed in. IF at least one of the required meters is greater than previous, we will push in ALL meters. If all meters are less than previous, NONE of the meters will push into eAuto.

 

Mapping Errors Explained:

Mapping Errors Explained:

Negative value indicates mapping not found: the DCA meter has not been mapped to an eAuto meter. Use the MeterType Mapping App to set.

read Invalid due to less or equal to previous: the meter from DCA is less than or equal to the previous meter in eAuto. You will need to correct the previous read in eAuto OR wait until DCA meter exceeds your previous meter.

If you have a DCA meter that is older than current day of meters being pushed in, then this indicates the device has fallen off monitoring, meaning no new meters coming in. But our integrations always considers the most recent record available:

a.PNG

 

 

*  *  *

OnDemand SSRS Report

OnDemand SSRS Report

You also have an On Demand SSRS Report to review what has pushed in that day and what has had errors that day. This is essentially a duplicate to the daily email sent to those emails listed on your ID311 subscription.

SSRS1.PNG

 

SSRS2.PNG

Report shows on Page 1, any meters unable to push into eAuto due to error indicated:

ID311SSRSErrors.PNG

Page 2 shows what meters have been pushed into eAuto:

ID311SSRSPushed.PNG

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk