Issue Summary: Please reprocess files so all new accounts are added
Description:
I am checking the most recent batch of files that were added through the Hilton, Hyatt, Marriott, and Four Seasons connectors and it looks like all accounts/records were processed, but some new accounts didn’t get added to the account table. Below is a list of the discrepancies in record count, by file. Please reprocess so all new accounts are added. I will map if need. Then we’ll need to process again to make sure the final, correct totals are showing up for all these datafiles/hotels.
Merit Marriott PL Actual 2022-06.txt – 5704 records in file log, but 5688 when I check in excel
Merit Marriott BS Actual 2022-06.txt – 380 records in file log, but 378 when I check in excel
Starwood Hilton PL Actual 2022-06.csv – 863 records in file log, but 861 in excel
Starwood Marriott PL Actual 2022-06.txt – 4476 records in file log, but 4455 in excel
Starwood Marriott BS Actual 2022-06.txt – 416 records in file log, but 413 in excel
Sunstone Marriott PL Actual 2022-06.txt – 9719 records in file log, but 8494 in excel
Sunstone Marriott BS Actual 2022-06.txt – 610 in file log, but 501 in excel
Sunstone Hilton PL Actual 2022-06.csv – 1520 in file log, but 1511 in excel
Sunstone SFORS Hyatt Actual 2022-06.csv – 1208 in file log, 1196 in excel
Sunstone MIAOB Hyatt Actual 2022-06.csv – 2162 in file log, 2158 in excel
Geolo SEATH Hyatt Actual 2022-06.csv – 1407 in file log, 1401 in excel
Gencom LIRAZ Hyatt Actual 2022-06.csv – 1332 in file log, 1329 in excel
Sunstone NVC Four Seasons PL Actual 2022-06.csv & Sunstone NVC Four Seasons STATS Actual 2022-06.csv – together had 1967 in file log, but 1960 in excel
Sunstone NVC Four Seasons BS Actual 2022-06.csv – file didn’t get processed
Issue Status: Issue Solved
Urgency: (1) High
Ticket Number: CAS-386941-Z5K2S4
Email: dwallace@hotelbisolutions.com
Created Date: July 12, 2022
Last Updated: July 13, 2022
Resolution Note: