Aspect Software

 

Back-office software for Restaurateurs

 
 
 

How to Import Missing Data

 

(Revised 4/12/2000)


 

Aspect can import past labor information from all point-of-sale systems and past sales information from some point-of-sale systems.


If you find that you are missing past sales or labor information, or if you want to import data from a period prior to when you began using Aspect Software, follow the steps below.


 

Importing Past Labor Information


1.

Select Payroll / Edit Daily Labor. You will see one line for every day that has been imported from your point-of-sale system.

2.

To import a day that is not in the list, press the green plus on the button bar or press the INS key on your keyboard. When prompted, enter the date that you wish to import. Answer Yes when Aspect asks if you want to import the day.


If the day appears, but there is no information, continue with these steps:


3.

Press Ok to close the day that was just imported.

4.

Delete the day from the list by highlighting it and pressing the red minus on the toolbar or the DEL key on your keyboard.

5.

Close the Daily Labor window.

6.

Select Action / Import POS Daily Totals. (Note: This will re-import data for the prior day. Any adjustments you may have made to the timeclock entries will need to be made again).

7.

After the import is complete, repeat steps 1 & 2 to import the missing day.


If you have completed all of the steps above and there is still no information, then the timeclock data is not available from your point-of-sale system. This can happen if you reset or clear the timeclock on your point-of-sale system before it is imported into Aspect.


Note: To re-import a day that already appears in the list, you must first delete the day and then follow the steps above. To delete a day, highlight it in the list and press the red minus on the button bar or the DEL key on your keyboard.



 

Importing Past Sales Information


As of the creation of this document, historical sales information can be imported from Aloha and HIS point-of-sale systems.


To import past data:


1.

Select Sales / Sales Summary Report and open the report for a range of dates including the days to be imported.

2.

To import a day, right-click on the day and select Import Past Journal from the pop-up menu.

3.

Aspect will prompt you for the name of the journal to be imported. Do not change this name. It should already be correct. Press the Ok button to import the day.


After the import is complete, you should find that the sales summary report contains numbers for the day that were not there before. If you do not see any numbers for the day you just imported, double-click on the day to view the daily sales report for the day.


If data was not imported for the day, close the daily sales window, right-click on the day, and select Import Past Journal again. Note the file name that is given. Using Windows Explorer, locate the file on your computer.


If you cannot locate the file, then there is no journal file for that day and nothing to import. If you do find the file, compare the size of the file to other journal files. If the file is very small in comparison, it may not contain any data.


If you find the file in another location, select Import Past Journal and enter the correct file name.