TMITS

TailorMade Info Technology Solutions Ltd

Tel/Fax: +44 (0)1359 242146 ~ Email: Solutions@tailormadeit.co.uk


Free Vision Appointment Wizards!Appointment Wizard

DLM485+ Vision Appointment Wizard

This new version of the Appointment Wizard will only work with DLM485 and above. There are no drivers to download or install. It also has a direct connection to Vision, therefore you will need to login to Vision before running the Wizard.

The download includes both an .xls version and .xlsm for Excel 2007 and above.

This will import all the active appointment data using a count option between your set date range:

v1.2 - Converted the Time columns to actual times so that they may be calculated.

V1.3 - Converted Date/Time cells to just Date

v1.4 - Fix times as some were converting to dates

v1.5 - Include patient demographic data and ethnicity

v1.6 - Fix to code due to name changes in Vision database

Download - Appointment Wizard (DLM485+)

Last updated: 06/03/2017 v1.6
Works on LAN or hosted environments (AEROS/WES etc...)
Subject to Freeware Licence Agreement

Once downloaded, click RUN and UNZIP to O:\Download\WizApp folder
Step by step instructions are in the Excel workbook.

DLM485+ Vision Appointment Wizard Extra - for Walk-in Centre sites

This is the same as above but includes additional patient demographics (ethnicity, registration status, address and practice details) intended for extended care and walk in Centre sites.

You no longer need to run any Vision searches as the Wizard will do it all!

With regards to Practice details it is looking for the last 9b1F or 9121 or 916 Read code
The practice details are only split correctly when using the GPLookup utility.
Transferred out patients are not included in additional data

Download - Appointment Wizard (DLM485+)

Last updated: 19/07/2016 v1.2
Works on LAN or hosted environments (AEROS/WES etc...)
Subject to Freeware Licence Agreement

Once downloaded, click RUN and UNZIP to O:\Download\WizApp folder
Step by step instructions are in the Excel workbook.

Download - V360 Appointment Wizard

This is specifically for the V360 shared online appointments and is the same as above, except that it will divide the comments text into separate columns, which includes the Practice Code and Patient ID.

Download - V360 Appointment Wizard (DLM485+)

Last updated: 17/01/2016 v1.1
Works on LAN or hosted environments (AEROS/WES etc...)
Subject to Freeware Licence Agreement

v1.2: Some changes have been made to format the patient and practice details received in the comments fields from V360 online shared appointments

Download - V360 Appointment Wizard (DLM485+)

Last updated: 30/11/2016 v1.2
Works on LAN or hosted environments (AEROS/WES etc...)
Subject to Freeware Licence Agreement

Once downloaded, click RUN and UNZIP to O:\Download\WizApp folder
Step by step instructions are in the Excel workbook.

DLM485+ V360 Appointment Wizard inc Practice details

This is specifically for the V360 shared online appointments and is the same as above, except that it will divide the comments text into separate columns. This version uses a specific tab to merge the practice details which can be manually updated by the organisation.

Download - V360 Appointment Wizard (DLM485+)

Last updated: 28/02/2016 v1.1
Works on LAN or hosted environments (AEROS/WES etc...)
Subject to Freeware Licence Agreement

Once downloaded, click RUN and UNZIP to O:\Download\WizApp folder
Step by step instructions are in the Excel workbook.

DLM485+ Vision Cancellation Appointment Wizard

This new version of the Appointment Wizard will only work with DLM485 and above. There are no drivers to download or install. It also has a direct connection to Vision, therefore you will need to login to Vision before running the Wizard.
The download includes both an .xls version and .xlsm for Excel 2007 and above.

This will import all the cancelled appointments. Which may be cross referenced using the APPT_ID.

Download - Cancellation Appointment Wizard (DLM485+)

Last updated: 13/12/2015 v1.0
Works on LAN or hosted environments (AEROS/WES etc...)
Subject to Freeware Licence Agreement

Once downloaded, click RUN and UNZIP to O:\Download\WizApp folder
Step by step instructions are in the Excel workbook.

Pre-DLM485 Vision Appointment Wizard

This version has now been written in Microsoft Excel VB and will work in all versions of Excel.

It does exactly the same as the original wizard written in AHK, but this new version runs much faster and will be more reliable. If used in Excel 2007 or higher it will allow you to analyse a much larger appointment date range. Previously Excel 2003 was restricted to 65536 rows, whereas from 2007 it has over 1 million.

Also includes the Cancellation and Free slot wizard as well.

Download for Excel 2003

Tested up to Vision DLM480 ~ Updated: 13/04/2015
Subject to Freeware Licence Agreement

Download for Excel 2007 and above

Tested up to Vision DLM480 ~ Updated: 13/04/2015
Subject to Freeware Licence Agreement

Click RUN to download and extract to O:\Download\Guidelines folder. Step by step instructions are in the Excel workbook.

Pre-DLM485 Vision Appointment Wizard Extra

This new version has been written in Microsoft Excel visual basic code and includes the Vision Appointment Wizard, so that you will only need to download and run this single file, also includes the Cancellation wizard as well.

This output file is written in Excel 2003 (i.e. .xls) and is therefore limited to 65536 rows. If your complete patient list size including transferred out patients is larger than 65K patients you ideally need to install Microsoft Excel 2007 or higher, otherwise you will not get the entire patient list size merged together.

Download for Excel 2003

Tested up to Vision DLM450 ~ Updated:02/12/2013
Subject to Freeware Licence Agreement

This output file is written for Excel 2007 or higher (i.e. .xlsm) macro-enabled and will work in all versions of Excel and has no size limitation as far as a practice list size is concerned.

Download for Excel 2007 and above

Tested up to Vision DLM450 ~ Updated: 02/12/2013
Subject to Freeware Licence Agreement

Pre-DLM485 Vision Appointment Wizard Prerequisite:

Importing any of the Pre-DLM485 Vision appointments data into Microsoft Excel requires two elements to of been performed before running either of the Appointment Wizards on a workstation; If you are on the Vision remote server (AEROS/WES) the following is automatically installed.

There are a few requirements that the wizard relies on if your using Microsoft Excel 2003, so that it functions correctly:

There are a few requirements that the wizard relies on within Microsoft Excel 2003, so that it functions correctly:

  1. This only applies to Excel 2003 (not 2007 or higher)

  2. For the Week Number column to work the function (WEEKNUM) must be added, from Tools menu Add-Ins... then select the "Analysis ToolPak".

Add-ins

Licence Agreement

You are granted a non-exclusive Licence to use the Software for any purposes for an unlimited period of time. The software product under this Licence is provided free of charge.

Even though a license fee is not paid for the use of Freeware Version software, it does not mean that there are no conditions for using such software:

  1. The Software may be installed and used by the Licensee for any legal purpose.
  2. The Software may be installed and used by the Licensee on any number of systems.
  3. The Software can be copied and distributed under the condition that original copyright notice and disclaimer of warranty will stay intact, and the Licensee will not charge money or fees for the Software product, except to cover distribution costs.
  4. The Licensee will not have any proprietary rights in and to the Software. The Licensee acknowledges and agrees that the Licensor retains all copyrights and other proprietary rights in and to the Software.
  5. Use within the scope of this Licence is free of charge and no royalty or licensing fees shall be paid by the Licensee.

Read the full version of the Freeware Licence Agreement

Back to Top