Old data imported from other software. Statistics incomplete
Posted: Thu Aug 05, 2010 2:11 pm
Hello,
From 1963 until 2006 my company has managed all reservations 100% manually (no computer at all). From 2006 until 2009 my company was running Windows on its computers and we managed bookings with a dedicated software called PlanningTour, which back then was a FoxPro application that stored all data in xBase (DBF) files. We moved to Linux in 2009, and we begun using PHP-Residence. Last week, I have imported all the data from the software that I was using prior to PHP-Residence. I have all my customer details, plus all the reservations for the years 2008, 2007, and 2006 (reservations were managed 100% manually before that, so no previous data). All tables display correctly, all client details are right and I see their reservations since 2006, all amounts paid are fine, etc etc. All seems perfect, but... When I look at the statistics, I find:
- % occupancy: correct
- Number of reservations per month: correct
- Monthly income from reservations: incorrect, no data for imported years
- Average price per apartment occupied: incorrect, no data for imported years
- RevPar: incorrect, no data for imported years
- Daily income with added costs: incorrect, no data for imported years
- Accumulated income of reservations, by months: correct
Any clues about why some data of the years that I have imported are displayed on the statistics but others aren't? The tables with the imported reservations are complete and correct, except for the following fields, which are NULL: num_persone, idprenota_compagna, tariffesetimanali (tariffa and tariffa_tot are correct), incompatibilita, sconto, caparra, metodo_pagamento, and data_modifica. I insist, everything works completely fine and all the data displayed is right; the problem is only in some of the statistics.
Thanks, Eduard.
From 1963 until 2006 my company has managed all reservations 100% manually (no computer at all). From 2006 until 2009 my company was running Windows on its computers and we managed bookings with a dedicated software called PlanningTour, which back then was a FoxPro application that stored all data in xBase (DBF) files. We moved to Linux in 2009, and we begun using PHP-Residence. Last week, I have imported all the data from the software that I was using prior to PHP-Residence. I have all my customer details, plus all the reservations for the years 2008, 2007, and 2006 (reservations were managed 100% manually before that, so no previous data). All tables display correctly, all client details are right and I see their reservations since 2006, all amounts paid are fine, etc etc. All seems perfect, but... When I look at the statistics, I find:
- % occupancy: correct
- Number of reservations per month: correct
- Monthly income from reservations: incorrect, no data for imported years
- Average price per apartment occupied: incorrect, no data for imported years
- RevPar: incorrect, no data for imported years
- Daily income with added costs: incorrect, no data for imported years
- Accumulated income of reservations, by months: correct
Any clues about why some data of the years that I have imported are displayed on the statistics but others aren't? The tables with the imported reservations are complete and correct, except for the following fields, which are NULL: num_persone, idprenota_compagna, tariffesetimanali (tariffa and tariffa_tot are correct), incompatibilita, sconto, caparra, metodo_pagamento, and data_modifica. I insist, everything works completely fine and all the data displayed is right; the problem is only in some of the statistics.
Thanks, Eduard.