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

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.

http://www.oneilsoft.com/news-portal/conference-news/2010-conference

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:  Read More...

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.

Read More...

Access Information Management Announces Acquisition of Southern California Records Management Firm

Accesscorp.com, 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.

Read More...

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.

Read More...

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.

Read More...

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
newsletter@oneilsoft.com?subject=News 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:

Read More...

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

where.......
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...

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