Skip to main content

mForms Configuration

The purpose of this section is to assist in the configuration of Coins ERP+ to enable use of the mobile Forms application.

The configuration and setup should only be implemented once the M1x Integration Guide has been followed and completed, which is a prerequisite to the mForms configuration. The mForm configuration must be completed before UAT/LIVE deployment of the mobile application to end users.

These topics are intended to provide full instructions for the necessary setup required for mForms application. Furthermore, it may describe additional setup for the following elements in Coins ERP+: Contract, H&S, Plot Based, Service Visit) which are client specific.

Note: This section is not finalised and any of the information below is subject to change.

Database and Processes publishing

The system users and look up data for mobile application will be published onto M1x middleware via Coins ERP+ ESB publishing. This will entail creating some tables and processes. This is only possible when the Coins ERP+ system parameters and ESB Brokers have been setup as per the M1x Integration Guide.

Setting up Coins ERP+ ESB Database Publish

Creating a new ESB Database Publish Tables

Note - root access required / KCO Specific (1 min per KCO). The following will need to be set within each KCO if global KCO is not being setup.

  1. Go to the ‘System’ module settings.

  2. Under ‘Enterprise Service Bus’, click ‘ESB Database Publish’.

  3. Add a new tables on the following list as shown below.

  4. Bulk Add can be used as per the attached.

  5. Once the tables are added, the reference data needs to be published. Select all tables and tap on ‘Resend All Records’

Table

Endpoint

Fields

Condition

Query

Prevent Duplicates

co_table.COINSMobile

COINSMobile

*

CAN-DO(HSACTYPE,HSPRTY,HSISSCAT,CCCANCREAS',ttco_table.cta_rtype)

CAN-DO(' HSACTYPE,HSPRTY,HSISSCAT,CCCANCREAS',co_table.cta_rtype)

Yes

dm_template.COINSMobile

COINSMobile

*

Yes

hs_action.COINSMobile

COINSMobile

*

Yes

sy_mobcfgdfn.COINSMobile

COINSMobile

kco,hih_chklist,hih_desc,rsp_dbrowid

$retire = hs_chklist.hih_retired;resutt = can-do('N',retire);

NOT hs_chklist.hih_retired

Yes

sy_mobcfglk.COINSMobile

COINSMobile

kco,hic_instype,hil_saleclass,hih_chklist,rsp_dbrowid

Yes

sy_mobcfgval.COINSMobile

COINSMobile

kco,hic_instype,hic_desc,hic_signreq,hic_signwho,rsp_dbrowid,hic_char__1,hic_char__2

Yes

sy_mobfel.COINSMobile

COINSMobile

*

Yes

sy_mobffield.COINSMobile

COINSMobile

*

Yes

sy_mobform.COINSMobile

COINSMobile

*

Yes

sy_mobfsec.COINSMobile

COINSMobile

*

Yes

sy_mobfstat.COINSMobile

COINSMobile

*

Yes

sy_moblink.COINSMobile

COINSMobile

*

Yes

sy_mobsched.COINSMobile

COINSMobile

*

Yes

sy_mobxitem.COINSMobile

COINSMobile

*

Yes

sy_mobxlist.COINSMobile

COINSMobile

*

sysdb.COINSMobile

COINSMobile

*

wf_template.COINSMobile

COINSMobile

kco,wfp_code,wfp_desc,wfg_code,wfp_doc,wsp_status

Adding Global ESB DB Publish

Creating a new Global ESB DB Publish

Note - root access required

  1. Go to the ‘System’ module settings.

  2. Under ‘Enterprise Service Bus’, click ‘Global ESB DB Publish’.

  3. Add a new process on the following list as shown below.

Table

Endpoint

Fields

Condition

Query

Prevent Duplicates

dm_template.COINSMobile

COINSMobile

*

menuparm.COINSMobile

COINSMobile

*

  1. (Optional)- Once the processes are added, the task data can be published. Select the table and tap on ‘Resend all records’

Adding Global ESB Process Publish

Creating a new Global ESB Process Publish

Note - root access required

  1. Go to the ‘System’ module settings.

  2. Under ‘Enterprise Service Bus’, click ‘Global ESB Process Publish’.

  3. Add a new process on the following list as shown below.

Process

Endpoint

Fields

Condition

DMU900

COINSMobile

*

SYU900

COINSMobile

*

SYU901

COINSMobile

*

  1. (Optional)- Once the process are added, the task data can be published. Select the process and tap on ‘Resend’

Roles and User Licence Requirements

Coins ERP+ will need to import the attached role for branding.

Requires SYSAdmin access/DAYPWD

  • System > User Maintenance > Import Roles

  • Copy and Paste Role from mForms.txt click save


Once branding has been applied to CLIENT Coins ERP+ environment (importing roles and licences installed) then the users of the mobile devices need the role to be configured against their Coins ERP+ username. All users need to be Coins ERP+ Named Users however if users are required to access both mForms and Coins ERP+, then Concurrent Users for that role will need to be included within the licence.

Each user (user of mForms) requires the following role to be assigned to them (licensed to Role %JCMF– mForms) as shown on following screenshots;

This is a Coins Mobile requirement that needs to be configured by Coins ERP+ Consultant/Customer on the Customer Coins ERP+ environment.

Document Management Setup

In order to link the photos or signatures submitted from the mobile devices, the following tables need to be added.

This is a Coins ERP+ Mobile requirement that needs to be configured by a Coins Consultant or the Customer on the Customer Coins ERP+ environment.

Note - The following tables will be created by the Coins ERP+ web service as soon as the category is called on Coins ERP+ or by mForms.

Creating a Document management link

  1. Go to the ‘System’ module settings.

  2. Under ‘System setup’, ‘Document Management Links’

  3. Add the following tables and set the Base URL as coins.

    sy_mobcfield

    sy_mobcform

    sy_mobffield

See screenshot below.

Once the above DM links have been added and documents have been sent back into Coins ERP+, the category maintenance links will automatically be created:

We will need to manually add in the description “Completed Mobile Form” for the sy_mobcform category.



Did this answer your question?