<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://accountingaddons.com.au/wiki/odbclink/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Jeff</id>
	<title>ODBClink wiki - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://accountingaddons.com.au/wiki/odbclink/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Jeff"/>
	<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Special:Contributions/Jeff"/>
	<updated>2026-05-20T07:27:36Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.36.1</generator>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_reduce_the_number_of_recors_per_page_to_100&amp;diff=2356</id>
		<title>How to reduce the number of recors per page to 100</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_reduce_the_number_of_recors_per_page_to_100&amp;diff=2356"/>
		<updated>2022-02-08T00:44:35Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;== Overview ==  The defult number of records retrieved per page for MYOB AcccountRight Live is 400. This generally works fine however if you have many lines on invoices it may...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
The defult number of records retrieved per page for MYOB AcccountRight Live is 400. This generally works fine however if you have many lines on invoices it may cause the MYOB API server to time out. If thats the case you will see a time out errer in the Get Data Log. To resolve that issue reduce the number of records from 400 to 100 and try the Get Data again.&lt;br /&gt;
&lt;br /&gt;
== How to reduce the number or records per page for MYOB AccountRight Live to 100==&lt;br /&gt;
&lt;br /&gt;
[[File:MYOBAccountRightLiveOptions.png|300px|thumb|right|MYOB AccountRight Live Options]]&lt;br /&gt;
&lt;br /&gt;
# Start '''ODBClink''';&lt;br /&gt;
# From the Menu screen, click on '''Settings''' tab in Excel's ribbon;&lt;br /&gt;
# Find the '''Options''' section and click the '''Set User Options''' button;&lt;br /&gt;
# Select '''MYOB AccountRight Live''' options from the dialogue;&lt;br /&gt;
# Edit the Records Per Page field to be 100;&lt;br /&gt;
# Click '''Save''' and '''Close''';&lt;br /&gt;
# Run the '''Get Data''' process.&lt;br /&gt;
&lt;br /&gt;
=== Notes ===&lt;br /&gt;
&lt;br /&gt;
* If the get data fails due to maximum number of connections reached, increasing the number of records per page can help.&lt;br /&gt;
&lt;br /&gt;
* We recommend making the number of records per page a multiple of 100 (e.g. 100, 200, 300). '''IT MUST''' be a number between 100 and 1000. &lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[Troubleshooting Get Data Problems with MYOB AccountRight Live]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Troubleshooting]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Troubleshooting_Get_Data_Problems_with_MYOB_AccountRight_Live&amp;diff=2355</id>
		<title>Troubleshooting Get Data Problems with MYOB AccountRight Live</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Troubleshooting_Get_Data_Problems_with_MYOB_AccountRight_Live&amp;diff=2355"/>
		<updated>2022-02-08T00:38:59Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Troubleshooting Guides */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
Read the following guides to correct any get data issues with [[MYOB AccountRight Live]].&lt;br /&gt;
&lt;br /&gt;
== MYOB AccountRight Live API ==&lt;br /&gt;
&lt;br /&gt;
For ODBClink or other third-party software to connect to your [[MYOB AccountRight Live|MYOB]] data file either on a '''local machine''' or on a '''server''', many components must be installed and running. &lt;br /&gt;
&lt;br /&gt;
Depending on which installer (PC or Server) used to install MYOB AccountRight Live, the MYOB API will be installed and running differently. See [[How to confirm if MYOB AccountRight Live was installed using the PC or Server Installation]] for more information.&lt;br /&gt;
&lt;br /&gt;
First, try [[Manually testing a connection to MYOB AccountRight Live| testing the MYOB AccountRight API]].&lt;br /&gt;
&lt;br /&gt;
If working, choose your installation location for further instruction.&lt;br /&gt;
* [[MYOB AccountRight Live API for PC installations]] &lt;br /&gt;
* [[MYOB AccountRight Live API for Server installations]]&lt;br /&gt;
&lt;br /&gt;
== MYOB AccountRight Live API for multiple installations ==&lt;br /&gt;
&lt;br /&gt;
For users who used have installed multiple versions of AccountRight Live and who may have used the PC installation (as opposed to Server installation) of the latest AccountRight Live, you may need to uninstall the old MYOB AccountRight Live API. For more information, see the following topic.&lt;br /&gt;
&lt;br /&gt;
* [[Uninstalling the MYOB AccountRight Live API]]&lt;br /&gt;
&lt;br /&gt;
== Issues ==&lt;br /&gt;
&lt;br /&gt;
The following articles may assist with various issues.&lt;br /&gt;
&lt;br /&gt;
* [[MYOB data file not present in list when browsing for data file]]&lt;br /&gt;
&lt;br /&gt;
== Error messages ==&lt;br /&gt;
&lt;br /&gt;
The following lists the known error messages when connecting to MYOB AccountRight Live.&lt;br /&gt;
&lt;br /&gt;
* [[Could not obtain the list of data files error message]]&lt;br /&gt;
* [[Access was denied to the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[Access was denied to ODBClink]]&lt;br /&gt;
* [[The MYOB AccountRight Live data file could not be found]]&lt;br /&gt;
* [[The MYOB AccountRight Live data file path is not entered]]&lt;br /&gt;
* [[The MYOB AccountRight Live data file must be upgraded]]&lt;br /&gt;
* [[The MYOB AccountRight Live server name is not entered]]&lt;br /&gt;
* [[The MYOB AccountRight Live server cannot be found]]&lt;br /&gt;
* [[The MY.MYOB login used to connect to the MYOB AccountRight Live data file is invalid]]&lt;br /&gt;
* [[The MYOB AccountRight Live API is not installed on the local machine or server]]&lt;br /&gt;
* [[The MYOB AccountRight Live API is not installed on the cloud]]&lt;br /&gt;
* [[The MYOB AccountRight Live API limits have been reached]]&lt;br /&gt;
* [[The MYOB AccountRight Live API request is invalid]]&lt;br /&gt;
* [[The application is not authorised to connect to the MYOB AccountRight Live API]]&lt;br /&gt;
* [[The data received from the MYOB AccountRight Live API was badly formed and could not be parsed]]&lt;br /&gt;
* [[The item could not be found within the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[The item was updated by another user within the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[The item was removed by another user within the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[The MYOB AccountRight Live API is corrupt and must be reinstalled]]&lt;br /&gt;
* [[The security protocol used to connect to MYOB AccountRight Live on the cloud is no longer supported]]&lt;br /&gt;
* [[ODBClink may not be compatible with your version of MYOB AccountRight Live]]&lt;br /&gt;
* [[Internal exception occurred in the MYOB AccountRight API]]&lt;br /&gt;
* [[Errors occurred creating Internet Explorer]]&lt;br /&gt;
* [[Unknown MYOB AccountRight Live Error]]&lt;br /&gt;
* [[An HTTP Server Error (500) occured in the MYOB AccountRight API]]&lt;br /&gt;
&lt;br /&gt;
== Troubleshooting Guides ==&lt;br /&gt;
&lt;br /&gt;
* [[How to increase the timeout length for MYOB AccountRight Live]]&lt;br /&gt;
* [[How to set the buffer size for MYOB AccountRight Live]]&lt;br /&gt;
* [[How to reduce the number of recors per page to 100]]&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[Troubleshooting Get Data Problems]]&lt;br /&gt;
&lt;br /&gt;
[[Category: Troubleshooting]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_restore_a_Data_Warehouse&amp;diff=2354</id>
		<title>How to restore a Data Warehouse</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_restore_a_Data_Warehouse&amp;diff=2354"/>
		<updated>2022-02-02T02:10:42Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
A Data Warehouse is a Database. If its an MS Access database its possible that it can get corrupted. If so it will generally show a message that it contains unreadable content. Restoring a data warehouse is a matter of locating a backup and then copying it into the Workspaces folder&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Go to the ODBClink\Workspaces\[Your Workspace] folder&lt;br /&gt;
# Cut the corrupt data base and paste it outside the ODBClink folder to keep it just in case&lt;br /&gt;
# Navigate go to Workspaces\Backups\Data Warehouses folder&lt;br /&gt;
# Copy the Backup of the data warehouse which was working last.&lt;br /&gt;
## Check the Get Data Logs to determine the last one which suceeded&lt;br /&gt;
# Paste it into the Workspaces\[Your Workspace] folder&lt;br /&gt;
# Re-run the get data process&lt;br /&gt;
&lt;br /&gt;
If that doesnt work, you might need to go back to a earlier backup&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_restore_a_Data_Warehouse&amp;diff=2353</id>
		<title>How to restore a Data Warehouse</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_restore_a_Data_Warehouse&amp;diff=2353"/>
		<updated>2022-02-02T02:10:09Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
A Data Warehouse is a Database. If its an MS Access database its possible that it can get corrupted. If so it will generally show a message that it contains unreadable content. Restoring a data warehouse is a matter of locating a backup and then copying it into the Workspaces folder&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Go to the ODBClink\Workspaces\[Your Workspace] folder&lt;br /&gt;
# Cut the corrupt data base and paste it outside the ODBClink folder to keep it just in case&lt;br /&gt;
# Navigate go to Workspaces\Backups\Data Warehouses folder&lt;br /&gt;
# Copy the Backup of the data warehouse which was working last.&lt;br /&gt;
## To see which one worked last check out the Get Data Logs for the last one which suceeded&lt;br /&gt;
# Paste it into the Workspaces\[Your Workspace] folder&lt;br /&gt;
# Re-run the get data process&lt;br /&gt;
&lt;br /&gt;
If that doesnt work, you might need to go back to a earlier backup&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_restore_a_Data_Warehouse&amp;diff=2352</id>
		<title>How to restore a Data Warehouse</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_restore_a_Data_Warehouse&amp;diff=2352"/>
		<updated>2022-02-02T02:09:14Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
A Data Warehouse is a Database. If its an MS Access database its possible that it can get corrupted. If so it will generally show a message that it contains unreadable content. Restoring a data warehouse is a matter of locating a backup and then copying it into the Workspaces folder&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Go to the ODBClink\Workspaces\[Your Workspace] folder&lt;br /&gt;
# Cut the corrupt data base and paste it outside the ODBClink folder to keep it just in case&lt;br /&gt;
# Navigate go to Workspaces\Backups\Data Warehouses folder&lt;br /&gt;
# Copy the Backup of the data warehouse which was working last.&lt;br /&gt;
# Paste it into the Workspaces\[Your Workspace] folder&lt;br /&gt;
# Re-run the get data process&lt;br /&gt;
&lt;br /&gt;
If that doesnt work, you might need to go back to a earlier backup&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Synchronised_Cloud_Folder&amp;diff=2335</id>
		<title>Synchronised Cloud Folder</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Synchronised_Cloud_Folder&amp;diff=2335"/>
		<updated>2021-07-10T03:38:59Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;br /&gt;
ODBClink can work in some synchronised cloud folders&lt;br /&gt;
&lt;br /&gt;
These include Dropbox, OneDrive or Sharepoint. &lt;br /&gt;
&lt;br /&gt;
It doesnt work from Google Drive yet. The reason is in order to make it work conflict files need to be removed via code and we haven't implemented that algorithm yet&lt;br /&gt;
&lt;br /&gt;
In order to work the folder must be synchronised to the local PC&lt;br /&gt;
&lt;br /&gt;
For OneDrive and Sharepoint, [[How to make ODBClink excel files work in OneDrive|turn off file collaboration]] before running ODBClink or create a mapped drive to ODBClink and open it that way. The Mapped drive forces the path be be C:\ rather than https://&lt;br /&gt;
&lt;br /&gt;
Once synchronised [[Run ODBClink for the first time from a new location|Run ODBClink for the first time from the new location]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouse_Tables&amp;diff=2317</id>
		<title>Data Warehouse Tables</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouse_Tables&amp;diff=2317"/>
		<updated>2021-02-09T01:33:27Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
Data Warehouse tables represent end points from either the MYOB or Xero API's&lt;br /&gt;
&lt;br /&gt;
ODBClink enables you to choose which tables you want populated during the Get Data Process&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# From the Edit Data Warehouse form, select the Tables tab&lt;br /&gt;
# Select or deselect tables to end up with the ones you want included in your data warehouse&lt;br /&gt;
# When done click Save&lt;br /&gt;
&lt;br /&gt;
== Related ==&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouse_Tables&amp;diff=2316</id>
		<title>Data Warehouse Tables</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouse_Tables&amp;diff=2316"/>
		<updated>2021-02-09T01:33:06Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Procedure */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
Data Warehouse tables represent end points from either the MYOB or Xero API's&lt;br /&gt;
&lt;br /&gt;
ODBClink enables you to choose which tables you want populated during the Get Data Process&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# From the Edit Data Warehouse form, select the Tables tab&lt;br /&gt;
# Select or deselect tables to end up with the ones you want included in your data warehouse&lt;br /&gt;
# When done click Save&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouse_Tables&amp;diff=2315</id>
		<title>Data Warehouse Tables</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouse_Tables&amp;diff=2315"/>
		<updated>2021-02-09T01:32:45Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;== Overview == Data Warehouse tables represent end points from either the MYOB or Xero API's  ODBClink enables you to choose which tables you want populated during the Get Dat...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
Data Warehouse tables represent end points from either the MYOB or Xero API's&lt;br /&gt;
&lt;br /&gt;
ODBClink enables you to choose which tables you want populated during the Get Data Process&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# From the Edit Data Warehouse form, select the Tables tab&lt;br /&gt;
# Select or deselect tables to end up with the ones you want included in your data warehouse&lt;br /&gt;
# CLick Save&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=ODBClink_v2020.11.3.300&amp;diff=2314</id>
		<title>ODBClink v2020.11.3.300</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=ODBClink_v2020.11.3.300&amp;diff=2314"/>
		<updated>2021-02-08T22:56:13Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Enhancements */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;ODBClink v2020.11.3.300 was released on 25/11/2020.&lt;br /&gt;
&lt;br /&gt;
== Enhancements ==&lt;br /&gt;
&lt;br /&gt;
'''MYOB AccountRight Live'''&lt;br /&gt;
* Enhanced MYOB conversion routine to create OX for converted sales orders and purchase orders.&lt;br /&gt;
* Resolve issue with OrderType field not being populate for MYOX_SalesOrder tables.&lt;br /&gt;
* Updated MYOX_JournalTransactions table to download data year-by-year instead of month-by-month.&lt;br /&gt;
* Updated MYOX_JournalTransactions table to download data using json format instead of xml format.&lt;br /&gt;
* Updated MYOX_Sales tables to download data year-by-year instead of month-by-month.&lt;br /&gt;
* Updated MYOX_Sales tables to download data using json format instead of xml format.&lt;br /&gt;
* Resolves the Server 500 Error due to extracting company information in json format&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[ODBClink version archive]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=An_HTTP_Server_Error_(500)_occured_in_the_MYOB_AccountRight_API&amp;diff=2313</id>
		<title>An HTTP Server Error (500) occured in the MYOB AccountRight API</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=An_HTTP_Server_Error_(500)_occured_in_the_MYOB_AccountRight_API&amp;diff=2313"/>
		<updated>2021-02-02T01:07:17Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;== Overview ==  Since September 2020 the MYOB API server has been returning server errors intermittently for some data files  Upon investigation we found that this occurs when...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
Since September 2020 the MYOB API server has been returning server errors intermittently for some data files&lt;br /&gt;
&lt;br /&gt;
Upon investigation we found that this occurs when returning a list of data files in xml format. The error does not occur when extracting the data in jsn format&lt;br /&gt;
&lt;br /&gt;
The latest version of BudgetLink gets around the issue by extracting the list of data files in jsn format&lt;br /&gt;
&lt;br /&gt;
== Solution ==&lt;br /&gt;
&lt;br /&gt;
[[Upgrading ODBClink|Upgrade to the latest version of ODBClink]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Troubleshooting_Get_Data_Problems_with_MYOB_AccountRight_Live&amp;diff=2312</id>
		<title>Troubleshooting Get Data Problems with MYOB AccountRight Live</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Troubleshooting_Get_Data_Problems_with_MYOB_AccountRight_Live&amp;diff=2312"/>
		<updated>2021-02-02T01:06:22Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Error messages */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
Read the following guides to correct any get data issues with [[MYOB AccountRight Live]].&lt;br /&gt;
&lt;br /&gt;
== MYOB AccountRight Live API ==&lt;br /&gt;
&lt;br /&gt;
For ODBClink or other third-party software to connect to your [[MYOB AccountRight Live|MYOB]] data file either on a '''local machine''' or on a '''server''', many components must be installed and running. &lt;br /&gt;
&lt;br /&gt;
Depending on which installer (PC or Server) used to install MYOB AccountRight Live, the MYOB API will be installed and running differently. See [[How to confirm if MYOB AccountRight Live was installed using the PC or Server Installation]] for more information.&lt;br /&gt;
&lt;br /&gt;
First, try [[Manually testing a connection to MYOB AccountRight Live| testing the MYOB AccountRight API]].&lt;br /&gt;
&lt;br /&gt;
If working, choose your installation location for further instruction.&lt;br /&gt;
* [[MYOB AccountRight Live API for PC installations]] &lt;br /&gt;
* [[MYOB AccountRight Live API for Server installations]]&lt;br /&gt;
&lt;br /&gt;
== MYOB AccountRight Live API for multiple installations ==&lt;br /&gt;
&lt;br /&gt;
For users who used have installed multiple versions of AccountRight Live and who may have used the PC installation (as opposed to Server installation) of the latest AccountRight Live, you may need to uninstall the old MYOB AccountRight Live API. For more information, see the following topic.&lt;br /&gt;
&lt;br /&gt;
* [[Uninstalling the MYOB AccountRight Live API]]&lt;br /&gt;
&lt;br /&gt;
== Issues ==&lt;br /&gt;
&lt;br /&gt;
The following articles may assist with various issues.&lt;br /&gt;
&lt;br /&gt;
* [[MYOB data file not present in list when browsing for data file]]&lt;br /&gt;
&lt;br /&gt;
== Error messages ==&lt;br /&gt;
&lt;br /&gt;
The following lists the known error messages when connecting to MYOB AccountRight Live.&lt;br /&gt;
&lt;br /&gt;
* [[Could not obtain the list of data files error message]]&lt;br /&gt;
* [[Access was denied to the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[Access was denied to ODBClink]]&lt;br /&gt;
* [[The MYOB AccountRight Live data file could not be found]]&lt;br /&gt;
* [[The MYOB AccountRight Live data file path is not entered]]&lt;br /&gt;
* [[The MYOB AccountRight Live data file must be upgraded]]&lt;br /&gt;
* [[The MYOB AccountRight Live server name is not entered]]&lt;br /&gt;
* [[The MYOB AccountRight Live server cannot be found]]&lt;br /&gt;
* [[The MY.MYOB login used to connect to the MYOB AccountRight Live data file is invalid]]&lt;br /&gt;
* [[The MYOB AccountRight Live API is not installed on the local machine or server]]&lt;br /&gt;
* [[The MYOB AccountRight Live API is not installed on the cloud]]&lt;br /&gt;
* [[The MYOB AccountRight Live API limits have been reached]]&lt;br /&gt;
* [[The MYOB AccountRight Live API request is invalid]]&lt;br /&gt;
* [[The application is not authorised to connect to the MYOB AccountRight Live API]]&lt;br /&gt;
* [[The data received from the MYOB AccountRight Live API was badly formed and could not be parsed]]&lt;br /&gt;
* [[The item could not be found within the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[The item was updated by another user within the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[The item was removed by another user within the MYOB AccountRight Live data file]]&lt;br /&gt;
* [[The MYOB AccountRight Live API is corrupt and must be reinstalled]]&lt;br /&gt;
* [[The security protocol used to connect to MYOB AccountRight Live on the cloud is no longer supported]]&lt;br /&gt;
* [[ODBClink may not be compatible with your version of MYOB AccountRight Live]]&lt;br /&gt;
* [[Internal exception occurred in the MYOB AccountRight API]]&lt;br /&gt;
* [[Errors occurred creating Internet Explorer]]&lt;br /&gt;
* [[Unknown MYOB AccountRight Live Error]]&lt;br /&gt;
* [[An HTTP Server Error (500) occured in the MYOB AccountRight API]]&lt;br /&gt;
&lt;br /&gt;
== Troubleshooting Guides ==&lt;br /&gt;
&lt;br /&gt;
* [[How to increase the timeout length for MYOB AccountRight Live]]&lt;br /&gt;
* [[How to set the buffer size for MYOB AccountRight Live]]&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[Troubleshooting Get Data Problems]]&lt;br /&gt;
&lt;br /&gt;
[[Category: Troubleshooting]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Moving_ODBClink_to_a_new_machine_or_folder&amp;diff=2303</id>
		<title>Moving ODBClink to a new machine or folder</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Moving_ODBClink_to_a_new_machine_or_folder&amp;diff=2303"/>
		<updated>2020-12-21T01:19:25Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
If you have ODBClink on a Server which is decommissioned and wish to move it to a new one or its installed on a PC and you will need to use it from another then follow the instructions below to move ODBClink&lt;br /&gt;
&lt;br /&gt;
The first step is to work out where ODBClink is installed. The default path is C:\ODBClink for a PC. If not sure you can locate the path by tracing the shortcut on your desktop. &lt;br /&gt;
&lt;br /&gt;
If its installed on a shared folder on your server and your new PC is located in the office then all you need to do is navigate to that folder from the new PC and run the ODBClink.exe from the new PC. The first time its run from that new location a setup wizard will start to capture setup instructions. &lt;br /&gt;
&lt;br /&gt;
If located on your local PC then you need to move that copy to your new machine rather than install a new version of ODBClink. To move ODBClink, cut and paste the [[ODBClink Folder]] to the new location. &lt;br /&gt;
&lt;br /&gt;
If you require ODBClink to be shared with an additional user then move the [[ODBClink Folder]] to a shared folder.&lt;br /&gt;
&lt;br /&gt;
If you require access to ODBClink from multiple PC's not connected to the office then move the [[ODBClink Folder]] to a [[Syncronised Folder]]&lt;br /&gt;
&lt;br /&gt;
Here are the steps to move ODBClink from one location to another&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
[[File:MoveBudgetLinkWelcomeWindow.png|300px|thumb|right|ODBClink welcome dialogue]]&lt;br /&gt;
[[File:MoveBudgetLinkRegistrationKeyDialogue.png|300px|thumb|right|Registration key dialogue]]&lt;br /&gt;
&lt;br /&gt;
# Locate the existing [[ODBClink Folder]];&lt;br /&gt;
# Cut (or Copy) and paste it to the new location;&lt;br /&gt;
# Enable user access to ODBClink folders&lt;br /&gt;
# Start ODBClink in the new location by double clicking the BudgetLink.exe file within the [[ODBClink Folder]];&lt;br /&gt;
A New User Setup Wizard will start.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
ODBClink should now be useable on the new machine. Be mindful you may need to update your data connection. See [[Changing how ODBClink connects to your data file]] for more information.&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=ODBClink_crashes_at_startup_on_first_use&amp;diff=2302</id>
		<title>ODBClink crashes at startup on first use</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=ODBClink_crashes_at_startup_on_first_use&amp;diff=2302"/>
		<updated>2020-12-15T23:20:49Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;== Overview == We have found that after upgrading, ODBClink will crash upon starting for the first time  == Procedure ==  Open Excel Disable all Addins Close Excel Restart ODB...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
We have found that after upgrading, ODBClink will crash upon starting for the first time&lt;br /&gt;
&lt;br /&gt;
== Procedure == &lt;br /&gt;
Open Excel&lt;br /&gt;
Disable all Addins&lt;br /&gt;
Close Excel&lt;br /&gt;
Restart ODBClink&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Troubleshooting_Start-Up_Problems&amp;diff=2301</id>
		<title>Troubleshooting Start-Up Problems</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Troubleshooting_Start-Up_Problems&amp;diff=2301"/>
		<updated>2020-12-15T23:17:26Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The purpose of this page is to list various topics that will assist you in solving start-up related problems.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* [[ODBClink opens but doesn't start]]&lt;br /&gt;
* [[ODBClink starts but shows error occurred during load]]&lt;br /&gt;
* [[ODBClink starts but shows a compile error message]]&lt;br /&gt;
* [[ODBClink starts but complain about the version of Microsoft Excel]]&lt;br /&gt;
* [[ODBClink starts but complains about files being read-only]]&lt;br /&gt;
* [[ODBClink starts but complains about read or write permissions]]&lt;br /&gt;
* [[ODBClink starts but complains about the installer path being too long]]&lt;br /&gt;
* [[ODBClink starts but complains about being installed on a network location]]&lt;br /&gt;
* [[ODBClink starts but complains about running on a terminal server]]&lt;br /&gt;
* [[ODBClink starts but complains about running from within Dropbox]]&lt;br /&gt;
* [[ODBClink crashes at startup on first use]]&lt;br /&gt;
* [[Installing the ODBClink ribbon]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
[[Troubleshooting]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Upgrading_ODBClink&amp;diff=2300</id>
		<title>Upgrading ODBClink</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Upgrading_ODBClink&amp;diff=2300"/>
		<updated>2020-12-14T02:45:30Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
This article assists '''existing users''' upgrading ODBClink to the latest version.&lt;br /&gt;
&lt;br /&gt;
If you are a '''new user''' and wish to install ODBClink, see [[Installing ODBClink]] instead.&lt;br /&gt;
&lt;br /&gt;
ODBClink's upgrade process transfers any settings from your old installation to the new one. If you have custom solutions or reports, they will be transferred during the process. Note that you may also need to configure ODBClink for any new features.&lt;br /&gt;
&lt;br /&gt;
To upgrade to the latest version follow the steps below.&lt;br /&gt;
&lt;br /&gt;
== Upgrading ODBClink ==&lt;br /&gt;
&lt;br /&gt;
[[File:InstallODBClink.png|300px|thumb|right|Unzip ODBClink]] &lt;br /&gt;
[[File:InstallODBClinkWelcome.png |300px|thumb|right|Accept the EULA]] &lt;br /&gt;
[[File:InstallODBClinkUpgradeOrNew.png |300px|thumb|right|Choose Upgrade]] &lt;br /&gt;
[[File:InstallODBClinkUpgradeLocation.png |300px|thumb|right|Confirm the old version installation]] &lt;br /&gt;
[[File:InstallODBClinkUpgradeReports.png |300px|thumb|right|Confirm reports to upgrade]] &lt;br /&gt;
[[File:InstallODBClinkUpgradeDataWarehouses.png |300px|thumb|right|Confirm data warehouses to upgrade]] &lt;br /&gt;
[[File:InstallODBClinkUpgradeFinal.png |300px|thumb|right|Start ODBClink]] &lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# Click the '''Upgrade''' button on the menu to see if a new version of ODBClink is available;&lt;br /&gt;
# From the website, [[Downloading ODBClink|download ODBClink]];&lt;br /&gt;
# To start the WinZip self extractor, click '''Install_ODBClink...exe''' and choose '''Run'''. It may be located at the bottom of your Browser;&lt;br /&gt;
# On the '''Winzip Self Extractor - Install_ODBClink...exe''' form, click '''Unzip''';&lt;br /&gt;
# Click '''OK''' once the unzip is successful;&lt;br /&gt;
# On the '''Welcome to ODBClink...''' window, read the User License Agreement and '''tick the checkbox''' if you accept them, then click '''Next''';&lt;br /&gt;
# Tick the '''Upgrade Installation''' checkbox and then click '''Next''';&lt;br /&gt;
# Confirm that you are upgrading the correct version and if not click '''Select''' to choose the old version of ODBClink and then click '''Next''';&lt;br /&gt;
# If upgrading from very old versions of ODBClink, enter a name for your organisation which will be used as the name of the [[Workspaces|workspace]];&lt;br /&gt;
# '''Tick or untick''' the reports to confirm which ones to upgrade, then click '''Next''';&lt;br /&gt;
# '''Tick or untick''' the data warehouses to confirm which ones to upgrade, then click '''Install''';&lt;br /&gt;
# Once the installation is complete click '''Start'''.&lt;br /&gt;
&lt;br /&gt;
=== Notes ===&lt;br /&gt;
* Older users of ODBClink may need to manually download the latest version as the check for upgrade functionality was not available.&lt;br /&gt;
&lt;br /&gt;
* The upgrade process only needs to be done by a single user if installed in a shared location that others can access.&lt;br /&gt;
&lt;br /&gt;
== Related Links ==&lt;br /&gt;
* [[Getting Started Guide]]&lt;br /&gt;
* [[Downloading ODBClink]]&lt;br /&gt;
* [http://accountingaddons.com.au/services/consulting-and-support/ Support]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Auto_Upload&amp;diff=2299</id>
		<title>Auto Upload</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Auto_Upload&amp;diff=2299"/>
		<updated>2020-12-02T04:46:04Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* How to set up Auto Upload */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
Auto Upload is a function that runs the [[Get Data]] process on a schedule. The main purpose of Auto Upload is to remove the manual running of the [[Get Data]] process and to move the processing to a non-productive time such as overnight.&lt;br /&gt;
&lt;br /&gt;
== Prerequisits ==&lt;br /&gt;
&lt;br /&gt;
Before setting up auto upload action the following steps first&lt;br /&gt;
&lt;br /&gt;
==== Enable Workspaces for Auto Upload ====&lt;br /&gt;
Make sure that each workspace you wish to run is enabled for Auto Upload&lt;br /&gt;
&lt;br /&gt;
To do this, go back to the Main Menu, click Workspace, then edit your workspace and make sure the Enable Auto Uplaod is ticked&lt;br /&gt;
&lt;br /&gt;
==== Test the Auto Upload can be run manually ====&lt;br /&gt;
&lt;br /&gt;
Test the Auto Upload manually to ensure it is running correctly. For more information, see [[Test the Auto Upload can be run manually]].&lt;br /&gt;
&lt;br /&gt;
== How to set up Auto Upload ==&lt;br /&gt;
&lt;br /&gt;
To setup Auto Upload, please follow these instructions. Note that these instructions are dependant on the version of windows you run and may vary slightly. It is also highly recommended that you get your IT personnel to setup the scheduled task. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
# Click '''Start''', then '''Control Panel''', then '''Administrative Tools''', then '''Task Scheduler''';&lt;br /&gt;
# In the Task Scheduler form, select '''Create Basic Task''';&lt;br /&gt;
# Enter a '''Name''' for the task (for example ODBClink Get Data) and click '''Next''';&lt;br /&gt;
# In the Task Trigger form, select the '''period''' for the Auto Upload to occur and click '''Next''';&lt;br /&gt;
# In the Daily form, enter the '''Start date and time''' that the first Auto Upload will occur and click '''Next''';&lt;br /&gt;
# In the Action form, select '''Start a program''' and click '''Next''';&lt;br /&gt;
# In the Start a Program form, click '''Browse…''' and select the '''AddonsLink.GetData.exe''' file in the ODBClink System folder and click '''Open'''. The path will display in the Program/script field. Click '''Next''';&lt;br /&gt;
# In the Summary form, select '''Open the Properties dialog for this task when I click Finish''' and click '''Finish''';&lt;br /&gt;
# In the General tab, select '''Run whether user is logged on or not'''. If you do not have Administrator rights then click '''Change User or Group…''' and change the user to be the Administrator. Click the '''Actions''' tab;&lt;br /&gt;
# In the Settings tab, tick the checkbox '''Stop the task if it runs longer than:''' and choose '''2 hours''' in the dropdown next to it;&lt;br /&gt;
# In the Settings tab, tick the checkbox '''If the running task does not end when requested, force it to stop''';&lt;br /&gt;
# In the Actions tab, click Edit;&lt;br /&gt;
# In the Program/script field, ensure that the path is a UNC path and not a mapped drive. A UNC path begins with the server name. Click '''OK''' to close the Edit Action dialog box and click OK to close the Properties dialog box. Enter your password if required.&lt;br /&gt;
# To test the Auto Upload process, select '''Task Scheduler Library''' to the left of the Task Scheduler form. Select the Auto Upload task and click '''Run'''.&lt;br /&gt;
&lt;br /&gt;
=== Notes ===&lt;br /&gt;
&lt;br /&gt;
* When choosing a time to run the auto upload process, ensure your chosen time does not conflict with backups or other system processes.&lt;br /&gt;
&lt;br /&gt;
* When browsing to the '''AddonsLink.GetData.exe''' file, ensure that the path is a UNC path and not a mapped drive. A UNC path begins with the server name.&lt;br /&gt;
&lt;br /&gt;
* For older versions of ODBClink, you will need to browse to the '''Excel.exe''' and include the UNC path to the '''AutoUpload.xls''' file located in the system folder.&lt;br /&gt;
&lt;br /&gt;
== Test the Auto Upload Scheduled Task is configured correctly ==&lt;br /&gt;
&lt;br /&gt;
Once the Auto Upload Scheduled tasks is configured, we recommend you test it. For more information, see [[Test the Auto Upload Scheduled Task is configured correctly]].&lt;br /&gt;
&lt;br /&gt;
== Troubleshooting the Auto Upload Scheduled Task ==&lt;br /&gt;
&lt;br /&gt;
If the Auto Upload scheduled task does not run or does not finish, see [[Troubleshooting Auto Upload Problems]].&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[Get Data]]&lt;br /&gt;
* [[Troubleshooting Auto Upload Problems]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2292</id>
		<title>How To Guides</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2292"/>
		<updated>2020-11-19T02:21:31Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Miscellaneous Guides */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
The following How To Guides can assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== Setup Guides ==&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[How to install custom report]]&lt;br /&gt;
* [[Adding a data file connection]]&lt;br /&gt;
* [[How to add tables to the Default Data Warehouse]]&lt;br /&gt;
* [[Adding a data warehouse]]&lt;br /&gt;
* [[How to filter company data in a Multi Company Data Warehouse]]&lt;br /&gt;
* [[Creating a DSN to a data warehouse]]&lt;br /&gt;
* [[How to Share ODBClink with Multiple Users]]&lt;br /&gt;
* [[How to Share ODBClink with Drop Box]]&lt;br /&gt;
* [[How to Share ODBClink on Network | How to Share ODBClink on a Network]]&lt;br /&gt;
* [[How to access ODBClink from another PC at home]]&lt;br /&gt;
&lt;br /&gt;
== Data Files ==&lt;br /&gt;
&lt;br /&gt;
* [[How to choose the data files for which to get data]]&lt;br /&gt;
&lt;br /&gt;
== Installation Guides ==&lt;br /&gt;
* [[Moving ODBClink to a new machine or folder|How to move ODBClink to a new machine or folder]]&lt;br /&gt;
* [[How to uninstall ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Miscellaneous Guides ==&lt;br /&gt;
* [[How to update ODBClink to point to moved or renamed MYOB data file]]&lt;br /&gt;
* [[How to move ODBClink to a new Computer]]&lt;br /&gt;
* [[How to Optimise the Get Data]]&lt;br /&gt;
&lt;br /&gt;
== Backup ==&lt;br /&gt;
* [[How to setup the default backup folder]]&lt;br /&gt;
* [[How to restore a Data Warehouse]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_Optimise_the_Get_Data&amp;diff=2291</id>
		<title>How to Optimise the Get Data</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_Optimise_the_Get_Data&amp;diff=2291"/>
		<updated>2020-11-19T02:20:33Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;*Change the Get Data Filter from Monthly to Yearly *Reduce the amount of data being pulled&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;*[[Change the Get Data Filter from Monthly to Yearly]]&lt;br /&gt;
*[[Reduce the amount of data being pulled]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2290</id>
		<title>How To Guides</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2290"/>
		<updated>2020-11-19T02:19:57Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Miscellaneous Guides */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
The following How To Guides can assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== Setup Guides ==&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[How to install custom report]]&lt;br /&gt;
* [[Adding a data file connection]]&lt;br /&gt;
* [[How to add tables to the Default Data Warehouse]]&lt;br /&gt;
* [[Adding a data warehouse]]&lt;br /&gt;
* [[How to filter company data in a Multi Company Data Warehouse]]&lt;br /&gt;
* [[Creating a DSN to a data warehouse]]&lt;br /&gt;
* [[How to Share ODBClink with Multiple Users]]&lt;br /&gt;
* [[How to Share ODBClink with Drop Box]]&lt;br /&gt;
* [[How to Share ODBClink on Network | How to Share ODBClink on a Network]]&lt;br /&gt;
* [[How to access ODBClink from another PC at home]]&lt;br /&gt;
&lt;br /&gt;
== Data Files ==&lt;br /&gt;
&lt;br /&gt;
* [[How to choose the data files for which to get data]]&lt;br /&gt;
&lt;br /&gt;
== Installation Guides ==&lt;br /&gt;
* [[Moving ODBClink to a new machine or folder|How to move ODBClink to a new machine or folder]]&lt;br /&gt;
* [[How to uninstall ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Miscellaneous Guides ==&lt;br /&gt;
* [[How to update ODBClink to point to moved or renamed MYOB data file]]&lt;br /&gt;
* [[How to move ODBClink to a new Computer]]&lt;br /&gt;
* [[How to change Optimise the Get Data]]&lt;br /&gt;
* [[How to Optimise the Get Data]]&lt;br /&gt;
&lt;br /&gt;
== Backup ==&lt;br /&gt;
* [[How to setup the default backup folder]]&lt;br /&gt;
* [[How to restore a Data Warehouse]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2289</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2289"/>
		<updated>2020-11-17T23:07:58Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
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&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2288</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2288"/>
		<updated>2020-11-17T23:07:25Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRight Live as pages of xml data. Originally, ODBClink's 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&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2287</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2287"/>
		<updated>2020-11-17T23:06:40Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRight Live as pages of xml data. Originally, ODBClink's instruction to MYOB included a date filter which restricted data by year. Overtime we found that by restricting data 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&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2286</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2286"/>
		<updated>2020-11-17T23:04:25Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRight Live as pages of xml data. The initial instruction to MYOB included a filter which defined the date range to extract data for to be yearly. Overtime we found that changing the date filter to Monthly 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&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2285</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2285"/>
		<updated>2020-11-17T23:02:34Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The initial instruction to MYOB included a fitler which defined the date range to extract data for to be yearly. Overtime we found that changing the date filter to Monthly 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&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2284</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2284"/>
		<updated>2020-11-17T23:01:33Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The initial instruction to MYOB included a fitler which defined the date range to extract data for to be yearly. Overtime we found that changing the date filter to Monthly 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 you then follow the steps below to convert the get data date filter algorithm from Monthly to Yearly&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2283</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2283"/>
		<updated>2020-11-17T09:23:12Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The instruction to MYOB includes a fitler which defines the range of data to extract data for. Initially we set this filter to be yearly. Overtime we found that some data files returned server errors and after testing found that changing the date filter to Monthly resolved the issue. So we made teh call to change the data filter to monthly for most of the date based end points which were likely to contain many records. The unintentional consequence of this change is that it does slow the get data down for some data files. If this is you then follow the steps below to convert the get data date filter algorithm from Monthly to Yearly&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This video runds through the process&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2282</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2282"/>
		<updated>2020-11-17T09:22:45Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The instruction to MYOB includes a fitler which defines the range of data to extract data for. Initially we set this filter to be yearly. Overtime we found that some data files returned server errors and after testing found that changing the date filter to Monthly resolved the issue. So we made teh call to change the data filter to monthly for most of the date based end points which were likely to contain many records. The unintentional consequence of this change is that it does slow the get data down for some data files. If this is you then follow the steps below to convert the get data date filter algorithm from Monthly to Yearly&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;br /&gt;
&lt;br /&gt;
This getting started video provides an overview of ODBClink.&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|Z2S98tKnp18|560|left|Getting Started with ODBClink}}&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2281</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2281"/>
		<updated>2020-11-17T09:13:51Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Procedure */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The instruction to MYOB includes a fitler which defines the range of data to extract data for. Initially we set this filter to be yearly. Overtime we found that some data files returned server errors and after testing found that changing the date filter to Monthly resolved the issue. So we made teh call to change the data filter to monthly for most of the date based end points which were likely to contain many records. The unintentional consequence of this change is that it does slow the get data down for some data files. If this is you then follow the steps below to convert the get data date filter algorithm from Monthly to Yearly&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a full [[Get Data]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2280</id>
		<title>Change the Get Data Filter from Monthly to Yearly</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Change_the_Get_Data_Filter_from_Monthly_to_Yearly&amp;diff=2280"/>
		<updated>2020-11-17T09:13:26Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;== Overview == ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The instruction to MYOB includes a fitler which defines the range of data to extract d...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
ODBClink extracts data from MYOB AccountRighth Live as pages of xml data. The instruction to MYOB includes a fitler which defines the range of data to extract data for. Initially we set this filter to be yearly. Overtime we found that some data files returned server errors and after testing found that changing the date filter to Monthly resolved the issue. So we made teh call to change the data filter to monthly for most of the date based end points which were likely to contain many records. The unintentional consequence of this change is that it does slow the get data down for some data files. If this is you then follow the steps below to convert the get data date filter algorithm from Monthly to Yearly&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
# Start Windows Explorer&lt;br /&gt;
# Navigate to the ODBClink\[Current Version]\Resources\Data Files\Interfaces\MYOX&lt;br /&gt;
# Sort the files by Type&lt;br /&gt;
# Scroll down to the configuration files (ending in .ini)&lt;br /&gt;
# Each configuration Setting file relates to an end point in the MYOB API&lt;br /&gt;
# End points with date fields will contain a filter algorithm setting&lt;br /&gt;
# Open a file relating to the end point you wish to change&lt;br /&gt;
# Change the line '''FilterAlgorithm=DateRangeByMonth''' to '''FilterAlgorithm=DateRangeByYear'''&lt;br /&gt;
# Save and close the file&lt;br /&gt;
# Repeat for each end point you wish to change the setting for&lt;br /&gt;
# Run a [[Full Get Data]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2278</id>
		<title>How To Guides</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2278"/>
		<updated>2020-11-17T09:02:16Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Miscellaneous Guides */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
The following How To Guides can assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== Setup Guides ==&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[How to install custom report]]&lt;br /&gt;
* [[Adding a data file connection]]&lt;br /&gt;
* [[How to add tables to the Default Data Warehouse]]&lt;br /&gt;
* [[Adding a data warehouse]]&lt;br /&gt;
* [[How to filter company data in a Multi Company Data Warehouse]]&lt;br /&gt;
* [[Creating a DSN to a data warehouse]]&lt;br /&gt;
* [[How to Share ODBClink with Multiple Users]]&lt;br /&gt;
* [[How to Share ODBClink with Drop Box]]&lt;br /&gt;
* [[How to Share ODBClink on Network | How to Share ODBClink on a Network]]&lt;br /&gt;
* [[How to access ODBClink from another PC at home]]&lt;br /&gt;
&lt;br /&gt;
== Data Files ==&lt;br /&gt;
&lt;br /&gt;
* [[How to choose the data files for which to get data]]&lt;br /&gt;
&lt;br /&gt;
== Installation Guides ==&lt;br /&gt;
* [[Moving ODBClink to a new machine or folder|How to move ODBClink to a new machine or folder]]&lt;br /&gt;
* [[How to uninstall ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Miscellaneous Guides ==&lt;br /&gt;
* [[How to update ODBClink to point to moved or renamed MYOB data file]]&lt;br /&gt;
* [[How to move ODBClink to a new Computer]]&lt;br /&gt;
* [[How to change Optimise the Get Data]]&lt;br /&gt;
&lt;br /&gt;
== Backup ==&lt;br /&gt;
* [[How to setup the default backup folder]]&lt;br /&gt;
* [[How to restore a Data Warehouse]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2277</id>
		<title>How To Guides</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_To_Guides&amp;diff=2277"/>
		<updated>2020-11-17T09:01:07Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
The following How To Guides can assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== Setup Guides ==&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[How to install custom report]]&lt;br /&gt;
* [[Adding a data file connection]]&lt;br /&gt;
* [[How to add tables to the Default Data Warehouse]]&lt;br /&gt;
* [[Adding a data warehouse]]&lt;br /&gt;
* [[How to filter company data in a Multi Company Data Warehouse]]&lt;br /&gt;
* [[Creating a DSN to a data warehouse]]&lt;br /&gt;
* [[How to Share ODBClink with Multiple Users]]&lt;br /&gt;
* [[How to Share ODBClink with Drop Box]]&lt;br /&gt;
* [[How to Share ODBClink on Network | How to Share ODBClink on a Network]]&lt;br /&gt;
* [[How to access ODBClink from another PC at home]]&lt;br /&gt;
&lt;br /&gt;
== Data Files ==&lt;br /&gt;
&lt;br /&gt;
* [[How to choose the data files for which to get data]]&lt;br /&gt;
&lt;br /&gt;
== Installation Guides ==&lt;br /&gt;
* [[Moving ODBClink to a new machine or folder|How to move ODBClink to a new machine or folder]]&lt;br /&gt;
* [[How to uninstall ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Miscellaneous Guides ==&lt;br /&gt;
* [[How to update ODBClink to point to moved or renamed MYOB data file]]&lt;br /&gt;
* [[How to move ODBClink to a new Computer]]&lt;br /&gt;
&lt;br /&gt;
== Backup ==&lt;br /&gt;
* [[How to setup the default backup folder]]&lt;br /&gt;
* [[How to restore a Data Warehouse]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_change_the_numbers_of_financial_years_available_in_ODBClink&amp;diff=2276</id>
		<title>How to change the numbers of financial years available in ODBClink</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_change_the_numbers_of_financial_years_available_in_ODBClink&amp;diff=2276"/>
		<updated>2020-11-13T07:33:53Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Overview */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
OBClink (Standard &amp;amp; Pro Editions) have a the ability to can download data up to 10 financial years into the past and future.&lt;br /&gt;
The option is configurable because the trade off of extracting more data is the increase in time the get data takes and so best practise is to only choose the years which contain data you actually need. The default is 1 year history and 1 year into the future based on the the current date. The date rolls forward on 3 months past the end of the financial year. ie if the date is 13Aug20 the financial year will be considered 2020. When the date roles to 1Oct20 then the current financial year will be considered 2021&lt;br /&gt;
&lt;br /&gt;
Note: ODBClink Free Edition is fixed at 3 financial years.&lt;br /&gt;
&lt;br /&gt;
== How to change the numbers of financial years available in ODBClink ==&lt;br /&gt;
[[File:YearOptions.png|300px|thumb|right|Year options in the Options dialogue]] &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
To change the number of financial years to download data, follow these steps.&lt;br /&gt;
&lt;br /&gt;
# From the ODBClink main menu, click on '''30. Settings''';&lt;br /&gt;
# Click on '''Options''';&lt;br /&gt;
# Click on the '''Set User Options''' button;&lt;br /&gt;
# From the options dialogue, select the '''Years''' item in the left-hand list;&lt;br /&gt;
# Change the '''Number of Prior Years to get data''' to the desired value;&lt;br /&gt;
# Change the '''Number of Future Years to get data''' to the desired value;&lt;br /&gt;
# Click on the '''Save''' button;&lt;br /&gt;
# Click on the '''Close''' button;&lt;br /&gt;
# Run a [[Get Data]].&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_change_the_numbers_of_financial_years_available_in_ODBClink&amp;diff=2275</id>
		<title>How to change the numbers of financial years available in ODBClink</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_change_the_numbers_of_financial_years_available_in_ODBClink&amp;diff=2275"/>
		<updated>2020-11-13T07:33:32Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Overview */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
OBClink (Standard &amp;amp; Pro Editions) have a the ability to can download data up to 10 financial years into the past and future.&lt;br /&gt;
The option is configurable because the trade off of extracting more data is the increase in time the get data takes and so best practise is to only choose the years which contain data you actually need. The default is 1 year history and 1 year into the future based on the the current date. The date rolls forward on 3 months past the end of the financial year. ie if the date is 13Aug20 the financial year will be considered 2020. When the date roles to 1Oct20 then the current financial year will be considered 2021&lt;br /&gt;
&lt;br /&gt;
'''Note: ODBClink Free Edition is fixed at 3 financial years. '''&lt;br /&gt;
&lt;br /&gt;
== How to change the numbers of financial years available in ODBClink ==&lt;br /&gt;
[[File:YearOptions.png|300px|thumb|right|Year options in the Options dialogue]] &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
To change the number of financial years to download data, follow these steps.&lt;br /&gt;
&lt;br /&gt;
# From the ODBClink main menu, click on '''30. Settings''';&lt;br /&gt;
# Click on '''Options''';&lt;br /&gt;
# Click on the '''Set User Options''' button;&lt;br /&gt;
# From the options dialogue, select the '''Years''' item in the left-hand list;&lt;br /&gt;
# Change the '''Number of Prior Years to get data''' to the desired value;&lt;br /&gt;
# Change the '''Number of Future Years to get data''' to the desired value;&lt;br /&gt;
# Click on the '''Save''' button;&lt;br /&gt;
# Click on the '''Close''' button;&lt;br /&gt;
# Run a [[Get Data]].&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2274</id>
		<title>How to subscribe</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2274"/>
		<updated>2020-11-10T23:25:14Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
ODBClink has 3 editions, Free, Standard and Pro.&lt;br /&gt;
&lt;br /&gt;
Upon first use, access to the Pro Edition is granted for 30 days.&lt;br /&gt;
&lt;br /&gt;
To to continue use after the trial period a subscription to one of the editions will be required. &lt;br /&gt;
&lt;br /&gt;
[[File:Licensing.png|400px|thumb|right|Licensing]]&lt;br /&gt;
[[File:Choose The Edition.png|400px|thumb|right|Licensing]]&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the '''Licensing dialogue''', click '''Subscribe''';&lt;br /&gt;
# In the Confirm The Edition dialogue, either confirm or change the edition you wish to subscribe to&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2273</id>
		<title>How to subscribe</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2273"/>
		<updated>2020-11-10T23:24:37Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
ODBClink has 3 editions, Free, Standard and Pro.&lt;br /&gt;
&lt;br /&gt;
Upon first use, access to the Pro Edition is granted for 30 days.&lt;br /&gt;
&lt;br /&gt;
To to continue use after the trial period a subscription to one of the editions will be required. &lt;br /&gt;
&lt;br /&gt;
[[File:Licensing.png|400px|thumb|right|Licensing]]&lt;br /&gt;
[[File:Choose_The_Edition.png|400px|thumb|right|Licensing]]&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the '''Licensing dialogue''', click '''Subscribe''';&lt;br /&gt;
# In the Confirm The Edition dialogue, either confirm or change the edition you wish to subscribe to&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2272</id>
		<title>How to subscribe</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2272"/>
		<updated>2020-11-10T23:20:13Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Overview */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
ODBClink has 3 editions, Free, Standard and Pro.&lt;br /&gt;
&lt;br /&gt;
Upon first use, access to the Pro Edition is granted for 30 days.&lt;br /&gt;
&lt;br /&gt;
To to continue use after the trial period a subscription to one of the editions will be required. &lt;br /&gt;
&lt;br /&gt;
[[File:Licensing.png|400px|thumb|right|Licensing]]&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the '''Licensing dialogue''', click '''Subscribe''';&lt;br /&gt;
#&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2271</id>
		<title>How to subscribe</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2271"/>
		<updated>2020-11-10T23:19:20Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Overview */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
ODBClink has 3 editions, Free, Standard and Pro. Upon first use, access to the Pro Edition is granted for 30 days. To to continue use after the trial period a subscription to one of the editions will be required. &lt;br /&gt;
&lt;br /&gt;
If you need to work out which edition you require &lt;br /&gt;
&lt;br /&gt;
After that trial period has expired a subscription to one of the editions will be required &lt;br /&gt;
ODBClink has an initial trial period which provide access to the Pro Edition for &lt;br /&gt;
 To continue to use the software after the&lt;br /&gt;
&lt;br /&gt;
[[File:Licensing.png|400px|thumb|right|Licensing]]&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the '''Licensing dialogue''', click '''Subscribe''';&lt;br /&gt;
#&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2270</id>
		<title>How to subscribe</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2270"/>
		<updated>2020-11-10T23:18:31Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Overview */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
[[File:Licensing.png|300px|thumb|right|Licensing]]&lt;br /&gt;
[[File:Licensing.png||thumb|right|Licensing]]&lt;br /&gt;
&lt;br /&gt;
ODBClink has 3 editions, Free, Standard and Pro. Upon first use, access to the Pro Edition is granted for 30 days. To to continue use after the trial period a subscription to one of the editions will be required. &lt;br /&gt;
&lt;br /&gt;
If you need to work out which edition you require &lt;br /&gt;
&lt;br /&gt;
After that trial period has expired a subscription to one of the editions will be required &lt;br /&gt;
ODBClink has an initial trial period which provide access to the Pro Edition for &lt;br /&gt;
 To continue to use the software after the&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the '''Licensing dialogue''', click '''Subscribe''';&lt;br /&gt;
#&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2269</id>
		<title>How to subscribe</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_subscribe&amp;diff=2269"/>
		<updated>2020-11-10T23:17:43Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Created page with &amp;quot;== Overview ==  Licensing  ODBClink has 3 editions, Free, Standard and Pro. Upon first use, access to the Pro Edition is granted for 3...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
[[File:Licensing.png|300px|thumb|right|Licensing]]&lt;br /&gt;
&lt;br /&gt;
ODBClink has 3 editions, Free, Standard and Pro. Upon first use, access to the Pro Edition is granted for 30 days. To to continue use after the trial period a subscription to one of the editions will be required. &lt;br /&gt;
&lt;br /&gt;
If you need to work out which edition you require &lt;br /&gt;
&lt;br /&gt;
After that trial period has expired a subscription to one of the editions will be required &lt;br /&gt;
ODBClink has an initial trial period which provide access to the Pro Edition for &lt;br /&gt;
 To continue to use the software after the &lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the '''Licensing dialogue''', click '''Subscribe''';&lt;br /&gt;
#&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=File:Licensing.png&amp;diff=2268</id>
		<title>File:Licensing.png</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=File:Licensing.png&amp;diff=2268"/>
		<updated>2020-11-10T23:05:37Z</updated>

		<summary type="html">&lt;p&gt;Jeff: Jeff uploaded a new version of &amp;amp;quot;File:Licensing.png&amp;amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=File:Licensing.png&amp;diff=2267</id>
		<title>File:Licensing.png</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=File:Licensing.png&amp;diff=2267"/>
		<updated>2020-11-10T23:02:45Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2266</id>
		<title>Getting Started Guide</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2266"/>
		<updated>2020-11-10T22:51:52Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The following topics will assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== New Installation ==&lt;br /&gt;
&lt;br /&gt;
The following pages contains all the main topics when first downloading and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
* [[Downloading ODBClink|How to download ODBClink]]&lt;br /&gt;
* [[Installing ODBClink|How to install ODBClink]]&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[Starting ODBClink|How to start ODBClink]]&lt;br /&gt;
* [[Get Data|How to Get Data]]&lt;br /&gt;
* [[How to view the data in a data warehouse]]&lt;br /&gt;
&lt;br /&gt;
Once you've evaluated ODBClink, you will require a subscription to keep using it after the trial expiry date. The following pages will assist you.&lt;br /&gt;
&lt;br /&gt;
* [[How to subscribe]]&lt;br /&gt;
* [[How to get a License Key]]&lt;br /&gt;
* [[How to enter a License Key]]&lt;br /&gt;
* [[How to locate your ODBCLink Serial number]]&lt;br /&gt;
&lt;br /&gt;
=== Video ===&lt;br /&gt;
&lt;br /&gt;
This getting started video provides an overview of ODBClink.&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|ISsb882H4Go|560|left|Getting Started with ODBClink}}&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Upgrades ==&lt;br /&gt;
&lt;br /&gt;
If you are upgrading to the latest version of ODBClink, see the following pages.&lt;br /&gt;
&lt;br /&gt;
* [[Upgrading ODBClink|How to upgrade ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Additional Information ==&lt;br /&gt;
&lt;br /&gt;
For a complete list of features, see the [[Features]] page.&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;br /&gt;
* [[Troubleshooting]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2265</id>
		<title>Getting Started Guide</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2265"/>
		<updated>2020-11-10T22:51:36Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The following topics will assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== New Installation ==&lt;br /&gt;
&lt;br /&gt;
The following pages contains all the main topics when first downloading and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
* [[Downloading ODBClink|How to download ODBClink]]&lt;br /&gt;
* [[Installing ODBClink|How to install ODBClink]]&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[Starting ODBClink|How to start ODBClink]]&lt;br /&gt;
* [[Get Data|How to Get Data]]&lt;br /&gt;
* [[How to view the data in a data warehouse]]&lt;br /&gt;
&lt;br /&gt;
Once you've evaluated ODBClink, you will require a subscription to keep using it after the trial expiry date. The following pages will assist you.&lt;br /&gt;
&lt;br /&gt;
* [[How to subscribe to an Edition]]&lt;br /&gt;
* [[How to get a License Key]]&lt;br /&gt;
* [[How to enter a License Key]]&lt;br /&gt;
* [[How to locate your ODBCLink Serial number]]&lt;br /&gt;
&lt;br /&gt;
=== Video ===&lt;br /&gt;
&lt;br /&gt;
This getting started video provides an overview of ODBClink.&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|ISsb882H4Go|560|left|Getting Started with ODBClink}}&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Upgrades ==&lt;br /&gt;
&lt;br /&gt;
If you are upgrading to the latest version of ODBClink, see the following pages.&lt;br /&gt;
&lt;br /&gt;
* [[Upgrading ODBClink|How to upgrade ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Additional Information ==&lt;br /&gt;
&lt;br /&gt;
For a complete list of features, see the [[Features]] page.&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;br /&gt;
* [[Troubleshooting]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_get_a_License_Key&amp;diff=2264</id>
		<title>How to get a License Key</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_get_a_License_Key&amp;diff=2264"/>
		<updated>2020-11-10T22:50:06Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* Notes */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
[[File:LicensingDialogue.png|300px|thumb|right|Licensing Dialogue]]&lt;br /&gt;
&lt;br /&gt;
Once you've evaluated the ODBClink and are happy with it's feature set, you will need to get a license of one of the editions.&lt;br /&gt;
&lt;br /&gt;
To do so, follow these steps.&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the licensing dialogue, click on the '''Get License Key''' button;&lt;br /&gt;
# From your web browser, choose which Edition and Payment Terms by clicking on the '''Subscribe''' button;&lt;br /&gt;
# Fill in your details (and credit card details if purchasing a paid version of the software) and click '''Subscribe'''.&lt;br /&gt;
&lt;br /&gt;
Once we receive your details, we will issue out your license key. To enter the license key into the software, see [[How to enter a License Key]].&lt;br /&gt;
&lt;br /&gt;
=== Notes ===&lt;br /&gt;
&lt;br /&gt;
* While the ODBClink Free Edition is free to use (not including support and training), we do require users request a license key in order to if you are continuing to use the software or not. &lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
* [[How to enter a License Key]]&lt;br /&gt;
* [[Getting Started Guide]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2251</id>
		<title>Getting Started Guide</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2251"/>
		<updated>2020-10-05T04:07:04Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The following topics will assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== New Installation ==&lt;br /&gt;
&lt;br /&gt;
The following pages contains all the main topics when first downloading and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
* [[Downloading ODBClink|How to download ODBClink]]&lt;br /&gt;
* [[Installing ODBClink|How to install ODBClink]]&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[Starting ODBClink|How to start ODBClink]]&lt;br /&gt;
* [[Get Data|How to Get Data]]&lt;br /&gt;
* [[How to view the data in a data warehouse]]&lt;br /&gt;
&lt;br /&gt;
Once you've evaluated ODBClink, you will require a subscription to keep using it after the trial expiry date. The following pages will assist you.&lt;br /&gt;
&lt;br /&gt;
* [[How to get a License Key]]&lt;br /&gt;
* [[How to enter a License Key]]&lt;br /&gt;
* [[How to locate your ODBCLink Serial number]]&lt;br /&gt;
&lt;br /&gt;
=== Video ===&lt;br /&gt;
&lt;br /&gt;
This getting started video provides an overview of ODBClink.&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|ISsb882H4Go|560|left|Getting Started with ODBClink}}&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Upgrades ==&lt;br /&gt;
&lt;br /&gt;
If you are upgrading to the latest version of ODBClink, see the following pages.&lt;br /&gt;
&lt;br /&gt;
* [[Upgrading ODBClink|How to upgrade ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Additional Information ==&lt;br /&gt;
&lt;br /&gt;
For a complete list of features, see the [[Features]] page.&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;br /&gt;
* [[Troubleshooting]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2250</id>
		<title>Getting Started Guide</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2250"/>
		<updated>2020-10-05T04:03:50Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* New Installation */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The following topics will assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== New Installation ==&lt;br /&gt;
&lt;br /&gt;
The following pages contains all the main topics when first downloading and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
* [[Downloading ODBClink|How to download ODBClink]]&lt;br /&gt;
* [[Installing ODBClink|How to install ODBClink]]&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[Starting ODBClink|How to start ODBClink]]&lt;br /&gt;
* [[Get Data|How to Get Data]]&lt;br /&gt;
* [[How to view the data in a data warehouse]]&lt;br /&gt;
&lt;br /&gt;
Once you've evaluated ODBClink, you will require a subscription to keep using it after the trial expiry date. The following pages will assist you.&lt;br /&gt;
&lt;br /&gt;
* [[How to Subscribe to an Edition]]&lt;br /&gt;
* [[How to get a License Key]]&lt;br /&gt;
* [[How to enter a License Key]]&lt;br /&gt;
* [[How to locate your ODBCLink Serial number]]&lt;br /&gt;
&lt;br /&gt;
=== Video ===&lt;br /&gt;
&lt;br /&gt;
This getting started video provides an overview of ODBClink.&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|ISsb882H4Go|560|left|Getting Started with ODBClink}}&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Upgrades ==&lt;br /&gt;
&lt;br /&gt;
If you are upgrading to the latest version of ODBClink, see the following pages.&lt;br /&gt;
&lt;br /&gt;
* [[Upgrading ODBClink|How to upgrade ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Additional Information ==&lt;br /&gt;
&lt;br /&gt;
For a complete list of features, see the [[Features]] page.&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;br /&gt;
* [[Troubleshooting]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2249</id>
		<title>Getting Started Guide</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Getting_Started_Guide&amp;diff=2249"/>
		<updated>2020-10-05T04:01:16Z</updated>

		<summary type="html">&lt;p&gt;Jeff: /* New Installation */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The following topics will assist you configuring and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
== New Installation ==&lt;br /&gt;
&lt;br /&gt;
The following pages contains all the main topics when first downloading and using ODBClink.&lt;br /&gt;
&lt;br /&gt;
* [[Downloading ODBClink|How to download ODBClink]]&lt;br /&gt;
* [[Installing ODBClink|How to install ODBClink]]&lt;br /&gt;
* [[Configuring ODBClink|How to configure ODBClink]]&lt;br /&gt;
* [[Starting ODBClink|How to start ODBClink]]&lt;br /&gt;
* [[Get Data|How to Get Data]]&lt;br /&gt;
* [[How to view the data in a data warehouse]]&lt;br /&gt;
&lt;br /&gt;
Once you've evaluated ODBClink, you will require a subscription to keep using it after the trial expiry date. The following pages will assist you.&lt;br /&gt;
&lt;br /&gt;
* [[How to get a License Key]]&lt;br /&gt;
* [[How to enter a License Key]]&lt;br /&gt;
* [[How to locate your ODBCLink Serial number]]&lt;br /&gt;
&lt;br /&gt;
=== Video ===&lt;br /&gt;
&lt;br /&gt;
This getting started video provides an overview of ODBClink.&lt;br /&gt;
&lt;br /&gt;
{{#ev:youtube|ISsb882H4Go|560|left|Getting Started with ODBClink}}&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Upgrades ==&lt;br /&gt;
&lt;br /&gt;
If you are upgrading to the latest version of ODBClink, see the following pages.&lt;br /&gt;
&lt;br /&gt;
* [[Upgrading ODBClink|How to upgrade ODBClink]]&lt;br /&gt;
&lt;br /&gt;
== Additional Information ==&lt;br /&gt;
&lt;br /&gt;
For a complete list of features, see the [[Features]] page.&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
* [[How To Guides]]&lt;br /&gt;
* [[Troubleshooting]]&lt;br /&gt;
&lt;br /&gt;
[[Category:Getting Started Guide]]&lt;br /&gt;
[[Category:How To Guides]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=Archiving&amp;diff=2245</id>
		<title>Archiving</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=Archiving&amp;diff=2245"/>
		<updated>2020-09-11T03:00:08Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==Overview==&lt;br /&gt;
&lt;br /&gt;
The archiving algorithm allows for historical transactions to be stored and for the Get data to only pull transactions which could have changed. The benefits are that it makes the Get Data process run faster and it allows reporting on purged transactions&lt;br /&gt;
&lt;br /&gt;
==Procedure==&lt;br /&gt;
[[File:Data_File_Setup_Options.png|300px|thumb|right|Archiving]]&lt;br /&gt;
&lt;br /&gt;
You can either setup during uploading the data file or any time later.&lt;br /&gt;
&lt;br /&gt;
If you have uploaded the data file already. Please follow the below process for archiving.&lt;br /&gt;
&lt;br /&gt;
* From the BudgetLink Sales Pivot menu Go to 30.Settings/Data Files.&lt;br /&gt;
&lt;br /&gt;
* Click Manage Data Files button.&lt;br /&gt;
&lt;br /&gt;
* From the pop out select the data file you will need to archive and click on edit data file.&lt;br /&gt;
&lt;br /&gt;
* In the data file setup dialogue to the bottom of the window.&lt;br /&gt;
&lt;br /&gt;
* Under Get Data Options click the dropdown. You will see the below options.&lt;br /&gt;
	&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
1.'''Archive and retain historical data recorded prior to a FIXED DATE.'''&lt;br /&gt;
With this option you will be able to select the date to archive the &lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
2.'''Archive and retain historical data recorded prior to the LOCKED PERIOD DATE.'''&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
3.'''Archive and retain historical data recorded prior to the PURGE DATE.'''&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* Select the option you will require and click OK.&lt;br /&gt;
&lt;br /&gt;
Done.&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Related Topics==&lt;br /&gt;
&lt;br /&gt;
[[How to Disable Archiving]]&lt;br /&gt;
&lt;br /&gt;
[[How to Delete an Archive]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
	<entry>
		<id>https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_locate_your_ODBCLink_Serial_number&amp;diff=2244</id>
		<title>How to locate your ODBCLink Serial number</title>
		<link rel="alternate" type="text/html" href="https://accountingaddons.com.au/wiki/odbclink/index.php?title=How_to_locate_your_ODBCLink_Serial_number&amp;diff=2244"/>
		<updated>2020-09-07T03:28:38Z</updated>

		<summary type="html">&lt;p&gt;Jeff: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Overview ==&lt;br /&gt;
&lt;br /&gt;
[[File:ODBCSerialNumber.png|600px|thumb|right|Licensing Dialogue]]&lt;br /&gt;
&lt;br /&gt;
Each ODBCLink installation generates its own unique [[ODBCLink Serial Number | Serial Number]]. &lt;br /&gt;
&lt;br /&gt;
When subscribing to or renewing an edition you may need to provide that serial number.&lt;br /&gt;
&lt;br /&gt;
If asked to location it, please follow the instructions below&lt;br /&gt;
&lt;br /&gt;
== Procedure ==&lt;br /&gt;
&lt;br /&gt;
# Start ODBClink;&lt;br /&gt;
# From the Menu click the '''License''' button;&lt;br /&gt;
# In the Licensing Dialogue, the Serial Number is located at the top right of the form as shown in the image;&lt;br /&gt;
# If you need to add it to a subscription form, copy it from here and paste it into the form;&lt;br /&gt;
# If you have been requested to email it then take a screen shot of the form and paste it into a reply email;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br clear=all /&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Related Topics ==&lt;br /&gt;
&lt;br /&gt;
*[[How to enter a License Key]]&lt;/div&gt;</summary>
		<author><name>Jeff</name></author>
	</entry>
</feed>