Smores
Full Member
- Joined
- May 18, 2011
- Messages
- 26,583
I read it, still no excuse. How it is done is to import into database immediately, with no intermediaries. Any other apps that use the data can then read from the database.
Why is it done like that?
Well, exactly because of situations such as this.
It's really not uncommon to use CSV or XLS to feed into disparate systems though, quite the opposite. Ideally you want to properly integrate the systems but considering it's a third parties system and time limited purpose I'm not at all suprised they went that route.
I think someone posted last week that the app doesn't include the Pillar 1 results so we already knew it wasn't integrated.
They've had the time to do it even with the complexities involved but someone will have knocked it on it's head due to cost.