RP9 RGIS EXPORT

A SQL export of all data (including all alternate ALU/UPC values) for RP9 users with RGIS is saved at:

T:sqlqueriesv9rgisRGIS_ALL.bat

Moving the *.BAT and *.SQL files over to the client’s RP9 machine, and then run the *.BAT file. The result will be a TAB and CSV delimited file created in the same directory as the *.BAT file.

Specs of the SQL query are below:

SET PAGESIZE 0
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 132
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET COLSEP ‘,’
set trim on
set term off
set wrap off
set trimspool on
set trimout on
spool rgis_all.csv
select p.description1||chr(44)||p.local_upc||chr(44)||p.alu||chr(44)||p.item_no||chr(44)||invn_sbs_vendor.alu||chr(44)||invn_sbs_vendor.upc from invn_sbs p
left join invn_sbs_vendor on p.item_sid = invn_sbs_vendor.item_sid
where p.active=1;
spool off
spool rgis_all.tab
select p.description1||chr(44)||p.local_upc||chr(44)||p.alu||chr(44)||p.item_no||chr(44)||invn_sbs_vendor.alu||chr(44)||invn_sbs_vendor.upc from invn_sbs p
left join invn_sbs_vendor on p.item_sid = invn_sbs_vendor.item_sid
where p.active=1;
spool off

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Comments
This field is for validation purposes and should be left unchanged.

or

Schedule A Demo

Popup — Contact Us

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Phone
This field is for validation purposes and should be left unchanged.

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Email
This field is for validation purposes and should be left unchanged.

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Name
This field is for validation purposes and should be left unchanged.

or

Schedule A Demo

Name*
Organization / Business name*
*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Email
This field is for validation purposes and should be left unchanged.

or

Schedule A Demo

Sandy Malaney

Upon graduating with a degree in business from California State University, Sacramento, Sandy Malaney accepted a sales position from Lanier Business Products. She found her stride in outside sales, becoming Lanier’s top producer in their telecommunications division.

In 1988, Malaney joined Checkpoint Systems, selling security systems to retail companies. Malaney gained valuable information about the retail sector that would eventually lead her to her next career at a startup called Retail Technologies, Inc. (RTI) in 1990.

As vice president of sales and marketing, Malaney focused on sales, brand marketing, and expanding product line. (Today Retail Technologies is known as Retail Pro International (RPI), and is headquartered in Folsom, CA.)

Then in 1993, RTI eliminated its sales division to focus solely on software development. Sandy and her husband Mick seized the opportunity to open a software distributorship that included selling and supporting RTI’s point of sale and inventory management solution—Retail Pro.

The Malaneys didn’t need to look far for a business name. “Big Hairy Dog” described the family dog, Molly, an Old English Sheep Dog. Today, pups Dugan Finnegan and Paisley Rose continue to dutifully represent the family business.

Sandy Malaney’s varied experiences in business and in life prepared her for the rigors of owning a small technology firm. Celebrating 27 years (or—189 dog years) of success, Big Hairy Dog continues to expand in the retail market place, while providing an award-winning help desk to customers worldwide.

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Email
This field is for validation purposes and should be left unchanged.

TECHNICAL SUPPORT

tech@BigHairyDog.com

Support Hours

Monday – Friday: 6AM-6PM PST

PST Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Saturday: 9AM-5PM PST

Sunday: 9AM-2PM PST

After-Hours Phone Number:
916.368.1070

Fax: 916.368.1411

3205 Ramos Circle Sacramento, CA 95827

Name*
Organization / Business name*
Address*
Street Address Address Line 2 City State / Province / Region ZIP / Postal Code Country
Email*
Phone*
Message
Email
This field is for validation purposes and should be left unchanged.

BIG HAIRY DOG

3205 Ramos Circle
Sacramento, CA 95827
800-377-7776 FAX: 916-368-1411
Info@BigHairyDog.com

OFFICE HOURS

Monday – Friday: 8AM-6PM PST

Support Hours

Monday – Friday: 6AM-6PM PST
Saturday: 9AM-5PM PST
Sunday: 9AM-2PM PST

Mick Malaney President & Co-Founder
CELL: (916) 803-3939

Sandy Malaney CEO & Co-Founder
CELL: (916) 802-3939

Sales Department

800-377-7776 | 916-368-3939
Info@BigHairyDog.com
Karen Page CELL: 503-728-8396

Felicia Casper CELL: 916-956-9727

Technical Support Department

916-368-1070
Tech@BigHairyDog.com

Customer Service/Upgrade Service

800-377-7776 | 916-368-3939
Service@BigHairyDog.com

Administration/Billing

916-368-3939
Admin@BigHairyDog.com