Conversion Process Guide - Midwinter AdviceOS: XPLAN Conversion Guide

Conversion Process Guide - Midwinter AdviceOS: XPLAN Conversion Guide

 

Midwinter AdviceOS to XPLAN Conversion Guide Overview

This document highlights data and functionality most often of concern to practices converting from MidWinter AdviceOS to XPLAN, however if there is specific data and/or functionality that is not contained within this document and is of importance to your Practice, please discuss with your IRESS representative prior toyour conversion.

It is also important to be aware that IRESS will not undertake data cleansing. Any data errors (i.e. misspellings, client names, date of birth) will be transferred; therefore a practice may wish to ‘clean up’ their data before commencing with the conversion.

 

Requesting a Data Conversion

Please be aware that there will be a wait of a number of weeks from the time that IRESS receives your request for a data conversion. This time frame will vary throughout the year and your IRESS representative will inform you of an estimated time when your conversion will be scheduled.

 

Out of Scope

If you require any data converted that is outside the scope of this document, IRESS is happy to assess the data. Once IRESS has made the assessment, a decision will be made on whether or not the conversion is possible. Once this decision has been made, an approximate quote on timeframe and additional cost will be given. Please contact your IRESS representative to discuss this further.

 

The Conversion Process

  1. Conversion preparation

    During this phase a Transition Consultant will work with you to prepare for the conversion of your data. 

  1. Obtaining a copy of your data for conversion

    Data must be received by the end of the business day prior to your conversion date.

  1. Data Import

    IRESS completes the first step to import your data into your new XPLAN site (the destination site). Data imports are done after business hours and the time required to import the data depends on the volume of the data. Your Transition Consultant will keep you informed of the progress.

  1. Post-conversion tasks

    IRESS completes the import of custom fields, choice value mappings, updating of risk profiles etc. on the next day after the data import completes. 

  1. Data checking and sign-off

    It is your responsibility to review your data in XPLAN after the conversion. You know your data better than anyone else and is best placed to notice any differences between your original data and the data that will reside your new XPLAN site after the conversion. 

 

Standard conversions 

Outlined in the following pages are details of the data within Midwinter that will be converted to XPLAN.  It is important that you review this information so you are fully aware of how your Midwinter data will be converted to XPLAN.


Key Details

Individual

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

FirstName

 

Key Details|First Name

entity

first_name

LastName

 

Key Details|Surname

entity

last_name

MiddleName

 

Key Details|Second Name

entity

middle_name

TaxFileNumber

 

Key Details|Tax File Number

entity

tfn

Male

 

Key Details|Gender

entity

sex

ClientTag

 

Key Details|Category

entity

client_category

Birthdate

 

Key Details|Date of Birth

entity

dob

PreferredName

 

Key Details|Preferred Name

entity

preferred_name

Salutation

 

Key Details|Salutation

entity

salutation

Health

 

Key Details|Health

entity

health

Smoker

 

Key Details|Smoker

entity

is_smoker

memberid

 

Key Details|Client reference/File number

entity

reference_file_number

OptInDate

 

Key Details|Next Opt-in Date

entity

next_opt_in_date

DisclosureDate

 

Key Details|Next Disclosure Statement Date

entity

disclosure_statement_date



Contact Details

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

Notes

Country

 

Address|Country

entity_address

country

 

PostCode

 

Address|Postcode

entity_address

postcode

 

State

 

Address|State

entity_address

state

 

Address1

Address2

 

Address|Street

entity_address

street

 

Suburb

 

Address|Suburb

entity_address

suburb

 

WorkPhone

HomePhone

Email

MobilePhone

 

 

Contact|Detail

entity_contact

value

WorkPhone = Work Phone

HomePhone = Home Phone

Email = Other Email

MobilePhone = Mobile Phone

WorkPhone

HomePhone

Email

MobilePhone

 

 

Contact|Type

entity_contact

type

WorkPhone = Work Phone

HomePhone = Home Phone

Email = Other Email

MobilePhone = Mobile Phone

 

Employment

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

 

Notes

EmploymentType

 

Employment|Status

entity_ employment

Emp_Status 

 

 

StartOfEmployment

 

Employment|StartDate

entity_

employment

Start_date  
OccupationID   Employment| Occupation(Standard)

entity_

employment

iqm2_ occupation  Mapping is required
Employer   Employment|Employment

entity_

employment

 employer  

 

Review/Marketing Details

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

Notes

ReviewDate

 

Review|Date

entity_review

date

Create a review in Xplan

 

Estate

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

DateOfWill

 

Estate|Date of Will

entity

date_of_will

 HasWill

 

Estate|Will Exists

entity

will_exists

 

Assets 

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

AssetyType

 

Balance Sheet-Asset|Asset Type

entity_asset

type

 Name

 

 

Balance Sheet-Asset|Description

entity_asset

desc

Value

 

Balance Sheet-Asset|Current Value

entity_asset

amount

 

Liabilities

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

Notes

 LoanType

 

Balance Sheet-Liability|Loan Type

entity_ liability

type

 

Value 

 

Balance Sheet-Liability| Outstanding Balance

entity_ liability

amount

 

InterestRate

 

Balance Sheet-Liability|Interest Rate (pa)

entity_ liability

rate

 

 Monthy Repayment

 

Balance Sheet-Liability|Repayment Amount

entity_ liability

repayment

 

 LoanType

 

Balance Sheet-Liability|Type

entity_ liability

type_group

 

Comments

 

Balance Sheet-Liability|Comment

entity_ liability

comment

 

 

 

Balance Sheet-Liability|Repayment Frequency

entity_ liability

frequency

Default to Monthly 

 TaxDeductibility

 

 

Balance Sheet-Liability|Deductible

entity_ liability

deductible

 

RepaymentType

 

Balance Sheet-Liability|Repayment Type

entity_ liability

repayment_ type

 

 Name

 

Balance Sheet-Liability| Package/Product Name

entity_ liability

package _name

 

YearsRemaining

 

Balance Sheet-Liability|Loan Term (integer)

entity_ liability

loan_ term _amount

 



Insurance

Policy

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

Notes

Nominated Beneficiaries

 

Insurance Group|Beneficiary

entity _insurance _group

beneficiary

Insurance.xls

UpfrontCommission Rate

OngoingCommission Rate

PaymentDate

TaxDeductibility

ProductLevelID

 

PaymentMethodID

 

ProductName

 

Comments

TerminalIllness Benefit ChildCoverDetails

 

 PolicyNumber

 

 

 

PolicyOwnerMemberID

 

 InsuranceStatusID

 

 

 

 FrequencyID

 

 

 

 PremiumWaiver

 

Insurance Group| Commission Comments

entity _insurance _group

commission _comments

 

 

Insurance Group|Payment Comments

entity _insurance _group

payment _comments

Insurance.xls

 

Insurance Group|Payment Method

entity _insurance _group

payment _method

Insurance.xls

Mapping of the ID required

 

Insurance Group|Plan Name

entity _insurance _group

plan_name

Insurance.xls

 

Insurance Group|Policy Comment

entity _insurance _group

policy _comments

Insurance.xls

 

Insurance Group|Policy Number

entity _insurance _group

policy_number

Insurance.xlsx

 

 

Insurance Group|Policy Owner

entity _insurance _group

policy_owner

Insurance.xls

 

Insurance Group|Policy Status

entity _insurance _group

policy_status

Insurance.xls

ID mapping required

 

Insurance Group|Premium Frequency

entity _insurance _group

frequency

Insurance.xls

ID mapping required

 

Insurance Group|Premium Waiver

entity _insurance _group

premium _waiver

 

PolicyProviderID

 

Insurance Group|Provider

entity _insurance _group

coy

Insurance.xlsx

Mapping for th ID required

 PolicyStartDate

 

Insurance Group|StartDate

entity _insurance _group

inception _date

 

 Premium

 

Insurance Group|Total Premiums Paid

entity _insurance _group

total _premium _paid

Insurance.xls

 


Cover

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

Notes

TPD

Trauma

IP

BE

Life

 

Risk|Sum Insured

entity_insurance

value

Insurance.xls

Life

 

Risk|Base Sum Insured

entity_insurance

base_sum _insured

 

PremiumBasis

 

InsuredIndividual

ID

Exclusions

 

Risk|Premium Structure

entity_insurance

premium _structure

Insurance.xls

ID mapping required

 

Risk|Life Insured

entity_insurance

life_insured

Insurance.xls

 

Risk|Exclusion Notes

entity_insurance

loading_exclusion _notes

 

 

Private Health Insurance

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

PrivateHealthInsurance

 

Risk-Medical|Cover under a Private Policy

entity

medical_private_cover

 

Notes and Attachments

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

Notes

 Created

 

Note|Date

entity_note

date

File note.xls

subject

 

Note|Subject

entity_note

subject

File note.xls

Text

 

Note|Text

entity_note

data

File note.xls

 

Risk Profile

Midwinter OS Screen Field Name

Midwinter OS Field Name

Screen Field Name

Group

Field Name

 Name

 

Portfolio Account|Investment Risk Profile

entity

risk_profile



Custom requirements

If you require any data to be converted that is outside the scope of this document, IRESS will be happy to assess the data and your specific requirement. If the conversion can be done IRESS will provide an estimate of the time it will take to complete the conversion and the associated cost. Please discuss any custom requirements with your Transition Consultant.

 

Appendices

Post conversion checking instructions

Once the conversion has taken place you will need to go through the data to ensure that everything has converted correctly. We recommend that you run a client list as well as check a 10-20 clients in full, comparing software to software where possible.

If any issues are discovered, the conversion analyst will need the following information to investigate and resolve the issues:

  • Client examples – experiencing the problem
  • New site screen shots – of the issue, a number if applicable
  • Original site screen shots – if you will no longer have access to your site, make sure to take screen shots of some sample client record 

This information will be submitted in the Feedback Form provided in Appendices F

The screen shots below illustrate how you should run your post conversion data check.

Run a ‘Client List’ management report:



This will allow you to produce a client list report to check all clients have converted.

Go through a client file from start to finish:





If IPS data has been converted:

Note: The default is to ONLY bring across manual data and for all datafeed data to be refreshed from inception post conversion.



 

Workstations recommended settings

The following are recommended settings for the Internet Explorer browser to access XPLAN.

  1. Start Internet Explorer and select Internet Options from the Tools menu. Make sure XPLAN is in the Trusted sites zone by:
  2. Select the Security tab, and click Trusted Sites.



  3. Click Sites. The Trusted Sites dialog box displays.
  4. Enter your XPLAN domain as it appears in your XPLAN site URL. For example, if your XPLAN site URL is https://mysite.xplan.iress.com.au, you should enter https://mysite.xplan.iress.com.au.
  5. Click Add. Your XPLAN domain will be added to the trusted Websites list.
  6. Click Close. The Trusted Sites dialog box closes and the new settings are saved.

 

Set the security level for Trusted Sites by:

  1. Ensure that Trusted sites is still selected and click Custom level.




  2. In the Reset to list, select Medium-Low, and then click Reset.
  3. In the Warning! dialog click Yes to confirm the change.
  4. Set Miscellaneous > Display Mixed Content to Enabled.
  5. Click OK. The Security Settings - Trusted Sites Zone dialog box closes.

    This also has the effect of enabling downloads, disabling the Pop-up blocker and disabling 
    the phishing filter, but only for XPLAN (and any other trusted sites) not general internet use.

  6. Activate the Advanced tab.
  7. In the Settings box, ensure that the following HTTP 1.1 settings are both ticked:
    • Use HTTP 1.1 
    • Use HTTP 1.1 through proxy connections.



  8. Press Ok. The settings are saved.

    You will need to exit and restart Internet Explorer.

 

Conversion feedback form 

Complete this form if you have identified an issue with your converted data and wish IRESS to investigate if there was a problem with the conversion.

Complete your XPLAN Transitions Conversion Feedback Form here

 

Conversion Sign Off Form

This form must be completed and returned to your transition consultant once you have checked your converted data in XPLAN and verified that all has been converted. In the absence of feedback, your conversion will be considered finalised after a period of ten working days.

Complete your XPLAN Transitions Data Conversion Sign Off Form here

 

 

 

IRESS Wealth Management | XPLAN Transitions | Platform to XPLAN Conversion Guide

 

    • Popular Articles

    • Wealth Axis Files - Naming Convention

      File Format: Date, Client Name, File Name Date - yymmdd E.g: 12 Sept 2013 - 130912 E.g: Undated - 010101 Client Names One Client / Only primary client (John Smith) E.g: Smith, J Two Clients (Primary and Secondary Client/Client and Partner) - Married ...
    • Wealth Axis Wizards - Overview

      Overview  This article is designed to help you effectively use the Wealth Axis Wizards in XPLAN. The key features of the Wealth Axis Wizards are: Integration with key modules such as Client Focus, Portfolios (IPS), Risk Researcher, WealthSolver and ...
    • New User Manual - Admin

      XPLAN and the Advice Process Overview Many advisers use the Advice to Client process to manage the advice process in their business. To enable participants to be able to relate to the different modules in XPLAN, this course is structured along the ...
    • Administration - Email: Setting up the Outlook Plugin

      Outlook Plugin - Overview  Outlook Plugin is a function available with XPLAN that allows you to quickly and easily save and record email correspondence in the XPLAN document library as a Note that is linked to a client or user entity. This allows for ...
    • XPLAN Workshop - XPLAN Client Setup

      Introduction Overview     Each practice deals with leads, referrals and potential clients differently. However, most practices have a system regarding the way client information is recorded and relationships with clients are managed. In this section, ...
    • Recent Articles

    • XPLAN Legislative Rates June 2022

      XPLAN Legislative Rates - June 2022 Legislative rates have been updated to reflect: 1. Social Security rates effective July 2022 2. AFSA Retirement Standard Benchmarks for the March Quarter 2022.  Social Security Rate Changes - July 2022 The rate ...
    • XPLAN: Task Notifications - Redirecting

      XPLAN: Redirecting Task Notifications XPLAN task notifications can be sent to your Email Inbox (e.g. Outllok, Gmail) to notify you if a task has been created, unactioned, is overdue or complete. If the task notifications cannot be turned off, then ...
    • XPLAN Version Enhancements - 18 November 2021 (Version 21.11.195)

      XPLAN Version Enhancements - 18 November 2021 (Version 21.11.195) Client Focus Digital Signature Notification will Honour the "Override from Address" when sent by Super User The notify signatories template configured in system settings > client focus ...
    • XPLAN Version Enhancements - November 2021 (Version 21.11.194)

      XPLAN Version Enhancements - November 2021 (Version 21.11.194) Client Focus New Current Residential Address Field A new field, current residential address, has been added to record a client’s current address. When entering the first address for a ...
    • XPLAN Datafeeds: HUB24 Enhancements (v4.3) 29 October 2021

      HUB24 Enhancements: 29 October 2021 HUB24 have released enhancements to their  XPLAN EPI 4.3 datafeeds, to be effective 15 November 2021. Below is the information directly from HUB24 on the enhancements. The Individual Holding extract is where the ...