I have a database with 4 million records, a directory of people. The database is hosted on FM Cloud using Server 15. Periodically I need to update those records as people move, etc... So I get a new list of people, maybe 100K - 200K at a time in Excell format. To just run update records from my computer is painfully slow and it always crashes before completion (hours into the update).
So I tried importing the spreadsheet into a new FM database and putting the database on the FM Cloud server, then writing a script to import the records from the new database on the server. It works fine if I run the script from my computer (at least the process does, it still crashes hours into it) so I created a simple PSoS script to run the update script but it won't run the update script.