Difference between revisions of "Add an Appointment"

Revision as of 18:51, 13 May 2008

There are a couple ways this can be accomplished...

Step one- obtain "AppointmentGenerator.sql" script file

Step two- on Database server launch SQL Server Management Studio

Located: Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio

Step three- enter the Login and Password if necessary.

IMPORTANT: Make sure you have the correct TEST server selected in Server name drop down!

Step Four- click on "New Query". This will open a blank window on the right side of the Management Studio.

Step five- change the database to "Works" in the dropdown

Step six- open "AppointmentGenerator.sql" in a text editor, such as Wordpad

Step seven- Paste (cntrl-V) this text into the window created by the "New Query" button

Step seight- scroll to the following section in the script

Step eight- modify the four red fields by doing the following. Keep the apostrophes (')around the data you enter.

@MyMRN- insert the MRN number of a known patient in the test system
@MyUser- insert the user name of a known provider in the test system, ie. jmedici
@myHour- enter the time for the appointment
@MyStartDate- Enter the date for the appointment
@NumberofAppointments- enter how many days the appointment should repeat for, if desired

Step nine- press the execute button

Note: DemoBlaster does not work in TW v11.0.X, it has been fixed as of v11.1.x

Step one- Login with TWAdmin

Step two- Select TW Setup from the dropdown

Step three- select "DemoBlaster" on the VTB on the left

Step four- select the provider you wish to use in from the dropdown menu

Step five-

Step five- Click on "New Appt..." in the DemoBlaster window

@@ Line 21: / Line 21: @@
-'''Step five'''- open "AppointmentGenerator.sql" in a text editor, such as Wordpad
+'''Step five'''- change the database to "Works" in the dropdown
+[[Image:Worksdb.jpg]]
+'''Step six'''- open "AppointmentGenerator.sql" in a text editor, such as Wordpad
 * Select all text (cntrl-A) and copy (cntrl-C)
-'''Step six'''- Paste (cntrl-V) this text into the window created by the "New Query" button
+'''Step seven'''- Paste (cntrl-V) this text into the window created by the "New Query" button
 [[Image:Script.jpg]]
-'''Step seven'''- scroll to the following section in the script
+'''Step seight'''- scroll to the following section in the script
 [[Image:Fillin.jpg]]
-'''Step eight'''- modify the four red fields by doing the following. Remove the apostrophes (')around the data you enter.
+'''Step eight'''- modify the four red fields by doing the following. Keep the apostrophes (')around the data you enter.
 *@MyMRN- insert the MRN number of a known patient in the test system
-*@MyUser- insert the Mnemonic of a known provider in the test system
+*@MyUser- insert the user name of a known provider in the test system, ie. jmedici
 *@myHour- enter the time for the appointment
 *@MyStartDate- Enter the date for the appointment
 *@NumberofAppointments- enter how many days the appointment should repeat for, if desired
+'''Step nine'''- press the execute button
+[[Image:Execute.jpg]]
 ==Method 2- Using DemoBlaster==