Anika Goonewardena

Datafeed Troubleshooting

Blog Post created by Anika Goonewardena Employee on May 25, 2018

With the vast amount of data flowing daily through IPS, every now and again you may have encountered an issue with your datafeeds.  Once a datafeed issue is present there are a few steps that can be taken to identify and hopefully rectify the issue. The System Datafeed Troubleshooting Guide provides you with a comprehensive run down of how this can be performed.

However, there are a few common issues that we have seen all too regularly and therefore will be addressed in this article.

 

Date Locks

A date lock is a date set at either platform, adviser or account level to stop data prior to this date from flowing through.

Assuming that there is data available, a date lock against the provider or adviser will prevent data from flowing through to XPLAN. The below is how you will be able to identify if there is a date lock present.

 

Platform/Provider Data Lock

The datafeed will only import/update transactions that occurred after the Vendor lock which impacts every adviser/every account coming through on the platform.

The below path will guide you to the area where you can check to see if a Provider date lock is in place.

XPLAN >  Datafeed Functions > System Datafeeds > Configuration (Menu on the Left) > Select Provider

 

 

 

·          Observe the “Vendor Lock” > “Lock Date”

 

 

If this is empty, then no date lock is present. If there is a date, any transactions that took place before that date will not feed through into XPLAN and will not be updated into IPS.

 

Adviser Date Lock

 

The datafeed will only import/update transactions that occurred after the Adviser lock. This will impact every account coming through on the platform under that specific Adviser.

 

The below path will guide you to the area where you can check to see if an Adviser date lock is in place.

XPLAN > Datafeed Functions > System Datafeeds > Mappings (from the Menu on the left) > Advisers

 

Select a relevant provider and user to see if there is a lock present.

 

 

Account Date Lock

The datafeed will only import/update transactions that occurred after the Account lock (impacts every holding that is held within the specific account)

 

The below path will guide you to the area where you can check to see if an account date lock is in place.

Access a Client >Client Menu > Portfolios> Admin > Cash & Accounts

 

 The equivalent of no lock date is 1/01/1901 as there will not be any data pre this date.

 

If a date lock is present at any level given above and you wish to delete it, this can be achieved by unticking the date lock and saving the changes. Once removed  the data will be updated overnight when the feed refreshes. However, please note that removing date locks and refreshing the data will wipe out any manual adjustments made on an account

 

 

 

Adviser Mappings

The Datafeed Addendum on Insights will provide information on the specified format that a mapping needs to take for each adviser. 

The below path will guide you to the area where you can check the current Adviser Mapping.

 

XPLAN > Datafeed Functions > System Datafeeds > Mappings (from the Menu on the left) > Advisers

Please check the adviser mapping against instructions provided on the data feed addendum to ensure that it has been set up correctly.

 

 

Datafeed Refresh

Datafeeds will refresh overnight (usually between the hours of 9pm – 2am) and each time this occurs, new data should flow through to the site majority of the times. If the data is still out of balance, this may be because the feed has not refreshed. This can happen at both an account or vendor level so it is important to check as per instructions below.

 

Account Level

Access a Client > Client Menu > Portfolios > Admin > External Accounts

The “Last Updated” field should display a time that is no more than 24 hours old

 

Provider Level

XPLAN > Datafeed Functions > System Datafeeds > Reporting (from the Menu on the left) > Platform Summary

The last column will indicate when the feed for each particular provider was last updated (site wide).

 

If you are unable to identify or rectify the data feed issue with any of the steps provided above, please reach out to our support team on 13001300 69 or email the team on  xplansupport@iress.com.au.

Outcomes