Change the Get Data Filter from Monthly to Yearly
Jump to navigation
Jump to search
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
- Start Windows Explorer
- Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX
- Sort the files by Type
- Scroll down to the configuration files (ending in .ini)
- Each configuration Setting file relates to an end point in the MYOB API
- End points with date fields will contain a filter algorithm setting
- Open a file relating to the end point you wish to change
- Change the line FilterAlgorithm=DateRangeByMonth to FilterAlgorithm=DateRangeByYear
- Save and close the file
- Repeat for each end point you wish to change the setting for
- Run a full Get Data
This video runds through the process