Welcome to the Piano World Piano Forums
Over 2 million posts about pianos, digital pianos, and all types of keyboard instruments
Join the World's Largest Community of Piano Lovers (it's free)
It's Fun to Play the Piano ... Please Pass It On!

SEARCH
the Forums & Piano World

This custom search works much better than the built in one and allows searching older posts.
(ad 125) Sweetwater - Digital Keyboards & Other Gear
Digital Pianos at Sweetwater
(ad) Pearl River
Pearl River Pianos
(ad) Pianoteq
Latest Pianoteq add-on instrument: U4 upright piano
(ad) P B Guide
Acoustic & Digital Piano Guide
PianoSupplies.com (150)
Piano Accessories Music Related Gifts Piano Tuning Equipment Piano Moving Equipment
We now offer Gift Certificates in our online store!
(ad) Estonia Piano
Estonia Piano
Quick Links to Useful Stuff
Our Classified Ads
Find Piano Professionals-

*Piano Dealers - Piano Stores
*Piano Tuners
*Piano Teachers
*Piano Movers
*Piano Restorations
*Piano Manufacturers
*Organs

Quick Links:
*Advertise On Piano World
*Free Piano Newsletter
*Online Piano Recitals
*Piano Recitals Index
*Piano Accessories
* Buying a Piano
*Buying A Acoustic Piano
*Buying a Digital Piano
*Pianos for Sale
*Sell Your Piano
*How Old is My Piano?
*Piano Books
*Piano Art, Pictures, & Posters
*Directory/Site Map
*Contest
*Links
*Virtual Piano
*Music Word Search
*Piano Screen Saver
*Piano Videos
*Virtual Piano Chords
Topic Options
#638109 - 08/18/03 02:17 PM Tuning customer database for Mac?
Rick Clark Offline
1000 Post Club Member

Registered: 01/04/03
Posts: 1810
Loc: North County San Diego CA
Hi All,

I assume all you techs know what the needs are.... keeping track of all the customers and their piano service records, have their names come up in 6 months for reminders, etc, cross referencing in various ways.....

I used to have Reyburn Piano Service manager which served the purpose quite nicely. But that was PC DOS and now I'm on a Mac with OSX. I've been checking around for a new pgm but nothing seems to fit the bill. Right now the simpleist and most effective system seems to be plain old 3X5 cards in a little box using the tickle file system.

I don't want some giant database program that will take the next month to learn and has 10,000X more capability than I will ever use. I'm just looking for one that understands managing customer info on my level. Something like the Reyburn pgm did. Is anyone using anything for Mac that simple/effective/cool?

I appreciate any suggestions.

Regards,

Rick Clark
_________________________
Rick Clark

Piano tuner-technician

Top
(ad PTG 568) Grand Action Regulation in 37 Steps
Grand Action Regulation in 37 Steps
#638110 - 08/18/03 03:45 PM Re: Tuning customer database for Mac?
Eric Gloo_dup1 Offline
Full Member

Registered: 06/05/03
Posts: 43
Loc: Richfield Springs, New York
Rick,

I did a Google search and came up with a couple of posts in "pianotech" - one from Dean Reyburn, himself. However, they're old posts (1996 and 1997). Not sure if you've seen them or not.
_________________________
Eric Gloo
Piano Technician

Top
#638111 - 08/18/03 08:10 PM Re: Tuning customer database for Mac?
Rick Clark Offline
1000 Post Club Member

Registered: 01/04/03
Posts: 1810
Loc: North County San Diego CA
Thanks Eric. No I didn't see those posts but that is too long ago. That was back when I bought my copy. Reyburn no longer supports that product. It was a DOS-only deal, now if you even want to ask him a question it costs $50 support fee..
Regards,

Rick Clark
_________________________
Rick Clark

Piano tuner-technician

Top
#638112 - 08/18/03 11:46 PM Re: Tuning customer database for Mac?
Matt G. Offline
3000 Post Club Member

Registered: 06/22/01
Posts: 3789
Loc: Plainfield, IL
Rick, don't know a whole lot about pgms for the Mac, but either Outlook or Act would probably work just fine. They are contact and calendar driven, and reminders can be set for any period, before or after an appointment. Outlook is part of MS Office, which I know is available for OSX, and I'm pretty sure (but not certain) Act is available as well.
_________________________
Sacred cows make the best hamburger. - Clemens

Top
#638113 - 08/20/03 07:51 AM Re: Tuning customer database for Mac?
Bob Offline
3000 Post Club Member

Registered: 06/01/01
Posts: 3866
For my customer list I simply use a spreadsheet such as excel which works for Macs and pc. For windows users, works data base works well. I can sort it by any field, and best of all, it syncs with my palm, so I have access to it on the road. Mailings are as simple as sorting by next tuning date, last tuning date, town, or what ever criteria you want, saving the file, and printing labels with a word processor.
_________________________
www.PianoTunerOrlando.com






Top
#638114 - 08/20/03 12:46 PM Re: Tuning customer database for Mac?
Rick Clark Offline
1000 Post Club Member

Registered: 01/04/03
Posts: 1810
Loc: North County San Diego CA
Thanks Matt and Bob for the additional reponses.

I found Outlook Express in the Mac but I guess that's not the same as Outlook because it just seems to be an email pgm.

I looked at Excel earlier (with no manual) and it looked to me like accounting, but I really didn't explore it or how it might be customized. First of all I'm unfamiliar with how to use spreadsheets in general and second of all with no manual it's kind of hard to figure out.

I'll delve into it a bit further however, maybe get an Excel book from the library and see what I can make it do.

However since my first post I found that the Address Book in Eudora 5.2 for Mac might be quite useful for my pupose if I ignore their labels on certain fields and enter different kinds of data, so that "Country" = "date of last tuning", etc. I can then call up a list of customers by "date of last tuning" or any other of several fields in addition to the usual alphabetical order. Actually if this Address Book only had a date reminder function, it might meet my needs 100%.

Thanks Again,

Rick Clark
_________________________
Rick Clark

Piano tuner-technician

Top
#638115 - 08/20/03 01:35 PM Re: Tuning customer database for Mac?
Rick Clark Offline
1000 Post Club Member

Registered: 01/04/03
Posts: 1810
Loc: North County San Diego CA
Bob,

What sections of Excel do you use for this? I'm looking at it and darned if I can begin to figure out even where to put Name, Address, Phone, etc.

Rick
_________________________
Rick Clark

Piano tuner-technician

Top
#638116 - 08/20/03 01:40 PM Re: Tuning customer database for Mac?
BDB Offline
Yikes! 10000 Post Club Member

Registered: 06/07/03
Posts: 21529
Loc: Oakland
If you use Excel, you need to set up a spreadsheet, or use a template that comes with it. You could use Entourage, which is a contact manager, as well as an email client.

I've written my own stuff, using Panorama, a database from Provue.
_________________________
Semipro Tech

Top
#638117 - 08/20/03 01:51 PM Re: Tuning customer database for Mac?
Brian Lawson, RPT Offline
500 Post Club Member

Registered: 07/04/01
Posts: 647
Loc: South Africa
_________________________
Brian Lawson, RPT
Johannesburg
South Africa

http://www.lawsonic.co.za

Top
#638118 - 08/20/03 06:14 PM Re: Tuning customer database for Mac?
Rick Clark Offline
1000 Post Club Member

Registered: 01/04/03
Posts: 1810
Loc: North County San Diego CA
Thanks for additional comments. I looked at Entourage and saw how it would work... post learning curve of course. I also checked those PTG references.

But as of now I'm pretty happy with what I have figured out with Eudora. I figured out ways to give me lists of "next tuning due", "last tuning done", etc in their proper sequential order. I'm actually kind of tickled because the trick is by writing dates yy/mm/dd, Eudora will "alphabetize" dates in sequence.

It may not be the most elegant thing, but simple and no learning curve, so I am already at work.

BTW the Eudora addy book is not unlike the one in Entourage.

Regards,

Rick Clark
_________________________
Rick Clark

Piano tuner-technician

Top
#638119 - 08/21/03 06:18 PM Re: Tuning customer database for Mac?
Bob Offline
3000 Post Club Member

Registered: 06/01/01
Posts: 3866
Using an excel spreadsheet, or the data base on Works, each row is a customer, each column is a data field.

For example, columns could be titled "next tune", "last tune", "FName", "Lname", "address", "city","zip","type" (my number code for grand, studio, console, piano I don't want to see again!! etc),"comments", and "last price paid".

Once entered in spread sheet form, the customer list can be sorted by any columns you want, for example,

next tuning date for people in Naperville

Schools in Joliet

Pianos I never want to see again (used for purging my customer list)

It's not very hard to use a spreadsheet to do this, and merge info into a compatible word processor to print labels.

All this syncs to my palm, so I can look up a customer's info while on the road. I know their last tuning date, what they paid, and any extra work done, etc.
_________________________
www.PianoTunerOrlando.com






Top
#638120 - 08/22/03 10:39 AM Re: Tuning customer database for Mac?
Rick Clark Offline
1000 Post Club Member

Registered: 01/04/03
Posts: 1810
Loc: North County San Diego CA
Thanks Bob, I see what you are saying.

Regards,

Rick Clark
_________________________
Rick Clark

Piano tuner-technician

Top

Moderator:  Piano World 
What's Hot!!
HOW TO POST PICTURES on the Piano Forums
-------------------
Sharing is Caring!
About the Buttons
-------------------
Forums Rules & Help
-------------------
ADVERTISE
on Piano World

The world's most popular piano web site.
-------------------
PIANO BOOKS
Interesting books about the piano, pianists, piano history, biographies, memoirs and more!
(ad) HAILUN Pianos
Hailun Pianos - Click for More
ad (Casio)
Celviano by Casio Rebate
Ad (Seiler/Knabe)
Seiler Pianos
Sheet Music
(PW is an affiliate)
Sheet Music Plus Featured Sale
(125ad) Dampp Chaser
Dampp Chaser Piano Life Saver
(ad) Lindeblad Piano
Lindeblad Piano Restoration
New Topics - Multiple Forums
Just Checked out a Richmond Studio upright
by Paul678
6 minutes 4 seconds ago
Piece ID
by IstvánE
Yesterday at 10:14 PM
Pre purchase inspection
by mellie62
Yesterday at 10:00 PM
Do Parents want to hear the truth anymore?
by chasingrainbows
Yesterday at 09:28 PM
DEBUSSY- 'The terrace for moonlit audiences'
by Hal Freedman
Yesterday at 07:49 PM
Who's Online
66 registered (barbaram, accordeur, Ben_NZ, billpst, AliAlkhiro, 12 invisible), 952 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
76281 Members
42 Forums
157682 Topics
2316091 Posts

Max Online: 15252 @ 03/21/10 11:39 PM
(ads by Google)

Visit our online store for gifts for music lovers

 
Help keep the forums up and running with a donation, any amount is appreciated!
Or by becoming a Subscribing member! Thank-you.
Donate   Subscribe
 
Our Piano Related Classified Ads
|
Dealers | Tuners | Lessons | Movers | Restorations | Pianos For Sale | Sell Your Piano |

Advertise on Piano World
| Subscribe | Piano World | PianoSupplies.com | Advertise on Piano World | Donate | Link to Us | Classifieds |
| |Contact | Privacy | Legal | About Us | Site Map | Free Newsletter | Press Room |


copyright 1997 - 2014 Piano World ® all rights reserved
No part of this site may be reproduced without prior written permission