New booking engine?

• Easy to use for guests
• Ability to run reports, both accounting and guest info retrieval
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons'
• Ability to integrate with OTA calendars
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability.
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other
• Hover feature that opens guest data without opening the whole record
• Guest records include all stays, not just present stay
• Flagging possible guest match on new reservations

Duff2014 said:

Time for Gomez to use that new computer to create your wish in his spare time and then you can retire while you two travel around the world selling his software to the innkeepers!

Okay maybe need to call in EN and Du, too…...

Click to expand...

Morticia said:

Ability to pull my old data in from my present system

Click to expand...

Morticia said:

Ok, new computer challenge done (Gomez has commandeered it, I'm back to using the old one), on to next thing on my list.
New booking software. What I want it to do:

• Easy to use for guests THE BOOKING PROCESS IS FAIRLY SIMPLE AND I'VE NEVER REALLY HAD COMPLAINTS FROM GUESTS, BUT IN SOME CASES APPLIED DISCOUNTS, WHILE LOWERING THE ROOM PRICE DO NOT MENTION THE DISCOUNT ON CONFIRMATION E-MAILS AND THIS HAS LEAD TO QUESTIONS AND INQUIRIES.
• Ability to run reports, both accounting and guest info retrieval THERE ARE MANY REPORTS AND MOST OF WHAT YOU NEED IS THERE. I'VE HAD PROBLEMS WITH SOME REPORTS BUT FOR THE MOST PART THEY HAVE GIVEN ME WHAT I'VE NEEDED.
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons' THIS ONE I HAVE NEVER BEEN ABLE TO FIGURE OUT HOW TO DO. SOME OF THE PACKAGE FUNCTIONS THAT WORK ON THE ONLINE BOOKING PORTION DO NOT WORK IN THE INTERNAL PMS. WE HAVE GENERALLY HAD TO USE THE ADD ON CAPABILITY.
• Ability to integrate with OTA calendars THEY HAVE PRETTY GOOD INTEGRATION WITH A 3RD PARTY CHANEL MANAGER (MYALLOCATOR) WHICH HAS WORKED WELL FOR US. MYALLOCATOR CONNECTS TO SOMETHING LIKE 85 CHANELS, INCLUDING EXPEDIA, BOOKING.COM, AIRBNB, TRIPADVISOR, AND BEDANDBREAKFAST.COM RECENTLY THEY ADDED THE CAPABILITY TO UPLOAD PRICES TO THE CHANEL MANAGER BY PUSHING A BUTTON. IT WILL NOT UPLOAD PRICING WHICH IS AFFECTED BY THE YIELD MANAGEMENT FUNCTION (WHICH IS A NICE FUNCTION BUT WE CAN'T USE IT BECAUSE IT DOES NOT UPLOAD TO THE CHANEL MANAGER)
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that. THEY DID A PRETTY GOOD JOB IMPORTING A COUPLE OF YEARS OF DATA BUT IT WAS NOT PERFECT. I'M NOT SURE IF THEY WILL IMPORT 12 YEARS WORTH.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability. THEY HAVE A CALENDAR OPTION
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other THEY HAVE BOTH COLOR CODING AND ANOTHER MARKING TOOL CALLED REMINDERS (PUTS LITTLE SYMBOLS ON THE RESERVATION IN THE CALENDAR)
• Hover feature that opens guest data without opening the whole record PROVIDES SOME LIMITED INFORMATION IN THIS FASHION
• Guest records include all stays, not just present stay IT DOES THIS
• Flagging possible guest match on new reservations NOT SURE WHAT YOU MEAN HERE

Ok, what have you got?

Click to expand...

JerseyBoy said:

Morticia said:

Ok, new computer challenge done (Gomez has commandeered it, I'm back to using the old one), on to next thing on my list.
New booking software. What I want it to do:

• Easy to use for guests THE BOOKING PROCESS IS FAIRLY SIMPLE AND I'VE NEVER REALLY HAD COMPLAINTS FROM GUESTS, BUT IN SOME CASES APPLIED DISCOUNTS, WHILE LOWERING THE ROOM PRICE DO NOT MENTION THE DISCOUNT ON CONFIRMATION E-MAILS AND THIS HAS LEAD TO QUESTIONS AND INQUIRIES.
• Ability to run reports, both accounting and guest info retrieval THERE ARE MANY REPORTS AND MOST OF WHAT YOU NEED IS THERE. I'VE HAD PROBLEMS WITH SOME REPORTS BUT FOR THE MOST PART THEY HAVE GIVEN ME WHAT I'VE NEEDED.
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons' THIS ONE I HAVE NEVER BEEN ABLE TO FIGURE OUT HOW TO DO. SOME OF THE PACKAGE FUNCTIONS THAT WORK ON THE ONLINE BOOKING PORTION DO NOT WORK IN THE INTERNAL PMS. WE HAVE GENERALLY HAD TO USE THE ADD ON CAPABILITY.
• Ability to integrate with OTA calendars THEY HAVE PRETTY GOOD INTEGRATION WITH A 3RD PARTY CHANEL MANAGER (MYALLOCATOR) WHICH HAS WORKED WELL FOR US. MYALLOCATOR CONNECTS TO SOMETHING LIKE 85 CHANELS, INCLUDING EXPEDIA, BOOKING.COM, AIRBNB, TRIPADVISOR, AND BEDANDBREAKFAST.COM RECENTLY THEY ADDED THE CAPABILITY TO UPLOAD PRICES TO THE CHANEL MANAGER BY PUSHING A BUTTON. IT WILL NOT UPLOAD PRICING WHICH IS AFFECTED BY THE YIELD MANAGEMENT FUNCTION (WHICH IS A NICE FUNCTION BUT WE CAN'T USE IT BECAUSE IT DOES NOT UPLOAD TO THE CHANEL MANAGER)
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that. THEY DID A PRETTY GOOD JOB IMPORTING A COUPLE OF YEARS OF DATA BUT IT WAS NOT PERFECT. I'M NOT SURE IF THEY WILL IMPORT 12 YEARS WORTH.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability. THEY HAVE A CALENDAR OPTION
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other THEY HAVE BOTH COLOR CODING AND ANOTHER MARKING TOOL CALLED REMINDERS (PUTS LITTLE SYMBOLS ON THE RESERVATION IN THE CALENDAR)
• Hover feature that opens guest data without opening the whole record PROVIDES SOME LIMITED INFORMATION IN THIS FASHION
• Guest records include all stays, not just present stay IT DOES THIS
• Flagging possible guest match on new reservations NOT SURE WHAT YOU MEAN HERE

Ok, what have you got?

Click to expand...

I have been using RK for several years and generally like it but have been having some issues with functions we use or need and am looking at other systems right now too. Having said that Morticia, it probably will meet almost all of your needs and is a very cost effective solution. I am making some comments above in the quote of your original text, using all CAPS
Just wondering what system you are moving from?.

Click to expand...

gillumhouse said:

JerseyBoy said:

Morticia said:

Ok, new computer challenge done (Gomez has commandeered it, I'm back to using the old one), on to next thing on my list.
New booking software. What I want it to do:

• Easy to use for guests THE BOOKING PROCESS IS FAIRLY SIMPLE AND I'VE NEVER REALLY HAD COMPLAINTS FROM GUESTS, BUT IN SOME CASES APPLIED DISCOUNTS, WHILE LOWERING THE ROOM PRICE DO NOT MENTION THE DISCOUNT ON CONFIRMATION E-MAILS AND THIS HAS LEAD TO QUESTIONS AND INQUIRIES.
• Ability to run reports, both accounting and guest info retrieval THERE ARE MANY REPORTS AND MOST OF WHAT YOU NEED IS THERE. I'VE HAD PROBLEMS WITH SOME REPORTS BUT FOR THE MOST PART THEY HAVE GIVEN ME WHAT I'VE NEEDED.
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons' THIS ONE I HAVE NEVER BEEN ABLE TO FIGURE OUT HOW TO DO. SOME OF THE PACKAGE FUNCTIONS THAT WORK ON THE ONLINE BOOKING PORTION DO NOT WORK IN THE INTERNAL PMS. WE HAVE GENERALLY HAD TO USE THE ADD ON CAPABILITY.
• Ability to integrate with OTA calendars THEY HAVE PRETTY GOOD INTEGRATION WITH A 3RD PARTY CHANEL MANAGER (MYALLOCATOR) WHICH HAS WORKED WELL FOR US. MYALLOCATOR CONNECTS TO SOMETHING LIKE 85 CHANELS, INCLUDING EXPEDIA, BOOKING.COM, AIRBNB, TRIPADVISOR, AND BEDANDBREAKFAST.COM RECENTLY THEY ADDED THE CAPABILITY TO UPLOAD PRICES TO THE CHANEL MANAGER BY PUSHING A BUTTON. IT WILL NOT UPLOAD PRICING WHICH IS AFFECTED BY THE YIELD MANAGEMENT FUNCTION (WHICH IS A NICE FUNCTION BUT WE CAN'T USE IT BECAUSE IT DOES NOT UPLOAD TO THE CHANEL MANAGER)
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that. THEY DID A PRETTY GOOD JOB IMPORTING A COUPLE OF YEARS OF DATA BUT IT WAS NOT PERFECT. I'M NOT SURE IF THEY WILL IMPORT 12 YEARS WORTH.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability. THEY HAVE A CALENDAR OPTION
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other THEY HAVE BOTH COLOR CODING AND ANOTHER MARKING TOOL CALLED REMINDERS (PUTS LITTLE SYMBOLS ON THE RESERVATION IN THE CALENDAR)
• Hover feature that opens guest data without opening the whole record PROVIDES SOME LIMITED INFORMATION IN THIS FASHION
• Guest records include all stays, not just present stay IT DOES THIS
• Flagging possible guest match on new reservations NOT SURE WHAT YOU MEAN HERE

Ok, what have you got?

Click to expand...

I have been using RK for several years and generally like it but have been having some issues with functions we use or need and am looking at other systems right now too. Having said that Morticia, it probably will meet almost all of your needs and is a very cost effective solution. I am making some comments above in the quote of your original text, using all CAPS
Just wondering what system you are moving from?.

Click to expand...

I have RezKey and I also have Packages that post one price, not as add-ons.
.

Click to expand...

gillumhouse said:

JerseyBoy said:

Morticia said:

Ok, new computer challenge done (Gomez has commandeered it, I'm back to using the old one), on to next thing on my list.
New booking software. What I want it to do:

• Easy to use for guests THE BOOKING PROCESS IS FAIRLY SIMPLE AND I'VE NEVER REALLY HAD COMPLAINTS FROM GUESTS, BUT IN SOME CASES APPLIED DISCOUNTS, WHILE LOWERING THE ROOM PRICE DO NOT MENTION THE DISCOUNT ON CONFIRMATION E-MAILS AND THIS HAS LEAD TO QUESTIONS AND INQUIRIES.
• Ability to run reports, both accounting and guest info retrieval THERE ARE MANY REPORTS AND MOST OF WHAT YOU NEED IS THERE. I'VE HAD PROBLEMS WITH SOME REPORTS BUT FOR THE MOST PART THEY HAVE GIVEN ME WHAT I'VE NEEDED.
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons' THIS ONE I HAVE NEVER BEEN ABLE TO FIGURE OUT HOW TO DO. SOME OF THE PACKAGE FUNCTIONS THAT WORK ON THE ONLINE BOOKING PORTION DO NOT WORK IN THE INTERNAL PMS. WE HAVE GENERALLY HAD TO USE THE ADD ON CAPABILITY.
• Ability to integrate with OTA calendars THEY HAVE PRETTY GOOD INTEGRATION WITH A 3RD PARTY CHANEL MANAGER (MYALLOCATOR) WHICH HAS WORKED WELL FOR US. MYALLOCATOR CONNECTS TO SOMETHING LIKE 85 CHANELS, INCLUDING EXPEDIA, BOOKING.COM, AIRBNB, TRIPADVISOR, AND BEDANDBREAKFAST.COM RECENTLY THEY ADDED THE CAPABILITY TO UPLOAD PRICES TO THE CHANEL MANAGER BY PUSHING A BUTTON. IT WILL NOT UPLOAD PRICING WHICH IS AFFECTED BY THE YIELD MANAGEMENT FUNCTION (WHICH IS A NICE FUNCTION BUT WE CAN'T USE IT BECAUSE IT DOES NOT UPLOAD TO THE CHANEL MANAGER)
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that. THEY DID A PRETTY GOOD JOB IMPORTING A COUPLE OF YEARS OF DATA BUT IT WAS NOT PERFECT. I'M NOT SURE IF THEY WILL IMPORT 12 YEARS WORTH.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability. THEY HAVE A CALENDAR OPTION
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other THEY HAVE BOTH COLOR CODING AND ANOTHER MARKING TOOL CALLED REMINDERS (PUTS LITTLE SYMBOLS ON THE RESERVATION IN THE CALENDAR)
• Hover feature that opens guest data without opening the whole record PROVIDES SOME LIMITED INFORMATION IN THIS FASHION
• Guest records include all stays, not just present stay IT DOES THIS
• Flagging possible guest match on new reservations NOT SURE WHAT YOU MEAN HERE

Ok, what have you got?

Click to expand...

I have been using RK for several years and generally like it but have been having some issues with functions we use or need and am looking at other systems right now too. Having said that Morticia, it probably will meet almost all of your needs and is a very cost effective solution. I am making some comments above in the quote of your original text, using all CAPS
Just wondering what system you are moving from?.

Click to expand...

I have RezKey and I also have Packages that post one price, not as add-ons.
.

Click to expand...

JerseyBoy said:

gillumhouse said:

JerseyBoy said:

Morticia said:

Ok, new computer challenge done (Gomez has commandeered it, I'm back to using the old one), on to next thing on my list.
New booking software. What I want it to do:

• Easy to use for guests THE BOOKING PROCESS IS FAIRLY SIMPLE AND I'VE NEVER REALLY HAD COMPLAINTS FROM GUESTS, BUT IN SOME CASES APPLIED DISCOUNTS, WHILE LOWERING THE ROOM PRICE DO NOT MENTION THE DISCOUNT ON CONFIRMATION E-MAILS AND THIS HAS LEAD TO QUESTIONS AND INQUIRIES.
• Ability to run reports, both accounting and guest info retrieval THERE ARE MANY REPORTS AND MOST OF WHAT YOU NEED IS THERE. I'VE HAD PROBLEMS WITH SOME REPORTS BUT FOR THE MOST PART THEY HAVE GIVEN ME WHAT I'VE NEEDED.
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons' THIS ONE I HAVE NEVER BEEN ABLE TO FIGURE OUT HOW TO DO. SOME OF THE PACKAGE FUNCTIONS THAT WORK ON THE ONLINE BOOKING PORTION DO NOT WORK IN THE INTERNAL PMS. WE HAVE GENERALLY HAD TO USE THE ADD ON CAPABILITY.
• Ability to integrate with OTA calendars THEY HAVE PRETTY GOOD INTEGRATION WITH A 3RD PARTY CHANEL MANAGER (MYALLOCATOR) WHICH HAS WORKED WELL FOR US. MYALLOCATOR CONNECTS TO SOMETHING LIKE 85 CHANELS, INCLUDING EXPEDIA, BOOKING.COM, AIRBNB, TRIPADVISOR, AND BEDANDBREAKFAST.COM RECENTLY THEY ADDED THE CAPABILITY TO UPLOAD PRICES TO THE CHANEL MANAGER BY PUSHING A BUTTON. IT WILL NOT UPLOAD PRICING WHICH IS AFFECTED BY THE YIELD MANAGEMENT FUNCTION (WHICH IS A NICE FUNCTION BUT WE CAN'T USE IT BECAUSE IT DOES NOT UPLOAD TO THE CHANEL MANAGER)
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that. THEY DID A PRETTY GOOD JOB IMPORTING A COUPLE OF YEARS OF DATA BUT IT WAS NOT PERFECT. I'M NOT SURE IF THEY WILL IMPORT 12 YEARS WORTH.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability. THEY HAVE A CALENDAR OPTION
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other THEY HAVE BOTH COLOR CODING AND ANOTHER MARKING TOOL CALLED REMINDERS (PUTS LITTLE SYMBOLS ON THE RESERVATION IN THE CALENDAR)
• Hover feature that opens guest data without opening the whole record PROVIDES SOME LIMITED INFORMATION IN THIS FASHION
• Guest records include all stays, not just present stay IT DOES THIS
• Flagging possible guest match on new reservations NOT SURE WHAT YOU MEAN HERE

Ok, what have you got?

Click to expand...

I have been using RK for several years and generally like it but have been having some issues with functions we use or need and am looking at other systems right now too. Having said that Morticia, it probably will meet almost all of your needs and is a very cost effective solution. I am making some comments above in the quote of your original text, using all CAPS
Just wondering what system you are moving from?.

Click to expand...

I have RezKey and I also have Packages that post one price, not as add-ons.
.

Click to expand...

Can you tell me how you do that? I've tried several times but could not figure it out.
.

Click to expand...

EmptyNest said:

JerseyBoy said:

gillumhouse said:

JerseyBoy said:

Morticia said:

Ok, new computer challenge done (Gomez has commandeered it, I'm back to using the old one), on to next thing on my list.
New booking software. What I want it to do:

• Easy to use for guests THE BOOKING PROCESS IS FAIRLY SIMPLE AND I'VE NEVER REALLY HAD COMPLAINTS FROM GUESTS, BUT IN SOME CASES APPLIED DISCOUNTS, WHILE LOWERING THE ROOM PRICE DO NOT MENTION THE DISCOUNT ON CONFIRMATION E-MAILS AND THIS HAS LEAD TO QUESTIONS AND INQUIRIES.
• Ability to run reports, both accounting and guest info retrieval THERE ARE MANY REPORTS AND MOST OF WHAT YOU NEED IS THERE. I'VE HAD PROBLEMS WITH SOME REPORTS BUT FOR THE MOST PART THEY HAVE GIVEN ME WHAT I'VE NEEDED.
• Ability to create packages that show the guest ONE price and don't break the package into 'room' + 'add ons' THIS ONE I HAVE NEVER BEEN ABLE TO FIGURE OUT HOW TO DO. SOME OF THE PACKAGE FUNCTIONS THAT WORK ON THE ONLINE BOOKING PORTION DO NOT WORK IN THE INTERNAL PMS. WE HAVE GENERALLY HAD TO USE THE ADD ON CAPABILITY.
• Ability to integrate with OTA calendars THEY HAVE PRETTY GOOD INTEGRATION WITH A 3RD PARTY CHANEL MANAGER (MYALLOCATOR) WHICH HAS WORKED WELL FOR US. MYALLOCATOR CONNECTS TO SOMETHING LIKE 85 CHANELS, INCLUDING EXPEDIA, BOOKING.COM, AIRBNB, TRIPADVISOR, AND BEDANDBREAKFAST.COM RECENTLY THEY ADDED THE CAPABILITY TO UPLOAD PRICES TO THE CHANEL MANAGER BY PUSHING A BUTTON. IT WILL NOT UPLOAD PRICING WHICH IS AFFECTED BY THE YIELD MANAGEMENT FUNCTION (WHICH IS A NICE FUNCTION BUT WE CAN'T USE IT BECAUSE IT DOES NOT UPLOAD TO THE CHANEL MANAGER)
• Ability to pull my old data in from my present system (I understand a certain amount of data loss occurs so I'm planning to keep my old system and manually transfer the most important data - guest notes) Losing 12 years of guest history is what will hurt the most so I need to be able to go back and retrieve that. THEY DID A PRETTY GOOD JOB IMPORTING A COUPLE OF YEARS OF DATA BUT IT WAS NOT PERFECT. I'M NOT SURE IF THEY WILL IMPORT 12 YEARS WORTH.
• It has to have the calendar feature available to guests. As a guest I refuse to enter date after date to find Availability. THEY HAVE A CALENDAR OPTION
• Color coding on my side so I can code by color things like: dietary issues, OTA guest, package or add on, other THEY HAVE BOTH COLOR CODING AND ANOTHER MARKING TOOL CALLED REMINDERS (PUTS LITTLE SYMBOLS ON THE RESERVATION IN THE CALENDAR)
• Hover feature that opens guest data without opening the whole record PROVIDES SOME LIMITED INFORMATION IN THIS FASHION
• Guest records include all stays, not just present stay IT DOES THIS
• Flagging possible guest match on new reservations NOT SURE WHAT YOU MEAN HERE

Ok, what have you got?

Click to expand...

I have been using RK for several years and generally like it but have been having some issues with functions we use or need and am looking at other systems right now too. Having said that Morticia, it probably will meet almost all of your needs and is a very cost effective solution. I am making some comments above in the quote of your original text, using all CAPS
Just wondering what system you are moving from?.

Click to expand...

I have RezKey and I also have Packages that post one price, not as add-ons.
.

Click to expand...

Can you tell me how you do that? I've tried several times but could not figure it out.
.

Click to expand...

For my clients, we have room rate separate from package. I set up items for sale and create say a romance package with roses, candy and massage for one price.
guest can choose their package and room separately. Works fine.
.

Click to expand...

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

Morticia said:

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.
I'm figuring I will just do a search on who has been coming for years and copy thos records by hand.
I need it mostly for who gets what perk. But that's all in the guest notes, which probably won't transfer no matter what.
.

Click to expand...

Morticia said:

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.

Click to expand...

JimBoone said:

Morticia said:

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.
I'm figuring I will just do a search on who has been coming for years and copy thos records by hand.
I need it mostly for who gets what perk. But that's all in the guest notes, which probably won't transfer no matter what.
.

Click to expand...

Morticia said:

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.

Click to expand...

It may not be as bad or difficult as you think of course you may rent more rooms in a year than I do, 1000 - 1500 a year. Database should be a group of relational tables, sounds like you are mostly wanting your guest info, name, address, notes. For fun I downloaded that info from RK for the six months I have used it into a spreadsheet, gave me around 500 lines in the sheet and less than a megabyte of data, taking that out 12 years at my rate might give me 10 megabytes and 10 to 20 thousand records, that's not really large for data. My database at work was getting close to a terabyte of information and some tables had records in hundreds of thousands.
Why not try it and see the result, I'm glad to help if I can. I've been downloading my payment and reservation data each month into my own database as that lets me pull out information in a manner that is easier for me to compare with Maxine's hand written book.
.

Click to expand...

Morticia said:

JimBoone said:

Morticia said:

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.
I'm figuring I will just do a search on who has been coming for years and copy thos records by hand.
I need it mostly for who gets what perk. But that's all in the guest notes, which probably won't transfer no matter what.
.

Click to expand...

Morticia said:

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.

Click to expand...

It may not be as bad or difficult as you think of course you may rent more rooms in a year than I do, 1000 - 1500 a year. Database should be a group of relational tables, sounds like you are mostly wanting your guest info, name, address, notes. For fun I downloaded that info from RK for the six months I have used it into a spreadsheet, gave me around 500 lines in the sheet and less than a megabyte of data, taking that out 12 years at my rate might give me 10 megabytes and 10 to 20 thousand records, that's not really large for data. My database at work was getting close to a terabyte of information and some tables had records in hundreds of thousands.
Why not try it and see the result, I'm glad to help if I can. I've been downloading my payment and reservation data each month into my own database as that lets me pull out information in a manner that is easier for me to compare with Maxine's hand written book.
.

Click to expand...

I have no idea how to do that! There's no 'download to file' button anywhere! I'll have to ask. From what I heard from another inn, it was $700 to build the DB when they switched.
.

Click to expand...

Morticia said:

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.
I'm figuring I will just do a search on who has been coming for years and copy thos records by hand.
I need it mostly for who gets what perk. But that's all in the guest notes, which probably won't transfer no matter what.
.

Click to expand...

Morticia said:

JimBoone said:

Morticia said:

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.
I'm figuring I will just do a search on who has been coming for years and copy thos records by hand.
I need it mostly for who gets what perk. But that's all in the guest notes, which probably won't transfer no matter what.
.

Click to expand...

Morticia said:

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.

Click to expand...

It may not be as bad or difficult as you think of course you may rent more rooms in a year than I do, 1000 - 1500 a year. Database should be a group of relational tables, sounds like you are mostly wanting your guest info, name, address, notes. For fun I downloaded that info from RK for the six months I have used it into a spreadsheet, gave me around 500 lines in the sheet and less than a megabyte of data, taking that out 12 years at my rate might give me 10 megabytes and 10 to 20 thousand records, that's not really large for data. My database at work was getting close to a terabyte of information and some tables had records in hundreds of thousands.
Why not try it and see the result, I'm glad to help if I can. I've been downloading my payment and reservation data each month into my own database as that lets me pull out information in a manner that is easier for me to compare with Maxine's hand written book.
.

Click to expand...

I have no idea how to do that! There's no 'download to file' button anywhere! I'll have to ask. From what I heard from another inn, it was $700 to build the DB when they switched.
.

Click to expand...

EmptyNest said:

Morticia said:

JimBoone said:

Morticia said:

EmptyNest said:

You can try it for free for a month. So why wonder, just give it a shot. I don't think I would import 12 years of guests but create a smaller version from your spreadsheet and use it.
Why would you want 12 years of guest records? How many of those actually come back? Or are on your donot book list?.

Click to expand...

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.
I'm figuring I will just do a search on who has been coming for years and copy thos records by hand.
I need it mostly for who gets what perk. But that's all in the guest notes, which probably won't transfer no matter what.
.

Click to expand...

Morticia said:

I don't have a spreadsheet of guest data and that's part of the problem. A data dump would be enormous.

Click to expand...

It may not be as bad or difficult as you think of course you may rent more rooms in a year than I do, 1000 - 1500 a year. Database should be a group of relational tables, sounds like you are mostly wanting your guest info, name, address, notes. For fun I downloaded that info from RK for the six months I have used it into a spreadsheet, gave me around 500 lines in the sheet and less than a megabyte of data, taking that out 12 years at my rate might give me 10 megabytes and 10 to 20 thousand records, that's not really large for data. My database at work was getting close to a terabyte of information and some tables had records in hundreds of thousands.
Why not try it and see the result, I'm glad to help if I can. I've been downloading my payment and reservation data each month into my own database as that lets me pull out information in a manner that is easier for me to compare with Maxine's hand written book.
.

Click to expand...

I have no idea how to do that! There's no 'download to file' button anywhere! I'll have to ask. From what I heard from another inn, it was $700 to build the DB when they switched.
.

Click to expand...

Be realistic why do you need 12 years of data? Download the file from your current system and see what you've got first. Then you may be able to weed it all out and come up with the ones you really need to keep. I also like that idea of having a check box for new or returning guest.
.

Click to expand...