Issue 103 - September 2009
Quick Links
What's New
Industry News
Tech Support
Quiz Us

I am getting excited as we start to focus on the preparations for our Strategic Partner Conference.  Although it still seems a long way off, experience tells us it will be here before we know it.  As such, we have set up the hotel and created an area of our website, where you will be able to get all the information as soon as it comes available.  More of that below in the What's New section.


In this edition we also have lots of news from customers, information about getting ready for RS-SQL version 4.0, and the answer to an interesting support question.


As always, I hope you enjoy this edition of the eNewsletter from O'Neil Software


Ian Thomas

Vice President - Business Development


If you received this newsletter in error or wish to find out more, please click here

If you want your O'Neil News sooner?

  Read our Blog or Follow us on Twitter or Network on Facebook

What's New at O'Neil

2010 Strategic Partner Conference  - Venue Booked

The venue for the 2010 Strategic Partner Conference has been selected and we will be meeting at the Hilton Waterfront Beach Resort. It is situated in the beautiful seaside community of Huntington Beach, California, overlooking the Pacific Ocean and miles of white sand beaches. This location will help us to create the perfect balance between getting some work done, but also relaxing & networking amongst your friends. 

We have created a dedicated page on our website for the conference so check back regularly for full details on registration, hotels and activities.


User Forum passes 1200 Posts in 12 months.

As we reach the approximate anniversary of the O'Neil User Forum, I was delighted to see the 1200th post arrive.  The User Forum has gone beyond our expectations with some great team-work among the O'Neil Users.  Just today I saw the following post in a relation to using Quickbooks with RS-SQL:


"Margaret, I have become very proficient in doing this. If you would like to contact me offline, send me an email... I will be happy to discuss with you. " - Mike Rich

This type of response not only sums up what a great resource the forum is, but also what a fabulous group of people we have as O'Neil Strategic Partners.


Thank you all for your involvement and for making the User Forum a great success in 2009.


Barcode Label Survey 2009 - The Results are in...

Thank you to all who participated in the recent Barcode Label Survey. we are pleased to announce the winners of our contest and to provide some highlights of the survey.

Our four contest winners were:

1) Col Jackson of Hunter Document Management - Newcastle NSW Australia
2) Patti Bowles of Phoenix Recycling Inc. - Winnipeg, Canada
3) Mary Cox of Riverside Assessor-County Clerk-Recorder - Riverside County, California
4) Richard Uiagaleli of The File Connection - Pearl City, Hawaii

Highlights of the survey include: 


Crown Records Management Acquires Athema Archiving

Crown RMS, Hong Kong, Sept 8, 2009 -- JOHANNESBURG—Crown Records Management, the world's number one private business information storage company, announced the acquisition of Athema Archiving, a South African records management business based in Johannesburg, South Africa. With the acquisition of this company and highly-developed scanning operation in South Africa, Crown's clients will enjoy a full spectrum of services ranging from imaging, data extraction, electronic media storage, secure and confidential waste destruction and traditional document storage services.


Access Information Management Announces Acquisition of Southern California Records Management Firm, CA - August 10, 2009 -- Pleasanton CA – Access Information Management has announced the acquisition of York Business Records Storage, based in Oxnard, California. This is the sixth acquisition made by Access in the Southern California region and Access’ 21st acquisition nationwide. York has provided offsite records storage and management services to Southern California clients for the past 32 years. Previous owner Mike York has joined the Access Account Management team, with an initial focus on managing the transition and introducing York clients to the Access team and Access’ additional Records and Information Management services.


Wincanton continue to be the fastest growing provider of services in the UK

Wincanton Records Management, UK - 26 September, 2009 -- Wincanton Records Management continue to be the fastest growing provider of records management services in the UK - Wincanton Group plc entered the UK market for records management in the UK & Ireland in 2002, through the acquisition of two regional companies in London and Dublin. Since then they have grown organically through the highest level of service possible to now be the 3rd largest provider in the records management sector. This growth has been accelerated during the past 18 months with the opening of new facilities in Scotland and the South West achieving complete national coverage on the UK & Ireland, with another facility to manage media tapes opening in September 2009 servicing London and the South East.


Iron Mountain Ranks No. 55 on 2009 InformationWeek 500

MSN Money, September 15th, 2009 -- MONARCH BEACH, Calif.–(BUSINESS WIRE)– Iron Mountain Incorporated (NYSE: IRM), the global leader in information protection and storage services, today announced that it ranked No. 55 on the 2009 InformationWeek 500, a listing of the nation’s most innovative users of information technology. The ranking was revealed last night at a gala awards ceremony at the InformationWeek 500 Conference.


Note: O'Neil Software is not responsible for the content of external internet sites. 

Do you have news you want to share?  We would be delighted to share it with our readers every month.  Simply Email us at to Include


Version 4.0 - Help with being Ready Coming Soon.

RS-SQL version 4.0 will come with a new program designed to ensure you are ready to upgrade.  Known as the Readiness Check program, it will be available on the RS-SQL installation CD in the folder with the same name.  You should run this program prior to upgrading your database to RS-SQL version 4.0.


So what will it do for you?


The program examines your RS-SQL database, looking for unexpected objects that might interfere with the RS-SQL 4.0 database upgrade.   The Readiness Check program will also check for and report on SQL Server 2000 presence, and inform you of the RS-SQL 4.0 requirement for SQL Server 2005 or later.

Version 4.0 Upgrade Notes

As we continue to develop and test RS-SQL version 4.0, I have previously been able to share some technical information about support for the underlying operating systems and SQL Server versions. We now have an updated statement that combines and clarifies all the previous points and gives some news on a new program to help prepare for the upgrade.


Read More...  

Why a stored procedure is not the API

During the examination of a recent support issue a customer misunderstanding about what actually is the API has come to light. We found, in this particular example, that portions of our code (known as the stored procedures) are being used on their own to insert records into a database. I shall do my best to explain why this is bad, without too many technical terms:



As always, if you are unsure or require further clarification on any of the technical topics discussed... simply ASK! Remember, we are only a telephone call or email away. For our contact details, click here.

IMPORTANT NOTE: Before loading any service packs, check with your O'Neil support representative first. News on the effects of loading a service pack is received all of the time and they will be able to advise you of any issues.

This month we look at another question that our support team was asked. Why not test your knowledge by seeing if you know the answer?

Question: I'd like to create a query to help me find a range of locations.
My Locations logic is as follows  O1-C-01-A-01

O1 = Building
C = Aisle (both side of the aisle are called "C")
01= Bay number (along the aisle)
A = Bay height (it goes from Height A-I)
01 = Box position within bay (it goes from 01 to 08)

So, for example, I would like a query to search on all the Locations in "C" aisle to include all the locations between:
Bay 01-19
Bay Height A-I
Box positions 1-8

Can it be done?


Click Here to Read the Answer...

Got a question for our technical specialists or want to learn more about this feature? E-mail us at one of the following addresses:

North & South American Customers
European Customers
Australian Customers

Send comments on our Quiz Us! questions to:

This eNewsletter comes to you at no charge as a service of O'Neil Software, Inc, the World's Leading Supplier of Records Management Software.  Visit our Web site at or contact us for complete and additional information.


To unsubscribe or update your company details regarding the O'NEIL NEWSLETTER, click on the link at the bottom of this newsletter.

O'Neil Software, Inc.
Corporate Office
11 Cushing, 
California, 92618
Tel: +1 949 458 1234
Support: +1 800 797 4321

O'Neil Software Ltd.
European Office
6 Joplin Court, Crownhill,
Milton Keynes MK8 0JP,
United Kingdom
Tel: +44 1908 635320
Fax: +44 1908 635328

O'Neil AustralAsia Pty Ltd.
AustralAsia Office
Ground Floor, Logan House South,
25 Donkin Street
South Brisbane QLD 4101
Tel: +61 7 3255 1333
Fax: +61 7 3255 1444

For more information visit our website

Check our site map or    search site

The Legal Bit
©O'Neil Software Inc. 2009. O'Neil Software, the O'Neil Logo, RSWin, RS-SQL, RSMobile, RSWeb, "Scan. Store. Manage. Deliver" and The FIRST Choice of Record Centers WORLDWIDE! are trademarks or registered trademarks of O'Neil Software Inc. All other trademarks acknowledged. This document may include many forward-looking statements regarding anticipated product functionality, targeted release dates, availability of technology and certain company initiatives that involve risks and uncertainties, and actual results may differ materially. This document is not intended to obligate O'Neil Software to such functionality, release dates, technology, initiatives and plans, but merely to inform of O'Neil Software's current intentions. This document is for informational purposes only and is subject to change without notice. O'Neil Software makes no warranties, express or implied in this document. The contents of this document are believed to be current and accurate as of its date of publication. For a complete description of the product features, please refer to the product's user guides, reference manuals and release notes.

O'Neil Software believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. The recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. O'Neil Software is not liable for any loss or damage arising in any way from this message or its attachments.