OOTP Developments Forums - View Single Post

brigmcneil · 10-12-2025, 05:50 PM

Hopefully this can be fixed in FHM12...
I am playing with the CSV exports and I am noticing that the STAFF_MASTER has duplicate STAFFID's. It appears that the duplicates are eliminated if you ignore RETIRED = 1 rows. But, there is also a problem where there are also duplicates in the STAFF_RATINGS table and there is no distinguishing characteristic indicating which one belongs to the ACTIVE staffer.

10-12-2025, 05:50 PM	#1
brigmcneil Minors (Triple A) Join Date: Feb 2016 Posts: 229	CSV problem with STAFF tables Hopefully this can be fixed in FHM12... I am playing with the CSV exports and I am noticing that the STAFF_MASTER has duplicate STAFFID's. It appears that the duplicates are eliminated if you ignore RETIRED = 1 rows. But, there is also a problem where there are also duplicates in the STAFF_RATINGS table and there is no distinguishing characteristic indicating which one belongs to the ACTIVE staffer.