If you need more help with these hints, have a question for our technical specialists or want to learn more about
this feature? E-mail us at one of the following addresses or log a request
at:
http://www.oneilsoft.com/support/support_request.shtml
Maybe your customer is a medical facility or an insurance company? Either way, if they use
terminal digit filing it can play havoc with your reports, especially in relation to how they are sorted. So what is Terminal Digit filing? Considered by many to be the most efficient of the numeric filing systems, in this system, the last digit or group of digits is the primary unit used for filing.
For example, the number 7123490 could be broken down as follows: 71-234- 90, with 90 as the primary unit for filing, 234 as the secondary unit, and 71 as the tertiary unit.
Using the "standard" sorting they were sorted correctly
but viewing them as terminal digit files, we can see #89 is following #90,
which is not correct.
Not to worry, O'Neil has a very
flexible solution, known as
Alternate Sort Order. This feature offers an alternative sorting option where priority
ranking of characters is evaluated in an order other than the standard
left-to-right, dictionary order.
In the Administration
program, Options menu,
Setup submenu, select
Alternate Sort Order, then
Template. The
Alternate
Sort Order
Template
grid appears. To
create a new template, click
Add
and the
ASO Template
Add dialog
appears
Using the Alternate Sort Order Template, you can type
the order in which you want the existing characters sorted. For our example,
we have a 7 character code (7123490) and you want to sort by the
last two characters first then the middle 3 characters and finally the last
2 characters , you would type the following in this field: 6 7 3 4 5 1 2.
The resulting ASO code would be 9023471.
You can
assign this template to accounts and then the system will automatically
create the Alternate Sort Order record for you. You can now search or
sort your filefolders using this new sequence.
March 2008 - Want to Know who
is Logged in to RS-SQL?
Maybe you want to know if a customer is logged on via the web or if
someone is working in a remote facility? Either way, here is a quick
and simple tip to help you know who is logged in to your RS-SQL system.
Go to the Administration > Options > User > Users Grid and press
F6 to see the available Quick Queries. You should see one named:
zUsersCurrentlyUsingRS-SQL
Run this query and you will see a list of all users currently using the
software. You may want to ensure you are showing the User Type column
on the grid. You can select this by selecting Format > Columns
from the menu.
February 2008: Your Company
Logo on Your Workorders?
When visiting customers over the last 2 weeks, I noticed that most of you
know how to put a barcode onto your workorders but most didn't know that you
can now add your company logo to the top of your workorders.
In the Workorder grid, from the Options menu, select Workorder
Customization. the following dialog appears:
Bitmap File: Type the path and filename of the bitmap. Only the BMP
file format is supported. At print time if the file is not found, the
workorder is printed without the logo.
Width/Height Inches: Enter a width and height in inches if you want
your image to be scaled. If no values are specified, no scaling is performed
and the actual image size is honored.
Logo Alignment: Select where on the page you want the logo to appear.
When you have completed all fields, click OK to save.
January 2008: Your New Year's
Resolution?
Want a suggestion for a great New Year’s resolution? How about this?
Resolve to review your RS-SQL database maintenance and disaster recovery
plans as early as possible this year. Without exception, companies who wait
for disaster to strike before reviewing their backup procedures are caught
between a rock and a hard place, often losing data and more than half going
out of business within three years.
Some great information on maintaining your database can be found at the
following links:...
Read More...
