AnsweredAssumed Answered

Update records on FM Cloud with PSoS

Question asked by PeterDurant on May 19, 2018
Latest reply on May 19, 2018 by philmodjunk

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.

 

Any ideas?

Outcomes