Change the Get Data Filter from Monthly to Yearly

Overview

ODBClink extracts data from MYOB AccountRight Live as pages of xml data. Originally, the instruction to MYOB included a date filter which restricted data by year. Overtime we found that by restricting data further by month resolved some MYOB API Server issues, so we made the call to change the default filter to monthly. The unintentional consequence of this change is that it has slowed the get data down for some data files. If this is the case for you then follow the steps below to convert the get data date filter algorithm from Monthly to Yearly

Procedure

1. Start Windows Explorer
2. Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX
3. Sort the files by Type
4. Scroll down to the configuration files (ending in .ini)
5. Each configuration Setting file relates to an end point in the MYOB API
6. End points with date fields will contain a filter algorithm setting
7. Open a file relating to the end point you wish to change
8. Change the line FilterAlgorithm=DateRangeByMonth to FilterAlgorithm=DateRangeByYear
9. Save and close the file
10. Repeat for each end point you wish to change the setting for
11. Run a full Get Data

This video runds through the process

Click to load content

Getting Started with ODBClink