Schedule the GetData Process

Schedule the GetData Process

To setup Auto Upload, please follow these instructions. Note that these instructions are dependent 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.

  1. Click Start, then Control Panel, then Administrative Tools, then Task Scheduler;
  2. In the Task Scheduler form, select Create Basic Task;
  3. Enter a Name for the task (for example ODBClink Get Data) and click Next;
  4. In the Task Trigger form, select the period for the Auto Upload to occur and click Next;
  5. In the Daily form, enter the Start date and time that the first Auto Upload will occur and click Next;
  6. In the Action form, select Start a program and click Next;
  7. 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;
  8. In the Summary form, select Open the Properties dialog for this task when I click Finish and click Finish;
  9. 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;
  10. 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;
  11. In the Settings tab, tick the checkbox If the running task does not end when requested, force it to stop;
  12. In the Actions tab, click Edit;
  13. 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.
  14. 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.

Notes

  • When choosing a time to run the auto upload process, ensure your chosen time does not conflict with backups or other system processes.
  • 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.
  • For older versions of ODBClink, you will need to browse to the Excel.exe and include the UNC path to the Auto Upload.xls file located in the system folder.

    • Related Articles

    • Replicating Auto-Connection Details on Terminal Server Profiles

      Problem: You are trying to replicate the auto-connection details on load balanced terminal servers or across multiple user profiles without requiring to send out all the details to the users. Solution: Configure the auto-connection on an ...
    • Error Scheduling Reports for Intelligence Reporting

      Problem There is an error scheduling reports to execute using the Windows Task Scheduler Symptoms: The Report is scheduled but the BICore.exe process doesn't launch The report is scheduled but the BICore.exe launches but doesn't consume any memory ...
    • Report Distribution using Intelligence Reporting

      Distribution Settings Email is the most popular distribution channel.  By default, your Microsoft Outlook profile settings will be used by Sage Intelligence to send emailed reports automatically, however, if this is not preferable, or you do not have ...
    • Data Source name not found and no default driver specified. SQLState=IM002

      Error "Data Source name not found and no default driver specified. SQLState=IM002" when trying to run any reports Resolution Go to the Connector Find the connection the report with the error is running off Ensure the report is on the correct ...
    • Scheduling Alchemex Reports

      You would like your reports automatically emailed to particular users across your organisation It’s time to stop manually distributing your reports and start saving time by scheduling your reports to automatically distribute themselves.  In this tip, ...